Sport
This contains the Sport Partnership Table and the Sport Classification View.
SportPartnership
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, 2024, and 2025. 2025 had a lot of changes and we are hoping the survey will stay consistent in 2026. We have all historical data for this survey formatted in the SportPartnership table. The next survey will be done in approximately 2 years (supposed to be every 2 years but they have been increasing the cadence).
| 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 |
| 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" |
| 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; Policy Recognition or Endorsement | varchar | Support Areas multiselect |
| 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. |
| UsePriorData | True/False | bit | If they want to use the prior year's sport partnership data for this year. Started in 2025 data. |
| SportMinistryRelationship | Values of: "Informal or ad-hoc collaboration", "Formal partnership (e.g. MOU, agreement)", "Strategic partnership (e.g. policy recognition, embedded in national sport strategy)" | varchar | This is a copy of the "Sport Ministry" column in the survey. |
| SportMinistryMoney | Freeform | varchar | Asked as: Money from Sport Ministry. |
| SportsCouldNotOffer | Freeform | varchar | Asked as: Sports could not offer without support? |
| CoachingPathway | Yes or No | varchar | Asked as: Coaching Pathway. |
| MinimumCoachCertification | Values: "Yes - for all coaches", "Yes - for some coaches", "No" | varchar | Asked as: Minimum Coach Certification |
| CoachEducationDeliveryOrg | Multiselect from: "National Sport Federation / Organization / Governing Body", "Non-Governmental Organizations (NGOs)", "Special Olympics Program", "University/Education Partner", "Other" | varchar | Asked as: "Coach Education Delivery - Org" |
| CoachEducationDeliveryPerson | Multiselect from: "National Sport Federation Staff/Coach Educators", "Special Olympics Coach Educators/Coach Developers (with formal qualification in Coach Development)", "Special Olympics Coach Educators/Coach Developers (without formal qualification - e.g. highly experienced coaches, teachers, clinicians)", "Special Olympics Program Staff" | varchar | Asked as: "Coach Education Delivery - Person" |
| CoachEducationDeliveryPersonLogic | Multiselect from: "Federation Qualified", "Special Olympics Qualified" | varchar | Asked as: "Coach Education Delivery - Person - Logic" |
| Level | Values: Regional, National, State, Global | varchar | Level of data reported, whether it is Regional, National, State, or Global |
| CreatedDateTime | Number | datetime | Date the table was created in the data warehouse |
SportClassification
The Sport Classification view was created with Maggie Brennan in August 2026. It is a view that combines together the Sport Partnership and Census data to create the sport classifications. This is all created in one query to make it easy to replicate. The Type (Season of Summer or Winter), Federation Partnerships, and Classification rules are from Maggie.
| colname | colvalues | coltype | detail |
|---|---|---|---|
| Year | Year | int | Year |
| Sport | Sport | varchar | Sport |
| Type | Summer or Winter | varchar | Season of the sport, Summer or Winter |
| Classification | Classification number 1-4 or null | int | Sport Classification, calculated in the query |
| ProgramCount | Count of Programs | int | Count of Programs |
| ProgramCount_USA_as_1 | Count of Programs where all USA programs together only count as 1 | int | Count of Programs, where all of USA counts only as 1 in the count |
| RegionCount | Count of Regions | int | Count of Regions |
| Athletes | Number | int | Sum of Athletes |
| Partners | Number | int | Sum of Partners |
| Participants | Number | int | Sum of Participants |
| Coaches | Number | int | Sum of Coaches |
| CertifiedCoaches | Number | int | Sum of Certified Coaches |
| FederationPartnerships | Number | int | Sum of Federation Partnerships |