All the FRC Teams That Ever Were

[Mark McLeod]

Here's one of those side projects that occasionally crop up when I should be doing spring cleaning around the house.

I extracted as complete a list as I could from our various spreadsheets and databases of all the FRC teams that have existed.
http://www.team358.org/files/frc_rec...Teams_Ever.xls

The list still needs vetting so I imagine it'll change a bit, especially if some of you old veterans feed comments back to me. I don't expect I'll hear much, especially in the off-season, but every insight is appreciated.

This spreadsheet has three tabs:

• Unnumbered Teams are those early teams who couldn't be associated with a later numbered team
• Numbered teams are just everybody from 1998 on
• All FRC Teams Ever is a combined list

The combined list has an additional column where I need the most help.
It relates current teams with other numbers they have had in the past, teams they have split off from/to, or combined with, what have you.

Raw numbers are 2623 teams, but 50 to 100 of these might be essentially multiple numbers that represent a single team.

[Billfred]

One omission I noticed: 803 out of South Carolina. (But man, I didn't realize how many teams used to exist around here!)

Also, some notes on the all-ever sheet: 91 (who I'd never heard of) would eventually lead to 507 (Carolina Academy) and 281 (JL Mann). 392 (Clover HS) would eventually field 1539.

[Zflash]

Originally Posted by Billfred

One omission I noticed: 803 out of South Carolina. (But man, I didn't realize how many teams used to exist around here!)

Also, some notes on the all-ever sheet: 91 (who I'd never heard of) would eventually lead to 507 (Carolina Academy) and 281 (JL Mann). 392 (Clover HS) would eventually field 1539.

Actually 91 (which is no longer in existence) gets credit for parenting many teams in SC. 281 was created from 91 when more schools were added to the mix. Later as things grew bigger for 281, groups of other schools and mentors decided it was time to start there own teams. A mentor on 281 broke off and started 343, other mentors broke off and started 415 (also no longer in existence). Later one of the founding mentors of 91 along with some of the mentors that were on 281 started 507 (also no longer in existence) which was one of the original schools involved with 91. Then some of the mentors on 507 started team 1319. Then 1319 started team 2751. So long story short team 91 takes the credit for bringing FIRST to the upstate of SC.

[Joe J.]

Awesome.

862 used to be 465 before the 2002 season.

[Burmeister #279]

Team 279 is now officially out of Toledo, Ohio and I think its Dana Holding Corporation now. excellent work though =)

[Tim L.]

This is an in depth chart! Good job ! However, one flaw I noticed is that you list as 1351 Archbishop Mitty High School and Gunn High School. It is just Mitty and Meadows Manufacturing.

[EricH]

I'm 90% sure that 330, Hope Chapel Academy, was also on 164, at least for the 1997 season. Also, the team designated as A1 would probably be 164 in that year. (Not sure if that was their number, though... I'll let one of the people that was actually on the team around that time answer that one. Unless 164 was formed the same year as 82/330 from the other teams that had been on that alliance of schools...)

[Joe Ross]

Originally Posted by EricH

I'm 90% sure that 330, Hope Chapel Academy, was also on 164, at least for the 1997 season. Also, the team designated as A1 would probably be 164 in that year. (Not sure if that was their number, though... I'll let one of the people that was actually on the team around that time answer that one. Unless 164 was formed the same year as 82/330 from the other teams that had been on that alliance of schools...)

A1 in '97 became 82 and 164 in '98. 82 became 330 in '99, and 164 became 207 and 294 in '99.

I believe the team right below A1 became 100.

[Mark McLeod]

Thanks for the inputs!
Some of what you've mentioned has jogged my memory about other similar circumstances, so I've gone back looking for those missing links too.

I'm adding in the team relationships you've all provided. I'll keep updating the file linked to in the original post and add a revision number to the Notes. I'll post an update this evening if you want to grab a new version tomorrow.

Some of you have noted that your team name, sponsor, school, etc. are incorrect. What I did was pull the name of your team as it was first incorporated (or the earliest data I could find), not what it may be today. Teams know where they are today, but may not know where they came from. Some of you will be surprised to learn of other schools that started along with your team. That may also be why the location is different than today's. Some Team Leaders obviously entered the information incorrectly in TIMS (a couple of teams had full mailing addresses in there ).
I do want to hear about school changes though.

I will expand the list of original un-numbered teams because they aren't all here. I was doing something else and started removing them if they could be associated with a later school, but I should have left them all alone and give them A1 kind of designations.

• I have a separate spreadsheet that contains rosters for every year and you can track team sponsors and school changes over the years there. Every un-numbered team and numbered team is listed.
• I have yet another spreadsheet that tracks the teams through the years, from un-numbered in 1992 to temporary numbers in 1997 and permanent ones starting in 1998.

If anyone wants to see those let me know and I'll link them. I don't want to overload people though. We actually have a webpage dedicated to this stuff, but all the spreadsheets are changing.

Our webmaster is designing an updated database structure to let us add more of this information to make it searchable. That's a summer project.

Nica:

I'll think of a way to reflect team relationships in that extra column. Maybe color coded - 1)parent, 2)child, 3)same team/new number.

FYI, No team number has ever been reassigned. Numbers have followed schools or primary sponsors.

[Nica F.]

Originally Posted by Mark McLeod

FYI, No team number has ever been reassigned. Numbers have followed schools or primary sponsors.

Oh, I was actually wondering about cases in which newer teams were assigned low numbers. Like my example from my previous post: HTHLA got the team number 4 in 2006, was there another team with that number before that just retired or was it just a dead number? (I hope I'm making sense?)

I know that I've read of a few more of these cases of teams splitting and "child" teams getting lownumber yyy in opposed to getting rookie number xxxx. I can't really name any at the top of my head at the current moment though.

[EricH]

Originally Posted by Mark McLeod

FYI, No team number has ever been reassigned. Numbers have followed schools or primary sponsors.

You sure about that, Mark? I seem to remember a member of one team saying on CD that they'd gotten the number of another team (reassigned) after that team folded. I don't think they shared the same school or the same sponsor.

[Mark McLeod]

Originally Posted by Nica F.

Oh, I was actually wondering about cases in which newer teams were assigned low numbers. Like my example from my previous post: HTHLA got the team number 4 in 2006, was there another team with that number before that just retired or was it just a dead number? (I hope I'm making sense?)

I know that I've read of a few more of these cases of teams splitting and "child" teams getting lownumber yyy in opposed to getting rookie number xxxx. I can't really name any at the top of my head at the current moment though.

These teams have all received earlier numbers than their starting year would warrant. None of these numbers had an earlier team associated with them. They are all "holes" in the team number assignments, or "dead numbers" as you call them. Back in 1997 it looks like FIRST allocated the numbers based on who they expected would play that year, but for whatever reason those teams never showed up. Since 1998 when the age of permanent team numbers began, no one else has ever competed as team number 4.
Now in 1997 permanent team #6 (Washburn High School, Hopkins, MN) used the temporary number 4, but I wasn't counting that. That only confuses things.

2006: 4,39,423,744,1013
2007: 424,425,1535,1711,1728
2008: 509,1025,1988
2009: 216,1729

Originally Posted by EricH

You sure about that, Mark? I seem to remember a member of one team saying on CD that they'd gotten the number of another team (reassigned) after that team folded. I don't think they shared the same school or the same sponsor.

As far as I can tell from database searches and perusing old competition lists. I started checking for that in 2005, because one of my students was first developing our database on all the teams back then. He was concerned about how to handle duplicate team numbers, but that problem has never actually materialized.

P.S. That could have been a post talking about old temporary team numbers, so the folks from 1996 and 1997 may be saying they used to have such-and-such a number. I treat those like the temporary number you hang on your chest for running the marathon.

[Fyzix Guy]

If it helps, team #1535 is a split from #1596. In 2007, when #1596 grew and split, it was an international team (half American, half Canadian), and the team split along the border. Since the team was registered in the US as a Michigan team (no way to register it as an international team), the American half kept the #1596 designation. Team 1535 (the Canadian half), was given an option to fish for dead numbers and picked 1535 so they could belong in the same rookie year grouping. We still post our winnings from our rookie and second year ('05 & '06), and still cheer on the Instigators whenever we can (harder to do this year with MI closed to us Cannucks).

[Mark McLeod]

Thanks for those details.
That's just the kind of information I'm looking to collect.
I remember when you guys were the only true international team

I'm sure there are more team splits & mergers out there we don't know about...

I'm continuing to find relationships and have been updating the original spreadsheet each day. At the rate I can dedicate to reviewing it it'll be another several weeks before I finish going through it.
Everyone's additions and corrections have been extremely helpful and I thank you for them. The longer range intent is to wrap these team relationships back into our FRC team database to make it searchable, and we anticipate that'll be done over the summer. We're also waiting for the FIRST database to be updated with 2009 awards data so that can be added as well.

We have a web page now dedicated to this kind of stuff at : http://www.team358.org/files/frc_records/index.php
That page has links to original prime data sources found via the Wayback Machine and on Chief Delphi threads.

[ClareG]

226 is Troy High School AND Troy Athens High School.