Linked Questions

6 votes
1 answer

How to access deleted question via data explorer? [duplicate]

Deleted questions only get soft-deleted. They are not shown anymore, (but accessible to >10k-rep-users). Thus, they should be available via the data dump. How would you access, say, what-stack-...
serv-inc's user avatar
  • 803
1 vote
1 answer

Filtering deleted questions in StackExchange Data Explorer [duplicate]

Is there a way to filter out the deleted questions in a StackExchange Data Explorer query?
user avatar
2 votes
0 answers

Can deleted posts be queried on data explorer? [duplicate]

For various reasons, I would like to search though posts including deleted ones, however it seems that deleted posts are not exported. If there a way to query them? If not, why aren't deleted posts ...
Bohemian's user avatar
  • 9,648
1 vote
0 answers

Add the DeletionDate column to the data dump or create a PostsWithDeleted table [duplicate]

The latest data dump has: no DeletionDate column no PostsWithDeleted table but it does contain deleted posts. This makes it hard to decide if posts are deleted or not. I think I could extract that ...
Ciro Santilli's user avatar
299 votes
8 answers

Why we don't keep public records of suspensions

Whenever the topic of a suspended user crops up, there's often confusion about what information moderators ought to share and what they should keep private. Sometimes moderators are just as unsure as ...
Jon Ericson's user avatar
  • 79.6k
382 votes
2 answers

Database schema documentation for the public data dump and SEDE

Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via, and also makes that information queryable over the Internet at the ...
144 votes
12 answers

Building an archive of deleted questions

Back when the first discussion about deleted questions came up, I promised to look into building an official unofficial read-only archive for good deleted SE content. I had a plan to build something ...
Pekka's user avatar
  • 114k
142 votes
10 answers

Turbocharging the Roomba: solutions for premature deletion

A couple weeks ago, I asked for help: How can we stop premature deletion? And I got some fantastic responses. A big thanks to everyone who participated in that discussion - you're the reason I don't ...
Shog9's user avatar
  • 451k
95 votes
9 answers

Can we have a guaranteed pipeline for responses from Stack Exchange?

I think we should have some mechanism that automatically flags certain meta posts (both child metas and here) for Stack Exchange staff attention when they get beyond a certain point. The thresholds ...
durron597's user avatar
  • 11.7k
70 votes
7 answers

How do you view deleted questions?

10k rep members are allowed to see deleted questions, is there a way to find questions that were deleted or to see a list of them somewhere?
Click Upvote's user avatar
  • 2,604
107 votes
2 answers

Enable searching with deleted:1 for 10k users

I just tried to find a recent answer I wrote (or comment, can't remember), but I couldn't. I assume the question was deleted. Can the deleted:1 operator be enabled to 10k users? We can see deleted ...
bfavaretto's user avatar
  • 8,576
34 votes
2 answers

How many questions are closed every day on Stack Overflow?

I really like the idea of Stack Overflow, but I was wondering if anyone knows that how many questions are being closed each day? And for which reasons, like duplicate of = ? off-topic because =? ...
Toseef Khilji's user avatar
18 votes
4 answers

Data dump should include deleted posts

Given that deleted content is licensed CC just as the regular content is, it exists in the current SO database, and it is accessible to over 400 (10k+ rep) users, it should also be exported as part of ...
Pollyanna's user avatar
  • 76.1k
23 votes
2 answers

Is 10k reputation the same as it used to be?

For the past 3+ years users with 10,000 reputation have had access to a moderator dashboard [A Theory of Moderation]. There are 3,269 users on SO that have these privileges. I am assuming that this ...
Austin Henley's user avatar
11 votes
2 answers

How to see the correctness of close/reopen votes?

How can I see the ratio of my previous close/reopen votes that were correct (i.e. resulted in the question being closed/reopened) or incorrect (i.e. resulted in the question left open/closed)? I am ...
user000001's user avatar
  • 4,058

15 30 50 per page