9 votes
Accepted

Is it possible to determine your average question and answer scores?

Some of these queries already exist. However, I made a slightly more at-a-glance version that captures average score, as well as average upvotes and downvotes for both questions and answers. ...
user avatar
9 votes

What names from Star Wars are often misspelled?

Candidates so far: Ahsoka (often misspelled "Ashoka") C-3PO (I've found C3-PO, C-3P0 and even C3-P0) Coruscant Exegol Force with a lower-case 'f' Kashyyyk Lightsaber Millennium Falcon ...
9 votes

What other names from Tolkien's Legendarium are often misspelled?

Candidates so far (other then Silmaril / Silmarillion): Barad-dûr (found: Baradur, Barad Ur) Dol Guldur (found: Dol Guldor) dwarf (found: dwarve, wearer of scarve) Eärendil (found: Erendil) Ilúvatar (...
8 votes
Accepted

How linky am I?

Ask and ye shall receive Standard SEDE disclaimers apply: Updated once weekly; currently we're about two days behind reality Doesn't include deleted posts Plug your SFF UserId into the box and away ...
user avatar
7 votes

What names from Star Wars are often misspelled?

Valorum asks for examples of Coruscant being misspelled. I added that word because I know I can't spell it. But now I searched a dump for examples. (This is from an old dump from 2020, that's what ...
user avatar
  • 32k
6 votes
Accepted

What are some useful Stack Exchange Data Explorer queries for this site?

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 ...
user avatar
  • 4,592
6 votes

Why are there so many deleted posts made on 2015-08-22?

You came closest to the mark with this: My guess is that many of these posts were due to a very busy troll Suffice it to say that a large number of offensive posts, mainly attacks against a ...
user avatar
  • 131k
6 votes

Who are the top users in our tags?

TL;DR: Here are the queries: Top users in a tag by score and answer count Top user in all tags by score and answer count Tags where specified user is top by score and answer count This can be done ...
user avatar
  • 141k
5 votes

Can a Data Stack Exchange query be used to dynamically update an answer?

Yes, but As has been mentioned in the comments on your question (e.g., by AncientSwordRage's Meta.SE link), it's not possibly to dynamically query the data explorer. It's also not possible to embed ...
user avatar
5 votes

Why are there so many deleted posts made on 2015-08-22?

As you suggested, we had "a very busy troll". Without getting into the details, the incident was dubbed "sock fest". A user believed he/she had been treated unfairly and ...
user avatar
  • 67.1k
2 votes

What are some useful Stack Exchange Data Explorer queries for this site?

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.
user avatar
  • 36.8k
2 votes

What other names from Tolkien's Legendarium are often misspelled?

I've just corrected, twice, (in comments; there aren't enough extra letters for the software to accept an edit) the misspelling entlings. Of course there's no letter "L". Their name is ...
user avatar
  • 2,218
1 vote

Is it possible to determine your average question and answer scores?

Sure. Nice one-liner to paste into the Data Explorer: SELECT AVG(Score) AS [Average Score] FROM Posts WHERE OwnerUserId = ##UserId:int## Provides an average score across all posts. If you want to ...
user avatar
  • 302
1 vote

What are some useful Stack Exchange Data Explorer queries for this site?

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....
user avatar
  • 131k
1 vote

What are some useful Stack Exchange Data Explorer queries for this site?

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 ...
user avatar
  • 37.4k

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