Snowflake Marketplace

US College Athletics Finances

Data documentation for the Civly listing on the Snowflake Marketplace: what’s in it, how it’s structured, and how to query it once installed.

40,081institution-year and institution-sport-year records
2survey years: 2024 and 2025
79columns across two tables
Freelisting
About this dataset

What’s in the listing

This free listing contains 40,081 institution-year and institution-sport-year records from the Department of Education's Equity in Athletics Disclosure Act (EADA) survey, verified September 27, 2026. The count is not a count of unique institutions or athletes. The survey covers qualifying postsecondary institutions with intercollegiate athletics programs, not every US college.

Both tables are static snapshots created September 27, 2026. Collection timestamps show when Civly stored or updated a record. They do not establish when an institution filed its survey. Earlier survey years, school-to-conference links, and booster or NIL funder records are not part of this listing.

FactDetail
Total records40,081 institution-year and institution-sport-year records, verified September 27, 2026. The count is not a count of unique institutions or athletes.
Survey years2024 and 2025
AccessFree listing: ATHLETICS.FREE_INSTITUTIONS and ATHLETICS.FREE_INSTITUTION_SPORTS
Not in this listingEarlier survey years, school-to-conference links, and booster or NIL funder records
SourceDepartment of Education Equity in Athletics Disclosure Act (EADA) survey data download
RefreshBoth tables are static snapshots created September 27, 2026
Geographic coverageQualifying postsecondary institutions with intercollegiate athletics programs, not every US college
Key matching columnsUNITID + SURVEY_YEAR
Coverage

Records by table

TableRecordsSurvey years
ATHLETICS.FREE_INSTITUTIONS4,0772024, 2025
ATHLETICS.FREE_INSTITUTION_SPORTS36,0042024, 2025

Reading the data

The department says its downloadable files are created immediately after each collection and may not include later corrections. Missing figures do not mean zero. Sport rows and school totals measure different levels of detail, so summing all sport rows will not reliably reproduce a school total. Participation across sports should not be treated as a count of unique athletes.

Schemas

Data dictionary

The two tables contain 79 columns in total. All fields below appear in the free listing.

Schema

Data dictionary: ATHLETICS.FREE_INSTITUTIONS

51 columns, 4,077 records.

ColumnTypeMeaning
IDNUMBER(38,0)Internal record identifier.
UNITIDNUMBER(38,0)Federal institution identifier used to join school and sport records.
SURVEY_YEARNUMBER(38,0)Year of the EADA survey submission.
ACADEMIC_YEARVARCHARAcademic year label associated with the survey.
OPEIDVARCHAROffice of Postsecondary Education institution identifier.
INSTITUTION_NAMEVARCHARInstitution name reported in the EADA survey.
ADDRESS_LINE1VARCHARFirst line of the institution address.
ADDRESS_LINE2VARCHARSecond line of the institution address, where reported.
CITYVARCHARCity reported for the institution.
STATEVARCHARState reported for the institution.
ZIP_CODEVARCHARPostal code reported for the institution, retained as text.
CLASSIFICATION_CODENUMBER(38,0)Source code for institution classification.
CLASSIFICATION_NAMEVARCHARInstitution classification reported in the EADA survey.
CLASSIFICATION_OTHERVARCHAROther institution classification text, where reported.
SECTOR_CODENUMBER(38,0)Source code for the institution sector.
SECTOR_NAMEVARCHARInstitution sector, such as public or private.
ENROLLMENT_MENNUMBER(38,0)Reported enrollment of men at the institution.
ENROLLMENT_WOMENNUMBER(38,0)Reported enrollment of women at the institution.
ENROLLMENT_TOTALNUMBER(38,0)Reported total institutional enrollment.
TOTAL_REVENUENUMBER(38,0)Reported athletics revenue, in US dollars.
TOTAL_EXPENSENUMBER(38,0)Reported athletics expenses, in US dollars.
REVENUE_MENNUMBER(38,0)Revenue attributed to men's athletics, in US dollars.
REVENUE_WOMENNUMBER(38,0)Revenue attributed to women's athletics, in US dollars.
EXPENSE_MENNUMBER(38,0)Expenses attributed to men's athletics, in US dollars.
EXPENSE_WOMENNUMBER(38,0)Expenses attributed to women's athletics, in US dollars.
ALLOCATED_REVENUENUMBER(38,0)Athletics revenue allocated to specific teams or activities, in US dollars.
ALLOCATED_EXPENSENUMBER(38,0)Athletics expense allocated to specific teams or activities, in US dollars.
UNALLOCATED_REVENUENUMBER(38,0)Athletics revenue not allocated to specific teams or activities, in US dollars.
UNALLOCATED_EXPENSENUMBER(38,0)Athletics expense not allocated to specific teams or activities, in US dollars.
TOTAL_OPERATING_EXPENSENUMBER(38,0)Reported total operating expenses for athletics, in US dollars.
ATHLETIC_AID_MENFLOATAthletic financial aid reported for men, in US dollars.
ATHLETIC_AID_WOMENFLOATAthletic financial aid reported for women, in US dollars.
ATHLETIC_AID_TOTALNUMBER(38,0)Total reported athletic financial aid, in US dollars.
RECRUITING_EXPENSE_MENFLOATRecruiting expenses reported for men, in US dollars.
RECRUITING_EXPENSE_WOMENFLOATRecruiting expenses reported for women, in US dollars.
RECRUITING_EXPENSE_TOTALNUMBER(38,0)Total reported recruiting expenses, in US dollars.
HEAD_COACH_AVG_SALARY_MENFLOATAverage annual salary reported for head coaches of men's teams, in US dollars.
HEAD_COACH_AVG_SALARY_WOMENFLOATAverage annual salary reported for head coaches of women's teams, in US dollars.
HEAD_COACH_COUNT_MENFLOATReported count of head coaches of men's teams.
HEAD_COACH_COUNT_WOMENFLOATReported count of head coaches of women's teams.
ASST_COACH_AVG_SALARY_MENFLOATAverage annual salary reported for assistant coaches of men's teams, in US dollars.
ASST_COACH_AVG_SALARY_WOMENFLOATAverage annual salary reported for assistant coaches of women's teams, in US dollars.
ASST_COACH_COUNT_MENFLOATReported count of assistant coaches of men's teams.
ASST_COACH_COUNT_WOMENFLOATReported count of assistant coaches of women's teams.
PARTICIPANTS_MENNUMBER(38,0)Reported number of men participating in athletics.
PARTICIPANTS_WOMENNUMBER(38,0)Reported number of women participating in athletics.
UNDUP_PARTICIPANTS_MENNUMBER(38,0)Unduplicated count of men participating across sports.
UNDUP_PARTICIPANTS_WOMENNUMBER(38,0)Unduplicated count of women participating across sports.
RAW_ROWVARCHAROriginal source row retained as text for audit.
CREATED_ATTIMESTAMP_NTZ(9)Timestamp when Civly first stored this record.
UPDATED_ATTIMESTAMP_NTZ(9)Timestamp when Civly last updated this record.
Schema

Data dictionary: ATHLETICS.FREE_INSTITUTION_SPORTS

28 columns, 36,004 records.

ColumnTypeMeaning
IDNUMBER(38,0)Internal record identifier.
UNITIDNUMBER(38,0)Federal institution identifier used to join school and sport records.
SURVEY_YEARNUMBER(38,0)Year of the EADA survey submission.
SPORTS_CODENUMBER(38,0)Source code for the sport.
SPORT_NAMEVARCHARSport name reported in the EADA survey.
INSTITUTION_NAMEVARCHARInstitution name reported in the EADA survey.
STATEVARCHARState reported for the institution.
CLASSIFICATION_NAMEVARCHARInstitution classification reported in the EADA survey.
PARTICIPANTS_MENFLOATReported number of men participating in athletics.
PARTICIPANTS_WOMENFLOATReported number of women participating in athletics.
SUM_PARTICIPANTS_MENNUMBER(38,0)Source-provided sum of men participants for this sport.
SUM_PARTICIPANTS_WOMENNUMBER(38,0)Source-provided sum of women participants for this sport.
OPEXP_PER_PARTICIPANT_MENFLOATOperating expense per man participant, in US dollars.
OPEXP_PER_PARTICIPANT_WOMENFLOATOperating expense per woman participant, in US dollars.
OPEXP_PER_TEAM_MENFLOATOperating expense per men's team, in US dollars.
OPEXP_PER_TEAM_WOMENFLOATOperating expense per women's team, in US dollars.
TOTAL_OPERATING_EXPENSENUMBER(38,0)Reported total operating expenses for athletics, in US dollars.
REVENUE_MENNUMBER(38,0)Revenue attributed to men's athletics, in US dollars.
REVENUE_WOMENNUMBER(38,0)Revenue attributed to women's athletics, in US dollars.
TOTAL_REVENUENUMBER(38,0)Reported athletics revenue, in US dollars.
EXPENSE_MENNUMBER(38,0)Expenses attributed to men's athletics, in US dollars.
EXPENSE_WOMENNUMBER(38,0)Expenses attributed to women's athletics, in US dollars.
TOTAL_EXPENSENUMBER(38,0)Reported athletics expenses, in US dollars.
HEAD_COACH_COUNTNUMBER(38,0)Reported number of head coaches for this sport.
ASST_COACH_COUNTNUMBER(38,0)Reported number of assistant coaches for this sport.
RAW_ROWVARCHAROriginal source row retained as text for audit.
CREATED_ATTIMESTAMP_NTZ(9)Timestamp when Civly first stored this record.
UPDATED_ATTIMESTAMP_NTZ(9)Timestamp when Civly last updated this record.
Matching

Joining the tables

Join on UNITID and SURVEY_YEAR. A school can have multiple sport rows in a survey year. Use the institution table for school-level totals and the sport table for sport-level comparisons.

Getting started

Sample queries

After installing, set your worksheet database selector to the installed database. These queries then run as written. Amounts are reported in US dollars.

-- 2025 athletics revenue by institution
SELECT INSTITUTION_NAME, STATE, TOTAL_REVENUE, TOTAL_EXPENSE
FROM ATHLETICS.FREE_INSTITUTIONS
WHERE SURVEY_YEAR = 2025
ORDER BY TOTAL_REVENUE DESC NULLS LAST
LIMIT 100;

-- Participation and athletic aid by institution
-- Compare reported men's and women's participation and athletic aid for the 2025 survey.
-- The aid fields are reported amounts, not audited spending.
SELECT INSTITUTION_NAME, STATE, PARTICIPANTS_MEN, PARTICIPANTS_WOMEN, ATHLETIC_AID_MEN, ATHLETIC_AID_WOMEN
FROM ATHLETICS.FREE_INSTITUTIONS
WHERE SURVEY_YEAR = 2025
ORDER BY INSTITUTION_NAME
LIMIT 100;

-- Connect sports to their institutions
-- Join on the federal institution ID and survey year.
-- Sport rows are reported separately and should not be summed to infer unique athletes.
SELECT i.INSTITUTION_NAME, i.STATE, s.SPORT_NAME, s.SURVEY_YEAR, s.TOTAL_REVENUE, s.TOTAL_EXPENSE
FROM ATHLETICS.FREE_INSTITUTION_SPORTS s
JOIN ATHLETICS.FREE_INSTITUTIONS i
  ON i.UNITID = s.UNITID AND i.SURVEY_YEAR = s.SURVEY_YEAR
WHERE s.SURVEY_YEAR = 2025
ORDER BY i.INSTITUTION_NAME, s.SPORT_NAME
LIMIT 100;
Provenance

Sourcing and attribution

The source is the Department of Education EADA data download. The department explains which institutions report under EADA. Revenue, expense, participation, athletic aid and coaching figures are institution-reported. Amounts are in US dollars and are not independently audited by Civly.

For coverage or access questions: [email protected]