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.
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.
| Fact | Detail |
|---|---|
| Total records | 40,081 institution-year and institution-sport-year records, verified September 27, 2026. The count is not a count of unique institutions or athletes. |
| Survey years | 2024 and 2025 |
| Access | Free listing: ATHLETICS.FREE_INSTITUTIONS and ATHLETICS.FREE_INSTITUTION_SPORTS |
| Not in this listing | Earlier survey years, school-to-conference links, and booster or NIL funder records |
| Source | Department of Education Equity in Athletics Disclosure Act (EADA) survey data download |
| Refresh | Both tables are static snapshots created September 27, 2026 |
| Geographic coverage | Qualifying postsecondary institutions with intercollegiate athletics programs, not every US college |
| Key matching columns | UNITID + SURVEY_YEAR |
| Table | Records | Survey years |
|---|---|---|
ATHLETICS.FREE_INSTITUTIONS | 4,077 | 2024, 2025 |
ATHLETICS.FREE_INSTITUTION_SPORTS | 36,004 | 2024, 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.
The two tables contain 79 columns in total. All fields below appear in the free listing.
ATHLETICS.FREE_INSTITUTIONS51 columns, 4,077 records.
| Column | Type | Meaning |
|---|---|---|
ID | NUMBER(38,0) | Internal record identifier. |
UNITID | NUMBER(38,0) | Federal institution identifier used to join school and sport records. |
SURVEY_YEAR | NUMBER(38,0) | Year of the EADA survey submission. |
ACADEMIC_YEAR | VARCHAR | Academic year label associated with the survey. |
OPEID | VARCHAR | Office of Postsecondary Education institution identifier. |
INSTITUTION_NAME | VARCHAR | Institution name reported in the EADA survey. |
ADDRESS_LINE1 | VARCHAR | First line of the institution address. |
ADDRESS_LINE2 | VARCHAR | Second line of the institution address, where reported. |
CITY | VARCHAR | City reported for the institution. |
STATE | VARCHAR | State reported for the institution. |
ZIP_CODE | VARCHAR | Postal code reported for the institution, retained as text. |
CLASSIFICATION_CODE | NUMBER(38,0) | Source code for institution classification. |
CLASSIFICATION_NAME | VARCHAR | Institution classification reported in the EADA survey. |
CLASSIFICATION_OTHER | VARCHAR | Other institution classification text, where reported. |
SECTOR_CODE | NUMBER(38,0) | Source code for the institution sector. |
SECTOR_NAME | VARCHAR | Institution sector, such as public or private. |
ENROLLMENT_MEN | NUMBER(38,0) | Reported enrollment of men at the institution. |
ENROLLMENT_WOMEN | NUMBER(38,0) | Reported enrollment of women at the institution. |
ENROLLMENT_TOTAL | NUMBER(38,0) | Reported total institutional enrollment. |
TOTAL_REVENUE | NUMBER(38,0) | Reported athletics revenue, in US dollars. |
TOTAL_EXPENSE | NUMBER(38,0) | Reported athletics expenses, in US dollars. |
REVENUE_MEN | NUMBER(38,0) | Revenue attributed to men's athletics, in US dollars. |
REVENUE_WOMEN | NUMBER(38,0) | Revenue attributed to women's athletics, in US dollars. |
EXPENSE_MEN | NUMBER(38,0) | Expenses attributed to men's athletics, in US dollars. |
EXPENSE_WOMEN | NUMBER(38,0) | Expenses attributed to women's athletics, in US dollars. |
ALLOCATED_REVENUE | NUMBER(38,0) | Athletics revenue allocated to specific teams or activities, in US dollars. |
ALLOCATED_EXPENSE | NUMBER(38,0) | Athletics expense allocated to specific teams or activities, in US dollars. |
UNALLOCATED_REVENUE | NUMBER(38,0) | Athletics revenue not allocated to specific teams or activities, in US dollars. |
UNALLOCATED_EXPENSE | NUMBER(38,0) | Athletics expense not allocated to specific teams or activities, in US dollars. |
TOTAL_OPERATING_EXPENSE | NUMBER(38,0) | Reported total operating expenses for athletics, in US dollars. |
ATHLETIC_AID_MEN | FLOAT | Athletic financial aid reported for men, in US dollars. |
ATHLETIC_AID_WOMEN | FLOAT | Athletic financial aid reported for women, in US dollars. |
ATHLETIC_AID_TOTAL | NUMBER(38,0) | Total reported athletic financial aid, in US dollars. |
RECRUITING_EXPENSE_MEN | FLOAT | Recruiting expenses reported for men, in US dollars. |
RECRUITING_EXPENSE_WOMEN | FLOAT | Recruiting expenses reported for women, in US dollars. |
RECRUITING_EXPENSE_TOTAL | NUMBER(38,0) | Total reported recruiting expenses, in US dollars. |
HEAD_COACH_AVG_SALARY_MEN | FLOAT | Average annual salary reported for head coaches of men's teams, in US dollars. |
HEAD_COACH_AVG_SALARY_WOMEN | FLOAT | Average annual salary reported for head coaches of women's teams, in US dollars. |
HEAD_COACH_COUNT_MEN | FLOAT | Reported count of head coaches of men's teams. |
HEAD_COACH_COUNT_WOMEN | FLOAT | Reported count of head coaches of women's teams. |
ASST_COACH_AVG_SALARY_MEN | FLOAT | Average annual salary reported for assistant coaches of men's teams, in US dollars. |
ASST_COACH_AVG_SALARY_WOMEN | FLOAT | Average annual salary reported for assistant coaches of women's teams, in US dollars. |
ASST_COACH_COUNT_MEN | FLOAT | Reported count of assistant coaches of men's teams. |
ASST_COACH_COUNT_WOMEN | FLOAT | Reported count of assistant coaches of women's teams. |
PARTICIPANTS_MEN | NUMBER(38,0) | Reported number of men participating in athletics. |
PARTICIPANTS_WOMEN | NUMBER(38,0) | Reported number of women participating in athletics. |
UNDUP_PARTICIPANTS_MEN | NUMBER(38,0) | Unduplicated count of men participating across sports. |
UNDUP_PARTICIPANTS_WOMEN | NUMBER(38,0) | Unduplicated count of women participating across sports. |
RAW_ROW | VARCHAR | Original source row retained as text for audit. |
CREATED_AT | TIMESTAMP_NTZ(9) | Timestamp when Civly first stored this record. |
UPDATED_AT | TIMESTAMP_NTZ(9) | Timestamp when Civly last updated this record. |
ATHLETICS.FREE_INSTITUTION_SPORTS28 columns, 36,004 records.
| Column | Type | Meaning |
|---|---|---|
ID | NUMBER(38,0) | Internal record identifier. |
UNITID | NUMBER(38,0) | Federal institution identifier used to join school and sport records. |
SURVEY_YEAR | NUMBER(38,0) | Year of the EADA survey submission. |
SPORTS_CODE | NUMBER(38,0) | Source code for the sport. |
SPORT_NAME | VARCHAR | Sport name reported in the EADA survey. |
INSTITUTION_NAME | VARCHAR | Institution name reported in the EADA survey. |
STATE | VARCHAR | State reported for the institution. |
CLASSIFICATION_NAME | VARCHAR | Institution classification reported in the EADA survey. |
PARTICIPANTS_MEN | FLOAT | Reported number of men participating in athletics. |
PARTICIPANTS_WOMEN | FLOAT | Reported number of women participating in athletics. |
SUM_PARTICIPANTS_MEN | NUMBER(38,0) | Source-provided sum of men participants for this sport. |
SUM_PARTICIPANTS_WOMEN | NUMBER(38,0) | Source-provided sum of women participants for this sport. |
OPEXP_PER_PARTICIPANT_MEN | FLOAT | Operating expense per man participant, in US dollars. |
OPEXP_PER_PARTICIPANT_WOMEN | FLOAT | Operating expense per woman participant, in US dollars. |
OPEXP_PER_TEAM_MEN | FLOAT | Operating expense per men's team, in US dollars. |
OPEXP_PER_TEAM_WOMEN | FLOAT | Operating expense per women's team, in US dollars. |
TOTAL_OPERATING_EXPENSE | NUMBER(38,0) | Reported total operating expenses for athletics, in US dollars. |
REVENUE_MEN | NUMBER(38,0) | Revenue attributed to men's athletics, in US dollars. |
REVENUE_WOMEN | NUMBER(38,0) | Revenue attributed to women's athletics, in US dollars. |
TOTAL_REVENUE | NUMBER(38,0) | Reported athletics revenue, in US dollars. |
EXPENSE_MEN | NUMBER(38,0) | Expenses attributed to men's athletics, in US dollars. |
EXPENSE_WOMEN | NUMBER(38,0) | Expenses attributed to women's athletics, in US dollars. |
TOTAL_EXPENSE | NUMBER(38,0) | Reported athletics expenses, in US dollars. |
HEAD_COACH_COUNT | NUMBER(38,0) | Reported number of head coaches for this sport. |
ASST_COACH_COUNT | NUMBER(38,0) | Reported number of assistant coaches for this sport. |
RAW_ROW | VARCHAR | Original source row retained as text for audit. |
CREATED_AT | TIMESTAMP_NTZ(9) | Timestamp when Civly first stored this record. |
UPDATED_AT | TIMESTAMP_NTZ(9) | Timestamp when Civly last updated this record. |
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.
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;
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]