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.

406,585records in the full dataset
19survey years: 2007 to 2025
40,081trial records, 2024 and 2025 surveys
30 daysfree trial
About this dataset

What’s in the listing

The full dataset contains 406,585 records: 38,852 institution-year and 367,626 institution-sport-year records from the Department of Education's Equity in Athletics Disclosure Act (EADA) survey for 2007 through 2025, and 107 booster foundation and NIL collective records for 70 schools, each with a match status. The count is not a count of unique institutions or athletes. Survey years before 2016 named the Division I subdivisions I-A, I-AA and I-AAA. Those records use today's names: FBS, FCS and Division I without football. The survey covers qualifying postsecondary institutions with intercollegiate athletics programs, not every US college.

The same views serve the trial and the subscription. During the free 30-day trial, COLLEGE_ATHLETICS.INSTITUTIONS and COLLEGE_ATHLETICS.INSTITUTION_SPORTS return the 2024 and 2025 surveys, 40,081 records. The donor-entity view returns no rows during the trial. A yearly subscription adds survey years 2007 through 2023 and the booster and NIL records. Collection timestamps show when Civly stored or updated a record. They do not establish when an institution filed its survey.

FactDetail
Total records406,585 in the full dataset and 40,081 in the trial, verified October 28, 2026. The count is not a count of unique institutions or athletes.
Survey years2007 to 2025 in the full dataset; 2024 and 2025 in the trial
Free trial30 days, the 2024 and 2025 surveys (4,077 institution-year and 36,004 institution-sport-year records)
SubscriptionAdds survey years 2007 through 2023 and booster and NIL collective records, billed yearly
SourceDepartment of Education Equity in Athletics Disclosure Act (EADA) survey data download
RefreshChecked for source changes weekly. Trial users see the same updates.
Geographic coverageQualifying postsecondary institutions with intercollegiate athletics programs, not every US college
Key matching columnsUNITID + SURVEY_YEAR
Coverage

Records by view

ViewRecordsSurvey yearsAccess
COLLEGE_ATHLETICS.INSTITUTIONS38,8522007 to 2025Subscription. Free trial: 4,077 records, 2024 and 2025
COLLEGE_ATHLETICS.INSTITUTION_SPORTS367,6262007 to 2025Subscription. Free trial: 36,004 records, 2024 and 2025
COLLEGE_ATHLETICS.DONOR_ENTITIES107Not applicableSubscription. No rows during the trial

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 COLLEGE_ATHLETICS.INSTITUTIONS and COLLEGE_ATHLETICS.INSTITUTION_SPORTS views contain 79 columns in total. The same views serve the trial and the subscription.

Schema

Data dictionary: COLLEGE_ATHLETICS.INSTITUTIONS

51 columns. During the free trial it returns the 2024 and 2025 surveys, 4,077 records. Subscribers see 2007 to 2025, 38,852 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: COLLEGE_ATHLETICS.INSTITUTION_SPORTS

28 columns. During the free trial it returns the 2024 and 2025 surveys, 36,004 records. Subscribers see 2007 to 2025, 367,626 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 COLLEGE_ATHLETICS.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 COLLEGE_ATHLETICS.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 COLLEGE_ATHLETICS.INSTITUTION_SPORTS s
JOIN COLLEGE_ATHLETICS.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: matthew@civly.ai