StackOverflow Download Data Schema

6th June 2009

Recently the StackOverflow team released a download of their data.

Unfortunately, a schema was not included. Here it is in full:

Users

  • Id
  • Reputation
  • CreationDate
  • DisplayName
  • LastAccessDate
  • WebsiteUrl
  • Location
  • Age
  • AboutMe
  • Views
  • UpVotes
  • DownVotes

Badges

  • UserId
  • Name
  • Date

Comments

  • Id
  • PostId
  • Text
  • CreationDate
  • UserId
  • UserDisplayName

Posts

  • Id
  • PostTypeId
  • CreationDate
  • Score
  • ViewCount
  • Body
  • OwnerUserId
  • OwnerDisplayName
  • LastEditorUserId
  • LastEditDate
  • LastActivityDate
  • Title
  • Tags
  • AnswerCount
  • CommentCount
  • FavoriteCount
  • ClosedDate

Votes

  • Id
  • PostId
  • VoteTypeId
  • CreationDate