NYSgptData LibraryConnectPricing

College Scorecard

Outcomes, costs and debt by institution and by field of study.

2.5MRecords
4Tables
7,222Fields
CurrentYears

Publisher: Department of Education

Try it

This runs against the full table, free, with no key.

Tables
Fields in scorecard_field_of_study_by_year
FieldTypeExample
unitidstring228769
opeid6string003656
instnmstringThe University of Texas at Arlington
controlstringPublic
mainstring1
cipcodestring4008
cipdescstringPhysics.
credlevstring3
creddescstringBachelor's Degree
ipedscount1string28
ipedscount2string32
debt_all_stgp_any_nstring27
debt_all_stgp_any_meanstring20883
debt_all_stgp_any_mdnstring21834
debt_all_stgp_eval_nstring25
debt_all_stgp_eval_meanstring19994
debt_all_stgp_eval_mdnstring21819
debt_all_pp_any_nstringPS
debt_all_pp_any_meanstringPS
debt_all_pp_any_mdnstringPS
debt_all_pp_eval_nstringPS
debt_all_pp_eval_meanstringPS
debt_all_pp_eval_mdnstringPS
debt_male_stgp_any_nstringNA
debt_male_stgp_any_meanstringNA
debt_male_stgp_any_mdnstringNA
debt_male_stgp_eval_nstringNA
debt_male_stgp_eval_meanstringNA
debt_male_stgp_eval_mdnstringNA
debt_male_pp_any_nstringNA
debt_male_pp_any_meanstringNA
debt_male_pp_any_mdnstringNA
debt_male_pp_eval_nstringNA
debt_male_pp_eval_meanstringNA
debt_male_pp_eval_mdnstringNA
debt_notmale_stgp_any_nstringNA
debt_notmale_stgp_any_meanstringNA
debt_notmale_stgp_any_mdnstringNA
debt_notmale_stgp_eval_nstringNA
debt_notmale_stgp_eval_meanstringNA
debt_notmale_stgp_eval_mdnstringNA
debt_notmale_pp_any_nstringNA
debt_notmale_pp_any_meanstringNA
debt_notmale_pp_any_mdnstringNA
debt_notmale_pp_eval_nstringNA
debt_notmale_pp_eval_meanstringNA
debt_notmale_pp_eval_mdnstringNA
debt_pell_stgp_any_nstringPS
debt_pell_stgp_any_meanstringPS
debt_pell_stgp_any_mdnstringPS
debt_pell_stgp_eval_nstringPS
debt_pell_stgp_eval_meanstringPS
debt_pell_stgp_eval_mdnstringPS
debt_pell_pp_any_nstringPS
debt_pell_pp_any_meanstringPS
debt_pell_pp_any_mdnstringPS
debt_pell_pp_eval_nstringPS
debt_pell_pp_eval_meanstringPS
debt_pell_pp_eval_mdnstringPS
debt_nopell_stgp_any_nstringPS
debt_nopell_stgp_any_meanstringPS
debt_nopell_stgp_any_mdnstringPS
debt_nopell_stgp_eval_nstringPS
debt_nopell_stgp_eval_meanstringPS
debt_nopell_stgp_eval_mdnstringPS
debt_nopell_pp_any_nstringPS
debt_nopell_pp_any_meanstringPS
debt_nopell_pp_any_mdnstringPS
debt_nopell_pp_eval_nstringPS
debt_nopell_pp_eval_meanstringPS
debt_nopell_pp_eval_mdnstringPS
debt_all_pp_any_mdn10yrpaystringNA
debt_all_pp_eval_mdn10yrpaystringNA
debt_all_stgp_any_mdn10yrpaystringNA
debt_all_stgp_eval_mdn10yrpaystringNA
earn_count_nwne_hi_1yrstringNA
earn_cntover150_hi_1yrstringNA
earn_count_wne_hi_1yrstringNA
earn_mdn_hi_1yrstringNA
earn_count_nwne_hi_2yrstringNA

151 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Education