This is an automated archive made by the Lemmit Bot.
The original was posted on /r/cfb by /u/CaptainScuttlebottom on 2024-01-19 16:31:53.
What is this?
As a side project, I decided to scrape every comment from every game thread this season. I decided to use the data to do a “r/CFB census” to see what I could learn about the different fanbases. I posted the first update here, the second update here, and the third update here. Since the season is over now, this is the final update!
Sorry I’m posting this so late by the way, I’d hoped to do it on the day after the final but other stuff got in the way.
The data
I scraped 1,369 game threads with 2,580,099 total comments. I actually also have the post game threads as well, which expands the total number of comments to 2,911,414. In this post I’m going to keep it limited to the actual game threads like I have been throughout the season, but the post game thread data is included in the interactive full dataset I have below, so you can dig in if you’d like!
Season Summary
To start, here’s a table with the top 25 game threads this year by total comments. Each one is also a link to a little graphic thing summarizing the game thread’s comments, which I think are pretty neat.
| Rank | Thread | Total Comments |
|---|---|---|
| #1 | Michigan vs Alabama | 77,970 |
| #2 | Michigan vs Washington | 75,631 |
| #3 | Ohio State @ Michigan | 64,896 |
| #4 | Washington vs Texas | 56,310 |
| #5 | Colorado State @ Colorado | 52,055 |
| #6 | Washington vs Oregon | 40,720 |
| #7 | Alabama vs Georgia | 39,848 |
| #8 | Florida State vs Georgia | 34,770 |
| #9 | Michigan @ Penn State | 34,702 |
| #10 | Penn State @ Ohio State | 32,793 |
| #11 | Florida State vs Louisville | 32,355 |
| #12 | Ohio State vs Missouri | 28,614 |
| #13 | Colorado @ Oregon | 28,412 |
| #14 | Florida State vs LSU | 26,206 |
| #15 | Iowa vs Michigan | 25,847 |
| #16 | Ohio State @ Notre Dame | 25,801 |
| #17 | Texas @ Alabama | 25,407 |
| #18 | Nebraska @ Colorado | 25,254 |
| #19 | Texas vs Oklahoma | 25,245 |
| #20 | Clemson @ Duke | 25,009 |
| #21 | Texas vs Oklahoma State | 24,467 |
| #22 | Colorado @ TCU | 23,449 |
| #23 | Alabama @ Auburn | 22,145 |
| #24 | Oregon @ Washington | 22,062 |
| #25 | Arizona @ USC | 19,545 |
/r/CFB flair census
To determine each individual user’s affiliation, I took every username that left a comment in a game thread this year, and classified them by their most recent primary flair. I’m going to post the final top 25 below, but I’m also going to include a link to a little interactive tool where you can mess around with the data yourself. There’s a ton of data and the hosting I have isn’t great though, so my apologies if it crashes or is finicky at all.
| Flair census |
|---|
Here are the top 25 active fanbases on r/CFB this season (remember, this is looking at game threads only):
| Rank | Logo | Primary Flair | Unique Users | Total Comments | Comments per User | Avg. Comment Score | Downvote Rate (score < 1) | % of Comments w/ Swears | % of Comments w/ Ref Complaints | Top Poster |
|---|---|---|---|---|---|---|---|---|---|---|
| #1 | Michigan | Michigan | 4,001 | 200,349 | 50.07 | 8.23 | 0.08 | 9.37% | 1.74% | PageOfLite (2,814 comments) |
| #2 | Ohio State | Ohio State | 3,356 | 162,051 | 48.29 | 7.05 | 0.08 | 9.73% | 2.24% | MD90__ (3,663 comments) |
| #3 | /r/CFB | /r/CFB | 2,545 | 35,296 | 13.87 | 8.00 | 0.09 | 10.25% | 2.82% | IEatDeFish (747 comments) |
| #4 | Georgia | Georgia | 2,268 | 139,874 | 61.67 | 8.14 | 0.05 | 11.46% | 2.82% | Competitive-Rise-789 (3,722 comments) |
| #5 | Texas | Texas | 2,142 | 98,941 | 46.19 | 10.27 | 0.06 | 10.64% | 2.7% | cn0285 (2,340 comments) |
| #6 | Alabama | Alabama | 2,067 | 91,723 | 44.37 | 7.16 | 0.08 | 10.87% | 2.88% | ChaseTheFalcon (1,274 comments) |
| #7 | Oklahoma | Oklahoma | 1,593 | 103,370 | 64.89 | 7.53 | 0.06 | 11.36% | 2.99% | The_Soccer_Heretic (2,329 comments) |
| #8 | Florida State | Florida State | 1,413 | 91,415 | 64.70 | 7.03 | 0.06 | 11.17% | 3.03% | Ajp_iii (3,314 comments) |
| #9 | Penn State | Penn State | 1,316 | 51,259 | 38.95 | 9.77 | 0.05 | 8.44% | 2.18% | BikiniATroll (2,302 comments) |
| #10 | Oregon | Oregon | 1,307 | 76,123 | 58.24 | 7.05 | 0.06 | 10.84% | 2.78% | easily_rekt (1,546 comments) |
| #11 | Nebraska | Nebraska | 1,291 | 44,281 | 34.30 | 9.77 | 0.04 | 10.39% | 2.21% | Panchoisthedog (1,231 comments) |
| #12 | Washington | Washington | 1,216 | 57,271 | 47.10 | 8.05 | 0.05 | 10.24% | 2.65% | Pollaski (1,808 comments) |
| #13 | Florida | Florida | 1,203 | 40,046 | 33.29 | 9.42 | 0.08 | 11.07% | 2.91% | RuairiQ (1,004 comments) |
| #14 | Notre Dame | Notre Dame | 1,196 | 56,490 | 47.23 | 9.01 | 0.04 | 10.56% | 2.73% | arrowfan624 (1,235 comments) |
| #15 | Texas A&M | Texas A&M | 1,151 | 47,258 | 41.06 | 8.43 | 0.04 | 10.07% | 2.95% | FightingFarrier18 (1,785 comments) |
| #16 | Tennessee | Tennessee | 1,150 | 46,848 | 40.74 | 7.71 | 0.06 | 12.03% | 3.53% | EWall100 (1,687 comments) |
| #17 | LSU | LSU | 970 | 40,084 | 41.32 | 7.63 | 0.06 | 13.45% | 2.5% | SnooBeans5570 (1,733 comments) |
| #18 | Iowa | Iowa | 951 | 51,041 | 53.67 | 9.32 | 0.04 | 11.19% | 2.54% | elgenie (2,235 comments) |
| #19 | Michigan State | Michigan State | 921 | 38,733 | 42.06 | 6.99 | 0.05 | 9.33% | 1.7% | byniri_returns (1,279 comments) |
| #20 | Clemson | Clemson | 875 | 44,832 | 51.24 | 8.73 | 0.04 | 9.21% | 2.38% | bigmike1877 (2,013 comments) |
| #21 | USC | USC | 871 | 43,566 | 50.02 | 7.40 | 0.06 | 10.05% | 2.07% | eosophobe (1,156 comments) |
| #22 | Wisconsin | Wisconsin | 804 | 26,053 | 32.40 | 8.57 | 0.05 | 9.83% | 2.92% | OldVeterinarian9 (815 comments) |
| #23 | Auburn | Auburn | 772 | 29,811 | 38.62 | 7.97 | 0.05 | 9.46% | 2.11% | Kodyaufan2 (2,818 comments) |
| #24 | South Carolina | South Carolina | 661 | 27,075 | 40.96 | 17.80 | 0.06 | 10.42% | 2.04% | jthomas694 (1,124 comments) |
| #25 | Virginia Tech | Virginia Tech | 642 | 32,294 | 50.30 | 8.69 | 0.03 | 7.54% | 2.4% | themattboard (1,752 comments) |
Michigan wins again! Although we can’t rule out a massive network of sockpuppet accounts masterminded by Connor Stallions.
| Check out the full dataset here |
|---|
LINK TO INTERACTIVE DATASET
You can use the controls at the top of the table to filter the data in various ways, and you can toggle the summary tabs to include / exclude the post game thread data. I tried my best to make it look good on mobile, but I recommend you look at it on a computer or maybe a tablet for best results. Also, there’s quite a bit of data being loaded, so it’s pretty finnicky and you might need to refresh a few times (my hosting isn’t the greatest). Finally, you can download the full datasets with the buttons on each page. Again, lots of data, so give it a sec to load once you click the button.
For a fun time, I recommend filtering to only comments with swears and then just scrolling for a while. It’s like an endless stream of your dad yelling at the Dallas Cowboys on TV every Sunday night when you were a kid.
Next up, the final tallies for the top tens I’ve been doing all along. You can see most of this for yourself in the full dataset, so I also wanted to answer some of the more specific requests I’ve gotten too. For all of these, I’ve set a minimum qualification of at least 75 unique users (bumped up from the 50 I’ve been using so far) and at least 2,500 individual comments throughout the season. I have to set some kind of floor on this unfortunately, or else all the tables would be dominated by outliers with 1-3 comments each. You can adjust the parameters in the full dataset if you’re curious how they change things.
| Top 10 most chatty flair |
|---|
This is measured by the number of comments per unique user made by each flair. Could be thought of as a measure of the most / least engaged fanbase, but it’s sensitive to outliers.
| Rank | Logo | …
Content cut off. Read original on old.reddit.com/…/cfb_flair_census_final_update_sc…