Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Moderators are special, privileged users who should serve as an example to the rest of us. Therefore, it is natural to want to query behaviors and statistics about these model users, Like I did, for example, when researching this question.

Unfortunately, there is no way to determine moderators in the SEDE data set! We are left with hand-coding the current mods like in this query. This is hardly a good solution and does not port if we want to quickly switch the query from, say, SO to Super User.

Please provide a Moderators table, listing the ID's of that site's moderators. (Or, alternatively, add a flag-column to the Users table, but this would be less efficient.)

As nhinkle notes, this information is already in the API. Please add it to SEDE, as well.

For reference, the identities of the mods is by no means secret -- being posted on each site's About page.

It's just very clunky to get this list inside a query. Currently, you can kludge a list of moderators by navigating to an About page and executing this javascript:

$("#mainbar-full div.content-page div a[href*='/users/']").map ( function () {
    return parseInt (this.href.replace (/.+\/users\/(\d+)\/.+$/, "$1"), 10);
} ).get ();

Alternatively, parse the return from the API.

share|improve this question
Go to the users page > Get their ID number? – Simon Sheehan Dec 10 '11 at 23:18
@SimonSheehan, that does no good inside a query. Getting a list of mods is not difficult for the public. Getting a list of mods in a query, is another matter. – Awesome Poodles Dec 10 '11 at 23:23
@BrockAdams FYI there is an easier way to automate it than by using that jquery call... a list of mods is provided by the API. That being said, providing it in SEDE would make things easier. – nhinkle Dec 11 '11 at 0:07
Thanks, @nhinkle! Now if we can get that information into the Data Explorer, it would be great. – Awesome Poodles Dec 11 '11 at 0:11

You must log in to answer this question.

Browse other questions tagged .