Winningest FRC team of all time??

FIRST General Forum
#41

One thing I love about FRC is seeing younger teams rise to power house status. I call them New Tech, and the teams who have been consistently good for at least a decade are Old Tech.

Some Old Tech Teams would be (There are more, these are just examples)
33
67
118
254
330
1114
2056

All of these teams have been fairly consistently solid throughout their lifespan as a team in FRC.

Then there are the New Tech Teams (Again, just naming a few)

2122
2481
2767
3310
3476
4488

New Tech Teams have started later, but have been building up their knowledge and are at the point where all of them can consistently perform at the high levels of play

Next there is the category of teams who have been around a while, and have done pretty well, but have really hit their stride in the last few (3-4) years.

195
971
1619
1678 (Citrus Circuits to an incredible degree, 20/22 of their blue banners were won in the last 4 years)
1690

There is also the inverse of this, which are teams that were giants, but have since fallen whether it be from loss of mentors, build spaces, or other factors. These teams are still fantastic, and are always one game/mentor/student/sponsor/etc away from having a great season.

71
111
177
217
233

Lastly there are the teams that are always good, but when they get the right combination of factors just knock it out of the park.

469
1241
1625
2338
2826

The point of this is to say that there are so many factors to determine a team being the “winningest”, that it is a poor metric to go by. FRC teams are so dependent on so many different factors that it is impossible to be objective.

(Apologies if I left out any obvious choices on the various lists, being from the Midwest I have an obvious leaning. Feel free to add any teams I may have left off)

#42

I think these lists are flipped. 1678 should be near the top of the 4-year list, not the 10-year list.

#43

Somewhat off-topic: Another concept that comes to mind in the context of “best teams of all time” is whether or not there is a “triple crown” of FRC.

That said, I personally don’t see a true triple crown as there are not three comparable high awards. We have Chairman’s (HOF) and Championship winner (lots of shared ground there, many teams to list). But the other top tier awards are personal, not team Awards, like WFA (which AFAIK the only teams to meet that plus the other two are 365, 67, 16, and 51*) and perhaps Dean’s list (Which I have not thoroughly studied to give a team list).

*- Due to the 47 and 65 merger. HOF though 47, WFA (Ken Patton) and championship win through 65. Both teams were top notch (as is 51), so I’m counting it

That said, at least in the first case (which has a small enough pool for me to comprehend), there are comparatively many teams with two of the legs, and two added this year alone, 2614 and 359 (both have a WFA mentor past or present and also are HOF).

There are other event wins which could be counted; historically there have been events considered as hard if not harder to win than championship (Midwest regional in years past, IRI and Michigan State Championship currently, and FOC this year), but since they don’t have nearly as wide of pool of eligble-to-win teams, winning such is a great accomplishment all right but IMHO not fair to count as the third leg of any triple crown definition.

That said, of the two-leg (HOF + Championship win) teams (“Double Crown” teams?), 67 a bonus for doing so at once, but since that’s practically a one-shot occurrence in the modern day, one could argue that luck is part of such since there have been several near-misses. 842, 1114, 1538, and 987 come to mind (842 and 1538 were division finalists whose elimination was not expected, the others all made Einstein with guns blazing but did not win).

Unfortunately, the double crown doesn’t narrow the list much it seems, as of the teams who seem to get mentioned a lot in this thread, 67, 254, and 1114 are all HOF and championship winners.

Perhaps there actually is no single #1 team here? Not this is at all a bad thing… lots of teams to look up to, which is a good thing (and I don’t think that’s disputable).

#44

TBA only has match data back to 2002. If someone has data going further back that would be awesome. I’m planning on summing match wins from 2002-2017 for the following teams: 254,1114,2056,67,359,125,148,20,190. Any more suggestions?

#45

With all due respect to a great team, 190 isn’t going to be close to in contention for this title.

Notable teams your list misses include 987, 469, 217, 195, 111, 71, 1678, 33, 16, 25, etc. Many of these are teams which have not had as much “flashy” recent success, but they are historically among the very best in the world.

Including match wins in 2003 will mess things up because the system for both quals and elims was not WLT based. Including match wins in 2015 similarly does not make sense.

#46

Dump to database, compute wins, sum all team wins, group by team… why not do all teams? It’s trivially easy for any year that’s not 2015 (which I propose we pretend simply never existed)

#47

Team 358’s history page has some hand-collected data in the form of excel docs for each year: http://team358.org/history/

#48

Would love to see total win results for all teams and maybe winning percentage since many teams only go to one or two events a year ( may be more helpful metric for predictive use going into events with grain of salt consideration?)

#49

2005 - Present
All events in tba-data repos (This means it includes some off season events, the data repos don’t have a handy way to skip these)
Define red win as redScore > blueScore, blue win as blueScore > redScore. Ties are not counted as wins for anyone.

“Winningest”

  team   | wins 
---------+------
 frc67   |  812
 frc1114 |  773
 frc33   |  752
 frc469  |  723
 frc118  |  699
 frc254  |  662
 frc217  |  662
 frc2056 |  651
 frc27   |  605
 frc148  |  583
 frc195  |  559
 frc1678 |  545
 frc330  |  524
 frc1918 |  520
 frc359  |  515
 frc494  |  513
 frc987  |  510
 frc125  |  509
 frc68   |  498
 frc503  |  496
 frc25   |  494
 frc1023 |  491
 frc1519 |  488
 frc70   |  486
 frc48   |  477

Most Likely To Win

  team   |     win_pct      | matches | match_wins 
---------+------------------+---------+------------
 frc2056 | 82.7191867852605 |     787 |        651
 frc1114 | 81.5400843881856 |     948 |        773
 frc254  | 80.3398058252427 |     824 |        662
 frc1678 |  79.100145137881 |     689 |        545
 frc987  | 78.9473684210526 |     646 |        510
 frc1986 |  78.348623853211 |     545 |        427
 frc118  | 76.3100436681223 |     916 |        699
 frc330  | 75.6132756132756 |     693 |        524
 frc4613 | 75.5952380952381 |     168 |        127
 frc971  | 74.9211356466877 |     634 |        475
 frc5172 | 74.6666666666667 |     150 |        112
 frc67   | 74.6323529411765 |    1088 |        812
 frc4488 | 74.1433021806854 |     321 |        238
 frc1519 | 73.0538922155689 |     668 |        488
 frc2970 | 72.9166666666667 |      48 |         35
 frc148  | 72.6932668329177 |     802 |        583
 frc1717 | 72.6027397260274 |     438 |        318
 frc469  |             72.3 |    1000 |        723
 frc1574 | 71.4723926380368 |     326 |        233
 frc359  | 71.2309820193638 |     723 |        515
 frc2122 | 70.4761904761905 |     525 |        370
 frc5553 | 70.4545454545455 |      44 |         31
 frc525  | 70.1525054466231 |     459 |        322
 frc2052 | 70.0534759358289 |     374 |        262
 frc2481 | 70.0258397932816 |     387 |        271

Code to import and recreate all views and queries is available at https://github.com/schreiaj/TBA-Data-SQL

TBA Data is loaded as a git submodule so that may need to be updated from time to time.

I used PG 9.6.

#50