One area that is lacking for Pushshift's data archives of Reddit is a comprehensive data source for all subreddits and which moderators mod various subreddits.

I am working on building a database which I will make available through new endpoints along adding the data to the monthly dumps. It would probably also be helpful to include information about all new subreddits that are created each month.

I should have the data ingested in the next week -- I will update when it is completed.

If you are interested in getting data for all Reddit subreddits (including their subscriber counts, etc.) and also getting information on moderators (who mods what, when they were added, what permissions they have, etc.) then this data is for you!

One issue that makes getting this data difficult is that the subreddit information provided by Reddit also includes all user subreddits. You can get data from Reddit's API by merely walking through the ids sequentially -- but once user subreddits were introduced, it vastly increased the number of subreddits available via the API and made getting regular subreddits more difficult from merely sequentially walking through the ids.

For example, the earliest subreddits on Reddit start around id #6, then skip around in the low thousands, and then skip up to around ID 4.5 million. Here is an example of some subreddits by ascending ID (below). As you can see, the ids skip around and then become relatively stable after ID 4,594,300 million.