Linked Questions

348
votes
2answers
89k views

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 archive.org, and also makes that information queryable over the Internet at the Stack Exchange ...
19
votes
2answers
608 views

Why is vote time missing in the SE data dump and SEDE?

Is there a particular reason why vote times are omitted in the data dump? IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not ...
16
votes
3answers
239 views

Is there somehow a way to find the questions which are the most referred to when closing duplicates?

Duplicated questions are a thing we want to avoid on these sites. However, it will happen anyway, this is why we get the "exact duplicate" close reason. There are some questions which are coming back ...
24
votes
3answers
354 views

How many questions have I voted to close and voted to delete?

I'm curious about how well I judge worthy questions in comparison to the rest of the community. How can I get a count of how many questions I have voted to close or delete, and how many of those ...
13
votes
3answers
100 views

Could there be close statistics visible to each user?

I am very curious as to whether my close judgements correspond to those of the larger community. When I'm vote #5, it's clear enough. Not so much so when it's vote #1. I make my vote, I move on, and I ...
10
votes
2answers
156 views

Request for data dump to contain userid of closers

Currently the data dump, the "votes" table contains rows that record votes to close (or reopen) a question, but the userid column is not filled in for these votes. Since this information is available ...
17
votes
1answer
282 views

Please Provide a "Table of Duplicates"

When a question is closed as a duplicate, links to the "proposed duplicate" questions are added to it. I'd like to see a sort of index, or table of these duplicates. For each proposed duplicate ...
2
votes
2answers
94 views

Idea to cut down on duplicate questions

Basically, add a new question view: Common. This would contain questions that have had both 10 or more upvotes and have 1 or more other questions closed as duplicates. Examples: which way is better ...
5
votes
1answer
110 views

Why are there only 4 days worth of close/reopen votes in the Data Explorer?

As the title states - what's the deal? Did close votes just start being added? Are the ones that are there only there because of some transient experiment? Example Query I'm pretty sure that a few ...
3
votes
2answers
118 views

Any Data Explorer query for number of close/open cycles?

Any way to see a question's history of being closed and opened?
6
votes
1answer
97 views

Statistical query: from 'most popular' to 'deleted' in a new york minute

I've been noticing a rather depressing trend. If I go to the 10k tools, and look at the questions with the most upvotes, many of them immediately strike me as needing a close vote. And I'm clearly ...
1
vote
1answer
70 views

Does the data-dump contain all close votes cast?

Does the data-dump contain all votes cast by people, or only those close votes that are displayed (i.e. votes on posts that got enough votes to close)?