Table: reddit_popular_subreddit - Query Reddit Popular Subreddits using SQL

Popular Subreddits on Reddit are the most active and trending communities that are categorized based on various topics of interest. These subreddits have a large number of active users and posts, making them a rich source of discussions and information. They cover a wide range of topics, from news and current events to specific interests like technology, movies, music, and more.

Table Usage Guide

The reddit_popular_subreddit table provides insights into the most popular subreddits on Reddit. As a data analyst or social media marketer, you can explore subreddit-specific details through this table, including the number of active users, post frequency, and community engagement. Utilize it to uncover information about trending topics, user behavior, and the popularity of various interests, which can be valuable for market research and trend analysis.

Important Notes

Limited to the top 500 results.

Examples

Top subreddits by popularity

Discover the most popular subreddits based on their subscriber count, which allows you to understand the trending topics and areas of interest among Reddit users.

select
  rank,
  display_name_prefixed,
  title,
  subscribers
from
  reddit_popular_subreddit
order by
  rank;

select
  rank,
  display_name_prefixed,
  title,
  subscribers
from
  reddit_popular_subreddit
order by
  rank;

Schema for reddit_popular_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.
rank	bigint	Rank of the subreddit among the result rows, use for sorting.
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_popular_subreddit