Quality ratings, staffing and inspections for hospitals, nursing homes, dialysis, home health, hospice and clinicians.
Publisher: Centers for Medicare and Medicaid Services
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| npi | string | 1679520977 |
| ind_pac_id | string | 9931098852 |
| ind_enrl_id | string | I20060508000013 |
| lst_nm | string | HERMANSEN |
| frst_nm | string | DANE |
| mid_nm | string | K |
| suff | string | JR. |
| gndr | string | M |
| cred | string | MD |
| med_sch | string | VIRGINIA COMMONWEALTH UNIVERSITY, SCHOOL OF MEDICINE |
| grd_yr | string | 1981 |
| pri_spec | string | UROLOGY |
| sec_spec_1 | string | SPORTS MEDICINE |
| sec_spec_2 | string | PAIN MANAGEMENT |
| sec_spec_3 | string | OSTEOPATHIC MANIPULATIVE MEDICINE |
| sec_spec_4 | string | |
| sec_spec_all | string | SPORTS MEDICINE |
| org_nm | string | |
| org_pac_id | string | 8224927132 |
| num_org_mem | string | 9 |
| adr_ln_1 | string | 84 PINNACLES DR |
| adr_ln_2 | string | SUITE 500 |
| ln_2_sprs | string | Y |
| cty | string | |
| st | string | |
| zip | string | |
| phn_numbr | string | |
| hosp_afl_1 | string | |
| hosp_afl_lbn_1 | string | |
| hosp_afl_2 | string | |
| hosp_afl_lbn_2 | string | |
| hosp_afl_3 | string | |
| hosp_afl_lbn_3 | string | |
| hosp_afl_4 | string | |
| hosp_afl_lbn_4 | string | |
| hosp_afl_5 | string | |
| hosp_afl_lbn_5 | string | |
| ind_assgn | string | Y |
| grp_assgn | string | Y |
| adrs_id | string | FL321642324PA84XXXDRXX304 |
| release_date | string | 2023-09-14 |
| source_file | string | lake/v1/health/raw/care-compare/2026-11-15/doctors-clinician |
| telehlth | string | |
| facility_name | string | FLORIDA UROLOGY CENTER PA |
| citytown | string | PALM COAST |
| state | string | FL |
| zip_code | string | 321642324 |
| telephone_number | string | 3866735100 |
| provider_last_name | string | |
| provider_first_name | string | |
| provider_middle_name | 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.