All the FRC Teams That Ever Were

[monkeymel1003]

Hmm either I phrased that weird or I didn't understand your post properly
I meant that 1455 and 487 are past team numbers of 423, but are not listed as such. I meant that I wasn't sure if they would be lisited as past numbers since the 2 teams combined to make 423.

[EricH]

Originally Posted by monkeymel1003

Hmm either I phrased that weird or I didn't understand your post properly
I meant that 1455 and 487 are past team numbers of 423, but are not listed as such. I meant that I wasn't sure if they would be lisited as past numbers since the 2 teams combined to make 423.

Think it was the phrasing... Mark, I'm looking forward to revision 1.

22 and 4 have the same situation, and are linked in the sheet.

[Heretic121]

1 minor change... 38 was from woodbury ct =D

and 2836 was team 38... just 2 years removed...

[Nica F.]

Thank you for sharing this, I think it is really interesting to read through.

A thought on:

Originally Posted by Mark McLeod

[*]All FRC Teams Ever is a combined list[/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.

I think that the column on linked teams is what many will be most interested to see and I think that differentiating between teams "split into" or "old team" would be a great place to start. It may cause a lot of confusion to do otherwise (I do realize this is a work in progress, just sharing my thoughts). For example, I wouldn't say that team 4 was ever team 22's past team number. As Eric pointed out 22 is the "parent" and a way to distinguish parent-child / former team # would be a great revision.

Something else I would like to suggest is a way to make it so you know which team numbers were reassigned. i.e. Team 4 was assigned the number in 2006, and something some people aware of this might want to know is whether or not there was a team with that number before(Sorry for using team 4 as a constant example but its the only one I'm completely knowledgeable about)?

[Akash Rastogi]

Mark, I love this type of information that you put together, it has influenced me to do a lot of different things in the past few months. Thank you.

[Chris is me]

Team 1714's name is a little out of date; we're no longer sponsored by NASA nor Team 1675.

(and it would be so fun to say "We're sponsored by UPS" )

Our current name should read: Quad Tech / Rockwell Automation / Siemens / Ladish Co. / Milwaukee SPE / Marquette University / American Nuclear Society RRSD / MSOE / GE Volunteers / ABB / American Acrylics USA LLC & Thomas More High School

[Jared Russell]

341 no longer has any association with Ortho-McNeil Pharmaceutical (and we haven't for several years).

Thanks for the list!

[McGurky]

nice!! although, our team is now based out of DePere High school, WI and all of our sponsors have changed to

[GaryVoshol]

It appears that several team names were gleaned from older versions of FIRST data, and sponsorships and/or HS names have changed.

ThunderChickens are indeed usually listed as being from Utica, as that is the school system. However their physical address may be Sterling Hts.

Team 264 would have been from Shelby Twp, not Shelby (two different communities in MI).

Mark, do you want information on the missing numbers? For instance, 2331 was the original number assigned to 1025 before it was determined that 1025 was not a rookie.

[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.

[smurfgirl]

I'm impressed by this list. I've always wanted to do something like this, but I don't think I know the appropriate resources (nor would it be the best use of my time at this point in my life). This is really interesting, thanks for putting it together.

As others have mentioned, some of the team information is outdated- 1124 is sponsored by UTC Fire & Security and Avon High School (as opposed to cheetahlearning.com). Still, I'm incredibly impressed by the list, and will probably spend a great deal of time looking at it once finals have passed. I just learned that there was a team founded in 1997 in my hometown, which outdates the current team whose rookie year was in 2003. I don't know if anyone connected to the current team had any idea that another school in our town ever had a team. This is fascinating. Thank you so much for your work on this resource.