Stack Exchange Data Explorer now includes the table PostsWithDeleted, which, as the name suggests, includes some data on deleted posts. (Meta announcement.) The content of deleted posts is not made available, however. Only the following information is present:
- Id of the post, from which one can manufacture a link to it by prepending
http://math.stackexchange.com/q/(or, within SEDE, simply by prepending
site://which makes the query site-independent)
- Type of the post: 1 for questions, 2 for answers.
- For answers only: ParentId, which is the Id of the parent question
- CreationDate and DeletionDate (which is null for non-deleted posts)
How to use this new table?