Data sources

Scraped 427 ASBCS closures via Playwright; 34 matched existing schools (8.0%), 393 new closure-only inserts, 407 new charter_actions. Reasons preserved verbatim in notes.

Ingested 1931 schools, 0 new closure actions. 90 rows skipped (no NCES ID).

Enriched 1912 CA charter rows with phone/website/principal/charter_number/funding_type/virtual/magnet/program_type/instructional_level/grade_span_offered. Re-run via npm run enrich:ca-extras when CDE refreshes pubschls.

Parsed 54 DC charter closures from DC PCSB Comprehensive List of All Public Charter LEAs (Google Sheet CSV); 0 matched (0.0%); 54 new closure-only schools; 54 new charter_actions. Year-only dates proxied to June 30 of the closure year.

Parsed 66 closures from FLDOE 2023-24 Authorizer Report (5 most recent years only); 27 matched (40.9%); 39 new closure-only schools; 66 new charter_actions.

17 closures applied this run. Indianapolis Office of Education Innovation (Mayor's Office) Annual Report 2021-22 PDF; 17 mayor-sponsored charter closures transcribed inline. Provides school name + opening year + revocation/non-renewal year + reason. Year-only dates proxied to June 30. Two schools (Marion Academy, Indianapolis Lighthouse College Prep East) have status='Closed' but no closure year published.

7 closures applied this run. Indiana Charter School Board closed-schools listing; 7 schools, each on its own detail page with a board-action sentence (revoke/non-renew/close) and date. Transcribed inline from a one-shot scrape on 2026-05-21. Ball State University (third Indiana authorizer) is not yet covered — see SKIP_LIST.md.

Parsed 28 MA charter closures from DESE factsheet Sheet1; 0 matched (0.0%); 28 new closure-only schools; 28 new charter_actions. Each action carries the per-closure BESE memo URL as source_url where available.

Parsed 265 MI PSA closures from EEM CSV (via Playwright scrape); 29 matched (10.9%) — 21 via NCES, 8 via name; 236 new closure-only schools; 265 new charter_actions.

Applied 30 MO charter closures from DESE Closure Doc PDF (Jul 2024 rev); 0 matched (0.0%); 30 new closure-only schools; 30 new charter_actions. Year-only dates proxied to June 30. 3 source typos preserved verbatim.

NC 2024 annual report; 94 historical closures in summary (no detail); 5 narrative closures extracted; 2 matched, 3 new closure-only schools; 5 new charter_actions.

Enriched 204 NC charter rows with phone/principal/address/city/zip/county/virtual/opened_date/grade_span_offered from NC DPI EDDIE Active Charter Schools Report (Playwright fetch).

Parsed 53 closures from NJ DOE Closure Process page; 3 matched (5.7%); 50 new closure-only schools inserted (synthetic state_school_id); 53 new charter_actions.

Parsed 52 closures from NYSED 'All NYS Charter Schools Issued' PDF (Jan 2025 edition); 6 matched (11.5%); 46 new closure-only schools (5 were charter-awarded-but-never-opened); 52 new charter_actions.

Parsed 342 closures from ODE Closed Community Schools xlsx; 19 matched (5.6%); 323 new closure-only schools; 342 new charter_actions.

Enriched 164 PA charter rows with phone (overrode CCD)/principal/funding_type/grade_span_offered from PDE Cyber and Charter Listing xlsx (3 sheets: Brick-n-Mortar, Regional, Cyber).

Parsed 161 closures from TEA PDF; 17 matched to existing schools (10.6%); 144 new closure-only schools inserted; 161 new charter_actions.

Enriched 994 TX charter rows with phone/website/principal/funding_type/magnet/program_type/grade_span_offered from TEA AskTED School Directory CSV (Playwright fetch).

Reconciled CCD 2023-24 SY_STATUS_TEXT. 54 schools → 'closed'; 0 → 'pre_opening'; 200 new closure events inserted (proxy date 2024-06-30).

CCD 2023-24 School Membership; 99,507 EUT rows scanned nationally; 8,027 matched our charter roster + applied; 8027 enrollment_history rows upserted.

Backfilled phone (6073 schools) and website (4677 schools) from CCD School Directory 2023-24 (029 series). Only updated fields that were NULL; existing state-DOE enrichment (CA, TX) was preserved.

Computed race % from CCD-052 race-subtotal rows for 7973 schools. Denominator: schools.enrollment_latest (fallback: sum of race counts).

Filled county (5866 schools) and lat/lng (7064 schools) from NCES EDGE Geocodes 2023-24. Only updated NULL fields; state-DOE values (CA/TX/NC/MI) were preserved.

Filled urbanicity (7358) and cbsa_name (7361) from NCES EDGE Geocodes 2023-24 LOCALE + CBSA_NAME columns. Only updated NULL fields.

Filled pct_frl from CCD-033 Free/Reduced-Price Lunch table. Computed as (free + reduced) / Education Unit Total * 100, rounded to int. Schools with DMS_FLAG Suppressed/NotReported/Missing were skipped.

Filled nslp_status (7606) and virtual (4863) from CCD-129 School Characteristics. Only NULL fields touched.

Filled pct_ell from EDFacts FS141 DG678 SY2021-22. Denominator = schools.enrollment_latest (2023-24). 2-year mismatch labeled on detail page via ell_year column.

Prior-year CCD-052 ingest: 2020-2021, 7392 rows upserted into enrollment_history.

IRS Exempt Organizations Business Master File, per-state extracts. Filtered to 501(c)(3) active orgs filing 990/990-EZ with charter-school-likely NTEE codes (B29 plus B2x/B11/B90/B99 with charter-hint name regex). 9,992 candidate orgs from 52 state files.

ProPublica Nonprofit Explorer API. Multi-year 990 financial summaries (revenue, expenses, assets, liab, aggregate officer comp). Per-officer detail not in this API — would require IRS XML 990 from s3://irs-form-990/. Fetched 196 of 315 EINs, 1373 filings inserted, 119 not found, 0 failures.

NCES Common Core of Data 2023-24 School Staff file (059). Teacher FTE per school, filtered to Education Unit Total + DMS_FLAG=Reported. Used to compute student-teacher ratio. Updated 7180 schools.

IRS TEOS Form 990 XML release. Per-officer compensation from Part VII Section A. Distributed as ~470 MB monthly batch ZIPs keyed by XML_BATCH_ID; index_YYYY.csv lists all filings. 2025 index: 861 full 990 filings parsed, 8000 officers inserted.

USA Spending federal-award API. CSP (CFDA 84.282) grants since FY2008. Recipient EIN matched via name → irs_bmf_orgs.name_norm. State-pass-through subprogram A is included in the table but should be filtered out at render time. 175 CSP grants inserted across 126 nonprofits ($740M total).