Marketplace rates, benefits and networks; Medicare Advantage and Part D plans, enrollment and star ratings.
Publisher: Centers for Medicare and Medicaid Services
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| businessyear | string | 2021 |
| statecode | string | AK |
| issuerid | string | 21989 |
| sourcename | string | HIOS |
| versionnum | string | |
| importdate | string | 2020-07-31 03:20:18 |
| issuerid2 | string | |
| federaltin | string | |
| rateeffectivedate | string | 2021-01-01 |
| rateexpirationdate | string | 2021-03-31 |
| planid | string | 21989AK0080001 |
| ratingareaid | string | Rating Area 1 |
| tobacco | string | No Preference |
| age | string | Family Option |
| individualrate | string | 51.23 |
| individualtobaccorate | string | 355.00 |
| couple | string | 106.56 |
| primarysubscriberandonedependent | string | 122.95 |
| primarysubscriberandtwodependents | string | 122.95 |
| primarysubscriberandthreeormoredependents | string | 122.95 |
| coupleandonedependent | string | 183.41 |
| coupleandtwodependents | string | 183.41 |
| coupleandthreeormoredependents | string | 183.41 |
| rownumber | string | |
| source_file | string | lake/v1/health/raw/marketplace-puf/2026-11-15/2021-rate-puf. |
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.