Payments and services by provider for physicians, prescribers, hospitals and equipment suppliers.
Publisher: Centers for Medicare and Medicaid Services
Runs against the full table. Enter your key; plans are below.
| Field | Type | Example |
|---|---|---|
| prscrbr_npi | string | 1912999426 |
| prscrbr_last_org_name | string | Jafar |
| prscrbr_first_name | string | Aman |
| prscrbr_city | string | Sugar Land |
| prscrbr_state_abrvtn | string | TX |
| prscrbr_state_fips | string | 48 |
| prscrbr_type | string | Emergency Medicine |
| prscrbr_type_src | string | Claim-Specialty |
| brnd_name | string | Valproic Acid |
| gnrc_name | string | Valproic Acid (As Sodium Salt) |
| tot_clms | string | 64 |
| tot_30day_fills | string | 64 |
| tot_day_suply | string | 1668 |
| tot_drug_cst | string | 1831.95 |
| tot_benes | string | 11 |
| ge65_sprsn_flag | string | # |
| ge65_tot_clms | string | 46 |
| ge65_tot_30day_fills | string | 46 |
| ge65_tot_drug_cst | string | 1401.76 |
| ge65_tot_day_suply | string | 1170 |
| ge65_bene_sprsn_flag | string | * |
| ge65_tot_benes | string | 41 |
| source_file | string | lake/v1/health/raw/cms-medicare-part-d-prescribers-by-provid |
Settings, Connectors, Add custom connector. Paste this address with your key:
https://data.nysgpt.com/mcp?key=YOUR_KEY
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"
curl -s https://data.nysgpt.com/query -H "X-Api-Key: YOUR_KEY" -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). Every call needs a key; plans are below.
$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.