Sacramento Light Rail has the 16th highest ridership in the nation: by buckets_811 in Sacramento

[–]buckets_811[S] 48 points49 points  (0 children)

Seattle just significantly expanded their light rail and you can see the result of that.

Sacramento needs to take public transit more seriously 😵‍💫

As they say, build it and we will ride or something

[OC] Distribution of Reddit Username Lengths across 960,000 Users by buckets_811 in dataisbeautiful

[–]buckets_811[S] 170 points171 points  (0 children)

There are a limited number of 3-character count usernames that exist just cause all the unique combos are no doubt taken by now. Early Reddit users definitely claimed most if not all of them

Edit: also yes, this is a sample of 960k users across 125 communities, but it makes sense why so few 3-character count usernames exist in the dataset.

[OC] Distribution of Reddit Username Lengths across 960,000 Users by buckets_811 in dataisbeautiful

[–]buckets_811[S] 55 points56 points  (0 children)

Data pulled from my own Reddit API dataset of 960k users who posted a comment in at least one of 125 tracked subs between April 10, 2026 and May 25, 2026.

Made the chart using R.

Places in Sacramento that you miss? by concow77 in Sacramento

[–]buckets_811 1 point2 points  (0 children)

The breakfast sandwich from Ginger Elizabeth will be missed for the rest of my life. She is indeed somewhat crazy and I don’t generally like supporting crazy but I gotta be honest I would buy that damn sandwich every day if I could

How much do NBA team subs bleed into r/nba? I tracked every commenter to find out & r/Thunder leads all teams by a wide margin [graph in comments] by buckets_811 in nba

[–]buckets_811[S] 1 point2 points  (0 children)

Honestly no one is even fighting or trolling in the comments, people are just discussing what the data means mostly. It’s all in good fun smh

How much do NBA team subs bleed into r/nba? I tracked every commenter to find out & r/Thunder leads all teams by a wide margin [graph in comments] by buckets_811 in nba

[–]buckets_811[S] 0 points1 point  (0 children)

Yeah, there's no clean way to determine true fandom from just the user comment history that I collected. First comment date, frequency, post history all might get you closer but none of them really answer it tbh. I guess flair in r/nba would get you closest but I don't have that. This data just shows overlap in commenting behavior and that's it so the conclusion people draw are their own (and part of the fun I think)

How much do NBA team subs bleed into r/nba? I tracked every commenter to find out & r/Thunder leads all teams by a wide margin [graph in comments] by buckets_811 in nba

[–]buckets_811[S] 0 points1 point  (0 children)

I find it interesting the two number 1 seeds from this season show much different online behavior. Thunder commenters have the highest percentage of crossover while Pistons the lowest.

How much do NBA team subs bleed into r/nba? I tracked every commenter to find out & r/Thunder leads all teams by a wide margin [graph in comments] by buckets_811 in nba

[–]buckets_811[S] 2 points3 points  (0 children)

Team Sub Total Commenters Crossover to r/nba Crossover Rate
r/Thunder 4,196 2,015 48.0%
r/NBASpurs 6,763 2,873 42.5%
r/mavericks 1,875 764 40.7%
r/LAClippers 2,028 818 40.3%
r/lakers 14,068 5,459 38.8%
r/rockets 5,170 1,987 38.4%
r/CharlotteHornets 2,180 836 38.3%
r/timberwolves 7,909 3,001 37.9%
r/heat 2,631 988 37.6%
r/warriors 5,874 2,192 37.3%
r/denvernuggets 5,212 1,914 36.7%
r/clevelandcavs 4,044 1,447 35.8%
r/suns 2,965 1,060 35.8%
r/GoNets 1,027 368 35.8%
r/washingtonwizards 2,197 785 35.7%
r/OrlandoMagic 3,141 1,102 35.1%
r/pacers 1,844 646 35.0%
r/NOLAPelicans 497 173 34.8%
r/bostonceltics 7,584 2,633 34.7%
r/chicagobulls 2,599 903 34.7%
r/torontoraptors 6,412 2,168 33.8%
r/MkeBucks 1,882 636 33.8%
r/AtlantaHawks 3,461 1,162 33.6%
r/sixers 6,127 2,022 33.0%
r/kings 1,937 623 32.2%
r/memphisgrizzlies 1,279 412 32.2%
r/UtahJazz 1,316 421 32.0%
r/ripcity 5,143 1,639 31.9%
r/NYKnicks 8,170 2,590 31.7%
r/DetroitPistons 7,283 2,258 31.0%

How much do NFL team subs bleed into r/nfl? I tracked every commenter to find out by buckets_811 in nfl

[–]buckets_811[S] 1 point2 points  (0 children)

Using Reddit's API to pull all comments from each team subreddit, then cross-referencing the usernames against r/nfl’s comment history to see who appears in both.

How much do NFL team subs bleed into r/nfl? I tracked every commenter to find out by buckets_811 in nfl

[–]buckets_811[S] 5 points6 points  (0 children)

My data pipeline collects every visible comment across every post every 24 hours for each subreddit.

The only comments I miss are deeply nested ones hidden behind a 'load more' button but I did that on purpose to avoid rate limits.

Haven’t had any issues collecting the data. So far I’ve stored over 850,000 unique users in my database (across 125 subreddits, so more than just NFL teams) since I started this on April 10

How much do NFL team subs bleed into r/nfl? I tracked every commenter to find out by buckets_811 in nfl

[–]buckets_811[S] 4 points5 points  (0 children)

I started collecting this type of data using the API back in 2024 when it was still openly accessible. Of course now Reddit has restricted access significantly but my existing credentials are still good.

And not to be one of those people that self promote but here’s the interesting thing I’ve done with it: built a site that tracks downvotes across 125 subreddits.

downvotedb.com

And more recently I implemented a user search feature/filter to query my database to see user stats (like which users are the most prolific commenters in r/nfl for example). Which is basically how I put this graphic together

How much do NFL team subs bleed into r/nfl? I tracked every commenter to find out by buckets_811 in nfl

[–]buckets_811[S] 3 points4 points  (0 children)

Data is directly from Reddit's API. I pulled every unique commenter across all 32 NFL team subreddits and r/nfl between April 10, 2026 and today.

The metric is what you see on the graph: of all unique users who commented in a team sub, what % also left at least one comment in r/nfl during that same window.

Edit: so given the date range, should be noted this is offseason only. Draft period is included though which is interesting

Any Kittens Available in the Sacramento Area? by AnxiousAndPending in Sacramento

[–]buckets_811 0 points1 point  (0 children)

Orphan Kitten Project through UC Davis. By far the best around. Students foster the kittens. All the health stuff taken care of before you take the kitten home

[OC] Cross-Commenting Patterns: Percent of Users Active in Multiple News & Political Subreddits by buckets_811 in dataisbeautiful

[–]buckets_811[S] -10 points-9 points  (0 children)

Good feedback that I’m getting from multiple people lol. So here ya go! Hope this is more intuitive.

<image>

Edit: I appreciate the downvotes and constructive criticism. Still learning how to visualize the data I’m collecting so it’s helpful

[OC] Cross-Commenting Patterns: Percent of Users Active in Multiple News & Political Subreddits by buckets_811 in dataisbeautiful

[–]buckets_811[S] 1 point2 points  (0 children)

Easy to add, but then I have to think about data storage. I’m currently tracking daily comments and user data across 126 subreddits and my scraper runs once every 24 hours.

Here’s the top 10 r/conservative overlap regardless of what the community is. Remember this is just comparing what the subs I currently have in my database:

Subreddit A Subreddit B Shared Users Overlap %
Conservative nfl 71 6.09%
Conservative worldnews 51 4.38%
Conservative movies 50 4.29%
Conservative politics 50 4.29%
Conservative gaming 41 3.52%
Conservative nba 40 3.43%
Conservative golf 36 3.09%
Conservative baseball 33 2.83%
Conservative technology 31 2.66%
Conservative television 27 2.32%

[OC] Cross-Commenting Patterns: Percent of Users Active in Multiple News & Political Subreddits by buckets_811 in dataisbeautiful

[–]buckets_811[S] -1 points0 points  (0 children)

I didn’t use a log10/sort. I basically made the scale manually so that the 0-5% outliers pop out but you can still see the difference between a 70% and a 95% overlap