Local health estimates, shortage areas and health centers, and New York inpatient discharges.
Publisher: CDC; HRSA; New York State Department of Health
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| health_service_area | string | New York City |
| hospital_county | string | Kings |
| operating_certificate_number | string | 7001002 |
| facility_id | string | 1286 |
| facility_name | string | Brookdale Hospital Medical Center |
| age_group | string | 0 to 17 |
| zip_code_3_digits | string | 112 |
| gender | string | M |
| race | string | Black/African American |
| ethnicity | string | Not Span/Hispanic |
| length_of_stay | string | 2 |
| type_of_admission | string | Emergency |
| patient_disposition | string | Home or Self Care |
| discharge_year | string | 2016 |
| ccs_diagnosis_code | string | 128 |
| ccs_diagnosis_description | string | Asthma |
| ccs_procedure_code | string | 41 |
| ccs_procedure_description | string | OT NON-OR THER PRC RESP |
| apr_drg_code | string | 141 |
| apr_drg_description | string | Asthma |
| apr_mdc_code | string | 4 |
| apr_mdc_description | string | Diseases and Disorders of the Respiratory System |
| apr_severity_of_illness_code | string | 1 |
| apr_severity_of_illness_description | string | Minor |
| apr_risk_of_mortality | string | Minor |
| apr_medical_surgical_description | string | Medical |
| source_of_payment_1 | string | |
| source_of_payment_2 | string | |
| source_of_payment_3 | string | |
| birth_weight | string | 0 |
| abortion_edit_indicator | string | N |
| emergency_department_indicator | string | Y |
| total_charges | string | 9984.34 |
| total_costs | string | 3776.84 |
| source_file | string | lake/v1/health/raw/ny-sparcs/2026-11-15/hospital-inpatient-d |
| payment_typology_1 | string | Medicaid |
| payment_typology_2 | string | Medicare |
| payment_typology_3 | string | Medicaid |
| hospital_service_area | string | |
| permanent_facility_id | string | |
| ccsr_diagnosis_code | string | |
| ccsr_diagnosis_description | string | |
| ccsr_procedure_code | string | |
| ccsr_procedure_description | string | |
| zip_code | string |
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.