13

During a discussion in chat, the question came up if there were any particularly useful SEDE (Stack Exchange Data Explorer) queries for this stack.

2
  • 2
    +1. This could be another good candidate for the faq.
    – Rand al'Thor Mod
    Apr 22, 2016 at 16:46
  • There are a few queries in other questions with the data-explorer tag.
    – Molag Bal
    Apr 23, 2016 at 3:41

5 Answers 5

6

Posts

Tags

Users

Other stuff

Bonus round

  • This isn’t a data.SE query, but it’s a data dump: Reputation audit. View your reputation changes, excluding deleted posts. More information here.
  • The truly curious can browse my list of favorite queries.

This has nothing to do with browsing data, but check out the hidden features of Stack Exchange.

1
2

Drive by Idents

This is an overview of all questions by a user who has asked just a single question, with a breakdown in identification requests and other questions.

1

Votes over time for a specific question and its answers

Input a question ID and go to the Graph tab to get a visualisation of how the score of that question and all its answers have changed over time.

0

Tags used more than once without a tag wiki.

The title says it all, these are tags that have been used more than once on a post, but have either no excerpt, no wiki, or neither.

1
  • WikiPostId will never be NULL when ExcerptPostId exists. Lots of tags have no wiki that don't show up in that query. I'm biased, but I like this query better for searching tags.
    – Molag Bal
    Apr 22, 2016 at 14:26
0

Finding images without alt text

This is a query to find the top 15,000 posts that contain images with no alt text, excluding closed questions (although not answers to closed questions).

This is part of an effort to slowly make the site more accessible by including alt text for images.

This variation finds questions with multiple answers that have images with no alt text (credit to @AncientSwordRage).

This query allows you to enter your user ID to find your posts that contain inaccessible images.

You must log in to answer this question.

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