Thread created automatically to discuss a document in CD-Media.
FRC Growth numbers
by: Jon Stratis
A look at how FRC has grown geographically since 1992.
This is a collection of data series and graphs depicting team growth for FRC, broken up geographically. Each US State has its own graph, as does each district, parts of Canada and parts of Israel. The data is there to do break downs for any other country, state, or province that’s desired, but this would quickly spiral out of control if I tried to do everything. Gotta know when to stop!
A description of the data sources:
All data used for these graphs was obtained through the TBA API. There are some interesting points to take into consideration for anyone looking to duplicate this effort:
- The State/Province field can contain EITHER the full name (ie Minnesota) OR the abbreviation (ie MN). This requires some work after pulling the data to merge the name and abbreviation datasets.
- There are a LOT of missing zip codes. It seems that only teams that have competed in the past couple of years have zip codes listed, otherwise that field is null. This limits how precise we can get looking at the data, unfortunately.
- There are some teams with a null value for their rookie year. This requires some extrapolation based on events teams were listed as competing in.
I don’t fault TBA for these items, it’s likely a result of receiving different amounts of data and different data formats from FIRST at different times (See the TBA blog for more info on that!). Still, it would be extremely helpful for those wishing to run analysis like this if the data could be standardized somewhere, and kept up to date each year
FRC Growth.xlsx (1.14 MB)