FIRST records

[ATannahill]

Mark, is that from the team pages or the archived awards pages? Isn't it true that some team pages are missing awards?

[Mark McLeod]

Different source of data.

This is from our own database we've been maintaining for about 5 years.
We have teams and awards that are missing from the current FIRST team database.

That doesn't mean that there aren't errors in our database too. They are just different mistakes.

This was just what I could knock out in a few minutes via a database query. Our database is undergoing redesign, so we have additional data that just hasn't been added to the main database. The redesign is why 2009 data wasn't readily available to sort by team number.

The 2009 FIRST event awards pages are missing for several competitions, but the team data has some of those missing awards.
And I've seen team pages that were incorrect too.

P.S.
It's probably pretty simple to calculate awards/year just because I have team years in a spreadsheet already. Awards/event requires some interesting merging of two data sources: events-by-team and this awards-by-team.

[Arefin Bari]

Originally Posted by Chris is me

I respectfully disagree. (68 2003)

That being said, I don't know 190's 08 robot nor have I been able to find anything about it.

Anybody have a video of their robot in action?

[Molten]

Originally Posted by Arefin Bari

Anybody have a video of their robot in action?

If I recall, it was never allowed to use it in a match. But I've just read about it.

[NickE]

Originally Posted by Molten

If I recall, it was never allowed to use it in a match. But I've just read about it.

Are you referring to 68 or 190. I'm not sure about the former, but 190 was certainly allowed in many matches, including the entire Silicon Valley Regional.

[Nuttyman54]

Originally Posted by NickE

Are you referring to 68 or 190. I'm not sure about the former, but 190 was certainly allowed in many matches, including the entire Silicon Valley Regional.

I would love to see some video of this 68 robot, it sounds epic.

190 was ruled legal during BAE and SVR, and was only after SVR that we were informed that our strategy would draw penalties if we attempted it at championships.

[Peter Matteson]

Originally Posted by Billfred

Not quite--33 was #1 on Archimedes in 2004, picked 60 and 1241, and was promptly knocked out in two matches in the quarters by 121, 237, and 386.

This was also done in 2004 on Galileo when 177, 27, and 365 beat the one seed and lost in the division finals to 469's championship finalist alliance.

[Mark McLeod]

Here are the teams that have won the most of each of the following awards and the number of times they have won.

Team --- # Wins --- Award
71 Team ---- 7 --- #1 Seed
103 Team --- 2 --- Autodesk Inventor Award
103 Team --- 8 --- Autodesk Visualization Award
192 Team --- 8 --- Autodesk Visualization Award
16 Team ---- 4 --- Chairman's Award Finalist
191 Team --- 2 --- Chairman's Award Winner
111 Team --- 2 --- Championship Finalist
254 Team --- 2 --- Championship Finalist
71 Team ---- 4 --- Championship Winner
33 Team ---- 5 --- Delphi "Driving Tomorrow's Technology"
357 Team --- 5 --- Delphi "Driving Tomorrow's Technology"
71 Team ---- 5 --- Division Champion
1305 Team -- 5 --- Engineering Inspiration Award
330 Team --- 5 --- GM Industrial Design
343 Team --- 5 --- GM Industrial Design
2337 Team -- 3 --- Highest Rookie Seed
365 Team --- 7 --- Imagery
107 Team --- 5 --- J&J Sportsmanship
191 Team --- 5 --- J&J Sportsmanship
217 Team --- 5 --- J&J Sportsmanship
68 Team ---- 6 --- Judges' Award
103 Team -- 13 --- KPC&B Entrepreneurship
67 Team ---- 7 --- Leadership in Controls
27 Team ---- 6 --- Motorola Quality
60 Team ---- 6 --- Motorola Quality
207 Team --- 6 --- Motorola Quality
236 Team --- 6 --- Regional Chairman's Award
254 Team -- 16 --- Regional Champion
16 Team ---- 6 --- Regional Finalist
118 Team --- 6 --- Regional Finalist
368 Team --- 6 --- Regional Finalist
375 Team --- 6 --- Regional Finalist
48 Team ---- 7 --- Safety Award
88 Team ---- 5 --- Team Spirit Award
234 Team --- 8 --- Website Design Award
357 Team --- 3 --- Woodie Flowers Regional Award
365 Team --- 3 --- Woodie Flowers Regional Award
1114 Team -- 3 --- Woodie Flowers Regional Award
190 Team --- 6 --- Xerox Creativity

[Carol]

Originally Posted by Mark McLeod

Here are the teams that have won the most of each of the following awards and the number of times they have won.

Team --- # Wins --- Award
71 Team ---- 7 --- #1 Seed
103 Team --- 2 --- Autodesk Inventor Award
103 Team --- 8 --- Autodesk Visualization Award
192 Team --- 8 --- Autodesk Visualization Award
16 Team ---- 4 --- Chairman's Award Finalist
191 Team --- 2 --- Chairman's Award Winner
111 Team --- 2 --- Championship Finalist
254 Team --- 2 --- Championship Finalist
71 Team ---- 4 --- Championship Winner
33 Team ---- 5 --- Delphi "Driving Tomorrow's Technology"
357 Team --- 5 --- Delphi "Driving Tomorrow's Technology"
71 Team ---- 5 --- Division Champion
1305 Team -- 5 --- Engineering Inspiration Award
330 Team --- 5 --- GM Industrial Design
343 Team --- 5 --- GM Industrial Design
2337 Team -- 3 --- Highest Rookie Seed
365 Team --- 7 --- Imagery
107 Team --- 5 --- J&J Sportsmanship
191 Team --- 5 --- J&J Sportsmanship
217 Team --- 5 --- J&J Sportsmanship
68 Team ---- 6 --- Judges' Award
103 Team -- 13 --- KPC&B Entrepreneurship
67 Team ---- 7 --- Leadership in Controls
27 Team ---- 6 --- Motorola Quality
60 Team ---- 6 --- Motorola Quality
207 Team --- 6 --- Motorola Quality
236 Team --- 6 --- Regional Chairman's Award
254 Team -- 16 --- Regional Champion
16 Team ---- 6 --- Regional Finalist
118 Team --- 6 --- Regional Finalist
368 Team --- 6 --- Regional Finalist
375 Team --- 6 --- Regional Finalist
48 Team ---- 7 --- Safety Award
88 Team ---- 5 --- Team Spirit Award
234 Team --- 8 --- Website Design Award
357 Team --- 3 --- Woodie Flowers Regional Award
365 Team --- 3 --- Woodie Flowers Regional Award
1114 Team -- 3 --- Woodie Flowers Regional Award
190 Team --- 6 --- Xerox Creativity

Very interesting! Thanks for putting this together.

Unless otherwise stated, are these award counts combined regional/championship awards? For instance, I know 365 has won Imagery at Championship and at several regionals, so is the 7 the total number at both or just at the regional level?

How many of these awards are no longer given? Chairman's finalist is one that I noticed.

[EricH]

I'm pretty sure it's regional and championship. 330 only has 2 awards at championship, not counting competition-based awards, and only one of those is the Industrial Design; we're listed as having 5 of those, which would mean 4 regional and one Championships.

[Mark McLeod]

Originally Posted by Carol

Unless otherwise stated, are these award counts combined regional/championship awards? For instance, I know 365 has won Imagery at Championship and at several regionals, so is the 7 the total number at both or just at the regional level?

How many of these awards are no longer given? Chairman's finalist is one that I noticed.

Yes, I collapsed some Regional/Championship awards, such as Imagery, into one generic category. Some of the awards with name changes, e.g., Leadership in Controls & Creativity, also were given a generic name.

There are some mistakes in this list too, so take it with a grain of salt.

I had a big long list of awards that are no longer given that I cut off this list. I just kept a couple of interesting ones around. I also dropped the Rookie awards, but some teams did win multiples of those too.

The original awards spreadsheet I posted earlier has all the old names and separations.

[Francis-134]

Originally Posted by Mark McLeod

Here are the teams that have won the most of each of the following awards and the number of times they have won.

Team --- # Wins --- Award
71 Team ---- 7 --- #1 Seed
103 Team --- 2 --- Autodesk Inventor Award
103 Team --- 8 --- Autodesk Visualization Award
192 Team --- 8 --- Autodesk Visualization Award
16 Team ---- 4 --- Chairman's Award Finalist
191 Team --- 2 --- Chairman's Award Winner
111 Team --- 2 --- Championship Finalist
254 Team --- 2 --- Championship Finalist
71 Team ---- 4 --- Championship Winner
33 Team ---- 5 --- Delphi "Driving Tomorrow's Technology"
357 Team --- 5 --- Delphi "Driving Tomorrow's Technology"
71 Team ---- 5 --- Division Champion
1305 Team -- 5 --- Engineering Inspiration Award
330 Team --- 5 --- GM Industrial Design
343 Team --- 5 --- GM Industrial Design
2337 Team -- 3 --- Highest Rookie Seed
365 Team --- 7 --- Imagery
107 Team --- 5 --- J&J Sportsmanship
191 Team --- 5 --- J&J Sportsmanship
217 Team --- 5 --- J&J Sportsmanship
68 Team ---- 6 --- Judges' Award
103 Team -- 13 --- KPC&B Entrepreneurship
67 Team ---- 7 --- Leadership in Controls
27 Team ---- 6 --- Motorola Quality
60 Team ---- 6 --- Motorola Quality
207 Team --- 6 --- Motorola Quality
236 Team --- 6 --- Regional Chairman's Award
254 Team -- 16 --- Regional Champion
16 Team ---- 6 --- Regional Finalist
118 Team --- 6 --- Regional Finalist
368 Team --- 6 --- Regional Finalist
375 Team --- 6 --- Regional Finalist
48 Team ---- 7 --- Safety Award
88 Team ---- 5 --- Team Spirit Award
234 Team --- 8 --- Website Design Award
357 Team --- 3 --- Woodie Flowers Regional Award
365 Team --- 3 --- Woodie Flowers Regional Award
1114 Team -- 3 --- Woodie Flowers Regional Award
190 Team --- 6 --- Xerox Creativity

Additionally, team 131 has won three regional WFA's: Dave Kelso, Andy Grady and Kristen Kelso (this past year).

Regardless, this is some of the best data I have seen. Great work!

[Mark McLeod]

Originally Posted by Francis-134

Additionally, team 131 has won three regional WFA's: Dave Kelso, Andy Grady and Kristen Kelso (this past year).

Yea, you have to add 2009 to this. I haven't done that yet.
I plan on going through all of this awards data in the next couple of days looking to catch and correct the most glaring mistakes. Then I'll add in the 2009 data too.

FIRST doesn't have 2009 event awards data for Midwest, BAE, NJ, or Boston.

[EricH]

Originally Posted by Mark McLeod

FIRST doesn't have 2009 event awards data for Midwest, BAE, NJ, or Boston.

The Fantasy FIRST scoring sheets do, I believe. They were collected either the day of the event or in the week after when teams were missing. They're in CD-Media at http://www.chiefdelphi.com/media/papers/2219; use the top Excel file.

[Peter Matteson]

Originally Posted by Mark McLeod

Here are the teams that have won the most of each of the following awards and the number of times they have won.

Team --- # Wins --- Award
71 Team ---- 7 --- #1 Seed
103 Team --- 2 --- Autodesk Inventor Award
103 Team --- 8 --- Autodesk Visualization Award
192 Team --- 8 --- Autodesk Visualization Award
16 Team ---- 4 --- Chairman's Award Finalist
191 Team --- 2 --- Chairman's Award Winner
111 Team --- 2 --- Championship Finalist
254 Team --- 2 --- Championship Finalist
71 Team ---- 4 --- Championship Winner
33 Team ---- 5 --- Delphi "Driving Tomorrow's Technology"
357 Team --- 5 --- Delphi "Driving Tomorrow's Technology"
71 Team ---- 5 --- Division Champion
1305 Team -- 5 --- Engineering Inspiration Award
330 Team --- 5 --- GM Industrial Design
343 Team --- 5 --- GM Industrial Design
2337 Team -- 3 --- Highest Rookie Seed
365 Team --- 7 --- Imagery
107 Team --- 5 --- J&J Sportsmanship
191 Team --- 5 --- J&J Sportsmanship
217 Team --- 5 --- J&J Sportsmanship
68 Team ---- 6 --- Judges' Award
103 Team -- 13 --- KPC&B Entrepreneurship
67 Team ---- 7 --- Leadership in Controls
27 Team ---- 6 --- Motorola Quality
60 Team ---- 6 --- Motorola Quality
207 Team --- 6 --- Motorola Quality
236 Team --- 6 --- Regional Chairman's Award
254 Team -- 16 --- Regional Champion
16 Team ---- 6 --- Regional Finalist
118 Team --- 6 --- Regional Finalist
368 Team --- 6 --- Regional Finalist
375 Team --- 6 --- Regional Finalist
48 Team ---- 7 --- Safety Award
88 Team ---- 5 --- Team Spirit Award
234 Team --- 8 --- Website Design Award
357 Team --- 3 --- Woodie Flowers Regional Award
365 Team --- 3 --- Woodie Flowers Regional Award
1114 Team -- 3 --- Woodie Flowers Regional Award
190 Team --- 6 --- Xerox Creativity

Mark, 177 and 217 also has 5 Division championships, did you just publish lowest team number for ties?