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:
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:
I need to calculate some metrics related to suggestion of edits. That's why I need to access tables such as
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.