Table: reddit_subreddit_banned - Query Reddit Banned Subreddits using SQL

Reddit is a social news aggregation, web content rating, and discussion website. It allows 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 key component of Reddit's moderation system involves the banning of subreddits that violate the site's community guidelines.

Table Usage Guide

The reddit_subreddit_banned table provides insights into banned subreddits on Reddit. As a moderator, researcher, or community manager, use this table to understand the enforcement of Reddit's community guidelines and moderation actions. It can be used to analyze patterns in banned content, identify common reasons for subreddit bans, and inform content moderation strategies.

Important Notes

You must specify the subreddit in the where clause to query this table.
Requires permission to read banned users from the subreddit.

Examples

List users banned from the subreddit "mysubreddit"

Determine the individuals who have been banned from a specific subreddit, along with the date of their ban, remaining ban duration, and any notes associated with the ban. This can be useful for subreddit moderators to track and manage user activity and behavior.

select
  name,
  date,
  days_left,
  note
from
  reddit_subreddit_banned
where
  subreddit = 'mysubreddit'
order by
  name;

select
  name,
  date,
  days_left,
  note
from
  reddit_subreddit_banned
where
  subreddit = 'mysubreddit'
order by
  name;

Schema for reddit_subreddit_banned

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
date	timestamp with time zone		Time when the subreddit was created.
days_left	bigint		Days left in the ban.
id	text		ID of the banned user.
name	text		Name of the banned user.
note	bigint		Note for the ban.
rel_id	text		ID of the ban.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subreddit	text	=	Subreddit for the ban.
username	text	=, !=, ~~, ~~, !~~, !~~	The authorized username.

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_subreddit_banned