All Questions
9
questions
9
votes
0
answers
113
views
How can we check how often questions sent to the close queue age out?
My site is dealing with a rather long close vote review queue and we believe reviews are regularly ageing out. We want to address the problem in Meta and motivate it with stats over time about how ...
- 537
4
votes
2
answers
58
views
How to select the time of a Review Task Result in Data Explorer Stack Exchange?
I am trying to find those posts that were edited after a Leave Closed result of a Reopen Votes review queue. For that, I had written the following query in the Stack Exchange Data explorer:
SELECT
...
- 187
2
votes
1
answer
49
views
SEDE query for posts flagged as NAA
I am trying to figure out where in the database schema is stored the information about the kind of flag that has eventually been raised on a given answer.
It seems spam/offensive flags should ...
- 3,196
2
votes
1
answer
39
views
Retrieving sequence of Review Tasks Results (within a date)?
Is it possible to know (be sure) the sequence of review tasks results, even though the time data from 'CreationDate' is removed (i.e., there is only date, not time)?
Let me explain better. I want to ...
- 1,982
6
votes
0
answers
42
views
Is it possible to estimate the active reviewer population using the SEDE data?
My main site has, I think, a problem with a shrinking reviewer population, and I would like to use the SEDE data to estimate whether this is indeed the case and, if so, how bad it is and how it has ...
- 19.5k
3
votes
1
answer
115
views
How does a post end up in the review queue?
I've read about Review Tasks here and examined the tables here.
My questions are:
What kinds of posts get to the review table? (E.g., questions, answers,..)
What is the qualifying factor?
Who/what ...
- 131
4
votes
2
answers
81
views
Can I query the SEDE for what fraction of close reviews are initiated by flags?
I would like to know what fraction of the recent close-vote review tasks were initiated by a flag cast by a user under 3k reputation (as opposed to tasks assigned to the queue by a close vote by a 3k+ ...
- 19.5k
6
votes
1
answer
68
views
SEDE's suggested edit tables seem to return information about the wrong suggested edit
I'm trying to use SEDE to hunt down robo-reviewers, and I've hit a rather nasty snag. I'm using this query to grab all reviews on edits I've also reviewed:
select * from SuggestedEditVotes where Id in ...
- 50.7k
7
votes
1
answer
123
views
Stack Exchange Table Structure [duplicate]
Possible Duplicate:
Add better descriptions and E/R diagram to Data Explorer’s schema
I was messing around with the Stack Exchange Data Explorer and it appears that not all the tables are present in ...
- 1,241