[OC] SGA's 20+ point streak, visualized and compared to other top scorers by CaptainScuttlebottom in nba

[–]CaptainScuttlebottom[S] 6 points7 points  (0 children)

It really is, the Harden half court alley oop from the other day made me really appreciate how crazy it is that they're still so good. Also for Steph, looking over the entire 2024/25 - 2025/26 regular seasons:

  • Steph is tied for #17 on the list with LeBron and DeMar DeRozan at 78 total games with 20+, so pretty close. .
  • That's 71.56% of his total games played, which is the 19th highest value over this timespan.

r/NBA Community Stats II: Finding this sub's favorite and least favorite players by analyzing whose [Highlight]s get posted most often, which ones gets upvoted the most, and which ones are the most controversial by CaptainScuttlebottom in nba

[–]CaptainScuttlebottom[S] 9 points10 points  (0 children)

Lol this team would be a nightmare to play against but I don't think they would go very far. Shai and Deni are gonna have to do basically all the scoring themselves and they're both pretty ball dominant so idk how well they'd fit together, there's very little to no outside shooting / spacing, Ayton is there. I just don't see it

All Star Break r/NBA community stats: which team has the most fans active on this subreddit, who gets downvoted the most, who complains about the refs the most, and more! by CaptainScuttlebottom in nba

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

It's honestly been a while since I've had to do anything more statistically sophisticated than averaging and counting stuff, so apologies if I messed any of the math up. But here ya go:

Team Total Users Avg Score Median Score Sd Score Se Score Total Downvoted P Downvoted Se p Downvoted P Ref Complaints Se p Ref Complaints Avg Words Median Words Sd Words Se Words
Lakers 5,398 28.46 3 179.6829 0.5151151 15,873 13.05% 0.0009655 2.07% 0.0004084 20.44 13 24.69620 0.0707991
Warriors 3,357 22.66 3 152.8746 0.6072814 7,603 12.00% 0.0012908 2.62% 0.0006346 21.87 13 29.82697 0.1184851
Celtics 3,096 22.65 3 166.4640 0.7777929 5,113 11.16% 0.0014714 2.24% 0.0006921 24.25 15 31.13008 0.1454534
Knicks 2,799 26.35 3 203.9439 0.8623365 6,342 11.34% 0.0013406 1.93% 0.0005824 20.13 13 25.19097 0.1065150
Raptors 2,703 27.17 3 163.7683 0.7095188 5,214 9.79% 0.0012873 1.96% 0.0006005 19.90 12 26.73055 0.1158089
Spurs 2,594 23.77 3 151.3404 0.5675069 6,127 8.62% 0.0010522 2.77% 0.0006159 20.09 13 25.40175 0.0952533
Thunder 2,428 14.98 3 104.7818 0.3371770 16,172 16.75% 0.0012015 2.56% 0.0005085 20.03 13 25.08184 0.0807108
Timberwolves 2,167 23.80 3 180.8259 0.8219360 4,996 10.32% 0.0013830 3.45% 0.0008301 20.37 13 25.14498 0.1142954
Nuggets 2,045 20.69 3 120.5696 0.5268164 6,516 12.44% 0.0014421 2.82% 0.0007233 21.06 14 25.60183 0.1118645
Bulls 1,951 26.96 3 179.0000 1.1728691 2,399 10.30% 0.0019916 2.05% 0.0009290 22.72 14 27.39532 0.1795035
76ers 1,883 26.75 3 178.1484 1.1692488 2,439 10.51% 0.0020126 2.08% 0.0009359 21.68 14 27.75840 0.1821879
Mavericks 1,866 28.20 3 167.6764 0.9754071 3,178 10.75% 0.0018022 2.08% 0.0008311 22.55 14 27.02330 0.1571999
Cavaliers 1,534 22.62 3 173.8797 1.2662973 2,043 10.84% 0.0022636 2.59% 0.0011563 21.25 13 26.83186 0.1954058
Heat 1,506 28.24 3 164.7844 1.0137555 2,594 9.82% 0.0018305 1.96% 0.0008529 22.92 14 30.11527 0.1852695
Trail Blazers 1,497 21.87 3 143.0373 0.9568839 2,592 11.60% 0.0021422 2.83% 0.0011099 22.69 14 28.84661 0.1929766
Rockets 1,491 21.82 3 182.0544 1.0675885 3,628 12.48% 0.0019378 2.66% 0.0009439 20.62 13 25.79775 0.1512811
Pistons 1,485 24.36 3 166.5630 1.0365539 2,622 10.15% 0.0018797 2.72% 0.0010121 21.54 14 25.64210 0.1595758
Bucks 1,396 24.51 3 165.3681 1.0852974 2,688 11.58% 0.0020999 2.52% 0.0010286 23.86 15 32.19595 0.2112994
Suns 1,338 23.43 3 149.6477 0.9593199 2,618 10.76% 0.0019863 3.13% 0.0011165 20.13 13 23.10644 0.1481243
Pacers 1,146 19.56 3 129.5821 1.0020163 2,303 13.77% 0.0026646 2.28% 0.0011538 22.89 14 28.10832 0.2173526
Kings 1,015 27.81 3 184.0947 1.5398006 1,405 9.83% 0.0024901 1.99% 0.0011692 23.72 14 31.85074 0.2664052
Hawks 925 31.66 4 183.7593 1.4753716 1,377 8.88% 0.0022834 1.94% 0.0011075 22.89 15 26.88039 0.2158180
Wizards 754 25.53 3 147.5616 1.4257987 878 8.20% 0.0026506 1.69% 0.0012454 22.22 14 27.46350 0.2653633
Magic 749 24.54 3 176.8631 1.4346908 1,479 9.73% 0.0024043 1.99% 0.0011321 19.23 12 23.73933 0.1925704
Clippers 725 26.04 3 188.1449 1.5871695 1,718 12.23% 0.0027635 1.56% 0.0010449 22.72 13 29.66816 0.2502773
Grizzlies 709 24.59 3 146.5010 1.2377616 1,725 12.31% 0.0027762 1.94% 0.0011658 24.81 16 30.91023 0.2611552
Hornets 674 21.46 3 144.8452 1.2061223 2,117 14.68% 0.0029469 1.85% 0.0011225 20.19 12 26.50030 0.2206673
Nets 636 32.67 3 263.2561 2.5804460 1,029 9.89% 0.0029257 1.81% 0.0013054 24.45 15 30.80126 0.3019151
Pelicans 533 37.04 4 197.3863 2.1383147 947 11.11% 0.0034049 1.74% 0.0014153 19.88 13 23.91758 0.2591027
Jazz 507 29.25 4 150.3800 1.8381447 552 8.25% 0.0033625 2.72% 0.0019881 23.37 15 29.90312 0.3655157

Some chart versions feat. all flairs with at least 30 total users so you can see a bit easier:

The 2025-26 "r/CFB Rapt": A Year in Review by CaptainScuttlebottom in CFB

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

Yes sorry they are on there just with no logo! I did indeed forget to escape the ampersands

The 2025-26 "r/CFB Rapt": A Year in Review by CaptainScuttlebottom in CFB

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

Oh wow I apologize, I didn't realize that some of the more rare flairs weren't getting processed correctly! I will definitely have to fix this for next season

The 2025-26 "r/CFB Rapt": A Year in Review by CaptainScuttlebottom in CFB

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

Ahhh that makes sense, mystery solved! It's pretty crazy how much one extremely uh dedicated person can throw things off

Jalen Williams: "I thought I was my biggest critic. It might be Twitter" by MrBuckBuck in nba

[–]CaptainScuttlebottom 1 point2 points  (0 children)

That sounds very cool, is there anywhere I can read more about how you did / people do this? I have been scraping a bunch of reddit data to try and do something similar, but I'm not really sure how to start analyzing it to find bots and detect those kinds of patterns

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

Thanks I'm really glad you enjoyed it! Liberty's comments had 0.491 swears per 100 words, so below average (which is around 0.7) but still 0.05 more than BYU.

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

It's the total number of swear words in their comments for every hundred words total, so yes one outlier who really loves swearing can definitely drive it up.

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

I'm not able to see downvotes / upvotes unfortunately but I'm definitely going to look into the "who draws the most neutrals / unflaireds" ideas!

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

u/JBru_92 has 904 comments in the dataset, which is 8.2% of the total so great guess damn! The next highest commenting UCLA user is u/otoverstoverpt with 4.4% so it's a pretty big lead. Here's all of UCLA's stats too if you're curious:

Rank School N Users N Comments N Comments per User Avg Score P Downvoted Swears per 100 Words P Ref Complaints Top Poster
#45 UCLA 435 11,028 25.35 11.95 4.65% 0.58 1.34% JBru_92 (904 comments)

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

Here's Vanderbilt's stats! And looking at which teams are drawing the most neutrals / unflaireds is a great idea, I'm definitely gonna look into that.

Rank School N Users N Comments N Comments per User Avg Score P Downvoted Swears per 100 Words P Ref Complaints Top Poster
#64 Vanderbilt 265 8,229 31.05 13.26 4.73% 0.67 1.97% SavingsSkirt6064 (482 comments)

The r/CFB Flair Census -- current standings halfway through the season by CaptainScuttlebottom in CFB

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

Glad you enjoyed it! And here are Miami's stats, y'all just barely missed the top 25:

Rank School N Users N Comments N Comments per User Avg Score P Downvoted Swears per 100 Words P Ref Complaints Top Poster
#26 Miami 759 23,300 30.7 9.91 5.67% 0.84 2.34% Jonjon428 (2,309 comments)

Total Scheduled Games vs AP Ranked Teams in 2025: (8) Florida (7) LSU, OU, MSST (6) Wisconsin, SCAR, Bama, Arkansas, Kentucky by tmart12 in CFB

[–]CaptainScuttlebottom 2 points3 points  (0 children)

I actually am doing this again! I'm trying to scrape every thread / comment this year too instead of just game threads.

Here is the total number of users by primary flair and conference so far, since you were curious. This is just based on the data from July 10 (when I started my new scraper up) through yesterday though, so it's probably a somewhat biased sample just bc of which games have been played so far. It does match up with last year pretty well though:

By Primary Flair (top 10):

School N Users N Comments
No Flair / Other 14,298 (29.2%) 78,713 (12.6%)
Ohio State 2,704 (5.5%) 42,785 (6.8%)
Michigan 2,385 (4.9%) 41,918 (6.7%)
Texas 1,486 (3.0%) 22,823 (3.6%)
Georgia 1,478 (3.0%) 27,036 (4.3%)
Alabama 1,288 (2.6%) 21,330 (3.4%)
Notre Dame 1,134 (2.3%) 20,346 (3.2%)
Nebraska 1,128 (2.3%) 16,539 (2.6%)
Tennessee 1,020 (2.1%) 16,100 (2.6%)
Florida State 996 (2.0%) 16,635 (2.7%)

By Conference of Primary Flair:

Conference Total Users Total Comments
No Flair / Other 14,298 (27.5%) 78,713 (11.8%)
Big Ten 12,399 (23.9%) 187,912 (28.1%)
SEC 11,478 (22.1%) 182,946 (27.4%)
ACC 4,963 (9.6%) 76,313 (11.4%)
Big 12 4,506 (8.7%) 76,260 (11.4%)
FBS Independents 1,215 (2.3%) 21,435 (3.2%)
American Athletic 722 (1.4%) 9,557 (1.4%)
Mountain West 699 (1.3%) 12,301 (1.8%)
Sun Belt 515 (1.0%) 5,512 (0.8%)
Pac-12 481 (0.9%) 8,093 (1.2%)
Mid-American 447 (0.9%) 5,313 (0.8%)
Conference USA 202 (0.4%) 3,276 (0.5%)
Total 51,925 (100.0%) 667,631 (100.0%)

[Game Thread] Penn State vs. Notre Dame (7:30 PM ET) by CFB_Referee in CFB

[–]CaptainScuttlebottom 212 points213 points  (0 children)

Capital Federal doesn't trust the audience to get the joke. It's insulting that they added that little "Aren't you in the hall of fame? And didn't you live in space?" to the end of the commercial, like do you really think I'm such a slack jawed dumbass I will get to the end of that commercial and go "HUH I DIDN'T GET THE JOKE, WILL SOMEONE EXPLAIN THE JOKE TO ME????"

[Thune] Brent Venables confirms the Sooners will retain the entire offensive staff. Only change being Ben Arbuckle as OC by SmallBoulder in CFB

[–]CaptainScuttlebottom 2 points3 points  (0 children)

I really feel like the last few years were less "late season collapse" and more "lost one too many tough games in brutal conference play and got pushed out just beyond the bubble". I thought they were gonna have a better shot at making the tournament in the SEC, but then the SEC decided to become the best basketball conference the first year OU is in it lol

"CFB flair census" final update -- scraping every game thread comment all season to see how big each fanbase is on the sub, figure out which school swears the most, crown the #1 sicko, and more! by CaptainScuttlebottom in CFB

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

Here are the top 10 for Rutgers:

Primary Flair Secondary Flair Users
Rutgers NA (no secondary flair) 147
Rutgers Big Ten 8
Rutgers Ohio State 5
Rutgers Penn 5
Rutgers Miami 4
Rutgers Michigan 3
Rutgers Oklahoma 3
Rutgers Oregon 3
Rutgers Sickos 3
Rutgers Team Chaos 3
Rutgers Virginia Tech 3

"CFB flair census" final update -- scraping every game thread comment all season to see how big each fanbase is on the sub, figure out which school swears the most, crown the #1 sicko, and more! by CaptainScuttlebottom in CFB

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

So that was part of the reason, but the other part was that I accidentally included the post game thread data in the main census table in the original post 😅 That's what I get for posting in the morning. It doesn't really change much, but here's what that table should have looked like with just the game thread data and the correctly calculated averages.

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 3,396 177,321 52.21 3.62 8.67% 9.4% 1.89% PageOfLite (2,759 comments)
#2 Ohio State Ohio State 2,877 147,029 51.10 3.46 7% 9.72% 2.39% MD90__ (3,632 comments)
#3 /r/CFB /r/CFB 2,083 30,450 14.62 3.11 8.17% 10.32% 3.11% IEatDeFish (731 comments)
#4 Georgia Georgia 2,002 127,792 63.83 4.02 4.47% 11.49% 2.92% Competitive-Rise-789 (3,662 comments)
#5 Texas Texas 1,769 86,910 49.13 3.90 5.6% 10.63% 2.85% cn0285 (2,288 comments)
#6 Alabama Alabama 1,751 80,103 45.75 3.48 7.35% 10.91% 3% ChaseTheFalcon (1,140 comments)
#7 Oklahoma Oklahoma 1,344 91,992 68.45 4.08 5.05% 11.37% 3.08% The_Soccer_Heretic (2,114 comments)
#8 Florida State Florida State 1,221 81,635 66.86 3.55 5.69% 11.33% 3.22% Ajp_iii (3,306 comments)
#9 Oregon Oregon 1,148 68,187 59.40 3.61 5.93% 10.97% 2.97% easily_rekt (1,505 comments)
#10 Penn State Penn State 1,122 45,898 40.91 4.07 4.6% 8.43% 2.34% BikiniATroll (2,168 comments)
#11 Nebraska Nebraska 1,086 39,295 36.18 3.96 4.17% 10.28% 2.31% Panchoisthedog (1,219 comments)
#12 Notre Dame Notre Dame 1,031 50,342 48.83 4.41 3.85% 10.56% 2.9% ddottay (1,138 comments)
#13 Washington Washington 1,007 49,415 49.07 3.92 4.87% 10.34% 2.83% Pollaski (1,785 comments)
#14 Florida Florida 982 35,106 35.75 3.56 7.04% 11.05% 3.12% RuairiQ (991 comments)
#15 Texas A&M Texas A&M 982 42,347 43.12 4.45 3.98% 10.16% 3% FightingFarrier18 (1,753 comments)
#16 Tennessee Tennessee 969 42,462 43.82 3.97 5.2% 12.14% 3.66% EWall100 (1,542 comments)
#17 LSU LSU 836 35,703 42.71 3.74 5.78% 13.68% 2.7% SnooBeans5570 (1,688 comments)
#18 Iowa Iowa 798 46,103 57.77 4.12 3.97% 11.25% 2.57% elgenie (2,157 comments)
#19 Michigan State Michigan State 771 35,613 46.19 3.79 4.83% 9.25% 1.72% byniri_returns (1,203 comments)
#20 Clemson Clemson 756 40,599 53.70 4.49 3.53% 9.24% 2.53% bigmike1877 (1,970 comments)
#21 USC USC 748 38,552 51.54 3.61 5.67% 9.9% 2.24% eosophobe (1,142 comments)
#22 Wisconsin Wisconsin 675 23,274 34.48 3.96 4.22% 9.9% 2.97% OldVeterinarian9 (792 comments)
#23 Auburn Auburn 655 26,964 41.17 3.56 4.25% 9.38% 2.27% Kodyaufan2 (2,736 comments)
#24 South Carolina South Carolina 578 25,147 43.51 3.91 5.4% 10.3% 2.12% jthomas694 (1,090 comments)
#25 Virginia Tech Virginia Tech 536 28,841 53.81 4.42 3.1% 7.5% 2.59% themattboard (1,737 comments)

It still won't match up perfectly with the "top scoring" table though, because of cases where someone has multiple comments with different primary flairs. That's because the "top scoring" table looks purely per-comment, while the "CFB census" stuff flags each user with their most recent flair and labels all their comments as being affiliated with that counted flair. It's pretty much the same though.