NYSgptData LibraryConnectPricing

Medicare payments by provider

Payments and services by provider for physicians, prescribers, hospitals and equipment suppliers.

487MRecords
16Tables
655Fields
CurrentYears

Publisher: Centers for Medicare and Medicaid Services

Try it

Runs against the full table. Enter your key; plans are below.

Tables
Fields in medicare_part_d_prescribers_by_provider_and_drug
FieldTypeExample
prscrbr_npistring1912999426
prscrbr_last_org_namestringJafar
prscrbr_first_namestringAman
prscrbr_citystringSugar Land
prscrbr_state_abrvtnstringTX
prscrbr_state_fipsstring48
prscrbr_typestringEmergency Medicine
prscrbr_type_srcstringClaim-Specialty
brnd_namestringValproic Acid
gnrc_namestringValproic Acid (As Sodium Salt)
tot_clmsstring64
tot_30day_fillsstring64
tot_day_suplystring1668
tot_drug_cststring1831.95
tot_benesstring11
ge65_sprsn_flagstring#
ge65_tot_clmsstring46
ge65_tot_30day_fillsstring46
ge65_tot_drug_cststring1401.76
ge65_tot_day_suplystring1170
ge65_bene_sprsn_flagstring*
ge65_tot_benesstring41
source_filestringlake/v1/health/raw/cms-medicare-part-d-prescribers-by-provid
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address with your key:

https://data.nysgpt.com/mcp?key=YOUR_KEY

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"

HTTP

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.

Pricing

Samples

$0

20,000-row samples of ten datasets, as Parquet files on Hugging Face.

Open samples

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