3

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?

4

1 Answer 1

1

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.

5
  • Will this data dump include suggested edits, close flags/votes, etc.?
    – hichris123
    Commented Apr 24, 2014 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. Commented Apr 24, 2014 at 10:41
  • How about suggested edits, though? They're more like posts: some are added but the rest stay the exact same.
    – hichris123
    Commented May 28, 2014 at 19:52
  • @hichris123 Suggested edits are still edits, and are contained in the PostHistory table in the dump. Commented May 29, 2014 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
    Commented May 29, 2014 at 1:49

You must log in to answer this question.

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