Linked Questions

4 votes
1 answer

Determining who is a moderator in data explorer [duplicate]

As far as I can tell, there's no indication in the data dumps accessible in Data Explorer as to whether a particular user is a diamond moderator or not. This would certainly be a useful thing to know (...
Ernest Friedman-Hill's user avatar
1 vote
0 answers

How to identify moderators in Data SE queries? [duplicate]

As I can see, the Data SE doesn't contain data, who are/were the moderator currently, or in the past. To some queries, I would like to use this data. Currently, I do this by checking the election ...
peterh's user avatar
  • 5,782
0 votes
0 answers

Information about moderators in the data dump [duplicate]

I was trying to look for information about the moderators of Stack Exchange Community, but I didn't find any. So can anyone please tell if there is any information available about the moderators in ...
arman's user avatar
  • 359
41 votes
40 answers

New Staff and Mod Labels on site metas and Meta Stack Exchange

Update: As can be seen on this post and elsewhere on the site, the styling for the mod/ staff labels has been modified, and hopefully will not pop out and be as overwhelming as the original colors: ...
Yaakov Ellis's user avatar
  • 63.3k
380 votes
2 answers

Database schema documentation for the public data dump and SEDE

Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via, and also makes that information queryable over the Internet at the ...
17 votes
2 answers

How can I get URLs and site names for a cross-site SEDE query?

When doing cross-site queries on the Stack Exchange Data Explorer, two of the main problems are 1) getting the URLs right and 2) getting the site names right. For URLs, we have constructions like the ...
Glorfindel's user avatar
  • 251k
5 votes
2 answers

Highest reputation moderators?

Highest-rep users on the network are easy enough to find. What about highest-rep moderators? We all know that moderation ability doesn't necessarily correlate with reputation, and moderators on ...
Rand al'Thor's user avatar
  • 33.4k
8 votes
4 answers

How to search for questions from ♦ users (moderators / Valued Associates <--- employees )?

We have announcements on Meta SE but it could be used by anyone, by the other hand we have featured on Meta sites but it's not always used and it isn't kept forever. Is there a way to search for ...
Rubén's user avatar
  • 15.4k
10 votes
1 answer

Are there any questions closed by 5 moderators?

Inspired by this question on Worldbuilding Meta, where a user noted that a question was closed by two ♦ moderators: For some people it might be obvious what happened here: one of the moderators ...
Glorfindel's user avatar
  • 251k
2 votes
3 answers

Does Sportmanship badge encourage clutter?

Sportsmanship badge is awarded for voting up 100 competing answers. But how often is there really a good reason to vote up a competing answer ? Another answer is better than mine, or says the same ...
Michael Low's user avatar
3 votes
1 answer

What are the advantages of exploring SE data via Google BigQuery over the T-SQL data explorer?

I have seen that it's possible to explore Stack Exchange data via Google BigQuery as well as via the Data Explorer. What are the benefits of this? As far as I see, the data explorer is T-SQL, which ...
Zach Smith's user avatar
8 votes
0 answers

Site meta info in SEDE

This is a feature request for an additional table in SEDE consisting of at least the following site meta data: The site's primary URL. The site's SEDE URL (or its TinyName). The date of the last SEDE ...
Jason C's user avatar
  • 26k