brycewang-stanford/Auto-Empirical-Research-Skills / skills/17-DAAF-Contribution-Community-daaf/dot-claude/skills/education-data-source-eada
education-data-source-eada
VerifiedEADA — college athletics gender equity (~2,000+ institutions, 2002-2021). Participation, coaching, salaries, expenses, revenues, athletic aid by gender. Not Title IX compliance data. No sector column; join IPEDS on unitid for institution type.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 15.2 KB |
| references/data-elements.md | markdown | 10.4 KB |
| references/fetch-patterns.md | markdown | 3.4 KB |
| references/limitations.md | markdown | 8.3 KB |
| references/sport-level-data.md | markdown | 6.8 KB |
| references/title-ix-context.md | markdown | 6.3 KB |
| references/variable-definitions.md | markdown | 19.7 KB |
references/variable-definitions.md
View on GitHub# EADA Variable Definitions
Detailed definitions for key EADA variables available through the Education Data Portal.
> **CRITICAL: Portal Integer Encoding**
>
> This document describes **Education Data Portal** integer encodings. The Portal converts categorical variables to integers for consistency across sources.
>
> | Variable | Code | Meaning |
> |----------|------|---------|
> | `ath_classification_code` | `1` | NCAA Division I FBS |
> | `ath_classification_code` | `2` | NCAA Division I FCS |
> | `ath_classification_code` | `8` | Other (see `ath_classification_other` for detail) |
> | `fips` | `6` | California |
> | Any variable | `-1` | Missing/not reported |
> | Any variable | `-2` | Not applicable |
> | Any variable | `-3` | Suppressed data |
>
> See the Athletic Classification Codes section below for complete mappings.
## Codebook Authority
> **This document summarizes Portal variable definitions for convenience.** When in doubt,
> consult the authoritative codebook via `get_codebook_url("eada/codebook_colleges_eada_inst-characteristics")`
> from `fetch-patterns.md`. If this document contradicts the codebook or observed data,
> trust the codebook or data (see Truth Hierarchy in `fetch-patterns.md`).
## Institution Identification
| Variable | Type | Description |
|----------|------|-------------|
| `unitid` | Integer | IPEDS institution identifier (6 digits) |
| `opeid` | String | OPE ID (null for early years, e.g., 2002) |
| `year` | Integer | Reporting year (fiscal year ending) |
| `inst_name` | String | Name of institution |
| `fips` | Integer | State FIPS code (see FIPS codes below) |
> **Note:** There is no `sector` column in EADA Portal data. To filter by institutional
> sector, join with IPEDS directory data on `unitid`.
### State FIPS Codes (Portal Integer Encoding)
| Code | State | Code | State | Code | State |
|------|-------|------|-------|------|-------|
| 1 | Alabama | 18 | Indiana | 35 | New Mexico |
| 2 | Alaska | 19 | Iowa | 36 | New York |
| 4 | Arizona | 20 | Kansas | 37 | North Carolina |
| 5 | Arkansas | 21 | Kentucky | 38 | North Dakota |
| 6 | California | 22 | Louisiana | 39 | Ohio |
| 8 | Colorado | 23 | Maine | 40 | Oklahoma |
| 9 | Connecticut | 24 | Maryland | 41 | Oregon |
| 10 | Delaware | 25 | Massachusetts | 42 | Pennsylvania |
| 11 | District of Columbia | 26 | Michigan | 44 | Rhode Island |
| 12 | Florida | 27 | Minnesota | 45 | South Carolina |
| 13 | Georgia | 28 | Mississippi | 46 | South Dakota |
| 15 | Hawaii | 29 | Missouri | 47 | Tennessee |
| 16 | Idaho | 30 | Montana | 48 | Texas |
| 17 | Illinois | 31 | Nebraska | 49 | Utah |
| | | 32 | Nevada | 50 | Vermont |
| | | 33 | New Hampshire | 51 | Virginia |
| | | 34 | New Jersey | 53 | Washington |
| | | | | 54 | West Virginia |
| | | | | 55 | Wisconsin |
| | | | | 56 | Wyoming |
**Territories and Special Codes:**
| Code | Jurisdiction |
|------|--------------|
| 60 | American Samoa |
| 66 | Guam |
| 69 | Northern Mariana Islands |
| 72 | Puerto Rico |
| 78 | Virgin Islands |
### Athletic Classification Codes (Portal Integer Encoding)
| Code | Athletic Division |
|------|-------------------|
| 1 | NCAA Division I FBS |
| 2 | NCAA Division I FCS |
| 3 | NCAA Division I (without football) |
| 4 | NCAA Division II (with football) |
| 5 | NCAA Division II (without football) |
| 6 | NCAA Division III (with football) |
| 7 | NCAA Division III (without football) |
| 8 | Other (see `ath_classification_other` field) |
| 9 | NAIA Division I |
| 10 | NAIA Division II |
| 11 | NAIA Division III |
| 12 | NJCAA Division I |
| 13 | NJCAA Division II |
| 14 | NJCAA Division III |
| 15 | NCCAA Division I |
| 16 | NCCAA Division II |
| 17 | CCCAA (California Community Colleges) |
| 18 | Independent |
| 19 | NWAC (Northwest Athletic Conference) |
| 20 | USCAA (United States Collegiate Athletic Association) |
| -1 | Missing/not reported |
| -2 | Not applicable |
| -3 | Suppressed |
> **Note:** Code `8` (Other) is used for institutions that don't fit the standard classifications. Check the `ath_classification_other` string field for additional detail.
## Participation Variables
### Institution-Level Participation
| Variable | Type | Description |
|----------|------|-------------|
| `undup_athpartic_men` | Integer | Unduplicated count of male participants across all sports |
| `undup_athpartic_women` | Integer | Unduplicated count of female participants across all sports |
| `undup_athpartic_total` | Integer | Total unduplicated participants (often `-1` coded; may need to sum men + women) |
| `athpartic_men` | Integer | Duplicated (sport-level sum) male participants |
| `athpartic_women` | Integer | Duplicated (sport-level sum) female participants |
| `athpartic_coed_men` | Integer | Male participants on coed teams |
| `athpartic_coed_women` | Integer | Female participants on coed teams |
| `sum_athpartic_men` | Integer | Sum of sport-level male participants |
| `sum_athpartic_women` | Integer | Sum of sport-level female participants |
### Enrollment Context
| Variable | Type | Description |
|----------|------|-------------|
| `enrollment_men` | Integer | Male undergraduate enrollment |
| `enrollment_women` | Integer | Female undergraduate enrollment |
| `enrollment_total` | Integer | Total undergraduate enrollment |
### Definition: "Participant"
A participant is a student who:
- Is listed on the varsity team roster
- As of the first day of the first scheduled contest
- During the reporting year
**Includes**:
- Scholarship athletes
- Walk-ons
- Redshirts (if on roster)
**Excludes**:
- Practice players not on varsity roster
- Club sport participants
- Junior varsity (unless no varsity)
### Unduplicated vs. Duplicated
- **Unduplicated**: Multi-sport athletes counted once for institution total
- **Duplicated**: Summing sport-level data will double-count multi-sport athletes
## Coaching Variables
### Head Coach Counts
The Portal naming convention for coach counts is `{team}_{status}{role}_{gender}`:
- `{team}`: `men_`, `women_`, `coed_`
- `{status}`: `ft` (full-time), `pt` (part-time)
- `{role}`: `hdcoach` (head coach)
- `{gender}`: `_male`, `_fem`
Additional categories exist for university employment status:
- `{team}_hdcoach_ftuniemp_{gender}`: Full-time university employee, head coaching assignment
- `{team}_hdcoach_ptuniemp_{gender}`: Part-time university employee, head coaching assignment
| Variable | Type | Description |
|----------|------|-------------|
| `men_fthdcoach_male` | Integer | Full-time male head coaches of men's teams |
| `men_pthdcoach_male` | Integer | Part-time male head coaches of men's teams |
| `men_fthdcoach_fem` | Integer | Full-time female head coaches of men's teams |
| `men_pthdcoach_fem` | Integer | Part-time female head coaches of men's teams |
| `men_hdcoach_ftuniemp_male` | Integer | FT university employee male head coaches, men's teams |
| `men_hdcoach_ptuniemp_male` | Integer | PT university employee male head coaches, men's teams |
| `men_hdcoach_ftuniemp_fem` | Integer | FT university employee female head coaches, men's teams |
| `men_hdcoach_ptuniemp_fem` | Integer | PT university employee female head coaches, men's teams |
| `men_total_hdcoach` | Integer | Total head coaches of men's teams |
| `women_fthdcoach_male` | Integer | Full-time male head coaches of women's teams |
| `women_pthdcoach_male` | Integer | Part-time male head coaches of women's teams |
| `women_fthdcoach_fem` | Integer | Full-time female head coaches of women's teams |
| `women_pthdcoach_fem` | Integer | Part-time female head coaches of women's teams |
| `women_hdcoach_ftuniemp_male` | Integer | FT university employee male head coaches, women's teams |
| `women_hdcoach_ptuniemp_male` | Integer | PT university employee male head coaches, women's teams |
| `women_hdcoach_ftuniemp_fem` | Integer | FT university employee female head coaches, women's teams |
| `women_hdcoach_ptuniemp_fem` | Integer | PT university employee female head coaches, women's teams |
| `women_total_hdcoach` | Integer | Total head coaches of women's teams |
| `coed_fthdcoach_male` | Integer | Full-time male head coaches of coed teams |
| `coed_pthdcoach_male` | Integer | Part-time male head coaches of coed teams |
| `coed_fthdcoach_fem` | Integer | Full-time female head coaches of coed teams |
| `coed_pthdcoach_fem` | Integer | Part-time female head coaches of coed teams |
| `coed_total_hdcoach` | Integer | Total head coaches of coed teams |
| `num_hdcoach_men` | Integer | Number of head coaches, men's teams |
| `num_hdcoach_women` | Integer | Number of head coaches, women's teams |
| `num_hdcoach_coed` | Integer | Number of head coaches, coed teams |
**Summary (aggregate) variables:**
| Variable | Type | Description |
|----------|------|-------------|
| `sum_fthdcoach_male` | Integer | Sum of full-time male head coaches across all teams |
| `sum_pthdcoach_male` | Integer | Sum of part-time male head coaches across all teams |
| `sum_fthdcoach_fem` | Integer | Sum of full-time female head coaches across all teams |
| `sum_pthdcoach_fem` | Integer | Sum of part-time female head coaches across all teams |
| `sum_total_hdcoach` | Integer | Sum of all head coaches across all teams |
### Assistant Coach Counts
Same structure as head coaches with `ascoach` replacing `hdcoach` in variable names (e.g., `men_ftascoach_male`, `women_ftascoach_fem`, `sum_total_ascoach`).
### Definition: Full-Time vs. Part-Time
| Status | Definition |
|--------|------------|
| **Full-time** | Employed by institution on a full-time basis (regardless of coaching assignment) |
| **Part-time** | Not full-time employees; may include graduate assistants |
**Note**: A full-time employee who coaches part-time is counted as full-time.
## Salary Variables
### Coach Salary Averages
| Variable | Type | Description |
|----------|------|-------------|
| `hdcoach_salary_men` | Integer | Average annual salary of head coaches of men's teams |
| `hdcoach_salary_women` | Integer | Average annual salary of head coaches of women's teams |
| `hdcoach_salary_coed` | Integer | Average annual salary of head coaches of coed teams |
| `hdcoach_sal_fte_men` | Integer | Head coach salary per FTE, men's teams |
| `hdcoach_sal_fte_women` | Integer | Head coach salary per FTE, women's teams |
| `hdcoach_sal_fte_coed` | Integer | Head coach salary per FTE, coed teams |
| `ascoach_salary_men` | Integer | Average annual salary of assistant coaches of men's teams |
| `ascoach_salary_women` | Integer | Average annual salary of assistant coaches of women's teams |
| `ascoach_salary_coed` | Integer | Average annual salary of assistant coaches of coed teams |
| `ascoach_sal_fte_men` | Integer | Assistant coach salary per FTE, men's teams |
| `ascoach_sal_fte_women` | Integer | Assistant coach salary per FTE, women's teams |
| `ascoach_sal_fte_coed` | Integer | Assistant coach salary per FTE, coed teams |
### FTE Coach Counts
| Variable | Type | Description |
|----------|------|-------------|
| `fte_hdcoach_men` | Float | FTE head coaches, men's teams |
| `fte_hdcoach_women` | Float | FTE head coaches, women's teams |
| `fte_hdcoach_coed` | Float | FTE head coaches, coed teams |
| `fte_ascoach_men` | Float | FTE assistant coaches, men's teams |
| `fte_ascoach_women` | Float | FTE assistant coaches, women's teams |
| `fte_ascoach_coed` | Float | FTE assistant coaches, coed teams |
### Definition: Salary
**Includes**:
- Base salary
- Bonuses from the institution
- Any supplemental pay from institutional funds
**Excludes**:
- Income from camps/clinics (unless institutional compensation)
- Media/broadcast contracts
- Apparel/equipment deals
- Outside speaking fees
- Deferred compensation
- Benefits (health insurance, retirement)
### Calculation Method
```
Average Salary = Total Salaries Paid / Number of Paid Coaching Positions
```
**Note**: Volunteer coaches (0 salary) may or may not be excluded from denominator depending on reporting practice.
## Expense Variables
### Total Expenses
| Variable | Type | Description |
|----------|------|-------------|
| `ath_exp_men` | Integer | Total expenses attributable to men's teams |
| `ath_exp_women` | Integer | Total expenses attributable to women's teams |
| `ath_exp_coed_men` | Float | Total expenses for coed teams, men's portion |
| `ath_exp_coed_women` | Float | Total expenses for coed teams, women's portion |
| `ath_exp_menall` | Float | Total expenses for men (including coed portion) |
| `ath_exp_womenall` | Float | Total expenses for women (including coed portion) |
| `ath_total_exp_menwomen` | Integer | Combined total expenses, men's + women's teams |
| `ath_total_exp_coed` | Integer | Total expenses, coed teams |
| `ath_total_exp_all` | Integer | Total expenses, all teams |
| `ath_tot_exp_all_notalloc` | Integer | Total expenses, not allocated by gender |
| `ath_grnd_total_exp` | Integer | Grand total of all athletic expenses |
### Operating Expenses
| Variable | Type | Description |
|----------|------|-------------|
| `ath_opexp_menwomen` | Integer | Operating expenses, men's + women's teams |
| `ath_opexp_coed` | Integer | Operating expenses, coed teams |
| `ath_total_opexp_allteams` | Integer | Total operating expenses, all teams |
| `ath_opexp_perpart_men` | Float | Operating expense per participant, men's teams |
| `ath_opexp_perpart_women` | Float | Operating expense per participant, women's teams |
| `ath_opexp_perpart_menall` | Float | Operating expense per participant, men (incl. coed) |
| `ath_opexp_perpart_womenall` | Float | Operating expense per participant, women (incl. coed) |
| `ath_opexp_perpart_coed_men` | Float | Operating expense per participant, coed teams (men) |
| `ath_opexp_perpart_coed_women` | Float | Operating expense per participant, coed teams (women) |
| `ath_opexp_perteam_men` | Integer | Operating expense per team, men's teams |
| `ath_opexp_perteam_women` | Integer | Operating expense per team, women's teams |
| `ath_opexp_perteam_menall` | Float | Operating expense per team, men (incl. coed) |
| `ath_opexp_perteam_womenall` | Float | Operating expense per team, women (incl. coed) |
### Definition: Operating Expenses
**Includes**:
- Team travel (transportation, lodging, meals)
- Equipment and uniforms
- Game officials
- Game-day support personnel
**Excludes**:
- Coaching salaries (separate)
- Athletic scholarships (separate)
- Facilities (capital)
- Administrative overhead
### Recruiting Expenses
| Variable | Type | Description |
|----------|------|-------------|
| `recruitexp_men` | Integer | Recruiting expenses for men's teams |
| `recruitexp_women` | Integer | Recruiting expenses for women's teams |
| `recruitexp_coed` | Integer | Recruiting expenses for coed teams |
| `recruitexp_total` | Integer | Total recruiting expenses |
### Definition: Recruiting Expenses
**Includes**:
- Travel for coaching staff on recruiting trips
- Lodging and meals during recruiting
- Prospect visit expenses (on-campus)
- Communication costs
- Recruiting services/subscriptions
## Revenue Variables
### Team Revenues
| Variable | Type | Description |
|----------|------|-------------|
| `ath_rev_men` | Integer | Revenues attributable to men's teams |
| `ath_rev_women` | Integer | Revenues attributable to women's teams |
| `ath_rev_coed_men` | Float | Revenues for coed teams, men's portion |
| `ath_rev_coed_women` | Float | Revenues for coed teams, women's portion |
| `ath_rev_menall` | Float | Total revenues for men (including coed portion) |
| `ath_rev_womenall` | Float | Total revenues for women (including coed portion) |
| `ath_total_rev_menwomen` | Integer | Combined total revenues, men's + women's teams |
| `ath_total_rev_coed` | Integer | Total revenues, coed teams |
| `ath_total_rev_all` | Integer | Total revenues, all teams |
| `ath_tot_rev_all_notalloc` | Integer | Total revenues, not allocated by gender |
| `ath_grnd_total_rev` | Integer | Grand total of all athletic revenues |
### Definition: Revenue
**Includes**:
- Ticket sales
- Game guarantees received
- Broadcast rights (attributed portion)
- NCAA/conference distributions (attributed)
- Program sales
- Concessions (if tracked by sport)
- Donations restricted to specific sports
**Excludes**:
- Student fees (typically)
- General institutional support
- Unrestricted donations
### Revenue Attribution Challenges
Many revenue sources are shared (conference distributions, multimedia rights) and attribution varies by institution.
## Athletic Aid Variables
### Financial Assistance
| Variable | Type | Description |
|----------|------|-------------|
| `ath_stuaid_men` | Integer | Total athletic aid to male students |
| `ath_stuaid_women` | Integer | Total athletic aid to female students |
| `ath_stuaid_coed` | Integer | Athletic aid for coed teams |
| `ath_stuaid_total` | Integer | Total athletic aid |
| `ath_stuaid_men_ratio` | Float | Ratio of male aid to total |
| `ath_stuaid_women_ratio` | Float | Ratio of female aid to total |
| `ath_stuaid_coed_ratio` | Float | Ratio of coed aid to total |
### Definition: Athletic Aid
Athletic student aid includes:
- Scholarships specifically for athletics
- Grants-in-aid designated for athletes
- Tuition waivers awarded for athletic participation
- Room, board, and required fees if athletically related
**Excludes**:
- Need-based aid that happens to go to athletes
- Academic merit aid to athletes
- Non-athletic institutional aid
### Equivalency Calculation
For Division I:
```
Full Scholarship Equivalency = Total Aid Dollars / Cost of Full Scholarship
```
**Note**: EADA reports total dollars, not equivalencies.
## Calculated Fields
### Common Calculations
```python
import polars as pl
# Total unduplicated participation
# Note: undup_athpartic_total is often coded -1; calculate manually
total_partic = pl.col("undup_athpartic_men") + pl.col("undup_athpartic_women")
# Female participation share
female_share = pl.col("undup_athpartic_women") / total_partic
# Per-athlete operating expense (pre-calculated in data)
# Use ath_opexp_perpart_men, ath_opexp_perpart_women directly
# Aid proportionality
aid_share_female = pl.col("ath_stuaid_women") / (
pl.col("ath_stuaid_men") + pl.col("ath_stuaid_women")
)
# Note: ath_stuaid_women_ratio is pre-calculated in the data
```
### Additional Miscellaneous Variables
| Variable | Type | Description |
|----------|------|-------------|
| `num_sports` | Integer | Number of sports offered (null for some years) |
## Missing Value Interpretation (Portal Integer Encoding)
| Code | Meaning | When Used |
|------|---------|-----------|
| `-1` | Missing/not reported | State/institution did not report; value unknown |
| `-2` | Not applicable | Item doesn't apply to this institution |
| `-3` | Suppressed | Data suppressed for privacy protection |
| `NULL` | Null value | Genuinely not present in source data |
| `0` | Zero | Reported as zero (institution has no activity) |
### Handling Missing Data
```python
import polars as pl
# Identify coded missing values
missing_codes = [-1, -2, -3]
# Filter to valid data only for a specific column
df_valid = df.filter(~pl.col("undup_athpartic_women").is_in(missing_codes))
# Or convert coded values to null for calculations
df_clean = df.with_columns(
pl.when(pl.col("ath_stuaid_men").is_in(missing_codes))
.then(None)
.otherwise(pl.col("ath_stuaid_men"))
.alias("ath_stuaid_men_clean")
)
```
## Data Type Notes
- **Integers**: Count variables (participants, coaches)
- **Decimals**: Financial variables (may have cents)
- **Strings**: Names, identifiers
- **Years**: Fiscal year ending (e.g., 2022 = FY2021-22)
## Joining with Other Data
### IPEDS Join Key
Use `unitid` to join with IPEDS data for:
- Enrollment figures
- Institutional characteristics
- Carnegie classification
- Geographic details
```python
import polars as pl
# Example join with IPEDS
eada_df.join(ipeds_df, on=["unitid", "year"], how="left")
```
### Year Alignment
EADA reporting year may not align perfectly with IPEDS year. Check documentation for specific alignment requirements.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |