Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,807,370 2,191,511,528
All Images 6,837,928 1,348,657,172
API Users 191 37,132
Article Revisions 52,565 1,651,689,696
Articles 705 11,050,912
Blog Posts 325 956,480
Browser Activity Log 2,529,571 446,103,660
Categories 9,601 405,628
Collections 82,510 40,201,668
Contributors 13,366 842,058
Discussion Forums 20 2,188
Discussion Post Reports 11,432 11,007,732
Discussion Posts 605,698 179,499,208
Discussion Promoted Post 78 2,808
Discussion Threads 22,119 1,469,160
Event Attendees 695 45,436
Events 67 15,804
FAQ Answers 169 196,608
FAQ Questions 188 16,012
Featured Search Results 342 11,608
Gallery Images 121,728 3,651,840
Game Plays 28,060 4,749,308
Geo Trips 1,734 6,652,688
Geographical Contexts 49 26,056
Grid Squares fixed for Land Percentage 34,164 1,205,756
Grid-Squares 352,203 28,458,220
Hectads 3,937 626,952
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 18,734,267 318,482,539
Images redirecting to new version 9,341 121,433
Leagues 377 45,688
Map Tiles 265,547 8,231,957
Moderation Actions 6,010,510 126,220,710
Moderation Actions (Historic) 0
Myriads 110 22,328
Picture of the Day images 6,017 96,272
Placename Gazetteer 285,339 19,119,584
Projects 25 15,800
Quiz Questions 55 10,120
Quizes 9 384
Registered Users 112,705 16,919,016
Registered Users (Historic) 22,687 2,870,280
Search Queries Performed 1,978,814 483,797,204
Search Queries Performed (Historic) 131,707,499 14,792,062,804
Shared Descriptions 21,669 13,000,460
Shared Descriptions attached to images 659,133 13,841,793
Suggestion Ticket Item Changes 1,870,033 672,965,248
Suggestion Tickets 33,593 2,462,048
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,262 349,500
Tags attached to Images 17,316,774 1,456,472,064
Unique Tags 268,126 19,415,040
User Preference Settings 20,175 1,222,880
Votes Cast 577,320 95,192,324
Primary Database Total 200,684,499 24,227,158,234
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