During a discussion in chat, the question came up if there were any particularly useful SEDE (Stack Exchange Data Explorer) queries for this stack.
5 Answers
Posts
- Find questions to reopen: Some of these questions should probably be reopened.
Tags
- Most common tags with short, long, or missing excerpt or wiki: You can browse tag wikis by tweaking the first four parameters on this query.
- Related tags: Browse the full list of related tags for any tag.
- Search posts with a specific post type ID: Mainly useful for searching tag wikis.
- Tags with the most views per question: See which tags are most likely to get views.
Users
- Users with the same display name: Find all of M.A. Golding’s posts, for example.
- My reputation graph: Cool, but it doesn’t consider the rep cap.
Other stuff
Search comments or view top comments: Find the most popular comments on the site, or search comments by user or by content.
Get all review tasks for a specific post ID or user's posts: Fill in the user ID or post ID, and browse old review tasks.
Find all questions sucessfully migrated away from a site: See what questions migrated away from here are still open. Click a site name in the results to see each question found.
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.
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.
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.
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.
-
WikiPostId
will never beNULL
whenExcerptPostId
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. Apr 22, 2016 at 14:26
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.