Pulling Team Awards

So, I’ve been looking into how to pull team awards data for the past season, and I was hoping that someone would help light the way a little bit.

First, I checked the The FIRST Alliance API and TBA API and neither of them appear to provide that information?

I tried like into going in event by event, but I don’t know what all of the event specific codes, and evens till, the html parsing would just get ugly.

So, any suggestions?

  • Sunny G.

Team 358 has already compiled that info. You can just grab it from them.
http://team358.org/files/frc_records/AllAwards.xls

They also compiled tons of other information about FRC teams.
http://team358.org/files/frc_records/

Those are some pretty nice sheets, but I would love to have the 2013 records.

I wonder how they build their spreadsheet.

  • Sunny G.

Sorry, I don’t understand. The sheet I linked to you does have the 2013 records.

Ah, so it does. My bad.

I’d still be interested in a automated approach so I can pull from various resources, but this does the job for now.

Thanks,

  • Sunny G.

I’ve been looking into doing the same thing, and haven’t found a better way other than scraping web pages or using an offline database such as the one AGPapa linked.

As far as event codes go, you can find them on the bottom of this page: http://frclinks.frclinks.com/. Remember that for the Championship division pages the full name of the division is used rather than a code.

If you need more ideas, you could try looking through The Blue Alliance’s code to see where they get their data: https://github.com/gregmarra/the-blue-alliance