Public schools and districts: directory, enrolment, staff, and district finances, by school year.
Publisher: National Center for Education Statistics
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| school_year | string | 2024-2025 |
| fipst | string | 01 |
| statename | string | ALABAMA |
| st | string | AL |
| sch_name | string | Albertville Middle School |
| state_agency_no | string | 01 |
| _union | string | |
| st_leaid | string | AL-101 |
| leaid | string | 0100005 |
| st_schid | string | AL-101-0010 |
| ncessch | string | 010000500870 |
| schid | string | 0100870 |
| grade | string | Grade 7 |
| race_ethnicity | string | American Indian or Alaska Native |
| sex | string | Female |
| student_count | string | 2 |
| total_indicator | string | Category Set A - By Race/Ethnicity; Sex; Grade |
| dms_flag | string | Reported |
| source_file | string | lake/v1/education/raw/ccd/2026-11-15/ccd_sch_052_2425_l_1a_0 |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.