NYSgptData LibraryConnectPricing

Health plans

Marketplace rates, benefits and networks; Medicare Advantage and Part D plans, enrollment and star ratings.

86.3MRecords
127Tables
20,259Fields
CurrentYears

Publisher: Centers for Medicare and Medicaid Services

Try it

This runs against the full table, free, with no key.

Tables
marketplace_rate_puf38.7Mmarketplace_benefits_and_cost_sharing_puf20.9Mma_enrollment_by_contract_plan_state_county3.4Mmarketplace_plan_id_crosswalk_puf1.8Mmarketplace_newyorksbepuf1.4Mmarketplace_idahosbepuf1.2Mmarketplace_pufny1.2Mmarketplace_pufco1Mmarketplace_pufid653Kmarketplace_coloradosbepuf630Kmarketplace_sbe_pufsstate_files_co592Kmarketplace_pennsylvaniasbepuf587Kmarketplace_pufor561Kmarketplace_pufca554Kmarketplace_californiasbepuf491Kmarketplace_oregonsbepuf453Kmarketplace_new_york_puf413Kmarketplace_sbe_pufsstate_files_ny374Kmarketplace_minnesotasbepuf369Kmarketplace_kentuckysbepuf337Kmarketplace_py_sbe_qhp_puf_data_new_york330Kmarketplace_colorado_puf326Kmarketplace_plan_attributes_puf312Kmarketplace_marylandsbepuf308Kmarketplace_massachusettssbepuf303Kmarketplace_idaho_sbe_qhp_puf284Kmarketplace_sbe_pufsstate_files_or281Kma_pdp_cy_landscape269Kmarketplace_virginiasbepuf257Kmarketplace_new_york_sbe_puf255Kmarketplace_nevadasbepuf244Kmarketplace_mainesbepuf224Kmarketplace_washingtonsbepuf220Kmarketplace_sbe_pufsstate_files_id219Kmarketplace_california_sbe_puf210Kmarketplace_pufmd196Kmarketplace_pufma195Kmarketplace_colorado_sbe_puf192Kmarketplace_sbe_pufsstate_files_ca191Kmarketplace_pufmn190Kmarketplace_georgiasbepuf183Kmarketplace_idaho_sbe_puf172Kmarketplace_districtofcolumbiasbepuf168Kmarketplace_californiasbpuf168Kmarketplace_service_area_puf167Kmarketplace_pufdc163Kmarketplace_pufwa162Kmarketplace_california_puf157Kmarketplace_idaho_puf155Kmarketplace_py_sbe_qhp_puf_data_colorado153Kmarketplace_california_sbe_qhp_puf151Kmarketplace_py_sbe_qhp_puf_data_pennsylvania132Kmarketplace_illinois_sbe_qhp_puf128Kmarketplace_pufpa127Kmarketplace_connecticutsbepuf124Kmarketplace_sbe_pufsstate_files_md120Kmarketplace_newmexicosbepuf116Kmarketplace_kentucky_puf116Kmarketplace_py_sbe_qhp_puf_data_oregon106Kmarketplace_pufct106Kmarketplace_oregon_puf105Kmarketplace_minnesota_puf99.7Kmarketplace_washington_puf99.2Kmarketplace_newjerseysbepuf95.5Kmarketplace_maryland_puf93.9Kmarketplace_sbe_pufsstate_files_ma92.2Kmarketplace_maryland_sbe_puf90.5Kmarketplace_py_sbe_qhp_puf_data_maryland85.5Kmarketplace_py_sbe_qhp_puf_data_minnesota84.4Kmarketplace_pufri84.3Kmarketplace_business_rules_puf82Kmarketplace_py_sbe_qhp_puf_data_kentucky77.7Kmarketplace_oregon_sbe_puf75.9Kmarketplace_connecticut_puf73.5Kmarketplace_py_sbe_qhp_pud_data_maine69.6Kmarketplace_py_sbe_qhp_puf_data_nevada68.4Kmarketplace_pufnv68.1Kmarketplace_sbe_pufsstate_files_nm67.9Kmarketplace_py_sbe_qhp_puf_data_district_columbia66.9Kmarketplace_massachusetts_sbe_puf64.4Kmarketplace_sbe_pufsstate_files_dc54.9Kmarketplace_pufnm53.2Kmarketplace_py_sbe_qhp_puf_data_washington53.1Kmarketplace_rhodeislandsbepuf52.8Kmarketplace_districtofcolumbiapuf52.7Kmarketplace_massachusetts_sbe_qhp_puf51.7Kmarketplace_dc_sbe_puf49.4Kmarketplace_sbe_pufsstate_files_mn47.7Kmarketplace_new_mexico_sbe_qhp_puf45.1Kmarketplace_sbe_pufsstate_files_ct45Kmarketplace_connecticut_sbe_puf41.9Kmarketplace_utah_puf38.7Kma_stars_star_ratings_and_display_measures38.4Kma_stars_plan_ratings_and_display_measures37.6Kmarketplace_pufnj36.9Kmarketplace_sbe_pufsstate_files_ri36.8Kmarketplace_vermontsbepuf36.1Kmarketplace_py_sbe_qhp_puf_data_connecticut35.7Kmarketplace_sbe_pufsstate_files_ar34.3Kmarketplace_minnesota_sbe_puf33Kmarketplace_new_mexico_sbe_puf32.6Kmarketplace_massachusetts_puf32Kmarketplace_py_sbe_qhp_puf_data_new_jersey27.9Kmarketplace_pufvt26Kmarketplace_sbe_pufsstate_files_wa26Kmarketplace_pufut25.1Kmarketplace_rhode_island_puf19.5Kma_stars_plan_ratings16.8Kmarketplace_mississippi_puf14.9Kmarketplace_pufms14.3Kmarketplace_rhode_island_sbe_puf13.9Kmarketplace_py_sbe_qhp_puf_data_rhode_island13.3Kmarketplace_dc_puf13Kmarketplace_network_puf11Kmarketplace_py_sbe_qhp_puf_data_vermont9.1Kmarketplace_sbe_pufsstate_files_vt8.9Kmarketplace_vermont_puf8.8Kma_stars_star_ratings_data_tables8.6Kmarketplace_pufar7.5Kmarketplace_vermont_sbe_puf7.3Kmarketplace_arkansas_puf6.8Kma_stars_star_ratings_data_tables_jul_25.2Kma_stars_star_ratings_data_tables_oct_83.7Kma_stars_display_measures2.9Kma_plan_directory995marketplace_quality_puf830pdp_plan_directory108
Fields in marketplace_rate_puf
FieldTypeExample
businessyearstring2021
statecodestringAK
issueridstring21989
sourcenamestringHIOS
versionnumstring
importdatestring2020-07-31 03:20:18
issuerid2string
federaltinstring
rateeffectivedatestring2021-01-01
rateexpirationdatestring2021-03-31
planidstring21989AK0080001
ratingareaidstringRating Area 1
tobaccostringNo Preference
agestringFamily Option
individualratestring51.23
individualtobaccoratestring355.00
couplestring106.56
primarysubscriberandonedependentstring122.95
primarysubscriberandtwodependentsstring122.95
primarysubscriberandthreeormoredependentsstring122.95
coupleandonedependentstring183.41
coupleandtwodependentsstring183.41
coupleandthreeormoredependentsstring183.41
rownumberstring
source_filestringlake/v1/health/raw/marketplace-puf/2026-11-15/2021-rate-puf.
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

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