NYSgptData LibraryConnectPricing

Local health, health resources and hospital discharges

Local health estimates, shortage areas and health centers, and New York inpatient discharges.

49.5MRecords
280Tables
34,912Fields
CurrentYears

Publisher: CDC; HRSA; New York State Department of Health

Try it

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

Tables
ny_sparcs_inpatient_discharges37.6Mcdc_places_census_tract3.2Mcdc_places_place2.3Mhrsa_xl_h80_healthcenterzipcodes1.3Mcdc_places_zcta1.2Mhrsa_xl_h80_tblgranteezipcodes438Khrsa_xl_h80_table7clinicalmeasures341Kcdc_places_county241Khrsa_xl_nursing_workforce_nssrn_dashboard_data_education_and_licenses209Khrsa_xl_h80_healthcentersiteinfo174Khrsa_site_dashboard129Khrsa_xl_site_dashboard_dash_site_vx129Khrsa_xl_workforce_projections_fulldata_stacked103Khrsa_xl_h80_edits99.7Khrsa_xl_nursing_workforce_nssrn_dashboard_data_earnings_hours87.6Khrsa_bcd_hpsa_fct_det_pc81Khrsa_xl_bcd_hpsa_fct_det_pc_shortage_area_hp_detail_vx81Khrsa_ahrf_csv77.6Khrsa_fs_ehb_award_grant_fa_agr_mvx75.9Khrsa_xl_fs_ehb_award_grant_fa_agr_mvx_fs_ehb_award_grant_fa_agr_mvx75.9Khrsa_xl_h80_granteezipcodes75.1Khrsa_xl_lal_healthcenterzipcodes71Khrsa_xl_h80_tblgranteesiteinfo70.5Khrsa_xl_external_clinician_dashboard_data_v_unified_data66.9Khrsa_xl_nursing_workforce_nssrn_dashboard_data_employment64Khrsa_bcd_hpsa_fct_det_dh47.6Khrsa_xl_bcd_hpsa_fct_det_dh_shortage_area_hp_detail_vx47.6Khrsa_xl_h80_tbltable45.7Khrsa_bcd_hpsa_fct_det_mh42.2Khrsa_xl_bcd_hpsa_fct_det_mh_shortage_area_hp_detail_vx42.2Khrsa_xl_nursing_workforce_nssrn_dashboard_data_work_environment39.8Khrsa_xl_h80_table39.8Khrsa_xl_h80_table739.8Khrsa_xl_external_clinician_dashboard_data_v_alumni_data37.5Khrsa_xl_nursing_workforce_nssrn_dashboard_data_demographics37.2Khrsa_xl_h80_tblt7clinicalmeasures36.8Khrsa_xl_lal_table7clinicalmeasures25.4Khrsa_xl_lal_uiidinfo22.3Khrsa_sdms_auto_hpsa_site_pc20.6Khrsa_xl_sdms_auto_hpsa_site_pc_dd_auto_hpsa_site_vx20.6Khrsa_sdms_auto_hpsa_site_dh20.6Khrsa_xl_sdms_auto_hpsa_site_dh_dd_auto_hpsa_site_vx20.6Khrsa_sdms_auto_hpsa_site_mh20.6Khrsa_xl_sdms_auto_hpsa_site_mh_dd_auto_hpsa_site_vx20.6Khrsa_mua_det20.2Khrsa_xl_mua_det_mua_det20.2Khrsa_xl_h80_table9e19.9Khrsa_xl_h80_table9d19.9Khrsa_xl_h80_table3a19.9Khrsa_xl_h80_table3b19.9Khrsa_xl_h80_table6a19.9Khrsa_xl_h80_table6b19.9Khrsa_xl_h80_table8a19.9Khrsa_xl_h80_table6bclinicalmeasures19.9Khrsa_health_center_service_delivery_and_lookalike_sites19.6Khrsa_xl_health_center_service_delivery_and_lookalike_sites_site_fqhc_fqhc_lal_dd_vx19.6Khrsa_xl_h80_healthcenterinfo18.7Khrsa_ehb_active_grant_fa_agr18.6Khrsa_xl_ehb_active_grant_fa_agr_grants_active_grant_fa_agr_vx18.6Khrsa_xl_h80_uiidinfo17.9Khrsa_xl_lal_edits16.1Khrsa_xl_h80_hitinformation13.7Khrsa_xl_h80_otherdataelements12.3Khrsa_xl_h80_tblgranteeinfo10.5Khrsa_xl_h80_tbltable3a10.5Khrsa_xl_h80_tbltable3b10.5Khrsa_xl_h80_tbltable8a10.5Khrsa_xl_h80_tbltable9d10.5Khrsa_xl_h80_tbltable9e10.5Khrsa_xl_h80_workforce9.6Khrsa_xl_h80_table5a9.2Khrsa_xl_chqr_badge_data_chqr_data9Khrsa_xl_hypertension_nhci_uds8.2Khrsa_xl_organ_donation_and_transplantation_data_overview_state7.9Khrsa_xl_h80_tblsiteservicearea7.3Khrsa_xl_h80_tbltable8b7.1Khrsa_xl_h80_tbltable9c7.1Khrsa_xl_h80_ehrinformation6.2Khrsa_xl_lal_healthcentersiteinfo5.3Khrsa_xl_h80_tlkurbanrural4.1Khrsa_xl_h80_sites3.4Khrsa_xl_h80_tbltable6a3.3Khrsa_xl_h80_tbltable6b3.3Khrsa_xl_h80_udscrosswalk3.3Khrsa_xl_organ_donation_and_transplantation_data_opo_service_area_by_county3.3Khrsa_xl_h80_crosswalk3.2Khrsa_xl_h80_table4ho3.2Khrsa_xl_h80_table3aho3.2Khrsa_xl_h80_table3bho3.2Khrsa_xl_h80_table5ho3.2Khrsa_xl_h80_table6aho3.2Khrsa_xl_h80_tlkmastergranteeinfo3Khrsa_xl_h80_uds2.8Khrsa_xl_lal_table2.8Khrsa_xl_lal_table72.8Khrsa_xl_lal_crosswalk2.7Khrsa_xl_h80_table4mhc2.3Khrsa_xl_h80_table3amhc2.3Khrsa_xl_h80_table3bmhc2.3Khrsa_xl_h80_table5mhc2.3Khrsa_xl_h80_table6amhc2.3Khrsa_xl_h80_tblt6bclinicalmeasures2.3Khrsa_hab_recipient_and_subrecipient2.2Khrsa_xl_hab_recipient_and_subrecipient_hab_rdr_provider_det_dd_vx2.2Khrsa_xl_organ_donation_and_transplantation_data_otc_transplants_by_demographics1.9Khrsa_xl_organ_donation_and_transplantation_data_opo_potr1.7Khrsa_xl_h80_tblinstructionsheet1.6Khrsa_xl_lal_table9e1.4Khrsa_xl_lal_table3a1.4Khrsa_xl_lal_table3b1.4Khrsa_xl_lal_table6b1.4Khrsa_xl_lal_table8a1.4Khrsa_xl_lal_table9d1.4Khrsa_xl_lal_table6bclinicalmeasures1.4Khrsa_xl_lal_healthcenterinfo1.4Khrsa_xl_h80_table4ph1.3Khrsa_xl_h80_table3aph1.3Khrsa_xl_h80_table3bph1.3Khrsa_xl_h80_table5ph1.3Khrsa_xl_h80_table6aph1.3Khrsa_xl_h80_tbltable3aho1.2Khrsa_xl_h80_tbltable3bho1.2Khrsa_xl_h80_tbltable4ho1.2Khrsa_xl_lal_table6a1.2Khrsa_xl_h80_granteeinfo1.1Khrsa_xl_organ_donation_and_transplantation_data_otc_outcome_measures1.1Khrsa_xl_organ_donation_and_transplantation_data_waitlist_otc_transplant_rate1.1Khrsa_xl_h80_tblclinicaldatameasures1.1Khrsa_xl_lal_hitinformation1Khrsa_xl_lal_otherdataelements986hrsa_xl_h80_tbltable3amhc917hrsa_xl_h80_tbltable3bmhc917hrsa_xl_h80_tbltable4mhc917hrsa_xl_h80_tbltable5mhc917hrsa_xl_h80_tbltable5ho879hrsa_xl_organ_donation_and_transplantation_data_waitlist_otc_removal_reasons865hrsa_xl_lal_workforce848hrsa_xl_h80_tbltable6ho804hrsa_xl_h80_profile691hrsa_xl_fy_nhsc_field_strength_rural_fs657hrsa_xl_fy_nhsc_field_strength_non_rural_fs651hrsa_xl_fy_nhsc_field_strength_mental_health_fs622hrsa_xl_fy_nhsc_field_strength_primary_care_fs560hrsa_xl_lal_table5a533hrsa_xl_fy_nhsc_field_strength_oral_health_fs532hrsa_xl_fy_nhsc_field_strength_nhsc_field_strength511hrsa_xl_h80_tbltable6mhc495hrsa_xl_nhsc_lrp_program_applicant_metrics_applicant_information435hrsa_xl_fy_star_field_strength_star_field_strength429hrsa_xl_h80_tbltable6aho428hrsa_xl_h80_tbltable6amhc422hrsa_xl_star_lrp_program_applicant_metrics_applicant_information407hrsa_xl_fy_nurse_corps_field_strength_annual_field_strength375hrsa_xl_h80_tbltable3aph369hrsa_xl_h80_tbltable3bph369hrsa_xl_h80_tbltable4ph369hrsa_xl_h80_tbltable3ahshc352hrsa_xl_h80_tbltable4hshc352hrsa_xl_h80_tbltable3bhshc351hrsa_xl_h80_tbltable6hshc351hrsa_xl_fy_nhsc_scholar_pipeline_nhsc_scholar_pipeline337hrsa_xl_bpmh_participant_summary_information_graduate_intentions336hrsa_xl_lal_ehrinformation332hrsa_xl_fy_flrp_field_strength_flrp_field_strength331hrsa_xl_fy_nurse_corps_scholar_pipeline_scholar_pipeline329hrsa_xl_flrp_program_applicant_metrics_applicant_information327hrsa_xl_bpmh_graduate_follow_up_information_other_graduate_follow_up326hrsa_xl_nhsc_lrp_program_applicant_metrics_applicant_site_information314hrsa_xl_nhsc_sp_program_applicant_metrics_applicant_information307hrsa_xl_bpmh_participant_summary_information_primary_discipline298hrsa_xl_nclrp_program_applicant_metrics_applicant_site_information291hrsa_xl_bpmh_participants_demographics_information_participant_demographics287hrsa_xl_h80_tbltable5ph267hrsa_xl_h80_table3ahp252hrsa_xl_h80_table3bhp252hrsa_xl_h80_table4hp252hrsa_xl_h80_table5hp252hrsa_xl_h80_table6ahp252hrsa_xl_s2s_lrp_program_applicant_metrics_applicant_information235hrsa_xl_h80_tbltable6ph234hrsa_xl_bpmh_courses_information_cde_participant_profession231hrsa_xl_star_lrp_program_applicant_metrics_applicant_site_information230hrsa_xl_fy_ps_lrp_field_strength_ps_lrp_field_strength223hrsa_xl_h80_tbltable5hshc220hrsa_xl_nursing_workforce_nssrn_dashboard_data_covid_burnout218hrsa_xl_bpmh_courses_information_fd_trainees_profession209hrsa_xl_nclrp_program_applicant_metrics_applicant_information180hrsa_xl_h80_table3amsaw166hrsa_xl_h80_table3bmsaw166hrsa_xl_h80_table4msaw166hrsa_xl_h80_table5msaw166hrsa_xl_h80_table6amsaw166hrsa_ahrf_sn_csv156hrsa_xl_bpmh_courses_information_ce_participant_profession149hrsa_xl_ncsp_program_applicant_metrics_applicant_information149hrsa_xl_bpmh_graduate_follow_up_information_employment_facility_type144hrsa_xl_nursing_workforce_nssrn_dashboard_data_rurality142hrsa_xl_bpmh_courses_information_fd_faculty_profession135hrsa_xl_h80_tbltable6aph135hrsa_xl_bpmh_courses_information_cde_course_type131hrsa_xl_bpmh_courses_information_ce_top_10_course_topics123hrsa_xl_h80_coversheet119hrsa_xl_h80_tlklocationcodes116hrsa_xl_ps_lrp_program_applicant_metrics_applicant_site_information116hrsa_xl_fy_star_lrp_program_applicant_metrics_applicant_information112hrsa_xl_h80_table3arph105hrsa_xl_h80_table3brph105hrsa_xl_h80_table4rph105hrsa_xl_h80_table5rph105hrsa_xl_h80_table6arph105hrsa_xl_fy_nhsc_lrp_program_applicant_metrics_applicant_information101hrsa_xl_bpmh_courses_information_ce_courses_delivery_mode89hrsa_xl_ps_lrp_program_applicant_metrics_applicant_information88hrsa_xl_fy_nclrp_program_applicant_metrics_applicant_site_information86hrsa_xl_organ_donation_and_transplantation_data_waitlist_candidate_registration84hrsa_xl_fy_flrp_program_applicant_metrics_applicant_information78hrsa_xl_fy_nhsc_lrp_program_applicant_metrics_applicant_site_information78hrsa_xl_fy_nurse_corps_field_strength_nurse_corps_field_strength78hrsa_xl_organ_donation_and_transplantation_data_donor_demographics77hrsa_xl_fy_nclrp_program_applicant_metrics_applicant_information76hrsa_xl_bpmh_courses_information_fd_project_purpose75hrsa_xl_fy_nc_field_strength_external_hdw_annual_field_strength70hrsa_xl_lal_coversheet67hrsa_xl_bcd_hpsa_fct_det_pc_data_dictionary66hrsa_xl_organ_donation_and_transplantation_data_recipient_demographics66hrsa_xl_bcd_hpsa_fct_det_dh_data_dictionary65hrsa_xl_bcd_hpsa_fct_det_mh_data_dictionary65hrsa_xl_bpmh_home_dashboard_summary_information_home_dashboard_summary_info65hrsa_xl_bpmh_participant_summary_information_hhs_priority_topic_area64hrsa_xl_hab_recipient_and_subrecipient_data_dictionary61hrsa_xl_ryan_white_hiv_aids_recipients_and_subrecipients_data_download_metadata_hab_rdr_provider_det_dd_meta_vx60hrsa_xl_fy_nhsc_sp_program_applicant_metrics_applicant_information58hrsa_xl_fy_ps_lrp_program_applicant_metrics_applicant_site_information58hrsa_xl_fy_star_lrp_program_applicant_metrics_applicant_site_information58hrsa_xl_health_center_service_delivery_and_lookalike_sites_data_dictionary56hrsa_xl_fy_s2s_lrp_program_applicant_metrics_applicant_information55hrsa_xl_health_center_service_delivery_and_lookalike_sites_data_download_metadata_site_fqhc_fqhc_lal_dd_meta_vx55hrsa_xl_bpmh_sites_information_sites_by_setting52hrsa_xl_fy_nhhsp_scholars_in_school_nhhsp_scholars52hrsa_xl_fy_ps_lrp_program_applicant_metrics_applicant_information48hrsa_xl_fs_ehb_award_grant_fa_agr_mvx_data_dictionary44hrsa_xl_fy_nhhsp_scholars_in_school_sheet44hrsa_xl_awarded_grants_data_download_metadata_fs_awd_grnt_fa_agr_dd_meta_vx43hrsa_xl_organ_donation_and_transplantation_data_read_me_first43hrsa_xl_organ_donation_and_transplantation_data_overview42hrsa_xl_bpmh_courses_information_ce_participantemploymentsetting39hrsa_xl_bpmh_participant_summary_information_key_training_settings39hrsa_xl_bpmh_graduate_follow_up_information_key_graduate_follow_up36hrsa_xl_fy_ncsp_program_applicant_metrics_applicant_information36hrsa_xl_ehb_active_grant_fa_agr_data_dictionary30hrsa_xl_active_grants_data_download_metadata_ehb_act_grant_fa_agr_dd_meta_vx29hrsa_xl_external_clinician_dashboard_data_v_alumni_data_dictionary25hrsa_xl_bpmh_graduate_follow_up_information_grantee_organization_hiring20hrsa_xl_bpmh_graduate_follow_up_information_partner_organization_hiring18hrsa_xl_h80_tbltable3ahoc18hrsa_xl_h80_tbltable3bhoc18hrsa_xl_h80_tbltable4hoc18hrsa_xl_h80_tbltable6hoc18hrsa_xl_site_dashboard_data_dictionary18hrsa_xl_site_dashboard_metadata_site_dashboard_metadata_vx18hrsa_xl_external_clinician_dashboard_data_v_unified_data_dictionary16hrsa_xl_sdms_auto_hpsa_site_dh_data_dictionary14hrsa_xl_sdms_auto_hpsa_site_mh_data_dictionary14hrsa_xl_sdms_auto_hpsa_site_pc_data_dictionary14hrsa_xl_active_grants_data_download_metadata_data_dictionary13hrsa_xl_awarded_grants_data_download_metadata_data_dictionary13hrsa_xl_bpmh_courses_information_cde_participant_trained_summary13hrsa_xl_bpmh_courses_information_cde_summary13hrsa_xl_bpmh_courses_information_ce_course_summary13hrsa_xl_bpmh_courses_information_ce_participant_trained_summary13hrsa_xl_bpmh_courses_information_fd_faculty_involved_summary13hrsa_xl_bpmh_courses_information_fd_faculty_trained_summary13hrsa_xl_bpmh_courses_information_fd_students_involved_summary13hrsa_xl_bpmh_courses_information_fd_trainees_trained_summary13hrsa_xl_bpmh_participant_summary_information_participant_summary13hrsa_xl_bpmh_participants_demographics_information_summary13hrsa_xl_bpmh_sites_information_sites_summary13hrsa_xl_health_center_service_delivery_and_lookalike_sites_data_download_metadata_data_dictionary13hrsa_xl_ryan_white_hiv_aids_recipients_and_subrecipients_data_download_metadata_data_dictionary13hrsa_xl_site_dashboard_metadata_data_dictionary12
Fields in ny_sparcs_inpatient_discharges
FieldTypeExample
health_service_areastringNew York City
hospital_countystringKings
operating_certificate_numberstring7001002
facility_idstring1286
facility_namestringBrookdale Hospital Medical Center
age_groupstring0 to 17
zip_code_3_digitsstring112
genderstringM
racestringBlack/African American
ethnicitystringNot Span/Hispanic
length_of_staystring2
type_of_admissionstringEmergency
patient_dispositionstringHome or Self Care
discharge_yearstring2016
ccs_diagnosis_codestring128
ccs_diagnosis_descriptionstringAsthma
ccs_procedure_codestring41
ccs_procedure_descriptionstringOT NON-OR THER PRC RESP
apr_drg_codestring141
apr_drg_descriptionstringAsthma
apr_mdc_codestring4
apr_mdc_descriptionstringDiseases and Disorders of the Respiratory System
apr_severity_of_illness_codestring1
apr_severity_of_illness_descriptionstringMinor
apr_risk_of_mortalitystringMinor
apr_medical_surgical_descriptionstringMedical
source_of_payment_1string
source_of_payment_2string
source_of_payment_3string
birth_weightstring0
abortion_edit_indicatorstringN
emergency_department_indicatorstringY
total_chargesstring9984.34
total_costsstring3776.84
source_filestringlake/v1/health/raw/ny-sparcs/2026-11-15/hospital-inpatient-d
payment_typology_1stringMedicaid
payment_typology_2stringMedicare
payment_typology_3stringMedicaid
hospital_service_areastring
permanent_facility_idstring
ccsr_diagnosis_codestring
ccsr_diagnosis_descriptionstring
ccsr_procedure_codestring
ccsr_procedure_descriptionstring
zip_codestring
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 Health