DAAF-Contribution-Community/daaf / .claude/skills/education-data-explorer
education-data-explorer
VerifiedMirror-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-ccd.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 — `ccd`
**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.
Source `ccd`: 5 dataset families, 300 unique variables.
## `ccd/districts_ccd_finance`
- **Canonical mirror path:** `ccd/districts_ccd_finance.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/school-districts/ccd/finance/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `leaid` | Local education agency identification number (NCES) | string | 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" |
| `censusid` | US Census Bureau 14-digit government identification number | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_total` | Total revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_total` | Total federal revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_child_nutrition_act` | Federal revenue through the state for the Child Nutrition Act | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_title_i` | Federal revenue through the state for Title I | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_idea` | Federal revenue through the state for the Individuals with Disabilities Education Act | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_math_sci_teach` | Federal revenue through the state for math, science, and teacher quality | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_drug_free` | Federal revenue through the state for safe and drug-free schools | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_vocational` | Federal revenue through the state for vocational and tech education | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_bilingual_ed` | Federal revenue through the state for bilingual education | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_other` | Federal revenue through the state for other purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_direct_impact_aid` | Direct federal revenue for impact aid | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_direct_indian_ed` | Direct federal revenue for Indian Education | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_direct_other` | Direct federal revenue for other purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_arra` | Federal revenue from the American Recovery and Reinvestment Act | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_nonspec` | Federal revenue for nonspecified purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_total` | Total state revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_gen_formula_assist` | State revenue from general formula assistance | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_special_ed` | State revenue for special education programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_transportation` | State revenue for transportation programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_staff_improve` | State revenue for staff improvement programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_compens_basic_ed` | State revenue for compensatory and basic skills programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_vocational_ed` | State revenue for vocational education programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_outlay_capital_debt` | State revenue for capital outlay and debt services programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_bilingual_ed` | State revenue for bilingual education | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_gifted_talented` | State revenue for gifted and talented programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_sch_lunch` | State revenue for school lunch programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_oth_prog` | State revenue for other programs | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_employee_benefits` | State revenue, on behalf of the local education agency, for employee benefits | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_not_employee_benefits` | State revenue, on behalf of the local education agency, for other benefits than employee benefits | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_nonspec` | State revenue for nonspecified purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_total` | Total local revenue | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_parent_govt` | Local revenue from parent government contributions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_prop_tax` | Local revenue from property taxes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_sales_tax` | Local revenue from general sales taxes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_utility_tax` | Local revenue from public utility taxes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_income_tax` | Local revenue from individual and corporate income taxes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_other_tax` | Local revenue from all other taxes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_other_sch_systems` | Local revenue from other school systems | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_cities_counties` | Local revenue from cities and counties | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_tuition_fees` | Local revenue from tuition fees from pupils and parents | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_transportation_fees` | Local revenue from transportation fees from pupils and parents | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_sch_lunch` | Local revenue from school lunches | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_textbook_sales_rents` | Local revenue from textbook sales and rentals | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_dist_activ_receipts` | Local revenue from district activity receipts | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_student_fees_nonspec` | Local revenue from nonspecified student fees | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_oth_sales_serv` | Local revenue from other sales and services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_interest_earnings` | Local revenue from interest earnings | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_rents_royalties` | Local revenue from rents and royalties | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_property_sale` | Local revenue from property sales | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_fines_forfeits` | Local revenue from fines and forfeits | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_private_contrib` | Local revenue from private contributions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_local_misc` | Local revenue from miscellaneous sources | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_nces` | NCES local revenue, Census Bureau state revenue | integer | 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_current_elsec_total` | Total current expenditures for elementary and secondary education | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_state_local_funds` | Current expenditures from state and local funds | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_federal_funds` | Current expenditures from federal funds | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_resa` | Current expenditures made by regional education service agencies on behalf of the local education agency | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_instruction_total` | Total current expenditures for instruction | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_supp_serve_total` | Total current expenditures for support services | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_pupils` | Current expenditures for pupil support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_instruc_staff` | Current expenditures for instructional staff support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_general_admin` | Current expenditures for general administration support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_sch_admin` | Current expenditures for school administration support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_operation_plant` | Current expenditures for support services for operation and maintenance of plant | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_student_transport` | Current expenditures for student transportation support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_bco` | Current expenditures for business, central, and other support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_supp_serv_nonspec` | Current expenditures for support services for nonspecified purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_other` | Total current expenditures for other elementary or secondary | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_food_serv` | Current expenditures for food services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_enterprise` | Current expenditures for enterprise operations | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_other_elsec` | Current expenditures for other elementary or secondary school purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_nonelsec` | Total non-elementary or secondary school expenditures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_nonelsec_community_serv` | Non-elementary or secondary school expenditures for community services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_nonelsec_adult_education` | Non-elementary or secondary school expenditures for adult education | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_nonelsec_other` | Non-elementary or secondary school expenditures for other purposes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_current_arra` | Current expenditures for the American Recovery and Reinvestment Act | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_textbooks` | Expenditures on textbooks | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_utilities_energy` | Expenditures for utilities and energy services | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_tech_supplies_services` | Expenditures for technology-related supplies and purchased services | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_tech_equipment` | Expenditures for technology-related equipment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_total` | Total capital outlay expenditures | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_construction` | Capital outlay for construction | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_land_structures` | Capital outlay for land and existing structures | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_instruc_equip` | Capital outlay for instructional equipment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_other_equip` | Capital outlay for other equipment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_nonspec_equip` | Capital outlay for nonspecified equipment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `outlay_capital_arra` | Capital outlay for the American Recovery and Reinvestment Act | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `payments_private_schools` | Payments to private schools | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `payments_charter_schools` | Payments to charter schools | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `payments_state_govt` | Payments to state governments | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `payments_local_govt` | Payments to local governments | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `payments_other_sch_system` | Payments to other school systems | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_total` | Total salary amount | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_instruction` | Salaries for instruction | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_teachers_regular_prog` | Teacher salaries for regular education programs | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_teachers_sped` | Teacher salaries for special education programs | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_teachers_vocational` | Teacher salaries for vocational education programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_teachers_other_ed` | Teacher salaries for other education programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_pupils` | Salaries for pupil support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_instruc_staff` | Salaries for instructional staff support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_general_admin` | Salaries for general administration support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_sch_admin` | Salaries for school administration support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_operation_plant` | Salaries for support services for operation and maintenance of plant | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_stud_transport` | Salaries for student transportation support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_supp_bco` | Salaries for business, central, and other support services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_food_service` | Salaries for food services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_employee_total` | Total employee benefits (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_employee_instruction` | Employee benefits for instruction (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_pupils` | Employee benefits for pupil support services (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_instruc_staff` | Employee benefits for instructional staff support services (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_general_admin` | Employee benefits for general administration support services (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_sch_admin` | Employee benefits for school administration support services (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_operation_plant` | Employee benefits for support services for operation and maintenance of plant (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_stud_transport` | Employee benefits for student transportation support services (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_supp_bco` | Employee benefits for business, central, and other support services (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_food_service` | Employee benefits for food services (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `benefits_enterprise_operations` | Employee benefits for enterprise operations (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_interest` | Interest on debt | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_longterm_outstand_beg_FY` | Long-term debt outstanding at beginning of fiscal year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_longterm_issued_FY` | Long-term debt issued during fiscal year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_longterm_retired_FY` | Long-term debt retired during fiscal year | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_longterm_outstand_end_FY` | Long-term debt outstanding at end of fiscal year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_shortterm_outstand_beg_FY` | Short-term debt outstanding at end of fiscal year | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `debt_shortterm_outstand_end_FY` | Short-term debt outstanding at beginning of fiscal year | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assets_sinking_fund` | Assets in a sinking fund (dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assets_bond_fund` | Assets in a bond fund (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `assets_other` | Assets in other funds (dollars) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment_fall_responsible` | Number of students for which the reporting local education agency is financially responsible | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment_fall_school` | Number of students attending school within the reporting local education agency | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_eff_instruction` | Federal revenue through state for effective instructional practices | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_supp_ed` | Federal revenue through state to support student achievement | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_supp_21st_LC` | Federal revenue through state to 21st century learning centers | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_state_rural_lowinc_sch` | Federal revenue through state for rural low-income schools | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_fed_direct_rural_achievement` | Federal revenue through state support small and rural district achievement | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sped_current` | Current special education expenditures | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sped_instruction` | Current special education expenditures for instruction | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sped_pupil_support_services` | Current special education expenditures for pupil support services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sped_staff_support_services` | Current special education expenditures for instructional support services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_sped_trans_support_services` | Current special education expenditures for Transportation services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_esser` | Federal CARES Act revenues (ESSER) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_crrsa_esser_ii` | Federal CRRSA Act revenues (ESSER II) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_arp_esser` | Federal ARP Act revenues (ESSER) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_geer` | Federal CARES Act revenues (GEER) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_crrsa_geer_ii` | Federal CRRSA Act revenues (GEER II) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_esf_rwp` | Federal CARES Act revenues (Education Stabilization Fund - Reimagine Workforce Preparation) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_esf_rem` | Federal CARES Act revenues (Education Stabilization Fund - Rethink K12 Models) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_serv` | Federal CARES Act revenues (Project School Emergency Response to Violence) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_cares_act_relief_crf` | Federal CARES Act revenues (Coronavirus Relief Fund) | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rev_state_local_recovery_funds` | Revenue from State and Local COVID-19 Fiscal recovery measures | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_current` | Expenditures using Federal COVID relief funds | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_instruction` | Expenditures using Federal COVID relief funds on instruction | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_support_services` | Expenditures using Federal COVID relief funds on support services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_outlay` | Expenditures using Federal COVID relief funds on capital outlay | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_tech_service` | Expenditures using Federal COVID relief funds on Technology and related support services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_tech_equipment` | Expenditures using Federal COVID relief funds on Technology and equipment | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_tech_plant` | Expenditures using Federal COVID relief funds on PLANT maintenance | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_cares_act_food` | Expenditures using Federal COVID relief funds on Food Services | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `exp_instruction` | Expenditures on instruction | long | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `ccd/school-districts_lea_directory`
- **Canonical mirror path:** `ccd/school-districts_lea_directory.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/school-districts/ccd/directory/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `leaid` | Local education agency identification number (NCES) | string | 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" |
| `lea_name` | Local education agency name | 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" |
| `state_leaid` | Local education agency identification number (state) | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `street_mailing` | Street of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_mailing` | City of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_mailing` | State of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_mailing` | Zip code of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip4_mailing` | 4-digit zip code of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `street_location` | Street of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_location` | City of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_location` | State of location | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_location` | Zip code of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip4_location` | 4-digit zip code of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `phone` | Telephone number | string | 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" |
| `longitude` | Longitude of institution | float | no | "-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" |
| `cmsa` | Consolidated metropolitan statistical area | integer | no | "-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" |
| `county_code` | County code | integer | 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" |
| `congress_district_id` | State and 114th congressional district identification number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_lower` | State legislative district—lower | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_upper` | State legislative district—upper | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `bureau_indian_education` | Bureau of Indian Education school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `supervisory_union_number` | Supervisory union number | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `agency_type` | Agency type | integer | no | "1" : "Regular local school district","2" : "Local school district that is a component of a supervisory union","3" : "Supervisory union","4" : "Regional education service agency","5" : "State-operated agency","6" : "Federally operated agency","7" : "Charter agency","8" : "Other education agency","9" : "Specialized public school district" |
| `agency_level` | Agency level | integer | yes | "0" : "Prekindergarten","1" : "Primary","2" : "Middle","3" : "High","4" : "Other","5" : "Ungraded","6" : "Adult Education","7" : "Secondary","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `boundary_change_indicator` | Boundary change | integer | no | "1" : "No change; operational","2" : "Closed","3" : "New","4" : "Added","5" : "Significant change in geographical boundaries or instructional responsibility","6" : "Temporarily closed","7" : "Future","8" : "Reopened","-1" : "Missing/not reported" |
| `agency_charter_indicator` | Agency charter | integer | no | "1" : "All charter schools","2" : "Some charter schools","3" : "No charter schools","-2" : "Not applicable" |
| `lowest_grade_offered` | Lowest grade offered | integer | no | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","-2" : "Not applicable","-3" : "Suppressed data" |
| `highest_grade_offered` | Highest grade offered | integer | no | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","-2" : "Not applicable","-3" : "Suppressed data" |
| `number_of_schools` | Number of schools associated with this agency | 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" |
| `spec_ed_students` | Number of IDEA students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `english_language_learners` | Number of English language learners | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `migrant_students` | Number of migrant students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_prek_fte` | Number of full-time equivalent prekindergarten teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_kindergarten_fte` | Number of full-time equivalent kindergarten teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_elementary_fte` | Number of full-time equivalent elementary school teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_secondary_fte` | Number of full-time equivalent secondary school teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_ungraded_fte` | Number of full-time equivalent ungraded teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_total_fte` | Total full-time equivalent teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instructional_aides_fte` | Number of full-time equivalent instructional aides or paraprofessionals | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `coordinators_fte` | Number of full-time equivalent instructional coordinators and supervisors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `guidance_counselors_elem_fte` | Number of full-time equivalent elementary school guidance counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `guidance_counselors_sec_fte` | Number of full-time equivalent secondary school guidance counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `guidance_counselors_other_fte` | Number of full-time equivalent other guidance counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `guidance_counselors_total_fte` | Total full-time equivalent guidance counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_counselors_fte` | Number of full-time school counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `librarian_specialists_fte` | Number of full-time equivalent librarians or media specialists | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `librarian_support_staff_fte` | Number of full-time equivalent library or media support staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_administrators_fte` | Number of full-time equivalent local education agency administrators | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_admin_support_staff_fte` | Number of full-time equivalent local education agency administrative support staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_staff_total_fte` | Total full-time equivalent LEA staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_administrators_fte` | Number of full-time equivalent school administrators | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_admin_support_staff_fte` | Number of full-time equivalent school administrative support staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_staff_total_fte` | Total full-time equivalent school staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `support_staff_students_fte` | Number of full-time equivalent student support services staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_psychologists_fte` | Number of full-time equivalent school psychologists | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `support_staff_stu_wo_psych_fte` | Number of full-time equivalent student support services staff (not including psychologists) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `support_staff_other_fte` | Number of full-time equivalent other support services staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `staff_total_fte` | Total full-time equivalent staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_staff_fte` | Number of other full-time equivalent staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `ccd/schools_ccd_directory`
- **Canonical mirror path:** `ccd/schools_ccd_directory.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/ccd/directory/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch` | National Center for Education Statistics (NCES) identification number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch_num` | National Center for Education Statistics (NCES) identification number (numeric) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_id` | School identification number (NCES) | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_name` | School name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `leaid` | Local education agency identification number (NCES) | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_name` | Local education agency name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leaid` | Local education agency identification number (state) | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `seasch` | School identification number (state) | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `street_mailing` | Street of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_mailing` | City of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_mailing` | State of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_mailing` | Zip code of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `street_location` | Street of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_location` | City of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_location` | State of location | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_location` | Zip code of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `phone` | Telephone number | 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" |
| `latitude` | Latitude of institution | float | no | "-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" |
| `csa` | Combined statistical area | integer | yes | "-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" |
| `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" |
| `county_code` | County code | integer | 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" |
| `state_leg_district_lower` | State legislative district—lower | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_upper` | State legislative district—upper | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_level` | School level | integer | yes | "0" : "Prekindergarten","1" : "Primary","2" : "Middle","3" : "High","4" : "Other","5" : "Ungraded","6" : "Adult Education","7" : "Secondary","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_type` | School type | integer | yes | "1" : "Regular school","2" : "Special education school","3" : "Vocational school","4" : "Other/alternative school","5" : "Reportable program","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_status` | Status at start of school year | integer | yes | "1" : "Open","2" : "Closed","3" : "New","4" : "Added","5" : "Changed agency","6" : "Inactive","7" : "Future","8" : "Reopened","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lowest_grade_offered` | Lowest grade offered | integer | no | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","-2" : "Not applicable","-3" : "Suppressed data" |
| `highest_grade_offered` | Highest grade offered | integer | no | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","-2" : "Not applicable","-3" : "Suppressed data" |
| `elem_cedp` | Elementary school indicator (Center on Education Data and Policy variable) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `middle_cedp` | Middle school indicator (Center on Education Data and Policy variable) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `high_cedp` | High school indicator (Center on Education Data and Policy variable) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ungrade_cedp` | Ungraded school indicator (Center on Education Data and Policy variable) | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `bureau_indian_education` | Bureau of Indian Education school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `title_i_status` | Title I status | integer | yes | "1" : "School is eligible for Title I Targeted Assistance (TAS) but provides no program","2" : "School is eligible for Title I Targeted Assistance (TAS) and provides TAS program","3" : "School is eligible for Title I Schoolwide program (SWP) and provides Targeted Assistance program (TAS)","4" : "School is eligible for Title I Schoolwide program (SWP) but provides no program","5" : "School is eligible for Title I Schoolwide program (SWP) and provides Title I Schoolwide program","6" : "School is not eligible for either Title I Targeted Assistance or Schoolwide program","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `title_i_eligible` | Title I eligibility | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `title_i_schoolwide` | Schoolwide Title I eligibility | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `charter` | Charter school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `magnet` | Magnet school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `shared_time` | Shared time | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `virtual` | Virtual school | integer | yes | "0" : "No","1" : "Yes","2" : "Virtual with face to face options","3" : "Supplemental virtual","-1" : "Missing/not reported" |
| `teachers_fte` | Number of full-time equivalent teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lunch_program` | National School Lunch Program (NSLP) status | integer | no | "0" : "No","1" : "Yes participating without using any Provision or the CEP","2" : "Yes under the Community Eligibility Provision (CEP)","3" : "Yes under Provision 1","4" : "Yes under Provision 2","5" : "Yes under Provision 3","-1" : "Missing/not reported" |
| `free_lunch` | Number of students eligible for free lunch | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `reduced_price_lunch` | Number of students eligible for reduced-price lunch | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `free_or_reduced_price_lunch` | Number of students eligible for free or reduced-price lunch | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `direct_certification` | Number of students eligible for free lunch by direct certification | 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" |
## `ccd/schools_ccd_enrollment_{year}`
- **Canonical mirror path:** `ccd/schools_ccd_enrollment_{year}.parquet` (39 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/ccd/enrollment/{year}/{grade}/`, `/api/v1/schools/ccd/enrollment/{year}/{grade}/race/`, `/api/v1/schools/ccd/enrollment/{year}/{grade}/race/sex/`, `/api/v1/schools/ccd/enrollment/{year}/{grade}/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch` | National Center for Education Statistics (NCES) identification number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch_num` | National Center for Education Statistics (NCES) identification number (numeric) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `leaid` | Local education agency identification number (NCES) | string | 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" |
| `grade` | Grade | integer | yes | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","99" : "Total","999" : "Not specified" |
| `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" |
| `enrollment` | Student enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `ccd/schools_ccd_lea_enrollment_{year}`
- **Canonical mirror path:** `ccd/schools_ccd_lea_enrollment_{year}.parquet` (39 mirror files)
- **Contributing endpoint route(s):** `/api/v1/school-districts/ccd/enrollment/{year}/{grade}/`, `/api/v1/school-districts/ccd/enrollment/{year}/{grade}/race/`, `/api/v1/school-districts/ccd/enrollment/{year}/{grade}/race/sex/`, `/api/v1/school-districts/ccd/enrollment/{year}/{grade}/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `leaid` | Local education agency identification number (NCES) | string | 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" |
| `grade` | Grade | integer | yes | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","99" : "Total","999" : "Not specified" |
| `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" |
| `enrollment` | Student enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| 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: 197k | Updated | Claude CodeCodex | Verified | Install |