Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,837,351 2,202,477,916
All Images 6,867,903 1,355,233,612
API Users 191 37,132
Article Revisions 52,627 1,659,375,052
Articles 705 11,068,640
Blog Posts 325 956,480
Browser Activity Log 2,793,553 494,226,352
Categories 9,601 405,628
Collections 82,592 40,201,668
Contributors 13,378 842,814
Discussion Forums 20 2,188
Discussion Post Reports 11,435 11,007,920
Discussion Posts 608,563 180,168,456
Discussion Promoted Post 78 2,808
Discussion Threads 22,160 1,472,776
Event Attendees 705 46,096
Events 67 15,804
FAQ Answers 170 196,608
FAQ Questions 190 16,244
Featured Search Results 342 11,608
Gallery Images 122,601 3,678,030
Game Plays 28,090 4,754,900
Geo Trips 1,736 6,654,816
Geographical Contexts 49 26,056
Grid Squares fixed for Land Percentage 34,176 1,206,252
Grid-Squares 352,207 28,460,192
Hectads 3,937 627,940
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 18,845,294 320,369,998
Images redirecting to new version 9,355 121,615
Leagues 377 45,688
Map Tiles 271,137 8,405,247
Moderation Actions 6,041,117 126,863,457
Moderation Actions (Historic) 0
Myriads 110 22,328
Picture of the Day images 6,034 96,544
Placename Gazetteer 285,339 19,119,584
Projects 25 15,800
Quiz Questions 55 10,120
Quizes 9 384
Registered Users 112,812 16,940,056
Registered Users (Historic) 22,687 2,870,280
Search Queries Performed 1,747,700 483,797,204
Search Queries Performed (Historic) 133,620,226 14,994,736,296
Shared Descriptions 21,742 13,040,100
Shared Descriptions attached to images 664,031 13,944,651
Suggestion Ticket Item Changes 1,883,371 677,301,516
Suggestion Tickets 41,959 3,089,288
Suggestion Tickets (Historic) 1,505,308 132,944,700
SuperLayer Tiles 1,755,816 121,990,280
System Tasks 88 10,020
Tag Reports 4,272 350,336
Tags attached to Images 17,455,054 1,456,472,064
Unique Tags 268,935 19,415,040
User Preference Settings 20,189 1,224,120
Votes Cast 583,098 96,263,152
Primary Database Total 203,012,977 24,512,816,296
Note, some of these totals might be slightly higher than the objects visible on the site, as tables often contain records for deleted items
· Download this table as a CSV File