NYSgptData LibraryConnectPricing

Integrated Postsecondary Education Data System

Colleges and universities: characteristics, enrolment, completions, finances, staff and student aid, every year.

46MRecords
192Tables
16,079Fields
CurrentYears

Publisher: National Center for Education Statistics

Try it

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

Tables
ipeds_eap8.4Mipeds_c_a6.8Mipeds_ef_b3.4Mipeds_ef_a3.2Mipeds_c_dep2.4Mipeds_s_oc2Mipeds_ef_cp1.7Mipeds_s_abd1.5Mipeds_ef_c1.5Mipeds_c_cip1.3Mipeds_gr1.1Mipeds_sal_b930Kipeds_c_a2dig759Kipeds_ef707Kipeds_s_is667Kipeds_sal_a499Kipeds_c_re488Kipeds_s_nh408Kipeds_om321Kipeds_s_f311Kipeds_s_g307Kipeds_ef_acp289Kipeds_s_cn276Kipeds_ef_a_dist255Kipeds_s_sis240Kipeds_gr_ath216Kipeds_c_c181Kipeds_sal_is179Kipeds_ic174Kipeds_ef_d165Kipeds_ef99_anr144Kipeds_efia143Kipeds_hd142Kipeds_f_f136Kipeds_flags136Kipeds_sfa134Kipeds_c8990cip130Kipeds_ef99_b123Kipeds_s97_s114Kipeds_s95_s110Kipeds_s_abcef107Kipeds_ic_ay105Kipeds_ic_b102Kipeds_ic_a102Kipeds_dictionaries95.9Kipeds_sal_faculty92.1Kipeds_ef96_acp88.5Kipeds_ef98_acp86.1Kipeds_gr20083.3Kipeds_c_b82.2Kipeds_ef97_b80.4Kipeds_ef95_b79.7Kipeds_ef_anr75.5Kipeds_ef_ark75.5Kipeds_ef95_anr74.8Kipeds_ef95_ark74.8Kipeds_c8990re70.6Kipeds_c_4ormore_cip69.7Kipeds_ef98_anr69.1Kipeds_ef98_ark69.1Kipeds_ef_dist68Kipeds_ef96_anr65.8Kipeds_ef96_ark65.8Kipeds_ef97_anr65.5Kipeds_ef97_ark65.5Kipeds_gr_pell_ssl60.9Kipeds_c_ic59.3Kipeds_ef90_a59.2Kipeds_sfav58.2Kipeds_gr_ath_aid56.5Kipeds_ic_py56.5Kipeds_ef_ic49.9Kipeds_ef98_c49.2Kipeds_sal_nis48.5Kipeds_ef96_c46.2Kipeds_sal_a_s44.2Kipeds_f_f1a40.4Kipeds_gr_l38.8Kipeds_al35.7Kipeds_f_a32.3Kipeds_f_b32.2Kipeds_f_e30.8Kipeds_s95_cn30.8Kipeds_c_4ormore_2dig30.3Kipeds_ic_c30.3Kipeds_f_ic29.2Kipeds_c_subba_cip27.6Kipeds_s99_cn26.7Kipeds_ic_mission26Kipeds_f_c23Kipeds_s_ic22.7Kipeds_f_d21.3Kipeds_f_k21.3Kipeds_efest20.7Kipeds_ic_ab20.2Kipeds_ic_d20.2Kipeds_ic_e20.2Kipeds_ic_f20.2Kipeds_ic_hdr20.2Kipeds_fa_hd19.3Kipeds_f_i19Kipeds_adm18.6Kipeds_s97_cn17.9Kipeds_f16.9Kipeds_sal_ic15.8Kipeds_c_subba_2dig14.8Kipeds_f_h14.6Kipeds_f_g14.3Kipeds_s13.7Kipeds_drvf12.2Kipeds_drvhr12.2Kipeds_drvc12.1Kipeds_drvef1212.1Kipeds_drvef12Kipeds_c_hdr11.9Kipeds_drvgr10.9Kipeds_ic90abce10.3Kipeds_ic90d10.3Kipeds_ic90hd10.3Kipeds_ic_other10.3Kipeds_c_hd9.7Kipeds_ef98_hd9.7Kipeds_ic98_ab9.7Kipeds_ic98_c9.7Kipeds_ic98_d9.7Kipeds_ic98_e9.7Kipeds_ic98_f9.7Kipeds_ic98hdac9.7Kipeds_sal98_hd9.7Kipeds_ic99_d9.5Kipeds_ic99_e9.5Kipeds_ic99_hd9.5Kipeds_ic99abcf9.5Kipeds_res_ic9.3Kipeds_s95_ic8.8Kipeds_ef95_ic8.8Kipeds_drval8Kipeds_drvom7.3Kipeds_f_cn7.1Kipeds_dfr7Kipeds_pub_financialaid7Kipeds_drvic6.9Kipeds_ef96_ic6.8Kipeds_s_a6.8Kipeds_s_b6.8Kipeds_s_hdr6.8Kipeds_s97_ic6.7Kipeds_ef97_hdr6.6Kipeds_ef_hdr6.5Kipeds_pub_studentcount6.2Kipeds_sal_a_lt6Kipeds_ic99_actot6Kipeds_ic_actot5.9Kipeds_ef_e5.9Kipeds_sfa0001s5.5Kipeds_sfa9900s5.5Kipeds_ef90_hd5.3Kipeds_c8990hd5.1Kipeds_ip_ay4.4Kipeds_f9900f4.2Kipeds_ef95_d4Kipeds_drvadm3.9Kipeds_sal98_a3.9Kipeds_sal98_b3.9Kipeds_sal97_hdr3.9Kipeds_sal95_a3.8Kipeds_sal95_b3.8Kipeds_sal95_ic3.8Kipeds_ef97_d3.8Kipeds_ef96_d3.8Kipeds_sal_b_s3.7Kipeds_sal97_a3.7Kipeds_sal97_b3.7Kipeds_f_hdr3.6Kipeds_f_hd3.6Kipeds_sal90_hd3.6Kipeds_ef98_d3.5Kipeds_sal90_a3.5Kipeds_sal96_a3.5Kipeds_sal96_b3.5Kipeds_sal_hdr3.3Kipeds_ef99_d3Kipeds_sal90_b2.7Kipeds_f_f1a_f2.5Kipeds_f_f1a_g2.2Kipeds_ip_py1.8Kipeds_sal96_ic1.8Kipeds_ic_campuses1Kipeds_s99_e924ipeds_s97_e889ipeds_s95_e876ipeds_f_j792
Fields in ipeds_eap
FieldTypeExample
unitidstring172644
typecdstring
functcdstring
xfstat1string
fstat1string
xfstat2string
fstat2string
xfstat3string
fstat3string
xfstat4string
fstat4string
xfstat5string
fstat5string
xfstat6string
fstat6string
source_filestringlake/v1/education/raw/ipeds/2026-11-15/EAP2013.zip
eaprectpstring
ftptstring
fstatstring
xeaptypstringR
eaptypstring98
xeapmedstringZ
eapmedstring0
xeaptotstringR
eaptotstring98
eapcatstring39000
occupcatstring390
facstatstring 0
xeapftstringR
eapftstring98
xeapfttystringR
eapfttypstring98
xeapftmdstringZ
eapftmedstring0
xeapptstringZ
eapptstring0
xeappttystringZ
eappttypstring0
xeapptmdstringZ
eapptmedstring0
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