Table: reddit_my_moderated_subreddit - Query Reddit Moderated Subreddits using SQL

Reddit is a social news aggregation, web content rating, and discussion website. It allows registered members to submit content to the site such as links, text posts, and images, which are then voted up or down by other members. A moderated subreddit is a specific section of the site with its own set of rules, guidelines, and moderators.

Table Usage Guide

The reddit_my_moderated_subreddit table provides insights into moderated subreddits within Reddit. As a subreddit moderator, explore subreddit-specific details through this table, including rules, guidelines, and moderation activities. Utilize it to uncover information about subreddits, such as those with specific rules, the relationships between moderators, and the verification of guidelines.

Examples

List moderated subreddits

Discover the segments that have been moderated on Reddit, sorted by their display name. This can help you assess the popularity of these segments based on the number of subscribers, and easily access them via their URLs.

select
  display_name_prefixed,
  subscribers,
  urle
from
  reddit_my_moderated_subreddit
order by
  display_name_prefixed;

select
  display_name_prefixed,
  subscribers,
  urle
from
  reddit_my_moderated_subreddit
order by
  display_name_prefixed;

Top 5 moderated subreddits by popularity

Discover the five most popular subreddits you moderate, ranked by the number of subscribers. This information can be useful to determine where your moderation efforts are having the most impact.

select
  display_name_prefixed,
  subscribers,
  url
from
  reddit_my_moderated_subreddit
order by
  subscribers desc
limit
  5;

select
  display_name_prefixed,
  subscribers,
  url
from
  reddit_my_moderated_subreddit
order by
  subscribers desc
limit
  5;

Schema for reddit_my_moderated_subreddit

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
active_user_count	bigint	Active user count for the subreddit.
created_utc	timestamp with time zone	Time when the subreddit was created.
display_name	text	Name of the subreddit, e.g. aws.
display_name_prefixed	text	Prefixed name of the subreddit, e.g. /r/aws.
id	text	ID of the subreddit.
name	text	Name (full ID) of the subreddit.
over18	boolean	True if the post is not safe for work (over 18).
public_description	text	Public description of the subreddit.
subreddit_type	text	Type of subreddit.
subscribers	bigint	Number of subscribers to the subreddit.
suggested_comment_sort	text	Suggested sort order for comments.
title	text	Title of the subreddit.
url	text	URL of the subreddit.
user_has_favorited	boolean	True if the caller has favorited the subreddit.
user_is_moderator	boolean	True if the caller is a moderator of the subreddit.
user_is_subscriber	boolean	True if the caller is a subscriber of the subreddit.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- reddit

You can pass the configuration to the command with the --config argument:

steampipe_export_reddit --config '<your_config>' reddit_my_moderated_subreddit