- Format: 7zipped - Files: - **Badges**.xml - Id - UserId, e.g.: "420" - Name, e.g.: "Teacher" - Date, e.g.: "2008-09-15T08:55:03.923" - Class - 1: Gold - 2: Silver - 3: Bronze - TagBased: true if is for a tag - **Comments**.xml - Id - PostId - Score - Text, e.g.: "@Stu Thompson: Seems possible to me - why not try it?" - CreationDate, e.g.:"2008-09-06T08:07:10.730" - UserDisplayName: populated if a user has been removed and no longer referenced by user Id - UserId - **PostHistory**.xml - Id - PostHistoryTypeId - 1: Initial Title - The first title a question is asked with. - 2: Initial Body - The first raw body text a post is submitted with. - 3: Initial Tags - The first tags a question is asked with. - 4: Edit Title - A question's title has been changed. - 5: Edit Body - A post's body has been changed, the raw text is stored here as markdown. - 6: Edit Tags - A question's tags have been changed. - 7: Rollback Title - A question's title has reverted to a previous version. - 8: Rollback Body - A post's body has reverted to a previous version - the raw text is stored here. - 9: Rollback Tags - A question's tags have reverted to a previous version. - 10: Post Closed - A post was voted to be closed. - 11: Post Reopened - A post was voted to be reopened. - 12: Post Deleted - A post was voted to be removed. - 13: Post Undeleted - A post was voted to be restored. - 14: Post Locked - A post was locked by a moderator. - 15: Post Unlocked - A post was unlocked by a moderator. - 16: Community Owned - A post has become community owned. - 17: Post Migrated - A post was migrated. - 18: Question Merged - A question has had another, deleted question merged into itself. - 19: Question Protected - A question was protected by a moderator - 20: Question Unprotected - A question was unprotected by a moderator - 21: Post Disassociated - An admin removes the OwnerUserId from a post. - 22: Question Unmerged - A previously merged question has had its answers and votes restored. - 24: Suggested Edit Applied - 25: Post Tweeted - 31: Comment discussion moved to chat - 33: Post notice added comment contains foreign key to PostNotices - 34: Post notice removed comment contains foreign key to PostNotices - 35: Post migrated away (replaces id 17) - 36: Post migrated here (replaces id 17) - 37: Post merge source - 38: Post merge destination - PostId - RevisionGUID: At times more than one type of history record can be recorded by a single action. All of these will be grouped using the same RevisionGUID - CreationDate: "2009-03-05T22:28:34.823" - UserId - UserDisplayName: populated if a user has been removed and no longer referenced by user Id - Comment: This field will contain the comment made by the user who edited a post - Text: A raw version of the new value for a given revision - If PostHistoryTypeId = 10, 11, 12, 13, 14, or 15 this column will contain a JSON encoded string with all users who have voted for the PostHistoryTypeId - If PostHistoryTypeId = 17 this column will contain migration details of either "from " or "to " - **PostLinks**.xml - Id: primary key - CreationDate: when the link was created - PostId: id of source post - RelatedPostId: id of target/related post - LinkTypeId: type of link - 1: Linked - 3: Duplicate - **Posts**.xml - Id - PostTypeId - 1: Question - 2: Answer - ParentId (only present if PostTypeId is 2) - AcceptedAnswerId (only present if PostTypeId is 1) - CreationDate - DeletionDate - Score - ViewCount - Body - OwnerUserId - OwnerDisplayName: populated if a user has been removed and no longer referenced by user Id or if the user was anonymous - LastEditorUserId - LastEditorDisplayName, e.g.:"Jeff Atwood" - LastEditDate, e.g.:"2009-03-05T22:28:34.823" - LastActivityDate, e.g.:"2009-03-11T12:51:01.480" - CommunityOwnedDate, e.g.:"2009-03-11T12:51:01.480" - ClosedDate, e.g.:"2009-03-11T12:51:01.480" - Title - Tags - AnswerCount - CommentCount - FavoriteCount - ClosedDate: populated if the post is closed - CommunityOwnedDate: populated if post is community wikied - **Tags**.xml - Id - TagName - Count - ExcerptPostId - if an Excerpt is created - WikiPostId - if an Wiki is created - **Users**.xml - Id - Reputation - CreationDate - DisplayName - EmailHash - ProfileImageUrl - LastAccessDate - WebsiteUrl - Location - Age - AboutMe - Views - UpVotes - DownVotes - AccountId - **Votes**.xml - Id - PostId - VoteTypeId - 1: AcceptedByOriginator - 2: UpMod (upvote) - 3: DownMod (downvote) - 4: Offensive - 5: Favorite - if VoteTypeId = 5 UserId will be populated - 6: Close - 7: Reopen - 8: BountyStart - 9: BountyClose - 10: Deletion - 11: Undeletion - 12: Spam - 13: InformModerator - 15: ModeratorReview - 16: ApproveEditSuggestion - CreationDate - UserId (only for VoteTypeId 5) - BountyAmount (only for VoteTypeId 9)