When a question migrates, answers are deleted and the question left as a stub. For example, a question is migrated from site superuser (post id: 82342) to stack overflow (post id: 1894170). I can access the edit history of 82342 (https://superuser.com/posts/82342/revisions), but my question: is it possible to collect that information from any data dump? The stack exchange data dump (PostHistory) does not contain any information about the deleted post (I have seen PostsWithDeleted in SEDE but that does not contain history).


Content of posts which are outright deleted can't be accessed through SEDE; you'll need other tricks to download them altogether, like an Apple Script.

It looks like that upon migration a question, only the final version of a post is migrated, so there is no way to get the complete history from SEDE.

  • Thanks for the pointer. I guess that's a design choice to remove the old history. That means if the migration rejection event occurs in the new site (this can happen if the migrated question is closed on the new site and eventually removed), the question will return back to the original site but it will appear as a new post. Is this correct? – Muhammad Asaduzzaman Dec 6 '18 at 11:11
  • Eh ... not exactly. This rejected migrated question is still closed on Electronics (but no longer 'migrated'). – Glorfindel Dec 6 '18 at 11:15
  • you said there is no way to get the complete history from SEDE. I am wondering whether that data is stored separately but not publicly available or the history is lost completely? – Muhammad Asaduzzaman Dec 6 '18 at 11:29
  • It's still stored, 10K users (and the post owners) can see it. – Glorfindel Dec 6 '18 at 11:30
  • Is it possible to get access to that data as a data dump or another way(such as for research purpose) ? what is the proper way to get access to that data? – Muhammad Asaduzzaman Dec 6 '18 at 11:33
  • There is no proper way, but I've constructed an Apple Script to download all revisions of certain posts, including deleted ones (if you have enough reputation). It's linked to in the answer already. – Glorfindel Dec 6 '18 at 11:35

You must log in to answer this question.

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