12

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 ...


7

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.


5

Top Reopen Voters for Reopened Questions: 92 Chad 89 gnat 81 enderland 79 Rachel 49 RhysW 42 jmort253 42 jcmeloni 42 CMW 37 jmac 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 ...


5

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 Distinct Contributors Finding potential problems for cleanup Answers with under 50 words Posts with lots of comments (alternative) Ranking Queries Top reopen voters Top ...


4

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 ...


4

# 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.


3

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 ...


3

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.


2

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" ...


2

Data for New Users by Week (adapted from one of Rachel's Queries posted on Programmers.SE).


2

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 ...


2

Answers with Under 50 Words Most of these should be flagged and/or deleted depending on score and content, based on the discussion here.


1

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 ...


1

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 ...


Only top voted, non community-wiki answers of a minimum length are eligible