Sport Partnership
The Sport Partnership data is from a survey conducted by Marie Merritt's team. The planned cadence of the survey is every other year going forward. Karly worked with Maggie Brennan to combine the historical data together into one dataset. The dataset started in 2018, then there was a survey in 2019, 2020, 2023, and 2024. We have all historical data for this survey formatted in the SportPartnership table. The next survey will be done in approximately 2 years and the sport team wants to partner with our team to create that survey in the future to have it best map to the old data.
Sport
| colname | colvalues | coltype | detail |
|---|---|---|---|
| Year | Year | bigint | Year |
| Program | Program in exact spelling from Census | varchar | Program in exact spelling from Census |
| ProgramRaw | Raw Program Name | varchar | Raw Program Name |
| Region | varchar | Region with Canada and the Caribbean broken out | |
| RegionRaw | Raw Region Name | varchar | Raw Region Name, without Canada and the Caribbean broken out |
| FirstName | Freeform | varchar | First Name |
| LastName | Freeform | varchar | Last Name |
| JobTitle | Freeform | varchar | Job Title |
| JobGrouping | Values of: "Other", "President, Board Chair or Board Member", "Executive or National Director, CEO ", "Sport or Competition Director" | varchar | Job Grouping |
| Freeform | varchar | Email Address | |
| AnyBoardMembersFromFederations | Yes or No | varchar | If any of the board members are from federations, yes or no |
| BoardMembers | Freeform | varchar | Board members freeform |
| OtherInformation | Freeform | varchar | Other information freeform |
| SupportAreas | Multiselect from: Access to Competition & Training Venues; Direct Financial Support (Grants, Donations, Fundraisers, Sponsorship); Sport Officials Training & Competition Support; Coach Education & Training Support; Promotional Support (Marketing & Communications); Sport Equipment; International Competition Support (Special Olympics World Games and/or Single-Sport International Competitions); Uniforms Support; Research & Evaluation Support; Transportation Support; None Listed | varchar | Support Areas multiselect |
| Sport | Sport from a set list of sports to best try to match how they are in Census. | varchar | Sport from a set list of sports to best try to match how they are in Census. |
| OfficialSport | Values: "Official Sport" or "Other Sport" | varchar | Designates if the sport listed is official or not. Values: "Official Sport" or "Other Sport" |
| Level | Values: Regional, National, State, Global | varchar | Level of data reported, whether it is Regional, National, State, or Global |
| SupportAreasCount | Number | bigint | Count of the distinct support areas listed, not including "None Listed". Sometimes the formulas do not match what is in the table. This is because some of the support areas and ways metrics have been over time has changed. There are notes in the code to when each one is used. Please refer to the notes in the code for specific details of how these are used. |
| LevelOfPartnership | Number | bigint | Level of Partnership. Formula for Level of Partnership: support areas count = 1 is a level 1 partnership, support areas count = 2 or 3 is level 2 partnership, support areas count = 4+ is level 3. Sometimes the formulas do not match what is in the table. This is because some of the support areas and ways metrics have been over time has changed. There are notes in the code to when each one is used. Please refer to the notes in the code for specific details of how these are used. |
| PartnershipVIKValue | Number | bigint | Partnership VIK (value in kind) Value. Formula for VIK: VIK = $1000 for partnership level 1, $5000 for partnership level 2 and $10,000 for partnership level 3. Sometimes the formulas do not match what is in the table. This is because some of the support areas and ways metrics have been over time has changed. There are notes in the code to when each one is used. Please refer to the notes in the code for specific details of how these are used. |
| CreatedDateTime | Number | datetime | Date the table was created in the data warehouse |