Use-case guides

Worked examples for analysis, bulk files, local copies, citations, and federal joins.

Worked examples use the open host and include curl, dependency-free JavaScript and Python standard-library code.

Revenue per pupil for every district in Delaware

List the measure keys in a record, select Delaware’s exact revenue-per-pupil key, and preserve missing values.

Download a whole state

Check the advertised byte size, stream the NDJSON file, and verify its line count against the directory.

Keep a local copy current

Store per-record SHA-256 values, fetch only changed or new records, and report removals.

Cite a figure with its official source

Resolve a measure’s source_id and print a citation from fields present in the district schema.

Join to federal data with NCES LEAID

Join two labelled sample federal rows on LEAID, while preserving a separate branch for records whose LEAID is null.

Developer documentation