I think this summary would be incomplete without mentioning the fact that in 2019 our site lost three out of five elected moderators.
Further reading for those interested in more details:
Update: an agreement with Monica Cellio
Resigning as moderator
Resigning as moderator from Workplace.SE
Firing mods and forced relicensing: is Stack Exchange still ...
Top Close Voters for Closed Questions:
gnat - 3752
Jim G. - 2027
IDrinkandIKnowThings - 1864
jcmeloni - 1182
Christopher Estep - 1053
Michael Grubey - 813
Lilienthal - 808
Jan Doggen - 772
Dawny33 - 748
scaaahu - 704
EDIT: @gnat is correct: These stats are skewed because close votes cast on deleted posts are not included in Data.SE.
Top Reopen Voters for Reopened Questions:
33 Joe Strazzere
Nice job guys! Editing + Reopening is part of what is making this site great :)
(It should be noted that you can't query Close/Reopen votes directly, which is why this query is based off the PostHistory table ...
Community Health Queries
New users per week
Activity per day (alternative query) (currently broke)
Site Activity, comment, Voting graph
Site Health Answer, accept, comment, etc. Ratios
Finding potential problems for cleanup
Answers with under 50 words
Posts with lots of comments (alternative)
Top reopen voters
Ok, so these numbers are for the entire history of the site and include all posts - questions, answers, deleted, closed, whatever. It does not, for what should be obvious reasons, include deleted/retracted votes.
Posts with outsider agreement: 8673
Posts with outsider disagreement: 685
Posts where outsider + insider ...
# Asked, # Closed, and # Re-Opened per week
Keep in mind that this query evalutes Post Activity per week, not new posts and their current status.
For example it shows you how many questions were closed in a week, regardless of when they were posted, instead of how many questions were asked that week but are now closed.
Thanks JNat for the information and post. I'm writing this answer to give a bit of explanation regarding the unusually high stat for "Users destroyed" this past year.
As suggested by JNat's foot-note (3) on that point, yes this translates mostly to SPAM account deletions.
Late 2020 we noticed a trend among SPAM users/posts on TWP (more like a ...
Here is a query that shows upvotes, downvotes, questions, and answers per day.
Use these for trends and the like. You can probably relatively easily include stuff like close votes as well if you felt compelled. I am just awful at SQL.
A list of Most Viewed Questions (all questions with 20k plus displayed below):
How Should I Indicate Language Proficiency on my Resume? - 76,632
How should I deal with an employee who has slept with my wife? - 64,018
Is it rude to leave an interview early if you have already made your decision? - 63,113
How can I overcome "years of experience" ...
Tag Wikis that are Too Short
This could be useful for expanding the tag wikis that are empty or very close to it.
The cut-off of 40 characters for summary and 100 characters for full wiki were plucked out of thin air and adjusted slightly (there were a bunch of decent summaries between 40 and 49 characters), so feel free to tweak it as needed.
Some ways ...
I've been spending some time in the Stack Exchange Data Explorer trying to see if there are any ways to get data that may be more meaningful than the above, which doesn't really tell much of a story to me.
Of course, I do think it's up for debate how meaningful any of this is, but there were some specific figures which I found interesting. Lately, I've been ...
Number of Questions by Answer Count.
This will be used shortly for cleaning up some of those outliers. We have over 700 questions with over 5 answers. There is something wrong with that...
(This is a better query that polls questions that have never been closed, but leaves out those that were re-opened, if someone good at SQL could fiddle with it so it ...