I was trying to link the Stack Exchange data together from the archive.org data dump as my college database subject project, but I can't understand how to link the Post and its answer. I tried to link using postlinks relation, but it didn't work that way...

Any kind of help is appreciated.


1 Answer 1


On the posts data set, there is a ParentId field. For answers, this is the Id of the "parent" question. Questions are PostTypeId = 1 and answers are PostTypeId = 2.

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