I haven't found any table that has user history information in the Stack Exchange Data Dump. For example, when a specific user has asked, answered, commented, edited and his answer is accepted.

Where I can find this information?


We include this information in the data dumps already in the Posts, Comments, and PostHistory tables already. We don't include any other denormalized versions of this data since it would add to already enormous data dumps.

Speaking of - I need to go kick off a new data dump right now.

  • Will this data dump include suggested edits, close flags/votes, etc.?
    – hichris123
    Apr 24 '14 at 1:22
  • @hichris123 the tables are the same as last time, and include whatever those tables currently hold in the Stack Exchange Data Explorer - that's what we match to. Flags and close votes we include in data explorer for querying what's currently in flight, but from a permanent archive perspective showing what's open right now makes almost no sense. For that reason, we don't include data that changes very rapidly in the archive. Apr 24 '14 at 10:41
  • How about suggested edits, though? They're more like posts: some are added but the rest stay the exact same.
    – hichris123
    May 28 '14 at 19:52
  • @hichris123 Suggested edits are still edits, and are contained in the PostHistory table in the dump. May 29 '14 at 1:47
  • Yeah, however if I remember correctly the votes (approve/reject) aren't in there. i.e. the SuggestedEdits and the SuggestedEditVotes tables.
    – hichris123
    May 29 '14 at 1:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .