I was told by email@example.com to try to post the following as a feature-request. I'm a scientist, and a few colleagues and I are interested in how networks of tagged knowledge units(bits) evolve. In the file stackoverflow.com-Posts.7z (from https://archive.org/details/stackexchange) I saw the view counts (total up to now) and scores of posts. Can the Admins export from the DB and provide for research purposes the time stamps of all views and all score change events? Thanks.
There are two tables (files if you use the datadump) that hold an history of events for posts.
First of all there is Votes. Each row hold a postid, creationdate and votetypeid (among other attributes). The votetypeid hold the type of vote. The most relevant ones are:
Do note that
creationdate only contains the date part. The time is zero-ed out to guarantee anonymity for the voters.
Secondly there is PostHistory. It keeps track of a various of events. You'll find postid, creationdate (including exact time) and a posthistorytypeid. With that attribute you can find values for:
10. Post Closed
11. Post Reopened
12. Post Deleted
13. Post Undeleted
19. Question Protected
20. Question Unprotected
for event 10, the attribute
text will hold the close voters. Other events might capture similar or other data in the
textattribute, often encoded as an JSON string.
For a complete description of the schema available in both the data dump as SEDE please see Database schema documentation for the public data dump and SEDE