Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-explorer

education-data-explorer

Verified

Mirror-first discovery for Urban Institute Education Data: maps a research question to the mirror dataset FILES that answer it — canonical path, entity grain, year coverage, key variables, and join keys — for CCD, IPEDS, CRDC, College Scorecard, SAIPE, EDFacts, FSA, MEPS, NHGIS, PSEO, NACUBO, NCCS, EADA, and Campus Safety. Discovery output is the mirror path (plus grain, years, variables, caveats), the currency planning and acquisition consume. A pure readable-reference skill for read-only discovery agents — no code, no live HTTP probes; all facts keyed to pinned mirror vintage 0.26.1. Load BEFORE education-data-query — routing (which file, what grain) here, retrieval (fetch code, mirror config) there.

references/variable-dictionary-ipeds.md

View on GitHub
<!-- MECHANICALLY GENERATED on 2026-10-28
     from the Portal varlist captured 2026-08-07 at Portal v0.26.1 — the same
     vintage as the pinned mirror (revision 0ad00ce0e232c96b0642459e4e7326607a8d26aa).
     Do not hand-edit: the DAAF maintainers regenerate these files at each new mirror vintage. -->

# Variable Dictionary — `ipeds`

**MECHANICALLY GENERATED** on 2026-10-28 from the Portal varlist captured 2026-08-07 at Portal v0.26.1 — the same vintage as the pinned mirror (revision `0ad00ce0e232c96b0642459e4e7326607a8d26aa`). Do not hand-edit: the DAAF maintainers regenerate these files at each new mirror vintage.

> Caveat: the `urban_csv` fallback mirror is unpinned; these facts are guaranteed for the pinned Hugging Face vintage only.

> Caveat: the `coded values` column reproduces the Portal varlist's declared legend (including the standard `-1`/`-2`/`-3` missing codes) and does not assert those codes occur in the pinned mirror file — several mirror files carry nulls instead (a probe of the pinned SAIPE file on 2026-10-28 found no `-1`/`-2`/`-3` or other negative value in any of its 10 columns; nulls occur only in the two `_pct` columns). Test for nulls and for sentinels before treating either as the missing-value convention, and defer to the source skill's SKILL.md where it documents the observed convention.

> Caveat: entries marked **Observed on pinned mirror** record what file-first probes of the pinned revision found on 2026-10-27 where it contradicts or qualifies the Portal varlist or the bridge's file counts; they are added beside the declared label, type and legend, which are kept verbatim, and override nothing declared.

Source `ipeds`: 32 dataset families, 753 unique variables.

## `ipeds/colleges_ipeds_academic_libraries`

- **Canonical mirror path:** `ipeds/colleges_ipeds_academic_libraries.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/academic-libraries/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `branches_and_independent_lib` | Number of branches and independent libraries | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `entire_library_electronic` | Is the library collection entirely electronic? | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `physical_books` | Number of physical books | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `physical_media` | Number of physical media | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `physical_serials` | Number of physical serials | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `electronic_books` | Number of digital/electronic books | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `electronic_databases` | Number of digital/electronic databases | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `electronic_media` | Number of digital/electronic media | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `electronic_serials` | Number of electronic serials | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_physical_circulations` | Total physical library circulations (books and media) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_physical_collections` | Total physical library collections (books and media) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_electronic_circulations` | Total digital/electronic circulations (books and media) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_electronic_collections` | Total electronic library collections (books, databases, media, and serials) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_circulations` | Total library circulations (physical and digital/electronic) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_collections` | Total library collections (physical and electronic) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `interlibrary_loan_services` | Does institution have interlibrary loan services? | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `interlibrary_loans_provided` | Total interlibrary loans and documents provided to other libraries | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `interlibrary_loans_received` | Total interlibrary loans and documents received | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `supports_virtual_ref_services` | Does your library support virtual reference services? | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total` | Total expenditures | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_wo_fringe_benefit` | Total expenditures (salaries/wages, benefits, materials/services, and operations/maintenance) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_operation_maint` | Total operations and maintenance expenditures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_materials_services` | Total materials/services expenditures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_fringe_benefits` | Total fringe benefits | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_onetime_purchases` | One-time purchases of books, serial backfiles, and other materials | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_ongoing_subscriptions` | Ongoing commitments to subscriptions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other_materials_services` | Other materials/services expenditures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other_operation_maint` | Other operation and maintenance expenditures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_preservation_services` | Preservation services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sal_wages_from_lib_budget` | Salaries/wages, benefits, materials/services, and operations/maintenance | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fringe_benefit_from_lib_budget` | Are staff fringe benefits paid out of the library budget? | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lib_exp_greater_100k` | Total annual library expenses greater than or equal to $100,000 | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lib_staff_indicator` | Has library staff | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `librarians_fte` | Full-time equivalent librarians | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_paid_lib_staff_fte` | Other paid full-time equivalent library staff, except student assistants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_prof_lib_staff_fte` | Other professional full-time equivalent library staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `student_assistants_fte` | Full-time equivalent student assistants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_lib_staff_fte` | Total full-time equivalent library staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_admissions-enrollment`

- **Canonical mirror path:** `ipeds/colleges_ipeds_admissions-enrollment.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/admissions-enrollment/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_applied` | Number of applicants | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_admitted` | Number of admissions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_enrolled_ft` | Number of students enrolled full time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_enrolled_pt` | Number of students enrolled part time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_enrolled_total` | Total number of students enrolled | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_admissions-requirements`

- **Canonical mirror path:** `ipeds/colleges_ipeds_admissions-requirements.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/admissions-requirements/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_hs_diploma` | Admissions requirement: Secondary school diploma | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_hs_rank` | Admissions requirement: Secondary school rank | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_test_scores` | Admissions requirement: Admission test scores | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_sat_scores` | Admissions requirement: SAT scores | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_other_test` | Admissions requirement: Other test | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_residence` | Admissions requirement: Residence | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_ability_to_benefit` | Admissions requirement: Ability to benefit | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_age` | Admissions requirement: Age | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_toefl` | Admissions requirement: TOEFL (Test of English as a Foreign Language) | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_other` | Admissions requirement: Other | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `years_college_reqd` | Years of college-level work required | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_entering_freshmen` | No entering freshmen | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `open_admissions_policy` | Open admissions policy | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_hs_gpa` | Admissions requirement: Secondary school GPA | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_hs_record` | Admissions requirement: Secondary school record | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_college_prep` | Admissions requirement: Completion of college preparatory program | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_recommendations` | Admissions requirement: Recommendations | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_competencies` | Admissions requirement: Formal demonstration of competencies | integer | yes | "0" : "Neither required nor recommended","1" : "Required","2" : "Recommended","3" : "Considered","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_act_report_period` | SAT/ACT reporting period | integer | yes | "1" : "Previous fall","2" : "Current fall","3" : "Test scores not required","-1" : "Missing/not reported","-2" : "Not applicable" |
| `sat_number_submitting` | Number of first-time degree/certificate-seeking students submitting SAT scores | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_percent_submitting` | Percentage of first-time degree/certificate-seeking students submitting SAT scores | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_number_submitting` | Number of first-time degree/certificate-seeking students submitting ACT scores | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_percent_submitting` | Percentage of first-time degree/certificate-seeking students submitting ACT scores | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_crit_read_25_pctl` | SAT critical reading 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_crit_read_75_pctl` | SAT critical reading 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_math_25_pctl` | SAT math 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_math_75_pctl` | SAT math 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_composite_25_pctl` | ACT composite 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_composite_75_pctl` | ACT composite 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_english_25_pctl` | ACT English 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_english_75_pctl` | ACT English 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_math_25_pctl` | ACT math 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_math_75_pctl` | ACT math 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_writing_25_pctl` | SAT writing 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_writing_75_pctl` | SAT writing 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_writing_25_pctl` | ACT writing 25th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_writing_75_pctl` | ACT writing 75th percentile score | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_work` | Work Requirement | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_personal_statement` | Personal Statement Required | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reqt_legacy_status` | Legacy Status Requirement | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_composite_50_pctl` | ACT writing 50th percentile score | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_english_50_pctl` | ACT writing 50th percentile score | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `act_math_50_pctl` | ACT writing 50th percentile score | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_crit_read_50_pctl` | SAT Critical Reading 50th percentile score | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sat_math_50_pctl` | SAT Math 50th percentile score | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_ay_room_board_other`

- **Canonical mirror path:** `ipeds/colleges_ipeds_ay_room_board_other.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/academic-year-room-board-other/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `living_arrangement` | Living arrangement (on or off campus) | integer | yes | "1" : "On campus","2" : "Off campus with family","3" : "Off campus not with family","4" : "Unknown","99" : "Total" |
| `books_supplies` | Books and supplies (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `room_board` | Room and board (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other` | Other expenses (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_ay_tuition_fees`

- **Canonical mirror path:** `ipeds/colleges_ipeds_ay_tuition_fees.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/academic-year-tuition/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_type` | Tuition type (in state, out of state, etc.) | integer | yes | "1" : "In state or in district","2" : "In district","3" : "In state","4" : "Out of state","5" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_fees_ft` | Average tuition and fees for full-time students (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_ft` | Average tuition for full-time students (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fees_ft` | Required fees for full-time students (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `credit_hour_charge_pt` | Cost per credit hour for part-time students (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_published` | Published tuition (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fees_published` | Published fees (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_fees_published` | Published tuition and fees (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_pub_pct_increase` | Published tuition guaranteed percentage increase (if applicable) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fees_pub_pct_increase` | Published fees guaranteed percentage increase (if applicable) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_ay_tuition_firstprof`

- **Canonical mirror path:** `ipeds/colleges_ipeds_ay_tuition_firstprof.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/academic-year-tuition-prof-program/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prof_program` | Professional program | integer | yes | "1" : "Chiropractic","2" : "Dentistry","3" : "Medicine","4" : "Optometry","5" : "Osteopathic medicine","6" : "Pharmacy","7" : "Podiatry","8" : "Veterinary medicine","9" : "Law","10" : "Theology","20" : "Other first professional" |
| `tuition_type` | Tuition type (in state, out of state, etc.) | integer | yes | "1" : "In state or in district","2" : "In district","3" : "In state","4" : "Out of state","5" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_fees` | Tuition and fees | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition` | Tuition (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fees` | Fees (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_completers`

- **Canonical mirror path:** `ipeds/colleges_ipeds_completers.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/completers/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers` | Completers | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_completions-2digcip_{year}`

- **Canonical mirror path:** `ipeds/colleges_ipeds_completions-2digcip_{year}.parquet` (33 mirror files, 1991-2023; **observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27)**)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/completions-cip-2/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cipcode` | 2-digit Classification of Instructional Programs (CIP) code | integer | yes | "10000" : "Agriculture, agriculture operations, and related sciences","20000" : "Agricultural sciences","30000" : "Natural resources and conservation","40000" : "Architecture and related services","50000" : "Area, ethnic, cultural, and gender studies","80000" : "Marketing and distribution","90000" : "Communication, journalism, and related programs","100000" : "Communications technologies/technicians and support services","110000" : "Computer and information sciences and support services","120000" : "Personal and culinary services","130000" : "Education","140000" : "Engineering","150000" : "Engineering technologies/technicians","160000" : "Foreign languages, literatures, and linguistics","190000" : "Family and consumer sciences/human sciences","200000" : "Vocational home economics","220000" : "Legal professions and studies","220101" : "Law (LLB, JD)","230000" : "English language and literature/letters","240000" : "Liberal arts and sciences, general studies and humanities","250000" : "Library science","260000" : "Biological and biomedical sciences","270000" : "Mathematics and statistics","290000" : "Military technologies","300000" : "Multi/interdisciplinary studies","310000" : "Parks, recreation, leisure, and fitness studies","380000" : "Philosophy and religious studies","390000" : "Theology and religious vocations","390602" : "Divinity/ministry (BD, MDiv)","390603" : "Rabbinical studies","390605" : "Rabbinical studies (MHL/Rav)","400000" : "Physical sciences","410000" : "Science technologies/technicians","420000" : "Psychology","430000" : "Security and protective services","440000" : "Public administration and social service professions","450000" : "Social sciences","460000" : "Construction trades","470000" : "Mechanic and repair technologies/technicians","480000" : "Precision production","490000" : "Transportation and materials moving","500000" : "Visual and performing arts","510000" : "Health professions and related clinical sciences","510101" : "Chiropractic (DC)","510401" : "Dentistry (DDS, DMD)","511201" : "Medicine (MD)","511701" : "Optometry (OD)","511901" : "Osteopathic medicine/osteopathy (DO)","512001" : "Pharmacy (PharmD [USA] PharmD, BS/BPharm [Canada])","512101" : "Podiatric medicine/podiatry (DPM)","512401" : "Veterinary medicine (DVM)","512704" : "Naturopathic medicine","520000" : "Business, management, marketing, and related support services","540000" : "History (new)","950000" : "Undesignated field of study","99" : "All programs","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_level` | Award level | integer | yes | "1" : "Award of less than one academic year","2" : "Award of less than two academic years","3" : "Award of at least one but less than two academic years","4" : "Associate's degree","5" : "Award of at least one but less than four academic years","6" : "Award of at least two but less than four academic years","7" : "Bachelor's degree","8" : "Postbaccalaureate or post-master's certificate","9" : "Master's degree","20" : "Doctor's degree (until 2008)","21" : "First-professional degree (until 2008)","22" : "Doctor's degree, research/scholarship (starting 2007)","23" : "Doctor's degree, professional practice (starting 2007)","24" : "Doctor's degree, other (starting 2007)","30" : "Certificate of less than 12 weeks","31" : "Certificates of at least 12 weeks but less than 1 year","32" : "Certificate of at least 1 year but less than 2 years","33" : "Certificate of at least 2 years but less than 4 years","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `majornum` | Major number | integer | yes | "1" : "First major","2" : "Second major" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `awards` | Awards | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_completions-6digcip_{year}`

- **Canonical mirror path:** `ipeds/colleges_ipeds_completions-6digcip_{year}.parquet` (41 mirror files, 1983-2023; **observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27)**)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/completions-cip-6/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cipcode_6digit` | 6-digit Classification of Instructional Programs (CIP) code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** stored as Int64, so CIP series 01-09 lose their leading zero (CIP 03.0101 is 30101); zero-pad to 6 digits before matching NCES CIP code strings (2023 file probed). |
| `award_level` | Award level | integer | yes | "1" : "Award of less than one academic year","2" : "Award of less than two academic years","3" : "Award of at least one but less than two academic years","4" : "Associate's degree","5" : "Award of at least one but less than four academic years","6" : "Award of at least two but less than four academic years","7" : "Bachelor's degree","8" : "Postbaccalaureate or post-master's certificate","9" : "Master's degree","20" : "Doctor's degree (until 2008)","21" : "First-professional degree (until 2008)","22" : "Doctor's degree, research/scholarship (starting 2007)","23" : "Doctor's degree, professional practice (starting 2007)","24" : "Doctor's degree, other (starting 2007)","30" : "Certificate of less than 12 weeks","31" : "Certificates of at least 12 weeks but less than 1 year","32" : "Certificate of at least 1 year but less than 2 years","33" : "Certificate of at least 2 years but less than 4 years","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `majornum` | Major number | integer | yes | "1" : "First major","2" : "Second major" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `awards_6digit` | Awards | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_directory`

- **Canonical mirror path:** `ipeds/colleges_ipeds_directory.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/directory/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `opeid` | 8-digit Office of Postsecondary Education (OPE) ID number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_name` | Institution (entity) name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_alias` | Institution name alias | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `address` | Street address or post office box | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_abbr` | State abbreviation | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip` | Zip code | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `phone_number` | General information telephone number | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city` | City location of institution | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `county_name` | County name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `county_fips` | Federal Information Processing Standards county code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `region` | Bureau of Economic Analysis (BEA) regions | integer | yes | "0" : "US service schools","1" : "New England: CT, ME, MA, NH, RI, and VT","2" : "Mid East: DE, DC, MD, NJ, NY, and PA","3" : "Great Lakes: IL, IN, MI, OH, and WI","4" : "Plains: IA, KS, MN, MO, NE, ND, and SD","5" : "Southeast: AL, AR, FL, GA, KY, LA, MS, NC, SC, TN, VA, and WV","6" : "Southwest: AZ, NM, OK, and TX","7" : "Rocky Mountains: CO, ID, MT, UT, and WY","8" : "Far West: AK, CA, HI, NV, OR, and WA","9" : "Outlying areas: AS, FM, GU, MH, MP, PR, PW, and VI","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `urban_centric_locale` | Degree of urbanization (urban-centric locale) | integer | yes | "1" : "Large city","2" : "Midsize city","3" : "Urban fringe of large city","4" : "Urban fringe of midsize city","5" : "Large town","6" : "Small town","7" : "Rural, outside CBSA","8" : "Rural, inside CBSA","9" : "Not assigned","11" : "City, large","12" : "City, midsize","13" : "City, small","21" : "Suburb, large","22" : "Suburb, midsize","23" : "Suburb, small","31" : "Town, fringe","32" : "Town, distant","33" : "Town, remote","41" : "Rural, fringe","42" : "Rural, distant","43" : "Rural, remote","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa` | Core-based statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_type` | Core-based statistical area type: Metropolitan or micropolitan | integer | yes | "1" : "Metropolitan statistical area","2" : "Micropolitan statistical area","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `csa` | Combined statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `necta` | New England city and town area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `longitude` | Longitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `latitude` | Latitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `congress_district_id` | State and 114th congressional district identification number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ein` | Employer identification number | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `duns` | Dun and Bradstreet numbers | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `chief_admin_name` | Name of chief administrator | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `chief_admin_title` | Title of chief administrator | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_status` | Status of institution | integer | yes | "1" : "Active","2" : "[Unknown]","3" : "Combined with other institution","4" : "Out of business","5" : "Perfect child campus","6" : "Inactive due to hurricane related problems","7" : "Closed in current year (active)","8" : "New (active), added during the current year","9" : "Out of scope of the IPEDS universe","10" : "Potential new/add institution","11" : "Potential restore institution","12" : "Restore (active), restored to the current universe","13" : "Split into more than one institution","14" : "Duplicate, unit ID previously assigned","15" : "Wipe out, out of scope, potential add","16" : "Potential restore not within scope of IPEDS","17" : "Universe III, out of scope" |
| `currently_active_ipeds` | Institution is active in current year | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_granting` | Degree-granting status | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `open_public` | Institution open to the general public | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `title_iv_indicator` | OPE Title IV eligibility indicator code | integer | yes | "1" : "Participates in Title IV federal financial aid programs","2" : "Branch campus of a main campus that participates in Title IV","3" : "Deferment only, limited participation","4" : "New participants (became eligible during the winter collection period)","5" : "Not currently participating in Title IV, has an OPE ID number","6" : "Not currently participating in Title IV, does not have OPE ID number","7" : "Stopped participating during the survey year","8" : "New participants (became eligible during the spring collection period)","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `postsec_public_active` | Postsecondary institution indicator | integer | yes | "1" : "Active postsecondary institution","2" : "Not primarily postsecondary or open to public","3" : "Not active","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `postsec_public_active_title_iv` | Postsecondary and Title IV institution indicator | integer | yes | "1" : "Title IV postsecondary institution","2" : "Non-Title IV postsecondary institution","3" : "Title IV NOT primarily postsecondary institution","4" : "Non-Title IV NOT primarily postsecondary institution","5" : "Title IV postsecondary institution that is NOT open to the public","6" : "Non-Title IV postsecondary institution that is NOT open to the public","9" : "Institution is not active in current universe","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `date_closed` | Date institution closed | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `newid` | Unit ID for merged schools | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year_deleted` | Year institution was deleted from Integrated Postsecondary Education Data System | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_control` | Control of institution | integer | yes | "1" : "Public","2" : "Private not-for-profit","3" : "Private for-profit","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `institution_level` | Level of institution | integer | yes | "1" : "Less than two years (below associate's)","2" : "At least two but less than four years","3" : "Less than four years","4" : "Four or more years","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_category` | Institutional category | integer | yes | "1" : "Degree-granting, graduate with no undergraduate degrees","2" : "Degree-granting, primarily baccalaureate or above","3" : "Degree-granting, not primarily baccalaureate or above","4" : "Degree-granting, associate's and certificates","5" : "Nondegree-granting, above the baccalaureate","6" : "Nondegree-granting, sub-baccalaureate","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_size` | Institution size category | integer | yes | "1" : "Under 1,000","2" : "1,000&ndash;4,999","3" : "5,000&ndash;9,999","4" : "10,000&ndash;19,999","5" : "20,000 and above","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sector` | Sector of institution | integer | yes | "0" : "Administrative unit","1" : "Public, four-year or above","2" : "Private not-for-profit, four-year or above","3" : "Private for-profit, four-year or above","4" : "Public, two-year","5" : "Private not-for-profit, two-year","6" : "Private for-profit, two-year","7" : "Public, less-than two-year","8" : "Private not-for-profit, less-than-two-year","9" : "Private for-profit, less-than-two-year","-1" : "Sector unknown (not active)","-2" : "Not applicable","-3" : "Suppressed data" |
| `primarily_postsecondary` | Primarily postsecondary indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `hbcu` | Historically black college or university | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `hospital` | Institution has hospital | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `medical_degree` | Institution grants a medical degree | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tribal_college` | Tribal college | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `land_grant` | Land grant institution | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `offering_highest_degree` | Highest degree offered | integer | yes | "0" : "Non&ndash;degree granting","1" : "First-professional only (until 2008)","10" : "Doctoral (until 2008)","11" : "Doctor's degree, research/scholarship and professional practice","12" : "Doctor's degree, research/scholarship","13" : "Doctor's degree, professional practice","14" : "Doctor's degree, other","20" : "Master's degree","21" : "Masters and first-professional (until 2008)","30" : "Bachelor's degree","31" : "Bachelor's and first-professional (until 2008)","40" : "Associate's degree","41" : "Associate's and first-professional (until 2008)","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `offering_highest_level` | Highest level of offering | integer | yes | "0" : "Other","1" : "Award of less than one academic year","2" : "At least one, but less than two academic years","3" : "Associate's degree","4" : "At least two, but less than four academic years","5" : "Bachelor's degree","6" : "Postbaccalaureate certificate","7" : "Master's degree","8" : "Post-master's certificate","9" : "Doctor's degree","10" : "Graduate non&ndash;degree-granting","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `offering_undergrad` | Undergraduate offering | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `offering_grad` | Graduate offering | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_school` | Institution's internet website address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_fin_aid` | Financial aid office web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_application` | Online application web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_netprice` | Net price calculator web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_veterans` | Veterans and military service members tuition policies web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_athletes` | Student-right-to-know student athlete graduation rate web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `url_disability_services` | Disability services web address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_basic_2010` | Carnegie classification 2010: Basic | integer | yes | "1" : "Associate's, public rural-serving small","2" : "Associate's, public rural-serving medium","3" : "Associate's, public rural-serving large","4" : "Associate's, public suburban-serving single campus","5" : "Associate's, public suburban-serving multicampus","6" : "Associate's, public urban-serving single campus","7" : "Associate's, public urban-serving multicampus","8" : "Associate's, public special use","9" : "Associate's, private not-for-profit","10" : "Associate's, private for-profit","11" : "Associate's, public two-year colleges under four-year universities","12" : "Associate's, public four-year primarily associate's","13" : "Associate's, private not-for-profit four-year primarily associate's","14" : "Associate's, private for-profit four-year primarily associate's","15" : "Research universities (very high research activity)","16" : "Research universities (high research activity)","17" : "Doctoral/research universities","18" : "Master's colleges and universities (larger programs)","19" : "Master's colleges and universities (medium programs)","20" : "Master's colleges and universities (smaller programs)","21" : "Baccalaureate colleges, arts & sciences","22" : "Baccalaureate colleges, diverse fields","23" : "Baccalaureate/associate's colleges","24" : "Theological seminaries, Bible colleges, and other faith-related institutions","25" : "Medical schools and medical centers","26" : "Other health professions schools","27" : "Schools of engineering","28" : "Other technology-related schools","29" : "Schools of business and management","30" : "Schools of art, music, and design","31" : "Schools of law","32" : "Other special-focus institutions","33" : "Tribal colleges","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_undergrad_2010` | Carnegie classification 2010: Undergraduate instructional program | integer | yes | "0" : "Not classified","1" : "Associate's","2" : "Associate's dominant","3" : "Arts & sciences focus, no graduate coexistence","4" : "Arts & sciences focus, some graduate coexistence","5" : "Arts & sciences focus, high graduate coexistence","6" : "Arts & sciences plus professions, no graduate coexistence","7" : "Arts & sciences plus professions, some graduate coexistence","8" : "Arts & sciences plus professions, high graduate coexistence","9" : "Balanced arts & sciences and professions, no graduate coexistence","10" : "Balanced arts & sciences and professions, some graduate coexistence","11" : "Balanced arts & sciences and professions, high graduate coexistence","12" : "Professions plus arts & sciences, no graduate coexistence","13" : "Professions plus arts & sciences, some graduate coexistence","14" : "Professions plus arts & sciences, high graduate coexistence","15" : "Professions focus, no graduate coexistence","16" : "Professions focus, some graduate coexistence","17" : "Professions focus, high graduate coexistence","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_grad_2010` | Carnegie classification 2010: Graduate instructional program | integer | yes | "1" : "Single postbaccalaureate (education)","2" : "Single postbaccalaureate (business)","3" : "Single postbaccalaureate (other field)","4" : "Postbaccalaureate comprehensive","5" : "Postbaccalaureate, arts & sciences dominant","6" : "Postbaccalaureate with arts & sciences (education dominant)","7" : "Postbaccalaureate with arts & sciences (business dominant)","8" : "Postbaccalaureate with arts & sciences (other dominant fields)","9" : "Postbaccalaureate professional (education dominant)","10" : "Postbaccalaureate professional (business dominant)","11" : "Postbaccalaureate professional (other dominant fields)","12" : "Single doctoral (education)","13" : "Single doctoral (other field)","14" : "Comprehensive doctoral with medical/veterinary","15" : "Comprehensive doctoral (no medical/veterinary)","16" : "Doctoral, humanities/social sciences dominant","17" : "STEM dominant","18" : "Doctoral, professional dominant","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_undergrad_2010` | Carnegie classification 2010: Undergraduate profile | integer | yes | "0" : "Not classified","1" : "Higher part-time two-year","2" : "Mixed part/full-time two-year","3" : "Medium full-time two-year","4" : "Higher full-time two-year","5" : "Higher part-time four-year","6" : "Medium full-time four-year, inclusive","7" : "Medium full-time four-year, selective, lower transfer-in","8" : "Medium full-time four-year, selective, higher transfer-in","9" : "Full-time four-year, inclusive","10" : "Full-time four-year, selective, lower transfer-in","11" : "Full-time four-year, selective, higher transfer-in","12" : "Full-time four-year, more selective, lower transfer-in","13" : "Full-time four-year, more selective, higher transfer-in","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_enroll_2010` | Carnegie classification 2010: Enrollment profile | integer | yes | "0" : "Not classified","1" : "Exclusively undergraduate two-year","2" : "Exclusively undergraduate four-year","3" : "Very high undergraduate","4" : "High undergraduate","5" : "Majority undergraduate","6" : "Majority graduate/professional","7" : "Exclusively graduate/professional","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_size_setting_2010` | Carnegie classification 2010: Size and setting | integer | yes | "0" : "Not classified","1" : "Very small two-year","2" : "Small two-year","3" : "Medium two-year","4" : "Large two-year","5" : "Very large two-year","6" : "Very small four-year, primarily nonresidential","7" : "Very small four-year, primarily residential","8" : "Very small four-year, highly residential","9" : "Small four-year, primarily nonresidential","10" : "Small four-year, primarily residential","11" : "Small four-year, highly residential","12" : "Medium four-year, primarily nonresidential","13" : "Medium four-year, primarily residential","14" : "Medium four-year, highly residential","15" : "Large four-year, primarily nonresidential","16" : "Large four-year, primarily residential","17" : "Large four-year, highly residential","18" : "Exclusively graduate or professional","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_basic_2000` | Carnegie classification 2000 | integer | yes | "15" : "Doctoral/research universities, extensive","16" : "Doctoral/research universities, intensive","21" : "Masters colleges and universities I","22" : "Masters colleges and universities II","31" : "Baccalaureate colleges, liberal arts","32" : "Baccalaureate colleges, general","33" : "Baccalaureate/associate's colleges","40" : "Associate's colleges","51" : "Theological seminaries and other specialized faith-related institutions","52" : "Medical schools and medical centers","53" : "Other separate health profession schools","54" : "Schools of engineering and technology","55" : "Schools of business and management","56" : "Schools of art, music, and design","57" : "Schools of law","58" : "Teachers colleges","59" : "Other specialized institutions","60" : "Tribal colleges","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_basic_2015` | Carnegie classification 2015: Basic | integer | yes | "1" : "Associate's colleges: high transfer-high traditional","2" : "Associate's colleges: high transfer-mixed traditional/nontraditional","3" : "Associate's colleges: high transfer-high nontraditional","4" : "Associate's colleges: mixed transfer/career & technical-high traditional","5" : "Associate's colleges: mixed transfer/career & technical-mixed traditional/nontraditional","6" : "Associate's colleges: mixed transfer/career & technical-high nontraditional","7" : "Associate's colleges: high career & technical-high traditional","8" : "Associate's colleges: high career & technical-mixed traditional/nontraditional","9" : "Associate's colleges: high career & technical-high nontraditional","10" : "Special focus two-year: health professions","11" : "Special focus two-year: technical professions","12" : "Special focus two-year: arts and design","13" : "Special focus two-year: other fields","14" : "Baccalaureate/associate's colleges: associate's dominant","15" : "Doctoral universities: highest research activity","16" : "Doctoral universities: higher research activity","17" : "Doctoral universities: moderate research activity","18" : "Master's colleges & universities: larger programs","19" : "Master's colleges & universities: medium programs","20" : "Master's colleges & universities: small programs","21" : "Baccalaureate colleges: arts & sciences focus","22" : "Baccalaureate colleges: diverse fields","23" : "Baccalaureate/associate's colleges: mixed baccalaureate/associate's","24" : "Special focus four-year: faith-related institutions","25" : "Special focus four-year: medical schools and centers","26" : "Special focus four-year: other health professions schools","27" : "Special focus four-year: engineering schools","28" : "Special focus four-year: other technology-related schools","29" : "Special focus four-year: business and management schools","30" : "Special focus four-year: arts, music, and design schools","31" : "Special focus four-year: law schools","32" : "Special focus four-year: other special focus institutions","33" : "Tribal colleges","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_undergrad_2015` | Carnegie classification 2015: Undergraduate instructional program | integer | yes | "0" : "Not classified (exclusively graduate programs)","1" : "Associate's colleges: high transfer","2" : "Associate's colleges: mixed transfer/vocational & technical","3" : "Associate's colleges: high vocational & technical","4" : "Special focus: two-year institution","5" : "Baccalaureate/associates colleges","6" : "Arts & sciences focus, no graduate coexistence","7" : "Arts & sciences focus, some graduate coexistence","8" : "Arts & sciences focus, high graduate coexistence","9" : "Arts & sciences plus professions, no graduate coexistence","10" : "Arts & sciences plus professions, some graduate coexistence","11" : "Arts & sciences plus professions, high graduate coexistence","12" : "Balanced arts & sciences and professions, no graduate coexistence","13" : "Balanced arts & sciences and professions, some graduate coexistence","14" : "Balanced arts & sciences and professions, high graduate coexistence","15" : "Professions plus arts & sciences, no graduate coexistence","16" : "Professions plus arts & sciences, some graduate coexistence","17" : "Professions plus arts & sciences, high graduate coexistence","18" : "Professions focus, no graduate coexistence","19" : "Professions focus, some graduate coexistence","20" : "Professions focus, high graduate coexistence","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_grad_2015` | Carnegie classification 2015: Graduate instructional program | integer | yes | "0" : "Not classified (Exclusively Undergraduate)","1" : "Postbaccalaureate: Single program-Education","2" : "Postbaccalaureate: Single program-Business","3" : "Postbaccalaureate: Single program-Other","4" : "Postbaccalaureate: Comprehensive programs","5" : "Postbaccalaureate: Arts & sciences-dominant","6" : "Postbaccalaureate: Education-dominant, with Arts & Sciences","7" : "Postbaccalaureate: Business-dominant, with Arts & Sciences","8" : "Postbaccalaureate: Other-dominant, with Arts & Sciences","9" : "Postbaccalaureate: Education-dominant, with other professional programs","10" : "Postbaccalaureate: Business-dominant, with other professional programs","11" : "Postbaccalaureate: Other-dominant, with other professional programs","12" : "Research Doctoral: Single program-Education","13" : "Research Doctoral: Single program-Other","14" : "Research Doctoral: Comprehensive programs, with medical/veterinary school","15" : "Research Doctoral: Comprehensive programs, no medical/veterinary school","16" : "Research Doctoral: Humanities/social sciences-dominant","17" : "Research Doctoral: STEM-dominant","18" : "Research Doctoral: Professional-dominant","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_undergrad_2015` | Carnegie classification 2015: Undergraduate profile | integer | yes | "0" : "Not classified (Exclusively Graduate)","1" : "Two-year, higher part-time","2" : "Two-year, mixed part/full-time","3" : "Two-year, medium full-time","4" : "Two-year, higher full-time","5" : "Four-year, higher part-time","6" : "Four-year, medium full-time, inclusive, lower transfer-in","7" : "Four-year, medium full-time, inclusive, higher transfer-in","8" : "Four-year, medium full-time, selective, lower transfer-in","9" : "Four-year, medium full-time , selective, higher transfer-in","10" : "Four-year, full-time, inclusive, lower transfer-in","11" : "Four-year, full-time, inclusive, higher transfer-in","12" : "Four-year, full-time, selective, lower transfer-in","13" : "Four-year, full-time, selective, higher transfer-in","14" : "Four-year, full-time, more selective, lower transfer-in","15" : "Four-year, full-time, more selective, higher transfer-in","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_enroll_2015` | Carnegie classification 2015: Enrollment profile | integer | yes | "1" : "Exclusively undergraduate two-year","2" : "Exclusively undergraduate four-year","3" : "Very high undergraduate","4" : "High undergraduate","5" : "Majority undergraduate","6" : "Majority graduate","7" : "Exclusively graduate","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_size_setting_2015` | Carnegie classification 2015: Size and setting | integer | yes | "1" : "Two-year, very small","2" : "Two-year, small","3" : "Two-year, medium","4" : "Two-year, large","5" : "Two-year, very large","6" : "Four-year, very small, primarily nonresidential","7" : "Four-year, very small, primarily residential","8" : "Four-year, very small, highly residential","9" : "Four-year, small, primarily nonresidential","10" : "Four-year, small, primarily residential","11" : "Four-year, small, highly residential","12" : "Four-year, medium, primarily nonresidential","13" : "Four-year, medium, primarily residential","14" : "Four-year, medium, highly residential","15" : "Four-year, large, primarily nonresidential","16" : "Four-year, large, primarily residential","17" : "Four-year, large, highly residential","18" : "Exclusively graduate/professional","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_basic_2018` | Carnegie classification 2018: Basic | integer | yes | "1" : "Associate's colleges: Transfer-focused, mostly traditional students","2" : "Associate's colleges: Transfer-focused, mixed traditional/nontraditional students","3" : "Associate's colleges: Transfer-focused, mostly nontraditional students","4" : "Associate's colleges: Mixed transfer/vocational focus, mostly traditional students","5" : "Associate's colleges: Mixed transfer/vocational focus, mixed traditional/nontraditional students","6" : "Associate's colleges: Mixed transfer/vocational focus, mostly nontraditional students","7" : "Associate's colleges: Vocational-focused, mostly traditional students","8" : "Associate's colleges: Vocational-focused, mixed traditional/nontraditional students","9" : "Associate's colleges: Vocational-focused, mostly nontraditional students","10" : "Special-focus two-year: Health professions","11" : "Special-focus two-year: Technical professions","12" : "Special-focus two-year: Arts & design","13" : "Special-focus two-year: Other fields","14" : "Baccalaureate/associate's colleges: Associate's-dominant","15" : "Doctoral universities: Very high research activity","16" : "Doctoral universities: High research activity","17" : "Doctoral/professional universities","18" : "Master's colleges & universities: Large programs","19" : "Master's colleges & universities: Medium programs","20" : "Master's colleges & universities: Small programs","21" : "Baccalaureate colleges: Arts & sciences focus","22" : "Baccalaureate colleges: Diverse fields","23" : "Baccalaureate/associate's colleges: Mixed baccalaureate/associate's","24" : "Special-focus four-year: Faith-related institutions","25" : "Special-focus four-year: Medical schools & centers","26" : "Special-focus four-year: Other health professions schools","27" : "Special-focus four-year: Engineering schools","28" : "Special-focus four-year: Other technology-related schools","29" : "Special-focus four-year: Business & management schools","30" : "Special-focus four-year: Arts, music, & design schools","31" : "Special-focus four-year: Law schools","32" : "Special-focus four-year: Other special-focus institutions","33" : "Tribal colleges","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `cc_instruc_undergrad_2018` | Carnegie classification 2018: Undergraduate instructional program | integer | yes | "0" : "Not classified (exclusively graduate programs)","1" : "Associate's colleges: Transfer-focused","2" : "Associate's colleges: Mixed transfer/vocational focus","3" : "Associate's colleges: Vocational focus","4" : "Special focus: Two-year institution","5" : "Baccalaureate/associate's colleges","6" : "Arts & sciences focus, no graduate coexistence","7" : "Arts & sciences focus, some graduate coexistence","8" : "Arts & sciences focus, high graduate coexistence","9" : "Arts & sciences plus professions, no graduate coexistence","10" : "Arts & sciences plus professions, some graduate coexistence","11" : "Arts & sciences plus professions, high graduate coexistence","12" : "Balanced arts & sciences/professions, no graduate coexistence","13" : "Balanced arts & sciences/professions, some graduate coexistence","14" : "Balanced arts & sciences/professions, high graduate coexistence","15" : "Professions plus arts & sciences, no graduate coexistence","16" : "Professions plus arts & sciences, some graduate coexistence","17" : "Professions plus arts & sciences, high graduate coexistence","18" : "Professions focus, no graduate coexistence","19" : "Professions focus, some graduate coexistence","20" : "Professions focus, high graduate coexistence","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `cc_instruc_grad_2018` | Carnegie classification 2018: Graduate instructional program | integer | yes | "0" : "Not classified (exclusively undergraduate)","1" : "Postbaccalaureate: Single program&ndash;Education","2" : "Postbaccalaureate: Single program&ndash;Business","3" : "Postbaccalaureate: Single program&ndash;Other","4" : "Postbaccalaureate: Comprehensive programs","5" : "Postbaccalaureate: Arts & sciences-dominant","6" : "Postbaccalaureate: Education-dominant, with arts & sciences programs","7" : "Postbaccalaureate: Business-dominant, with arts & aciences programs","8" : "Postbaccalaureate: Other-dominant, with arts & sciences programs","9" : "Postbaccalaureate: Education-dominant, with other professional programs","10" : "Postbaccalaureate: Business-dominant, with other professional programs","11" : "Postbaccalaureate: Other-dominant, with other professional programs","12" : "Research doctoral: Single program&ndash;Education","13" : "Research doctoral: Single program&ndash;Other","14" : "Research doctoral: Comprehensive programs, with medical/veterinary school","15" : "Research doctoral: Comprehensive programs, no medical/veterinary school","16" : "Research doctoral: Humanities/social sciences-dominant","17" : "Research doctoral: STEM-dominant","18" : "Research doctoral: Professional-dominant","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `cc_undergrad_2018` | Carnegie classification 2018: Undergraduate profile | integer | yes | "0" : "Not classified (exclusively graduate)","1" : "Two-year, mostly part-time","2" : "Two-year, mixed part/full-time","3" : "Two-year, mostly full-time","4" : "Two-year, nearly all full-time","5" : "Four-year, mostly part-time","6" : "Four-year, mostly full-time, inclusive acceptance, lower transfer-in","7" : "Four-year, mostly full-time, inclusive acceptance, higher transfer-in","8" : "Four-year, mostly full-time selective acceptance, lower transfer-in","9" : "Four-year, mostly full-time, selective acceptance, higher transfer-in","10" : "Four-year, nearly all full-time, inclusive acceptance, lower transfer-in","11" : "Four-year, nearly all full-time, inclusive acceptance, higher transfer-in","12" : "Four-year, nearly all full-time, selective acceptance, lower transfer-in","13" : "Four-year, nearly all full-time, selective acceptance, higher transfer-in","14" : "Four-year, nearly all full-time, highly selective acceptance, lower transfer-in","15" : "Four-year, nearly all full-time, highly selective acceptance, higher transfer-in","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `cc_enroll_2018` | Carnegie classification 2018: Enrollment profile | integer | yes | "1" : "Exclusively undergraduate two-year","2" : "Exclusively undergraduate four-year","3" : "Very high undergraduate","4" : "High undergraduate","5" : "Majority undergraduate","6" : "Majority graduate","7" : "Exclusively graduate","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `cc_size_setting_2018` | Carnegie classification 2018: Size and setting | integer | yes | "1" : "Two-year, very small","2" : "Two-year, small","3" : "Two-year, medium","4" : "Two-year, large","5" : "Two-year, very large","6" : "Four-year, very small, primarily nonresidential","7" : "Four-year, very small, primarily residential","8" : "Four-year, very small, highly residential","9" : "Four-year, small, primarily nonresidential","10" : "Four-year, small, primarily residential","11" : "Four-year, small, highly residential","12" : "Four-year, medium, primarily nonresidential","13" : "Four-year, medium, primarily residential","14" : "Four-year, medium, highly residential","15" : "Four-year, large, primarily nonresidential","16" : "Four-year, large, primarily residential","17" : "Four-year, large, highly residential","18" : "Exclusively graduate/professional","-2" : "Not applicable, not in Carnegie universe (not accredited or nondegree-granting)" |
| `comparison_group` | Data feedback report comparison group category created by National Center for Education Statistics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `comparison_group_custom` | Data feedback report, institution submitted a custom comparison group | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_system_flag` | Multi-institution or multicampus organization | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_system_name` | Name of multi-institution or multicampus organization | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reporting_method` | Reporting method for student charges, graduation rates, retention rates, and student financial aid | integer | yes | "1" : "Student charges for full academic year and fall graduation rates, student financial aid rates, and retention rates cohort","2" : "Student charges by program and full-year graduation rates, student financial aid rates, and retention rates cohort","3" : "Student charges for full academic year and full-year graduation rates, student financial aid rates, and retention rates cohort","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ueis` | Unique Entity Identifier (UEI) Numbers | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_basic_2025` | Carnegie Classification 2025: Basic | integer | yes | "1" : "Mixed Associate Large","2" : "Mixed Associate Medium","3" : "Mixed Associate Small","4" : "Mixed Associate/Baccalaureate","5" : "Mixed Baccalaureate","6" : "Mixed Undergraduate/Graduate-Doctorate Large","7" : "Mixed Undergraduate/Graduate-Doctorate Medium","8" : "Mixed Undergraduate/Graduate-Doctorate Small","9" : "Mixed Undergraduate/Graduate-Master's Large/Medium","10" : "Mixed Undergraduate/Graduate-Master's Small","11" : "Professions-focused Associate Large/Medium","12" : "Professions-focused Associate Small","13" : "Professions-focused Associate/Baccalaureate","14" : "Professions-focused Baccalaureate Medium","15" : "Professions-focused Baccalaureate Small","16" : "Professions-focused Undergraduate/Graduate-Doctorate Large","17" : "Professions-focused Undergraduate/Graduate-Doctorate Medium","18" : "Professions-focused Undergraduate/Graduate-Doctorate Small","19" : "Professions-focused Undergraduate/Graduate-Master's Large/Medium","20" : "Professions-focused Undergraduate/Graduate-Master's Small","21" : "Special Focus: Applied and Career Studies","22" : "Special Focus: Arts and Sciences","23" : "Special Focus: Arts, Music, and Design","24" : "Special Focus: Business","25" : "Special Focus: Graduate Studies","26" : "Special Focus: Law","27" : "Special Focus: Medical Schools and Centers","28" : "Special Focus: Nursing","29" : "Special Focus: Other Health Professions","30" : "Special Focus: Technology, Engineering, and Sciences","31" : "Special Focus: Theological Studies","-2" : "Not classified" |
| `cc_award_level_focus_2025` | Carnegie Classification 2025: Award Level Focus | integer | yes | "1" : "Associate","2" : "Associate/Baccalaureate","3" : "Baccalaureate","4" : "Undergraduate/Graduate-Master's","5" : "Undergraduate/Graduate-Doctorate","6" : "Graduate-focused","-2" : "Not classified" |
| `cc_instit_size_2025` | Carnegie Classification 2025: Institutional Size | integer | yes | "1" : "Very Small","2" : "Small","3" : "Medium","4" : "Large","5" : "Very Large","-2" : "Not classified" |
| `cc_instruc_grad_2025` | Carnegie Classification 2025: Graduate Academic Program Mix | integer | yes | "1" : "Mixed","2" : "Professions-focused","3" : "Special Focus: Applied and Career Studies","4" : "Special Focus: Arts and Sciences","5" : "Special Focus: Arts, Music, and Design","6" : "Special Focus: Business","7" : "Special Focus: Law","8" : "Special Focus: Medical Schools and Centers","9" : "Special Focus: Nursing","10" : "Special Focus: Other Health Professions","11" : "Special Focus: Technology, Engineering, and Sciences","12" : "Special Focus: Theological Studies","-2" : "Not classified" |
| `cc_research_act_desig_2025` | Carnegie Classification 2025: Research Activity Designation | integer | yes | "1" : "Research 1: Very High Spending and Doctorate Production","2" : "Research 2: High Spending and Doctorate Production","3" : "Research Colleges and Universities","-2" : "No research designation" |
| `cc_stud_access_earn_2025` | Carnegie Classification 2025: Student Access and Earnings | integer | yes | "1" : "Lower Access, Lower Earnings","2" : "Higher Access, Lower Earnings","3" : "Lower Access, Medium Earnings","4" : "Higher Access, Medium Earnings","5" : "Lower Access, Higher Earnings","6" : "Opportunity Colleges and Universities – Higher Access, Higher Earnings","-2" : "Not Classified in SAEC" |
| `cc_undergrad_2025` | Carnegie Classification 2025: Undergraduate Academic Program Mix | integer | yes | "1" : "Mixed","2" : "Professions-focused","3" : "Special Focus: Applied and Career Studies","4" : "Special Focus: Arts and Sciences","5" : "Special Focus: Arts, Music, and Design","6" : "Special Focus: Business","8" : "Special Focus: Medical Schools and Centers","9" : "Special Focus: Nursing","10" : "Special Focus: Other Health Professions","11" : "Special Focus: Technology, Engineering, and Sciences","12" : "Special Focus: Theological Studies","-2" : "Not classified" |
| `cc_basic_2021` | Carnegie Classification 2021: Basic | integer | yes | "1" : "Associate's Colleges: High Transfer-High Traditional","2" : "Associate's Colleges: High Transfer-Mixed Traditional/Nontraditional","3" : "Associate's Colleges: High Transfer-High Nontraditional","4" : "Associate's Colleges: Mixed Transfer/Career & Technical-High Traditional","5" : "Associate's Colleges: Mixed Transfer/Career & Technical-Mixed Traditional/Nontraditional","6" : "Associate's Colleges: Mixed Transfer/Career & Technical-High Nontraditional","7" : "Associate's Colleges: High Career & Technical-High Traditional","8" : "Associate's Colleges: High Career & Technical-Mixed Traditional/Nontraditional C21BASIC 9 Associate's Colleges: High Career & Technical-High Nontraditional","10" : "Special Focus Two-Year: Health Professions","11" : "Special Focus Two-Year: Technical Professions","12" : "Special Focus Two-Year: Arts & Design","13" : "Special Focus Two-Year: Other Fields","14" : "Baccalaureate/Associate's Colleges: Associate's Dominant","15" : "Doctoral Universities: Very High Research Activity","16" : "Doctoral Universities: High Research Activity","17" : "Doctoral/Professional Universities","18" : "Master's Colleges & Universities: Larger Programs","19" : "Master's Colleges & Universities: Medium Programs","20" : "Master's Colleges & Universities: Small Programs","21" : "Baccalaureate Colleges: Arts & Sciences Focus","22" : "Baccalaureate Colleges: Diverse Fields","23" : "Baccalaureate/Associate's Colleges: Mixed Baccalaureate/Associate's","24" : "Special Focus Four-Year: Faith-Related Institutions","25" : "Special Focus Four-Year: Medical Schools & Centers","26" : "Special Focus Four-Year: Other Health Professions Schools","27" : "Special Focus Four-Year: Research Institutions","28" : "Special Focus Four-Year: Engineering and Other Technology-Related Schools","29" : "Special Focus Four-Year: Business & Management Schools","30" : "Special Focus Four-Year: Arts, Music & Design Schools","31" : "Special Focus Four-Year: Law Schools","32" : "Special Focus Four-Year: Other Special Focus Institutions","33" : "Tribal Colleges","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_undergrad_2021` | Carnegie Classification 2021: Undergraduate Instructional Program | integer | yes | "0" : "Not Classified (Exclusively Graduate Programs)","1" : "Associate's Colleges: High Transfer","2" : "Associate's Colleges: Mixed Transfer/Career & Technical","3" : "Associate's Colleges: High Career & Technical","4" : "Special Focus: Two-Year Institution","5" : "Baccalaureate/Associates Colleges","6" : "Arts & sciences focus, no graduate coexistence","7" : "Arts & sciences focus, some graduate coexistence","8" : "Arts & sciences focus, high graduate coexistence","9" : "Arts & sciences plus professions, no graduate coexistence","10" : "Arts & sciences plus professions, some graduate coexistence","11" : "Arts & sciences plus professions, high graduate coexistence","12" : "Balanced arts & sciences/professions, no graduate coexistence","13" : "Balanced arts & sciences/professions, some graduate coexistence","14" : "Balanced arts & sciences/professions, high graduate coexistence","15" : "Professions plus arts & sciences, no graduate coexistence","16" : "Professions plus arts & sciences, some graduate coexistence","17" : "Professions plus arts & sciences, high graduate coexistence","18" : "Professions focus, no graduate coexistence","19" : "Professions focus, some graduate coexistence","20" : "Professions focus, high graduate coexistence","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_instruc_grad_2021` | Carnegie Classification 2021: Graduate Instructional Program | integer | yes | "0" : "Not classified (Exclusively Undergraduate)","1" : "Postbaccalaureate: Single program&ndash;Education","2" : "Postbaccalaureate: Single program&ndash;Business","3" : "Postbaccalaureate: Single program&ndash;Other","4" : "Postbaccalaureate: Comprehensive programs","5" : "Postbaccalaureate: Arts & sciences-dominant","6" : "Postbaccalaureate: Education-dominant, with Arts & Sciences","7" : "Postbaccalaureate: Business-dominant, with Arts & Sciences","8" : "Postbaccalaureate: Other-dominant, with Arts & Sciences","9" : "Postbaccalaureate: Education-dominant, with other professional programs","10" : "Postbaccalaureate: Business-dominant, with other professional programs","11" : "Postbaccalaureate: Other-dominant, with other professional programs","12" : "Research Doctoral: Single program-Education","13" : "Research Doctoral: Single program-Other","14" : "Research Doctoral: Comprehensive programs, with medical/veterinary school","15" : "Research Doctoral: Comprehensive programs, no medical/veterinary school","16" : "Research Doctoral: Humanities/social sciences-dominant","17" : "Research Doctoral: STEM-dominant","18" : "Research Doctoral: Professional-dominant","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_undergrad_2021` | Carnegie Classification 2021: Undergraduate Profile | integer | yes | "0" : "Not classified (Exclusively Graduate)","1" : "Two-year, higher part-time","2" : "Two-year, mixed part/full-time","3" : "Two-year, medium full-time","4" : "Two-year, higher full-time","5" : "Four-year, higher part-time","6" : "Four-year, mostly full-time, inclusive acceptance, lower transfer-in","7" : "Four-year, mostly full-time, inclusive acceptance, higher transfer-in","8" : "Four-year, medium full-time, selective acceptance, lower transfer-in","9" : "Four-year, medium full-time , selective acceptance, higher transfer-in","10" : "Four-year, nearly all full-time, inclusive acceptance, lower transfer-in","11" : "Four-year, nearly all full-time, inclusive acceptance, higher transfer-in","12" : "Four-year, nearly all full-time, selective acceptance, lower transfer-in","13" : "Four-year, nearly all full-time, selective acceptance, higher transfer-in","14" : "Four-year, nearly all full-time, highly selective acceptance, lower transfer-in","15" : "Four-year, nearly all full-time, highly selective acceptance, higher transfer-in","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_enroll_2021` | Carnegie Classification 2021: Enrollment Profile | integer | yes | "1" : "Exclusively undergraduate two-year","2" : "Exclusively undergraduate four-year","3" : "Very high undergraduate","4" : "High undergraduate","5" : "Majority undergraduate","6" : "Majority graduate","7" : "Exclusively graduate","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cc_size_setting_2021` | Carnegie Classification 2021: Size and Setting | integer | yes | "1" : "Two-year, very small","2" : "Two-year, small","3" : "Two-year, medium","4" : "Two-year, large","5" : "Two-year, very large","6" : "Four-year, very small, primarily nonresidential","7" : "Four-year, very small, primarily residential","8" : "Four-year, very small, highly residential","9" : "Four-year, small, primarily nonresidential","10" : "Four-year, small, primarily residential","11" : "Four-year, small, highly residential","12" : "Four-year, medium, primarily nonresidential","13" : "Four-year, medium, primarily residential","14" : "Four-year, medium, highly residential","15" : "Four-year, large, primarily nonresidential","16" : "Four-year, large, primarily residential","17" : "Four-year, large, highly residential","18" : "Exclusively graduate/professional","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_enrollment-fte`

- **Canonical mirror path:** `ipeds/colleges_ipeds_enrollment-fte.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/enrollment-full-time-equivalent/{year}/{level_of_study}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `credit_hours` | 12-month instructional activity credit hours | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `contact_hours` | 12-month instructional activity contact hours for undergraduates | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `acttype` | Instructional activity based on credit- or contact-hours indicator | integer | yes | "1" : "Contact hours","2" : "Credit hours","3" : "Both contact and credit hours","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `est_fte` | Estimated full-time equivalent enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rep_fte` | Reported full-time equivalent enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_fall-enrollment-age_{year}`

- **Canonical mirror path:** `ipeds/colleges_ipeds_fall-enrollment-age_{year}.parquet` (30 mirror files)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/fall-enrollment/{year}/{level_of_study}/age/sex/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `age` | Age | integer | yes | "10" : "Under 18","11" : "18&ndash;24","12" : "25&ndash;39","13" : "40 or older","21" : "18&ndash;19","22" : "20&ndash;21","23" : "22&ndash;24","24" : "25&ndash;29","25" : "30&ndash;34","26" : "35&ndash;39","27" : "40&ndash;49","28" : "50&ndash;64","29" : "65 or older","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `enrollment_fall` | Fall enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_fall-enrollment-race_{year}`

- **Canonical mirror path:** `ipeds/colleges_ipeds_fall-enrollment-race_{year}.parquet` (39 mirror files)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/fall-enrollment/{year}/{level_of_study}/race/sex/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment_fall` | Fall enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_fall-res`

- **Canonical mirror path:** `ipeds/colleges_ipeds_fall-res.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/fall-enrollment/{year}/residence/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_of_residence` | State of residence | integer | yes | "1" : "Alabama","2" : "Alaska","4" : "Arizona","5" : "Arkansas","6" : "California","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","57" : "State unknown","58" : "US total","60" : "American Samoa","64" : "Federated States of Micronesia","66" : "Guam","68" : "Marshall Islands","69" : "Northern Marianas","70" : "Palau","72" : "Puerto Rico","75" : "Trust Territory of the Pacific Islands","78" : "Virgin Islands","89" : "Outlying areas total","90" : "Foreign countries","98" : "Residence not reported (balance line)","99" : "Total" |
| `type_of_freshman` | Type of freshman | integer | yes | "1" : "Graduated from HS in past 12 months","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment_fall` | Fall enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_fall-retention`

- **Canonical mirror path:** `ipeds/colleges_ipeds_fall-retention.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/fall-retention/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `retention_rate` | Retention rate | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `returning_students` | Students from the full-time adjusted previous fall cohort enrolled in the fall of the current year | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prev_cohort` | Previous fall cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prev_exclusions` | Exclusions from previous fall cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prev_cohort_adj` | Previous fall cohort, adjusted (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prev_inclusions` | Exclusions from previous fall cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_finance`

- **Canonical mirror path:** `ipeds/colleges_ipeds_finance.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/finance/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_tuition_fees_gross` | Revenue: Tuition and fees | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_tuition_fees_net` | Revenue: Tuition and fees, net of discounts and allowances | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_appropriations_fed` | Revenue: Federal appropriations | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_appropriations_state` | Revenue: State appropriations | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_appropriations_local` | Revenue: Local appropriations | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_grants_contracts_federal` | Revenue: Federal grants and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_grants_contracts_state` | Revenue: State grants and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_grants_contracts_local` | Revenue: Local grants and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_approps_grants` | Revenue: Federal appropriations, grants, and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_local_approps_grants` | Revenue: State and local appropriations, grants, and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_gifts_grants_contracts` | Revenue: Private gifts, grants, and contracts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_affiliated_entities` | Revenue: Total contributions from affiliated entities | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_investment_return` | Revenue: Investment return | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_edu_services_sales` | Revenue: Sales and services of educational activities | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_auxiliary_enterprises_gross` | Revenue: Auxiliary enterprises | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_auxiliary_enterprises_net` | Revenue: Auxiliary enterprises, net of discounts and allowances | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_independent_operations` | Revenue: Independent operations | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_other_operating` | Revenue: Other operating income | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_other_nonoperating` | Revenue: Other nonoperating income | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_other_additions` | Revenue: Other additions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_other` | Revenue: Other sources | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_hospital` | Revenue: Hospital revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_hosp_ind_op_other` | Revenue: Hospitals, independent operations, and other sources | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_operating` | Revenue: Total operating revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_nonoperating` | Revenue: Total nonoperating revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_capital_approps` | Revenue: Capital appropriations | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_capital_grants_gifts` | Revenue: Capital grants and gifts | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_endowment_income` | Revenue: Endowment income | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_endowment_additions` | Revenue: Additions to permanent endowments | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_additions` | Revenue: Total other revenue and additions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_total_current` | Revenue: Total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_pell_grant` | Pell grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_other_federal_grants` | Other federal grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_grants_state` | State grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_grants_local` | Local grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_grants_state_local` | State and local grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_restricted_inst_grants` | Institutional grants (restricted) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_unrestricted_inst_grants` | Institutional grants (unrestricted) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_grants_institutional` | Institutional grants (total) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_grants_private` | Private grants | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_total_student_aid` | Total student aid | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_allowances_tuition_fees` | Discounts and allowances applied to tuition and fees | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_allowances_aux_enterp` | Discounts and allowances applied to auxiliary enterprise revenues | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_allowances_total` | Total discounts and allowances | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_exp_net_fellowships` | Net scholarships and fellowship expenses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_instruc_total` | Expenditures: Instruction&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_instruc_salaries` | Expenditures: Instruction&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_research_total` | Expenditures: Research&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_research_salaries` | Expenditures: Research&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_pub_serv_total` | Expenditures: Public service&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_pub_serv_salaries` | Expenditures: Public service&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_res_pub_serv_total` | Expenditures: Research and public service&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_res_pub_serv_salaries` | Expenditures: Research and public service&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_acad_supp_total` | Expenditures: Academic support&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_acad_supp_salaries` | Expenditures: Academic support&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_student_serv_total` | Expenditures: Student services&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_student_serv_salaries` | Expenditures: Student services&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_inst_supp_total` | Expenditures: Institutional support&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_inst_supp_salaries` | Expenditures: Institutional support&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_acad_inst_student_total` | Expenditures: Academic and institutional support and student services&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_acad_inst_student_salaries` | Expenditures: Academic and institutional support and student services&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_aux_ent_total` | Expenditures: Auxiliary enterprises&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_aux_ent_salaries` | Expenditures: Auxiliary enterprises&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_net_grant_aid_total` | Expenditures: Net scholarships and fellowship expenses&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_net_grant_aid_salaries` | Expenditures: Net scholarships and fellowship expenses&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_hospital_total` | Expenditures: Hospital services&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_hospital_salaries` | Expenditures: Hospital services&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_ind_op_total` | Expenditures: Independent operations&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_ind_op_salaries` | Expenditures: Independent operations&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other_total_funct` | Expenditures: Other functional expenses&mdash;total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other_salaries` | Expenditures: Other functional expenses&mdash;salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_current` | Expenditures: Total | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_salaries` | Expenditures: Salaries and wages | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_benefits` | Expenditures: Benefits | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_opm` | Expenditures: Operations and maintenance of plant | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_depr` | Expenditures: Depreciation | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_interest` | Expenditures: Interest | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_total_other_nat` | Expenditures: Other natural expenses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `endowment_beg` | Value of endowment (beginning of year) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `endowment_end` | Value of endowment (end of year) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `own_endowment_assets` | Own endowment assets? (yes/no) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `longterm_investments` | Long-term investments | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `depr_capital_assets` | Depreciable capital assets, net of depreciation | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assets` | Total assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `liabilities` | Total liabilities | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assets_net` | Net assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `def_outflows_resources` | Deferred outflows of resources | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `longterm_debt` | Long-term debt | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `def_inflows_resources` | Deferred inflows of resources | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `invest_capital_assets` | Investments in capital assets, net of related debt | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `position_net` | Net position | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `plant_prop_equip_debt` | Debt related to property, plant, and equipment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equity_total` | Total equity | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `land_improvements` | Assets: Land and land improvements | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `infrastructure` | Assets: Infrastructure | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `buildings` | Assets: Buildings | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equipment` | Assets: Equipment, including art and library collections | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `construction_in_progress` | Assets: Construction in progress | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_plant_prop_equip` | Assets: Other plant, property, and equipment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `plant_property_equipment` | Assets: Total plant, property, and equipment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `depreciation_accumulated` | Accumulated depreciation | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `intangible_assets_net` | Intangible assets, net of accumulated amortization | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `capital_assets_other` | Other capital assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `plant_prop_equip_net` | Property, plant, and equipment, net of accumulated depreciation | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_revenues_additions` | Total revenue, investment return, and other additions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_expenses_deductions` | Total expenses and deductions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equity_changes_total` | Sum of changes in equity or net assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `income_net` | Net income or change in net assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equity_changes_other` | Other changes in equity or net assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equity_beg` | Equity or net assets, beginning of year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_equity_beg_adjust` | Adjustments to beginning-of-year net equity or net assets | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `equity_end` | Equity or net assets, end of year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_position_change` | Change in net position during the year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_position_beginning` | Net position, beginning of year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_position_adjustments` | Adjustments to beginning net position | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_position_end` | Net position, end of year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `income_tax_fed` | Federal income tax expenses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `income_tax_state` | State and local income tax expenses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `pension_info_reported` | Pension information reported (Government Accounting Standards Board institutions) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `def_inflows_pension` | Deferred inflows of resources for pensions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `def_outflows_pension` | Deferred outflows of resources for pensions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `pension_expense` | Pension expenses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_pension_liability` | Net pension liability | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `parent_child_flag` | Parent-child flag | integer | no | "1" : "Parent record&mdash;includes data from branch campuses","2" : "Child record&mdash;data reported with parent campus","3" : "Partial child record&mdash;reports revenue and expenses; assets and liabilities reported with parent campus","4" : "Child record&mdash;data included with entity that is not a postsecondary institution","5" : "Child record&mdash;reports partial data, but other data are included with entity that is not a postsecondary institution","6" : "Partial parent-child record&mdash;reports revenue and expenses that also includes branch campuses; assets and liabilities reported with parent","-1" : "Missing/not reported","-2" : "Not applicable" |
| `parent_child_system_flag` | Parent-child system flag | integer | no | "1" : "Full parent-child system","2" : "Partial parent-child system","3" : "Partial parent-child system where some partial child institutions also act as parent institutions for other child institutions","5" : "System with partial reporting children campuses of non-IPEDS entity","-1" : "Missing/not reported","-2" : "Not applicable" |
| `parent_unitid` | Unit ID of parent institution | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `parent_child_allocation` | Parent-child allocation factor | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reporting_form` | Reporting form, as reported to IPEDS | integer | no | "1" : "GASB Reporting Standards before GASB 34/35","2" : "GASB reporting standards 34/35","3" : "GASB reporting standards (aligned)","4" : "FASB reporting standards","5" : "FASB reporting standards (aligned)","6" : "Modified FASB (private for-profit institutions)","-1" : "Missing/not reported","-2" : "Not applicable" |
| `form_type` | Reporting form based on file name | integer | no | "1" : "Common form","2" : "Form 1","3" : "Form 1A","4" : "Form 2","5" : "Form 3" |
| `gasb_alternative_accounting` | Government Accounting Standards Board alternative accounting indicator | integer | no | "1" : "Business-type activities","2" : "Governmental activities","3" : "Governmental activities with business-type activities","-1" : "Missing/not reported","-2" : "Not applicable" |
| `pell_grant_treatment` | Treatment of Pell grants | integer | no | "1" : "Pass through (agency)","2" : "Federal grants","3" : "Does not award Pell grants","-1" : "Missing/not reported","-2" : "Not applicable" |
| `athletic_expense_treatment` | Athletic expense treatment | integer | no | "1" : "Intercollegiate athletic expenses are accounted for as auxiliary enterprises","2" : "Intercollegiate athletic expenses are treated as student services","3" : "Does not participate in intercollegiate athletics","4" : "Other","-1" : "Missing/not reported","-2" : "Not applicable" |
| `cpi` | Consumer Price Index | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `hepi` | Higher Education Price Index | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `heca` | Higher Education Cost Adjustment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `est_fte` | Estimated full-time equivalent enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rep_fte` | Reported full-time equivalent enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `calc_fte` | Calculated full-time equivalent enrollment, based on fall enrollment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_grad-rates`

- **Canonical mirror path:** `ipeds/colleges_ipeds_grad-rates.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/grad-rates/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_year` | Year students in this cohort enrolled, left the institution, or otherwise entered this cohort depending on the data source | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `institution_level` | Level of institution | integer | yes | "1" : "Less than two years (below associate's)","2" : "At least two but less than four years","3" : "Less than four years","4" : "Four or more years","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `subcohort` | Subcohorts within a four-year institution | integer | yes | "1" : "Degree/certificate nonbachelor's seeking subcohort of four-year institutions","2" : "Bachelor's or equivalent subcohort of four-year institutions","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_rev` | Revised cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions` | Students who left the cohort for certain reasons and are not included in the denominator of the completion rate | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj_150pct` | Adjusted cohort (revised cohort minus exclusions) (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_150pct` | Completers within 150% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `transfers_out` | Number of adjusted cohort who enrolled subsequently at another institution | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enrolled_long_program` | Number of noncompleters, still enrolled in long program | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_100pct` | Completers within 100% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enrolled` | Number of noncompleters, still enrolled | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_longer_enrolled` | Number of students no longer enrolled | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_150pct` | Graduation rate within 150% of normal time | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_grad-rates-200pct`

- **Canonical mirror path:** `ipeds/colleges_ipeds_grad-rates-200pct.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/grad-rates-200pct/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `institution_level` | Level of institution | integer | yes | "1" : "Less than two years (below associate's)","2" : "At least two but less than four years","3" : "Less than four years","4" : "Four or more years","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_year` | Year students in this cohort enrolled, left the institution, or otherwise entered this cohort depending on the data source | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_100pct` | Graduation rate within 100% of normal time | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_150pct` | Graduation rate within 150% of normal time | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_200pct` | Graduation rate within 200% of normal time | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj_150pct` | Adjusted cohort (revised cohort minus exclusions) (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj_200pct` | Adjusted cohort (revised cohort minus exclusions and additional exclusions) (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_100pct` | Completers within 100% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_150pct` | Completers within 150% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_200pct` | Completers within 200% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enrolled_200pct` | Noncompleters, still enrolled | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_rev` | Revised cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions` | Students who left the cohort for certain reasons and are not included in the denominator of the completion rate | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `add_exclusions` | Additional exclusions that occurred between 150% and 200% of normal time to completion (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_grad-rates-pell`

- **Canonical mirror path:** `ipeds/colleges_ipeds_grad-rates-pell.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/grad-rates-pell/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_year` | Year students in this cohort enrolled, left the institution, or otherwise entered this cohort depending on the data source | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `institution_level` | Level of institution | integer | yes | "1" : "Less than two years (below associate's)","2" : "At least two but less than four years","3" : "Less than four years","4" : "Four or more years","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `subcohort` | Subcohorts within a four-year institution | integer | yes | "1" : "Degree/certificate nonbachelor's seeking subcohort of four-year institutions","2" : "Bachelor's or equivalent subcohort of four-year institutions","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fed_aid_type` | Type of federal aid that the student received | integer | yes | "1" : "Pell grant","2" : "Subsidized Stafford","3" : "Not recipients of either Pell or subsidized Stafford","4" : "Not recipients of Pell","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_rev` | Revised cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions` | Students who left the cohort for certain reasons and are not included in the denominator of the completion rate | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj` | Adjusted cohort (revised cohort minus exclusions) (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_150pct` | Completers within 150% of normal time | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_150pct` | Graduation rate within 150% of normal time | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_headcount`

- **Canonical mirror path:** `ipeds/colleges_ipeds_headcount.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/enrollment-headcount/{year}/{level_of_study}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `headcount` | Unduplicated head count of students enrolled over a 12-month period | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_institutional-characteristics`

- **Canonical mirror path:** `ipeds/colleges_ipeds_institutional-characteristics.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/institutional-characteristics/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_affiliation` | Institutional control or affiliation | integer | yes | "1" : "Public","2" : "Private for-profit","3" : "Private not-for-profit (no religious affiliation)","4" : "Private not-for-profit (religious affiliation)","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `primary_public_control` | Primary public control | integer | yes | "1" : "Federal","2" : "State","3" : "Territorial","4" : "School district","5" : "County","6" : "Township","7" : "City","8" : "Special district","9" : "Other","0" : "Implied no","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `secondary_public_control` | Secondary public control | integer | yes | "1" : "Federal","2" : "State","3" : "Territorial","4" : "School district","5" : "County","6" : "Township","7" : "City","8" : "Special district","9" : "Other","0" : "Implied no","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `occupational_prog_offered` | Occupational program offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `academic_prog_offered` | Academic program offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cont_prof_prog_offered` | Continuing professional program offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `avocational_prog_offered` | Recreational or avocational program offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `remedial_prog_offered` | For-credit adult basic remedial or high school equivalent program offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `secondary_prog_offered` | Secondary (high school) program offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cert_0_1_offered` | Less than one-year certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cert_0_1_a_offered` | Less than 12-week certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cert_0_1_b_offered` | Less than one-year but more than 12-week certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cert_1_2_offered` | At least one- but less than two-year certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assoc_offered` | Associate's degree offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cert_2_4_offered` | At least two- but less than four-year certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `bach_offered` | Bachelor's degree offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `postbac_cert_offered` | Postbaccalaureate certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `masters_offered` | Master's degree offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `post_masters_cert_offered` | Post-master's certificate offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `doctors_research_offered` | Doctor's degree, research/scholarship offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `doctors_professional_offered` | Doctor's degree, professional practice offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `doctors_other_offered` | Doctor's degree, other offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_degree_offered` | Other degree offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_ug_courses_offered` | Undergraduate level distance education courses offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_ug_progs_offered` | Undergraduate level distance education programs offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_ug_not_offered` | Undergraduate level distance education not offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_grad_courses_offered` | Graduate level distance education courses offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_grad_progs_offered` | Graduate level distance education programs offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_grad_not_offered` | Graduate level distance education not offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_progs_offered` | Distance education programs offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_courses_offered` | Distance education courses offered (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_progs_all` | All programs offered completely via distance education (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_ug_offered` | Undergraduate programs or courses are offered via distance education (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_grad_offered` | Graduate programs or courses are offered via distance education (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dist_ed_not_offered` | Does not offer distance education opportunities | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_undergrad_fulltime` | Full-time undergraduate students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_undergrad_firsttime_ft` | Full-time first-time degree/certificate-seeking undergraduate students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_undergrad_parttime` | Part-time undergraduate students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_undergrad_firsttime_pt` | Part-time first-time degree/certificate-seeking undergraduate students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_graduate_fulltime` | Full-time graduate (not including doctor's professional practice) students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_graduate_parttime` | Part-time graduate (not including doctor's professional practice) students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_doctors_professional` | Doctor's professional practice students are enrolled (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrolled_doctors_first_prof` | Doctor's professional practice students are enrolled in programs formerly designated as first-professional (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `remedial_services` | Remedial services offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `academic_counseling` | Academic/career counseling service offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `employment_services` | Employment services for students offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `placement_services` | Placement services for completers offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `oncampus_daycare` | On-campus day care for students' children offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_selected_services` | None of the above selected services are offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `oncampus_housing` | Institution provides on-campus housing | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `oncampus_required` | Full-time, first-time degree/certificate-seeking students required to live on campus (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dormitory_capacity` | Total dormitory capacity | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meal_plan` | Institution provides board or meal plan | integer | no | "0" : "No meal plan","1" : "Yes, number of meals in the maximum meal plan offered","2" : "Yes, number of meals per week can vary","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meals_per_week` | Number of meals per week in board charge | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `typical_room_charge` | Typical room charge for academic year | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `typical_board_charge` | Typical board charge for academic year | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `room_board_charge` | Combined charge for room and board | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_varies` | Tuition charge varies for in-district, in-state, out-of-state students | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alt_tuition` | Any alternative tuition plans offered by institution | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_guaranteed` | Tuition guaranteed plan | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prepaid_tuition` | Prepaid tuition plan | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_payment_plan` | Tuition payment plan | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_alt_tuition` | Other alternative tuition plan | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `religious_affiliation` | Religious affiliation | integer | yes | "22" : "American Evangelical Lutheran Church","24" : "African Methodist Episcopal Zion Church","26" : "Not applicable","27" : "Assemblies of God Church","28" : "Brethren Church","29" : "Brethren in Christ Church","30" : "Roman Catholic","33" : "Wisconsin Evangelical Lutheran Synod","34" : "Christ and Missionary Alliance Church","35" : "Christian Reformed Church","36" : "Evangelical Congregational Church","37" : "Evangelical Covenant Church of America","38" : "Evangelical Free Church of America","39" : "Evangelical Lutheran Church","40" : "International United Pentecostal Church","41" : "Free Will Baptist Church","42" : "Interdenominational","43" : "Mennonite Brethren Church","44" : "Moravian Church","45" : "North American Baptist","46" : "American Lutheran and Lutheran Church in America","47" : "Pentecostal Holiness Church","48" : "Christian Churches and Churches of Christ","49" : "Reformed Church in America","50" : "Episcopal Church","51" : "African Methodist Episcopal","53" : "American Lutheran","54" : "Baptist","55" : "Christian Methodist Episcopal","56" : "Church of Christ (Scientist)","57" : "Church of God","58" : "Church of Brethren","59" : "Church of the Nazarene","60" : "Cumberland Presbyterian","61" : "Christian Church (Disciples of Christ)","64" : "Free Methodist","65" : "Friends","66" : "Presbyterian Church (USA)","67" : "Lutheran Church in America","68" : "Lutheran Church - Missouri Synod","69" : "Mennonite Church","70" : "General Conference Mennonite Church","71" : "United Methodist","73" : "Protestant Episcopal","74" : "Churches of Christ","75" : "Southern Baptist","76" : "United Church of Christ","77" : "Protestant","78" : "Multiple Protestant Denomination","79" : "Other Protestant","80" : "Jewish","81" : "Reformed Presbyterian Church","82" : "Reorganized Latter Day Saints Church","83" : "Seventh Day Adventists Church","84" : "United Brethren Church","86" : "Independent Fundamental Church of America","87" : "Missionary Church Inc","88" : "Undenominational","89" : "Wesleyan","91" : "Greek Orthodox","92" : "Russian Orthodox","93" : "Unitarian Universalist","94" : "Latter Day Saints (Mormon Church)","95" : "Seventh Day Adventists","97" : "The Presbyterian Church in America","98" : "Salvation Army","100" : "Original Free Will Baptist","101" : "Ecumenical Christian","102" : "Evangelical Christian","103" : "Presbyterian","105" : "General Baptist","106" : "Muslim","107" : "Plymouth Brethren","108" : "Nondenominational","200" : "Other (none of the above)","52" : "American Baptist","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_natl_athletic_assoc` | Member of National Athletic Association | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_ncaa` | Member of National Collegiate Athletic Association (NCAA) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_naia` | Member of National Association of Intercollegiate Athletics (NAIA) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_njcaa` | Member of National Junior College Athletic Association (NJCAA) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_nscaa` | Member of National Small College Athletic Association (NSCAA) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_nccaa` | Member of National Christian College Athletic Association (NCCAA) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_ath_assoc_other` | Member of other national athletic association not listed above | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_conf_football` | NCAA/NAIA member for football | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_conf_basketball` | NCAA/NAIA member for basketball | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_conf_baseball` | NCAA/NAIA member for baseball | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `member_conf_track` | NCAA/NAIA member for cross country/track | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `conf_number_football` | NCAA/NAIA conference number football | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `conf_number_basketball` | NCAA/NAIA conference number basketball | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `conf_number_baseball` | NCAA/NAIA conference number baseball | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `conf_number_track` | NCAA/NAIA conference number cross country/track | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `dual_credit` | Institution accepts dual credit | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `credit_for_life` | Institution accepts credit for life experiences | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ap_credit` | Institution accepts Advanced Placement (AP) credits | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_alt_credit` | Institution does not accept dual, credit for life, or AP credits | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rotc` | Reserve Officers' Training Corps (ROTC) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rotc_army` | ROTC, Army | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rotc_navy` | ROTC, Navy | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rotc_airforce` | ROTC, Air Force | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `study_abroad` | Study abroad offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `weekend_evening_college` | Weekend/evening college offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teacher_cert` | Teacher certification (below the postsecondary level) offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teacher_cert_specialization` | Teacher certification: Students can complete their preparation in certain areas of specialization | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teacher_cert_other_inst` | Teacher certification: Students must complete their preparation at another institution for certain areas of specialization | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teacher_cert_state_approved` | Teacher certification: Approved by the state for initial certifcation or licensure of teachers | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_special_learning_opps` | None of the above special learning opportunities are offered | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability_indicator` | Indicates if fewer than 3 percent of undergraduates are formally registered as students with disabilities | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability_percentage` | Percentage of undergraduates, who are formally registered as students with disabilities, when percentage is greater than 3 percent | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `yellow_ribbon_program` | Yellow Ribbon Program (officially known as Post-9/11 GI Bill, Yellow Ribbon Program) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `military_training_credit` | Credit for military training | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `veteran_point_of_contact` | Dedicated point of contact for support services for veterans, military service members, and their families | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `student_veteran_organization` | Recognized student veteran organization | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `servicemember_opp_coll_member` | Member of Servicemembers Opportunity Colleges | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_vet_services` | Services and programs are not available to veterans, military service members, or their families | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_physical` | Library resources/services: Physical facilities (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_printed_collection` | Library resources/services: Organized collection of printed materials (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_digital` | Library resources/services: Access to digital/electronic resources (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_trained_staff` | Library resources/services: Staff trained to provide and interpret library materials (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_hours` | Library resources/services: Established library hours (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `library_shared` | Library resources/services: Access to library collections that are shared with other institutions (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_library` | Library resources/services not provided | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `calendar_system` | Calendar system | integer | yes | "1" : "Semester","2" : "Quarter","3" : "Trimester","4" : "Four-one-four plan","5" : "Other academic year","6" : "Differs by program","7" : "Continuous","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_workforce_edu_offered` | Noncredit workforce education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_cust_training_offered` | Noncredit contract training/customized training offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_remedial_edu_offered` | Noncredit remedial education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_rec_edu_offered` | Noncredit recreational/avocational/leisure/personal enrichment education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_adult_edu_offered` | Noncredit adult basic education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncred_hs_diploma_offered` | Noncredit adult high school diploma or equivalent education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncredit_esl_edu_offered` | Noncredit English as a second language education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `noncredit_prof_edu_offered` | Noncredit continuing professional education offered | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_noncredit_edu` | Institution does not offer noncredit education | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rotc_navy_marinecorps` | ROTC - Navy Marine Corps option | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `undergrad_research` | Undergraduate research (co-curricula) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `postsec_tr_prog_disabilities` | Comprehensive transition and postsecondary program for students with intellectual disabilities | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `promise_prog_participant` | Participates in a Promise Program | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_outcome-measures`

- **Canonical mirror path:** `ipeds/colleges_ipeds_outcome-measures.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/outcome-measures/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fed_aid_type` | Type of federal aid that the student received | integer | yes | "1" : "Pell grant","2" : "Subsidized Stafford","3" : "Not recipients of either Pell or subsidized Stafford","4" : "Not recipients of Pell","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_year` | Year students in this cohort enrolled, left the institution, or otherwise entered this cohort depending on the data source | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_rev` | Revised cohort (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions` | Students who left the cohort for certain reasons and are not included in the denominator of the completion rate | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj` | Adjusted cohort (revised cohort minus exclusions) (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_rev_6yr` | Revised cohort at 6 years (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions_6yr` | Exclusions to cohort at 6 years (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj_6yr` | Adjusted cohort at 6 years (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exclusions_add_8yr` | Additional exclusions between 6 and 8 years (number of students) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cohort_adj_8yr` | Adjusted cohort at 8 years (number) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_cert_4yr` | Number of adjusted cohort receiving a certificate at 4 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_assoc_4yr` | Number of adjusted cohort receiving an associate's degree at 4 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_bach_4yr` | Number of adjusted cohort receiving a bachelor's degree at 4 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_4yr` | Number of adjusted cohort receiving an award at 4 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_4yr` | Graduation rate within 4 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_cert_6yr` | Number of adjusted cohort receiving a certificate at 6 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_assoc_6yr` | Number of adjusted cohort receiving an associate's degree at 6 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_bach_6yr` | Number of adjusted cohort receiving a bachelor's degree at 6 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_6yr` | Number of adjusted cohort receiving an award at 6 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_6yr` | Graduation rate within 6 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_cert_8yr` | Number of adjusted cohort receiving a certificate at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_assoc_8yr` | Number of adjusted cohort receiving an associate's degree at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `award_bach_8yr` | Number of adjusted cohort receiving a bachelor's degree at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completers_8yr` | Number of adjusted cohort receiving an award at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enroll_8yr` | Number of adjusted cohort still enrolled at your institution at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `transfer_8yr` | Number of adjusted cohort who enrolled subsequently at another institution at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `unknown_8yr` | Number of adjusted cohort whose subsequent enrollment status is unknown at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_award_8yr` | Number of adjusted cohort who did not receive an award from your institution at 8 years | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `completion_rate_8yr` | Graduation rate within 8 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enroll_transfer_rate_8yr` | Percent of adjusted cohort still or subsequently enrolled at 8 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `still_enroll_rate_8yr` | Percent of adjusted cohort still enrolled at your institution at 8 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `transfer_rate_8yr` | Percent of adjusted cohort enrolled subsequently at another institution at 8 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `unknown_rate_8yr` | Percentage of adjusted cohort whose status is unknown at 8 years | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_py_room_board_other`

- **Canonical mirror path:** `ipeds/colleges_ipeds_py_room_board_other.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/program-year-room-board-other/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `living_arrangement` | Living arrangement (on or off campus) | integer | yes | "1" : "On campus","2" : "Off campus with family","3" : "Off campus not with family","4" : "Unknown","99" : "Total" |
| `room_board` | Room and board (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_other` | Other expenses (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_py_tuition_cip`

- **Canonical mirror path:** `ipeds/colleges_ipeds_py_tuition_cip.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/program-year-tuition-cip/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `program_size_rank` | Program size ranking | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cipcode_6digit` | 6-digit Classification of Instructional Programs (CIP) code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_fees` | Tuition and fees | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `books_supplies` | Books and supplies (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment` | Student enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `no_ftft_ug` | No full-time, first-time undergaduate students | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `program_length_hours` | Length of program (in credit or contact hours) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `contact_or_credit_hours` | Program length is measured in contact or credit hours | integer | yes | "1" : "Contact hours","2" : "Credit hours","-1" : "Missing/not reported" |
| `program_length_weeks` | Length of program as completed by a full-time student (weeks) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `average_length_months` | Average program length (months) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `acad_year_length_hours` | Length of academic year as used to calculate Pell budget (contact or credit hours) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `acad_year_length_weeks` | Length of academic year as used to calculate Pell budget (weeks) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_salaries_is`

- **Canonical mirror path:** `ipeds/colleges_ipeds_salaries_is.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/salaries-instructional-staff/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `academic_rank` | Academic rank | integer | yes | "1" : "Professor","2" : "Associate professor","3" : "Assistant professor","4" : "Instructor","5" : "Lecturer","6" : "No academic rank","99" : "Total" |
| `contract_length` | Contract length | integer | yes | "5" : "9&ndash;10 months","6" : "11&ndash;12 months","7" : "9-month equivalent","8" : "Less than 9 months","9" : "9 months","10" : "10 months","11" : "11 months","12" : "12 months","13" : "9-, 10-, 11-, and 12-month total","99" : "Total" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instruc_staff_count` | Instructional staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salary_outlays` | Total salary outlays | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `average_salary` | Average salary | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_months` | Months covered by salary outlays | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `avg_wgtd_mon_salary` | Average weighted monthly salary | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_salaries_nis`

- **Canonical mirror path:** `ipeds/colleges_ipeds_salaries_nis.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/salaries-noninstructional-staff/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `staff_category` | Staff category | integer | yes | "2" : "Research","3" : "Public service","4" : "Education services (librarians, curators, archivists, academic affairs, etc.)","5" : "Management","6" : "Business and financial operations","7" : "Computer, engineering, and science","8" : "Community, social service, legal, arts, design, entertainment, sports, and media","9" : "Healthcare practitioners and technical","10" : "Service","11" : "Sales and related","12" : "Office and administrative support","13" : "Natural resources, construction, and maintenance","14" : "Production, transportation, and material moving","99" : "Total" |
| `noninstruc_staff_count` | Noninstructional staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salary_outlays` | Total salary outlays | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_sfa_all_undergrads`

- **Canonical mirror path:** `ipeds/colleges_ipeds_sfa_all_undergrads.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/sfa-all-undergraduates/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `type_of_aid` | Type of financial aid | integer | yes | "1" : "Any aid","2" : "Federal, state, local, or institutional aid","3" : "Federal, state, local, or institutional grants","4" : "Federal grants","5" : "Pell grant","6" : "Other federal grants","7" : "State or local grants","8" : "Institutional grants","9" : "Title IV aid","10" : "Student loan","11" : "Federal student loan","12" : "Other student loan","13" : "Post-9/11 GI Bill Benefits","14" : "Department of Defense Tuition Assistance Program","99" : "Total" |
| `number_of_students` | Total students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `percent_of_students` | Percent of students | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `average_amount` | Average aid amount (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_amount` | Total aid amount (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_sfa_by_living_arrangement`

- **Canonical mirror path:** `ipeds/colleges_ipeds_sfa_by_living_arrangement.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/sfa-by-living-arrangement/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_type` | Tuition type (in state, out of state, etc.) | integer | yes | "1" : "In state or in district","2" : "In district","3" : "In state","4" : "Out of state","5" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `type_of_aid` | Type of financial aid | integer | yes | "1" : "Any aid","2" : "Federal, state, local, or institutional aid","3" : "Federal, state, local, or institutional grants","4" : "Federal grants","5" : "Pell grant","6" : "Other federal grants","7" : "State or local grants","8" : "Institutional grants","9" : "Title IV aid","10" : "Student loan","11" : "Federal student loan","12" : "Other student loan","13" : "Post-9/11 GI Bill Benefits","14" : "Department of Defense Tuition Assistance Program","99" : "Total" |
| `living_arrangement` | Living arrangement (on or off campus) | integer | yes | "1" : "On campus","2" : "Off campus with family","3" : "Off campus not with family","4" : "Unknown","99" : "Total" |
| `number_of_students` | Total students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_sfa_by_tuition_type`

- **Canonical mirror path:** `ipeds/colleges_ipeds_sfa_by_tuition_type.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/sfa-by-tuition-type/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `type_of_cohort` | Type of cohort (fall or full-year) | integer | yes | "1" : "Fall cohort","2" : "Full-year cohort" |
| `tuition_type` | Tuition type (in state, out of state, etc.) | integer | yes | "1" : "In state or in district","2" : "In district","3" : "In state","4" : "Out of state","5" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_of_students` | Total students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `percent_of_cohort` | Percentage of cohort | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `percent_of_undergrads` | Percentage of all undergraduate students | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_sfa_ftft`

- **Canonical mirror path:** `ipeds/colleges_ipeds_sfa_ftft.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/sfa-ftft/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `type_of_aid` | Type of financial aid | integer | yes | "1" : "Any aid","2" : "Federal, state, local, or institutional aid","3" : "Federal, state, local, or institutional grants","4" : "Federal grants","5" : "Pell grant","6" : "Other federal grants","7" : "State or local grants","8" : "Institutional grants","9" : "Title IV aid","10" : "Student loan","11" : "Federal student loan","12" : "Other student loan","13" : "Post-9/11 GI Bill Benefits","14" : "Department of Defense Tuition Assistance Program","99" : "Total" |
| `number_of_students` | Total students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `percent_of_students` | Percent of students | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `average_amount` | Average aid amount (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_amount` | Total aid amount (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_sfa_grants_and_net_price`

- **Canonical mirror path:** `ipeds/colleges_ipeds_sfa_grants_and_net_price.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/sfa-grants-and-net-price/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ftpt` | Full-time or part-time status | integer | yes | "1" : "Full-time","2" : "Part-time","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `level_of_study` | Level of study | integer | yes | "1" : "Undergraduate","2" : "Graduate","3" : "First professional","4" : "Postbaccalaureate","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_seeking` | Degree/certificate-seeking | integer | yes | "0" : "No","1" : "Yes","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","99" : "Total" |
| `class_level` | Class level (freshman, transfer, continuing) | integer | yes | "1" : "First-time","2" : "Other (transfer-ins or non-first-time-entering)","3" : "Other (continuing)","4" : "Other (total)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `tuition_type` | Tuition type (in state, out of state, etc.) | integer | yes | "1" : "In state or in district","2" : "In district","3" : "In state","4" : "Out of state","5" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `type_of_aid` | Type of financial aid | integer | yes | "1" : "Any aid","2" : "Federal, state, local, or institutional aid","3" : "Federal, state, local, or institutional grants","4" : "Federal grants","5" : "Pell grant","6" : "Other federal grants","7" : "State or local grants","8" : "Institutional grants","9" : "Title IV aid","10" : "Student loan","11" : "Federal student loan","12" : "Other student loan","13" : "Post-9/11 GI Bill Benefits","14" : "Department of Defense Tuition Assistance Program","99" : "Total" |
| `income_level` | Family income level | integer | yes | "1" : "Less than $30,000","2" : "$30,001&ndash;$48,000","3" : "$48,001&ndash;$75,000","4" : "$75,001&ndash;$110,000","5" : "$110,001 or more","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `average_grant` | Average grant amount (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_of_students` | Total students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_grant` | Total grant amount (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `net_price` | Net price (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_receiving_grants` | Total students receiving grants | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |

## `ipeds/colleges_ipeds_student-faculty-ratio`

- **Canonical mirror path:** `ipeds/colleges_ipeds_student-faculty-ratio.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/ipeds/student-faculty-ratio/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `student_faculty_ratio` | Student-faculty ratio | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 198kUpdated Claude CodeCodexVerifiedInstall