I work on the data dump from December 2011, and I have encountered two things that I need to ask about.


In the README, it says that the attribute PostTypeId can only be 1 for the questions and 2 for the answers, but I found that there are another possibilities (3, 4, 5, 6, and 7). So what are they?

Second (it's more a remark):

I found that sometimes there isn't an answer corresponding to the question's AcceptedAnswerId.

  • 1
    Not all questions have accepted answers. May 9, 2012 at 15:47
  • 1
    Some accepted answers may have been deleted, without a new answer being accepted
    – Flexo
    May 9, 2012 at 15:50

1 Answer 1


You can query Data Explorer for the list of PostTypeId values:

Id Name                
-- ------------------- 
1  Question            
2  Answer              
3  Wiki                
4  TagWikiExcerpt      
5  TagWiki             
6  ModeratorNomination 
7  WikiPlaceholder     
8  PrivilegeWiki  

Also check out Database schema documentation for the public data dump and SEDE, which has similar information (although the list of post types seems to be a bit out of date at the moment).

The README should also be updated, but the way the data dump is being distributed is changing, so I'm not sure what impact that will have on how this kind of information is made available.

I found that sometimes there isn't an answer corresponding to the question's AcceptedAnswerId

The data dump does not contain deleted content, so presumably the corresponding answers were removed by the owner or through moderation. I guess the export process doesn't remove invalid AcceptedAnswerId values, but I'm not sure that there's necessarily a reason it should.

You must log in to answer this question.

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