State drug utilization, pharmacy acquisition costs and enrollment.
Publisher: Centers for Medicare and Medicaid Services
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| utilization_type | string | FFSU |
| state | string | XX |
| ndc | string | 00472033856 |
| labeler_code | string | 00472 |
| product_code | string | 0338 |
| package_size | string | 56 |
| year | string | 2009 |
| quarter | string | 3 |
| suppression_used | string | true |
| product_name | string | HYDROCORTI |
| units_reimbursed | string | 00000023000.700 |
| number_of_prescriptions | string | 000000702 |
| total_amount_reimbursed | string | 000000005629.81 |
| medicaid_amount_reimbursed | string | 0000005481.03 |
| non_medicaid_amount_reimbursed | string | 0000000148.78 |
| source_file | string | lake/v1/health/raw/medicaid/2026-11-15/state-drug-utilizatio |
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.