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?
-
Isn't that in the Votes and PostHistory tables?– reneApr 23, 2014 at 15:52
-
Did you find this: meta.stackexchange.com/questions/2677/…– reneApr 23, 2014 at 15:58
-
Yes. I found. But I hope there is more easy way to retrieve the user activity as it is shown stackoverflow.com/users/412270/myborobudur?tab=activity activity-->all tab– Gerel tumenApr 23, 2014 at 16:03
-
No, I'm afraid not. A query/subquery that joins those tables is needed– reneApr 23, 2014 at 16:11
Add a comment
|
1 Answer
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.
answered Apr 23, 2014 at 23:18
-
Will this data dump include suggested edits, close flags/votes, etc.? 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. 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. May 28, 2014 at 19:52
-
@hichris123 Suggested edits are still edits, and are contained in the PostHistory table in the dump. 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. May 29, 2014 at 1:49