Sometimes it is useful to get some info on deleted posts from SEDE.
The PostsWithDeleted table is useful for that. However, for deleted questions only some information is kept - according to this answer it is Id, PostTypeId, ParentId, CreationDate, DeletionDate, Score.
Yes
We've added a new table called PostsWithDeleted that includes metadata from all posts, including the deleted ones. If the post is deleted, we've nulled out all fields except:
ID
PostTypeId
ParentId
CreationDate
DeletionDate
Score
That's helpful for doing meaningful research that requires...
@Martin yes, but the tags field is later added to be populated as well which is reflected in the Database schema answer (the superscript 1 are used to indicate that)
Yes
We've added a new table called PostsWithDeleted that includes metadata from all posts, including the deleted ones. If the post is deleted, we've nulled out all fields except:
ID
PostTypeId
ParentId
CreationDate
DeletionDate
Score
That's helpful for doing meaningful research that requires...
Why doesn't http://data.stackexchange.com/ have HTTPS?
