13
$\begingroup$

This post is here to house SEDE (StackExchange Data Explorer) queries relating to this site. Originally spawned from this thread.

Queries are categorised below depending on the data they look at. If you have written a query and would like it added to the list, just edit it in in the correct category (if you feel there is no category, create one). Please do not add new answers for other queries. I've made the answer CW so most people can edit, however if you have insufficient reputation and would like your query added, leave it in a comment below or talk to someone in chat.

If you feel like you can improve on a query, just fork the query using the link in SEDE and make your changes. You can change the link in the answer when you're done.

| |
$\endgroup$
  • 1
    $\begingroup$ This queries could benefit other Stack Exchange sites. Should we post this on Meta, or do something related? $\endgroup$ – HDE 226868 Apr 15 '15 at 23:50
  • $\begingroup$ We could do, some sites (TWP notably) already have some. I can post it today. $\endgroup$ – ArtOfCode Apr 16 '15 at 7:42
  • $\begingroup$ Suggested addition: Tag Experts, lists the person with the highest answer score for each tag. Not sure if it's useful, especially on low-traffic tags, but it might be nice to find your name somewhere on the list. Mostly I just like making up new queries. $\endgroup$ – DaaaahWhoosh Apr 21 '15 at 20:18
  • $\begingroup$ @DaaaahWhoosh Do feel free just to edit things in :) $\endgroup$ – ArtOfCode Apr 21 '15 at 20:32
  • $\begingroup$ I've found this, it could be of interest : quantcast.com/worldbuilding.stackexchange.com#!demo $\endgroup$ – Vincent Sep 3 '15 at 4:32
  • $\begingroup$ i dont understand what query and it real purpose is, but looking at some answer i have a gist of it. would it be possible to add previous hot network list question regarding world building? especially our own. $\endgroup$ – Li Jun Jun 7 at 5:00
12
$\begingroup$

Voting and Moderation

Post Statistics

Posts to Watch

Users

Tags

  • Tag Usage over time - shows how much a tag has been used over time as a graph of number of posts against time.
  • Tag Experts - shows the user who has the highest answer score for each tag.
  • Tag Expertise - shows in how many tags the user is top expert (based on the Tag Experts script above)

General Activity/Utility

$\endgroup$
  • $\begingroup$ The low-quality posts query is awesome. It beats automatic flagging. $\endgroup$ – HDE 226868 Apr 15 '15 at 2:37
  • $\begingroup$ @HDE226868 I've managed to lose a good 20 rep from downvote get answers off that query... $\endgroup$ – ArtOfCode Apr 15 '15 at 7:41
  • $\begingroup$ I've done some similar voting. $\endgroup$ – HDE 226868 Apr 15 '15 at 23:50
4
$\begingroup$

Badges Progress

Some of the users like to see how they fare with their virtual rewards, namely badges. And sometimes it isn't easy to know how much more we have to wait before we get such and such badge. Here are some queries which can give some views on those. Or explanation on how to get to know.

Questions

Answers

Participation

Moderation

Others

$\endgroup$

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .