Linked Questions

3
votes
1answer
86 views

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 (...
1
vote
0answers
84 views

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 ...
0
votes
0answers
42 views

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 ...
41
votes
40answers
2k views

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: ...
348
votes
2answers
89k views

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 archive.org, and also makes that information queryable over the Internet at the Stack Exchange ...
12
votes
2answers
232 views

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 ...
8
votes
4answers
346 views

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 ...
2
votes
3answers
247 views

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 ...
5
votes
1answer
151 views

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 ...
3
votes
1answer
84 views

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 ...
8
votes
0answers
91 views

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 ...