List of Teams by Year Created?

Hey CD,

I need a little bit of help from ya’ll today. I’m putting together a little statistics project where @Mink and I are looking to see which year a team is created results in the highest current ELO. We were looking for a complete list of teams by the year they were founded. We started by manually finding them on Blue Alliance but quickly found out that would be far more work then it’s worth.

Does anybody know of a place I can find a list of teams by year founded? If not, does anyone know the first and last team founded from every year?

Thanks for the help!

-Eric Kline

This would be a great use of the TBA API for getting that info.

4 Likes

Check out the TBA API. It’s a great way to get any of the info they have on there, and a quick, small program could grab the year founded for every team quite easily!

And if you don’t want to pull it from the API, it’s available here as a CSV file.

2 Likes

@Mark_McLeod has possibly a more accurate list than the TBA/FIRST API. Possibly. TBA isn’t effective before permanent numbers in 1999; Mark has those teams cross-referenced if they competed before then as I recall.

2 Likes

The TBA list also doesn’t take into account team splits. It lists 1025 as being formed in 2003; it was really 2008. But because it qualified as a “new veteran team” rather than a rookie, it was assigned a number from the 2003 team series.

1 Like

Here’s a quick sanity check for rookie team years from my records.
In the earliest years FIRST tracked teams by their primary sponsor, not by their school, so some discrepancies exist due to that. I track by their primary schools (or community organization for non-school teams).

Year ---- Rookies
1992 ---- 20,45,97,99,111,125,126,131,146,148,151,157,181,190,191,213,224,681/2047,760
1993 ---- 73,129,184,266,811,2479
1994 ---- 6,36,80,81,83,90,98,144,155,239,500,2621
1995 ---- 14,23,37,42,43,55,61,72,74,100,108,110,120,141,161,166,171,173,177,562
1996 ---- 8,12,13,16,26,28,33,47,58,69,71,75,85,86,88,105,109,116,121,124,130,138,140,153,158,172,175,176,200,214,319,562,508
1997 ---- 1,3,7,11,15,18,22,24,25,27,31,34,35,41,44,52,56,59,60,62,63,65,76,82/164/207/294/330,87,89,91,92,93,95,96,101,103,106,107,113,114,118,119,122,123,128,133,134,136,137,142,143,145,147,150,152,160,162,178,183,187,192,302,455,508/1124,1185,1817,2414
1998 ---- 2,5,9,10,17,19,21,29,30,32,38,40,46,48,49,50/218,53,54,57,64,66,68,70,77,79,84,94,102,104,112,115,117,127,132,135,139,149,154,159,163,165,167,168,169,170,174,179,180,182,185,186,188,189,194,195,196,197,198,201,202,203,204,205,206
1999 ---- 207 to 336
2000 ---- 337 to 491
2001 ---- 492 to 716
2002 ---- 743 to 999
2003 ---- 1000 to 1238
2004 ---- 1239 to 1497
2005 ---- 1498 to 1708
2006 ---- 1710 to 1978 & 4,39,423,744,1013
2007 ---- 1980 to 2287 & 424,425,1535,1711,1724,1728
2008 ---- 2330 to 2680 & 509,1025,1988
2009 ---- 2702 to 3122 & 216,1729
2010 ---- 3123 to 3423 & 51, 78, 1749, 1754, 2000, 2350, 2392, 2704, 2949
2011 ---- 3450 to 3883 & 156, 244, 2055, 2059, 2087
2012 ---- 3925 to 4410 & 2093, 1774
2013 ---- 4450 to 4859 & 193, 2128, 3562, 3884, 3885, 3953, 4369, 4412
2014 ---- 4900 to 5350 & 265, 746, 1285, 1786,3134,3886,4413,4415,4416,4418,4524
2015 ---- 5400 to 5786 & 283,297,2682,3166,3233,4584,4613,4614,4617,4712,4729,4739,4788,4953,5029,5087,5127,5128,5331,5333
2016 ---- 5800 to 6226 & 199, 1360, 1792, 4763, 4999, 5777
2017 ---- 6300-6771 & 299,747,1374,2708,5058,6239,6240
2018 ---- 6800-7331 & 323,1085,2710,4652,4764, 5787, 6238, 6312
2019 ---- 7400-7913 & 2097,2712,2714,3889,4414,6241,6486
11 Likes

A common thing I’ve seen across both wikipedia and thebluealliance is 148 having won the 1993 championship, is this not true?

Edit: Also, do you have records for which teams that “new veterans” split off from?

I thought this to be the case as well, and FIRST lists 148 as an original and sustaining team. I’m wondering if they split from another team that started in 1992, getting a new team number in the process.

148 is indeed an original team, by sponsor, competing under “E-Systems Inc. & Dallas Christian School” in both 1992 and 1993.

In 1994 E-Systems Inc. added a second team at “Greenville High School” (148).
In 1995 Dallas Christian School got a different primary sponsor.

So, that’s one of the discrepancies I mentioned before due to tracking by schools vs sponsor.
I change the record above to reflect that.

I do have records, but the splits are somewhat buried, and haven’t been vetted.

Numbers weren’t permanent until 1998, and in 1998 they were with their current school, so 148 has always had the same permanent number.

You’re right, for some reason it just slipped my mind that they wouldn’t have had a permanent number at that point. Thanks!

Are they here?

That’s a summation, and is good up to a point, but I haven’t necessarily kept the team split info up to date through this year.

There’s a decent amount of weirdness here as well with 207, 294, and 330.

Edit: whoops, I was looking under the wrong number.

Take a look at the 1997 block.

Mark’s well aware of that weirdness–I’ve brought it up more than once.

1 Like

So, it appears that in 1997:

  • 302 (under a different number) attended the Midwest Regional, played no matches, and won a Judges Award

  • 1817 (under a different number) attended the National Championship, played no matches, and won a Judges Award

Seems the judges back then had an interesting standard.

2 Likes

I remember another award (one not requiring a robot) for a year or two.
Teams could submit and win a particular award at multiple events without regard to if their robot competed there or not.
I’ll have to search through my notes.
Maybe it was for Website or animation?

Are you looking at TBA? It doesn’t have match data for that year: https://www.thebluealliance.com/event/1997il
(and I can’t find working links on https://www.firstinspires.org/team-event-search/event?id=5097 either)