Useful Data Queries

Question

Over on Worldbuilding, we've come up with a list of data queries. HDE226868 suggested that these queries might be useful to other sites, and we should post them on Meta: this is the result.

This post is a re-list of all the queries we've come up with. It will be updated as new queries are invented, but you may wish to check both posts to get the full list.

As with the post on Worldbuilding, if you have a query you wish to add, just edit it in. Please avoid making new answers for your queries, I have seen query lists get incredibly messy because of this. The answer is community wiki, so most people can edit it.

Return to FAQ index

Answer 1

Voting and Moderation

• Upvotes Over Time - shows how many votes each post received on average over time.
• Percentage of questions closed - shows a simple rundown of total questions, closed questions, and the percentage of questions closed.

Post Statistics

• Distribution of Votes on Answers - shows how many answers have how many votes. I find the graph most interesting here.
• Distribution of Votes on Questions - shows how many questions have how many votes. Again, the graph is very interesting.
• Asked/Closed/Reopened per week - shows the number of questions asked, closed and reopened together in a graph.
• Number of questions with respective number of answers - shows the number of questions that has each specific number of answers. (For example, how many questions have 0 answers, 1 answer, 2 answers, ..., 10 answers, ...)

Posts to Watch

• Possible low-quality answers - gives a list of answers which satisfy some common criteria of low-quality answers. Note that being in this list does not automatically make an answer low quality, they should still be evaluated on their own merits.
• New Answers to Old Questions - shows answers from the last week posted on questions more than 30 days older.
• Highest Voted Posts - gives the top 15 highest voted posts from the last week.
• Lowest Voted Posts - gives the top 15 lowest voted posts from the last week.
• Most Commented - lists the 15 most commented posts of the last week.
• Most Viewed - lists the 15 most viewed questions of the last week.
• Most Edited - lists the 15 most edited posts of that were last edited in the last week.

Users

• Distinct Contributors per week - shows the number of different users engaged in different activities per week. Taken directly from TWP.
• New Users per week - shows the number of new users who joined each week. Again, from TWP.
• New User Progress - shows newly-contributing users, showing numbers of questions/answers and rep.

Tags

• Tag Usage over time - shows how much a tag has been used over time as a graph of number of posts against time.

General Activity/Utility

• Site Activity and Voting graph - a graph of significant stats like votes, questions and answers, all per week. Copied from TWP.