Insurer negotiated rates

CMS independent State-based Exchange QHP PUF packages - plan, benefit and premium detail for the states not on HealthCare.gov (PY2016-PY2026)

cms_independent_sbe_packages·live·raw

Rows

20,911,204

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1The six Exchange PUF families (Benefits & Cost Sharing, Rate, Plan Attributes, Business Rules, Service Area, Network) that CMS republishes for each independent State-based Exchange in its SBE template: 195 state/year packages (17 states in PY2016 to 22 in PY2026) plus 11 annual dictionary ZIPs.
2With the federal-platform PUFs they cover all 51 jurisdictions for PY2016-PY2026.

Grain

Key	Grain
N/A	1One publisher CSV row per (plan_year, state, family, archive member, source_row_number) inside one immutable CMS state/year ZIP.

Columns (0)

Columns are not in the catalog for this source; describe_data_source("cms_independent_sbe_packages") reads them live.

Query it

describe_data_source(source_fqn="cms_independent_sbe_packages")     # the card, live
query_substrate(sql="SELECT * FROM cms_independent_sbe_packages WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,state,family,archive_member_sha256,source_row_number`
Join	`how_to_join(source_fqn="cms_independent_sbe_packages")`
Raw door	Athena (read-only via query_substrate) through the six sibling tables, one per family: medicare_silver.fact_sbe_plan_attributes_puf_history, fact_sbe_benefits_cost_sharing_puf_history, fact_sbe_business_rules_puf_history, fact_sbe_service_area_puf_history, fact_sbe_network_puf_history and fact_sbe_rate_puf_history (20,911,204 rows, PY2016-2026, loaded 2026-10-13). All 206 publisher ZIPs (153,871,791 B) stay byte-exact in s3://vlada-platform-raw/medicare/bronze/cms_independent_sbe_packages/.

This page as markdown: /docs-md/data/cms_independent_sbe_packages.md · every page in one file: /llms-full.txt