Dataset Statistics

199,045,343 records across 164 US city subreddits (2019–2025)

9,607,752
Posts
189,437,591
Comments
164
Subreddits
2019–2025
Year Span

Top Subreddits by Records

# Subreddit City Posts Comments Total
1 r/austin Austin, TX 260,523 6,556,122 6,816,645
2 r/losangeles Los Angeles, CA 249,154 6,236,131 6,485,285
3 r/Seattle Seattle, WA 225,236 6,096,389 6,321,625
4 r/Portland Portland, OR 201,715 5,275,118 5,476,833
5 r/chicago Chicago, IL 192,113 4,973,843 5,165,956
6 r/nyc New York, NY 202,736 4,918,731 5,121,467
7 r/bayarea Bay Area, CA 181,513 4,687,260 4,868,773
8 r/boston Boston, MA 188,674 4,569,924 4,758,598
9 r/sanfrancisco San Francisco, CA 179,247 4,248,789 4,428,036
10 r/Denver Denver, CO 181,285 4,111,872 4,293,157
11 r/houston Houston, TX 189,096 3,946,689 4,135,785
12 r/pittsburgh Pittsburgh, PA 153,797 3,679,795 3,833,592
13 r/sandiego San Diego, CA 178,729 3,625,571 3,804,300
14 r/philadelphia Philadelphia, PA 164,580 3,514,725 3,679,305
15 r/Columbus Columbus, OH 153,420 3,341,055 3,494,475

Data Explorer

Ask questions about the dataset. The agent can query the data and generate charts.

AI Data Agent
I can help you explore the Reddit city dataset. Ask me things like "which city has the most comments?" or "show me a bar chart of posts by city" and I'll query the data and visualize it for you.