About this Dataset

Plan ID Crosswalk PUF – PY2026

The Plan ID Crosswalk PUF (CW-PUF) is one of the files that comprise the Health Insurance Exchange Public Use Files. The purpose of the CW-PUF is to map QHPs and SADPs offered through the Exchanges during the previous plan year to plans that will be offered through the Exchanges in the current plan year.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-11-01T11:34:01.919830
Tags: exchange-puf, marketplace-puf, plan-id-crosswalk, py2026

Tables

Table 1

@usgov.hhs_gov_plan_id_crosswalk_puf_py2026.table_1

246.92 kB
158,746 rows
24 columns

CREATE TABLE table_1 (
  "state" VARCHAR,
  "dentalplan" VARCHAR,
  "planid_2025" VARCHAR,
  "issuerid_2025" BIGINT,
  "multistateplan_2025" VARCHAR,
  "metallevel_2025" VARCHAR,
  "childadultonly_2025" BIGINT,
  "fipscode" BIGINT,
  "zipcode" BIGINT,
  "crosswalklevel" BIGINT,
  "reasonforcrosswalk" BIGINT,
  "planid_2026" VARCHAR,
  "issuerid_2026" BIGINT,
  "multistateplan_2026" VARCHAR,
  "metallevel_2026" VARCHAR,
  "childadultonly_2026" VARCHAR,
  "ageoffplanid_2026" VARCHAR,
  "issuerid_ageoff2026" BIGINT,
  "multistateplan_ageoff2026" VARCHAR,
  "metallevel_ageoff2026" VARCHAR,
  "childadultonly_ageoff2026" VARCHAR,
  "reasonforbronzetosilvercrosswalk" VARCHAR,
  "silvercsreligplanid_2026" VARCHAR,
  "silvercsreligissuerid_2026" BIGINT
);