Is there any way to query the user id of a deleted post author on a Stack Exchange site?

I tried to query the table postswithdeleted from https://data.stackexchange.com/stackoverflow/queries. But the column owneruserid of the table is empty.

Is there any other to know the user id of a deleted post?


No, you can't obtain that information from the Data Explorer. The PostWithDeleted table was only added to allow reporting over trends in tags, closing, deletes, etc., not as a means to gain easy access to deleted content or its authors.

If the post was created more than three months ago (and not yet deleted at that time) you could fetch the Posts.xml from the datadump and find the id of the post you're interested in. That record will give you all content, including the owneruserid.

An alternative might be the Internet Archive Wayback machine, but they don't capture all pages.

You'll need the Access To Moderator Tools privilege that comes at 10K (2K on beta sites) of reputation to see a specific deleted post. Either get that reputation on the site the post is on or maybe ask in chat if a user with said privilege is willing to help you out.

Let me add a warning for casual readers: Not all users appreciate being randomly contacted about their posts and that might be even more so for deleted posts. Keep that in mind once you managed to find the userid and now want to take a next step...

You must log in to answer this question.

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