NYSgptData LibraryConnectPricing

Common Core of Data

Public schools and districts: directory, enrolment, staff, and district finances, by school year.

110MRecords
200Tables
21,857Fields
CurrentYears

Publisher: National Center for Education Statistics

Try it

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

Tables
ccd_sch_05257.3Mccd_lea_05223Mccd_sch_052_l_2a_csv12.3Mccd_lea_052_l_2a3.8Mccd_sch_0332.9Mccd_lea_0592.7Mccd_lea_040_l_1a_pub660Kccd_sch_029612Kccd_sch_059600Kccd_sch_129600Kccd_sch_033_l_2a495Kccd_lea_059_l_2a418Kccd_lea_032_l_1a_pub409Kccd_lea_029137Kccd_sdf132Kccd_sc092a_txt104Kccd_sc071b_txt104Kccd_sc102a_txt103Kccd_sc081b_txt103Kccd_sc111a_supp_txt103Kccd_sc132a_txt103Kccd_sch_029_w_0216601a_txt103Kccd_sc122a_txt103Kccd_sch_029_w_2a_011717_csv102Kccd_edge_geoids_15_public_school_csv102Kccd_sch_029_w_1a_csv102Kccd_sch_059_w_2a_011717_csv100Kccd_sch_129_w_2a_011717_csv100Kccd_sch_033_w_0216161a_txt100Kccd_sch_052_w_0216161a_txt100Kccd_sch_059_w_0216161a_txt100Kccd_sch_129_w_0216161a_txt100Kccd_sch_059_l_2a100Kccd_sch_129_w_1a100Kccd_sch_033_w_2a_011717_csv99.3Kccd_sch_052_w_2a_011717_csv99.3Kccd_sea_05285Kccd_lea_2_8955.2Kccd_lea_14136.1Kccd_psu92ow_dat30Kccd_psu90ow_dat29.8Kccd_psu86ow_dat29.7Kccd_psu87ow_dat29.7Kccd_psu93ow_dat29.7Kccd_psu93kn_dat29.6Kccd_psu88ow_dat29.6Kccd_psu89ow_dat29.6Kccd_psu91ow_dat29.4Kccd_psu91kn_dat29.1Kccd_psu90kn_dat29.1Kccd_psu87kn_dat29.1Kccd_psu92kn_dat29Kccd_psu86kn_dat29Kccd_psu89kn_dat28.8Kccd_psu88kn_dat28.7Kccd_psu91ai_dat27.4Kccd_psu90ai_dat27.4Kccd_psu93ai_dat27.4Kccd_psu92ai_dat27.2Kccd_psu89ai_dat26.9Kccd_psu88ai_dat26.6Kccd_psu86ai_dat26.6Kccd_psu87ai_dat26.4Kccd_sdf20_2a_txt19.7Kccd_sdf21_2a_txt19.6Kccd_lea_029_w_1a_011717_csv18.9Kccd_lea_029_w_1a_csv18.8Kccd_lea_029_w_0216161ar_txt18.8Kccd_ag131a_supp_txt18.8Kccd_edge_geoids_15_public_lea_csv18.8Kccd_ag121a_supp_txt18.6Kccd_sdf14_1a_flat18.6Kccd_lea_00_w_1a_011717_csv18.6Kccd_lea_059_w_1a_011717_csv18.6Kccd_ag111a_txt18.5Kccd_lea_046141_w_0216161a_txt18.5Kccd_lea_052_w_0216161a_txt18.5Kccd_lea_059_w_0216161a_txt18.5Kccd_ag102a_txt18.5Kccd_dr091a_txt18.4Kccd_ag092a_txt18.4Kccd_sdf121a18.4Kccd_dr08p1a_txt18.4Kccd_ag081a_txt18.3Kccd_sdf11_1a_txt18.3Kccd_dr06p1b_txt18.3Kccd_sdf101a_txt18.2Kccd_ag071b_txt18.1Kccd_dr07p1b_txt18.1Kccd_lea_00_w_0216161a_txt17.9Kccd_lea_2_89_l_2a17.9Kccd_lea_141_l_2a17.6Kccd_lea_052_w_1a_011717_csv17.6Kccd_lea_141_w_1a_011717_csv17.6Kccd_pau87data17.1Kccd_pau88data17Kccd_sdf061a_txt16.6Kccd_sdf051a_txt16.6Kccd_sdf091a_txt16.6Kccd_sdf041b_txt16.5Kccd_sdf081a_txt16.5Kccd_sdf071a_txt16.4Kccd_sdf031b_txt16.3Kccd_sdf021ctxt16.3Kccd_sdf921a16.2Kccd_sdf011d16.2Kccd_sdf001d16Kccd_sdf901a15.9Kccd_sdf991c15.9Kccd_sdf981e15.7Kccd_sdf97d1a15.7Kccd_sdf95c1d15.6Kccd_sdf96c1b15.5Kccd_sea_052_l_1a_csv14.5Kccd_sea_032_l_1a_pub11.5Kccd_sea_0598.5Kccd_sea_040_l_1a_pub2.8Kccd_sea_059_l_1a_csv1.4Kccd_drp00lay1b1Kccd_drp01lay0d1Kccd_spss_031b827ccd_sdf21_2a_layout601ccd_sdf20_2a_layout570ccd_sdf121a_spss_code559ccd_sdf19_2a_layout495ccd_sdf18_1a_layout493ccd_sdf101alayout492ccd_sdf11_1a_layout492ccd_sdf121alayout492ccd_sdf13_1a_layout492ccd_sdf14_1a_layout492ccd_sdf16_1a_layout489ccd_sdf17_1a_layout489ccd_sdf15_1a_layout486ccd_sdf091alayout482ccd_stfis448ccd_sea_029338ccd_st111a_imp325ccd_code_to_create_sch_directory_file315ccd_stfis00layr309ccd_code_to_create_lea_directory_file296ccd_sdf081alayout291ccd_drp97lay1c287ccd_drp98lay1b287ccd_drp99lay1b287ccd_sdf071alayout281ccd_sdf95layr163ccd_sdf96layr163ccd_sdf97layr159ccd_agdr02lay1a66ccd_agdr03lay1a66ccd_agdr04lay1a66ccd_dr05p1b63ccd_sdr051b59ccd_sdr061b_txt59ccd_sdr071b_txt59ccd_sdr081a_txt59ccd_st021b59ccd_st071b_txt59ccd_st081c_txt59ccd_st091b_txt59ccd_sdr091a58ccd_st101a_txt58ccd_st111a_txt58ccd_st121a_imp_txt58ccd_st131a_imp_txt58ccd_sea_029_w_1a_011717_csv57ccd_sea_029_w_1a_csv57ccd_sea_052_w_1a_011717_csv57ccd_sea_059_w_1a_011717_csv57ccd_stfis871b57ccd_stfis881b57ccd_sea_029_w_0216161a_txt56ccd_sea_052_w_0216161a_txt56ccd_sea_059_w_0216161a_txt56ccd_st861c56ccd_st871c56ccd_st881c56ccd_st891c56ccd_st901c56ccd_stfis_1a_txt56ccd_stfis011bdata56ccd_stfis021d_txt56ccd_stfis031b_txt56ccd_stfis041b_txt56ccd_stfis051b_txt56ccd_stfis061b_txt56ccd_stfis071b_txt56ccd_stfis081b_txt56ccd_stfis091b_txt56ccd_stfis101a_txt56ccd_stfis111a_txt56ccd_stfis21_2a_txt56ccd_stfis931bdata56ccd_stfis981bdata56ccd_stfis001bdata55ccd_agdr08lay1a34ccd_dr09lay1a34ccd_agdr06lay1b14ccd_agdr07lay1b14
Fields in ccd_sch_052
FieldTypeExample
school_yearstring2024-2025
fipststring01
statenamestringALABAMA
ststringAL
sch_namestringAlbertville Middle School
state_agency_nostring01
_unionstring
st_leaidstringAL-101
leaidstring0100005
st_schidstringAL-101-0010
ncesschstring010000500870
schidstring0100870
gradestringGrade 7
race_ethnicitystringAmerican Indian or Alaska Native
sexstringFemale
student_countstring2
total_indicatorstringCategory Set A - By Race/Ethnicity; Sex; Grade
dms_flagstringReported
source_filestringlake/v1/education/raw/ccd/2026-11-15/ccd_sch_052_2425_l_1a_0
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