I have downloaded the Stack Overflow data dump and imported it into a MySQL database. There were six XML files in the dump, so I created six tables, one for each XML file present in the dump:
badges
, comments
, postHistory
, posts
, users
, votes
But using the Data Explorer, I could see the Data Explorer has more tables than the six mentioned above. Also, accordinly to this question, the tables present in Data Explorer are:
posts
, users
, comments
, badges
, postFeedback
, postHistory
, postHistoryTypes
, postTags
, PostTypes
, SuggestedEdits
, SuggestedEditVotes
, Tags
, TagSynonyms
, Votes
, VoteTypes
I need to calculate some metrics related to suggestion of edits. That's why I need to access tables such as SuggestedEdits
and SuggestedEditVotes
. Can someone tell me why the public dump does not have those tables?
I need to perform an offline computation. That's why I need a database locally stored on my computer because I can't access the online Data Explorer.