Colleges and universities: characteristics, enrolment, completions, finances, staff and student aid, every year.
Publisher: National Center for Education Statistics
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| unitid | string | 172644 |
| typecd | string | |
| functcd | string | |
| xfstat1 | string | |
| fstat1 | string | |
| xfstat2 | string | |
| fstat2 | string | |
| xfstat3 | string | |
| fstat3 | string | |
| xfstat4 | string | |
| fstat4 | string | |
| xfstat5 | string | |
| fstat5 | string | |
| xfstat6 | string | |
| fstat6 | string | |
| source_file | string | lake/v1/education/raw/ipeds/2026-11-15/EAP2013.zip |
| eaprectp | string | |
| ftpt | string | |
| fstat | string | |
| xeaptyp | string | R |
| eaptyp | string | 98 |
| xeapmed | string | Z |
| eapmed | string | 0 |
| xeaptot | string | R |
| eaptot | string | 98 |
| eapcat | string | 39000 |
| occupcat | string | 390 |
| facstat | string | 0 |
| xeapft | string | R |
| eapft | string | 98 |
| xeapftty | string | R |
| eapfttyp | string | 98 |
| xeapftmd | string | Z |
| eapftmed | string | 0 |
| xeappt | string | Z |
| eappt | string | 0 |
| xeapptty | string | Z |
| eappttyp | string | 0 |
| xeapptmd | string | Z |
| eapptmed | string | 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.