Outcomes, costs and debt by institution and by field of study.
Publisher: Department of Education
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| unitid | string | 228769 |
| opeid6 | string | 003656 |
| instnm | string | The University of Texas at Arlington |
| control | string | Public |
| main | string | 1 |
| cipcode | string | 4008 |
| cipdesc | string | Physics. |
| credlev | string | 3 |
| creddesc | string | Bachelor's Degree |
| ipedscount1 | string | 28 |
| ipedscount2 | string | 32 |
| debt_all_stgp_any_n | string | 27 |
| debt_all_stgp_any_mean | string | 20883 |
| debt_all_stgp_any_mdn | string | 21834 |
| debt_all_stgp_eval_n | string | 25 |
| debt_all_stgp_eval_mean | string | 19994 |
| debt_all_stgp_eval_mdn | string | 21819 |
| debt_all_pp_any_n | string | PS |
| debt_all_pp_any_mean | string | PS |
| debt_all_pp_any_mdn | string | PS |
| debt_all_pp_eval_n | string | PS |
| debt_all_pp_eval_mean | string | PS |
| debt_all_pp_eval_mdn | string | PS |
| debt_male_stgp_any_n | string | NA |
| debt_male_stgp_any_mean | string | NA |
| debt_male_stgp_any_mdn | string | NA |
| debt_male_stgp_eval_n | string | NA |
| debt_male_stgp_eval_mean | string | NA |
| debt_male_stgp_eval_mdn | string | NA |
| debt_male_pp_any_n | string | NA |
| debt_male_pp_any_mean | string | NA |
| debt_male_pp_any_mdn | string | NA |
| debt_male_pp_eval_n | string | NA |
| debt_male_pp_eval_mean | string | NA |
| debt_male_pp_eval_mdn | string | NA |
| debt_notmale_stgp_any_n | string | NA |
| debt_notmale_stgp_any_mean | string | NA |
| debt_notmale_stgp_any_mdn | string | NA |
| debt_notmale_stgp_eval_n | string | NA |
| debt_notmale_stgp_eval_mean | string | NA |
| debt_notmale_stgp_eval_mdn | string | NA |
| debt_notmale_pp_any_n | string | NA |
| debt_notmale_pp_any_mean | string | NA |
| debt_notmale_pp_any_mdn | string | NA |
| debt_notmale_pp_eval_n | string | NA |
| debt_notmale_pp_eval_mean | string | NA |
| debt_notmale_pp_eval_mdn | string | NA |
| debt_pell_stgp_any_n | string | PS |
| debt_pell_stgp_any_mean | string | PS |
| debt_pell_stgp_any_mdn | string | PS |
| debt_pell_stgp_eval_n | string | PS |
| debt_pell_stgp_eval_mean | string | PS |
| debt_pell_stgp_eval_mdn | string | PS |
| debt_pell_pp_any_n | string | PS |
| debt_pell_pp_any_mean | string | PS |
| debt_pell_pp_any_mdn | string | PS |
| debt_pell_pp_eval_n | string | PS |
| debt_pell_pp_eval_mean | string | PS |
| debt_pell_pp_eval_mdn | string | PS |
| debt_nopell_stgp_any_n | string | PS |
| debt_nopell_stgp_any_mean | string | PS |
| debt_nopell_stgp_any_mdn | string | PS |
| debt_nopell_stgp_eval_n | string | PS |
| debt_nopell_stgp_eval_mean | string | PS |
| debt_nopell_stgp_eval_mdn | string | PS |
| debt_nopell_pp_any_n | string | PS |
| debt_nopell_pp_any_mean | string | PS |
| debt_nopell_pp_any_mdn | string | PS |
| debt_nopell_pp_eval_n | string | PS |
| debt_nopell_pp_eval_mean | string | PS |
| debt_nopell_pp_eval_mdn | string | PS |
| debt_all_pp_any_mdn10yrpay | string | NA |
| debt_all_pp_eval_mdn10yrpay | string | NA |
| debt_all_stgp_any_mdn10yrpay | string | NA |
| debt_all_stgp_eval_mdn10yrpay | string | NA |
| earn_count_nwne_hi_1yr | string | NA |
| earn_cntover150_hi_1yr | string | NA |
| earn_count_wne_hi_1yr | string | NA |
| earn_mdn_hi_1yr | string | NA |
| earn_count_nwne_hi_2yr | string | NA |
151 more fields; select the table above to list them all.
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.