About this Dataset

Benefits And Cost Sharing PUF - PY2025

The Benefits and Cost Sharing PUF (BenCS-PUF) is one of the files that comprise the Health Insurance Exchange Public Use Files. The BenCS-PUF contains plan variant-level data on essential health benefits, coverage limits, and cost sharing for each QHP and SADP.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-02-03T22:06:44.784377
Tags: benefits-and-cost-sharing, exchange-puf, marketplace-puf, py2025

Tables

Table 1

@usgov.hhs_gov_benefits_and_cost_sharing_puf_py2025.table_1

2.68 MB
1,645,350 rows
24 columns

CREATE TABLE table_1 (
  "businessyear" BIGINT,
  "statecode" VARCHAR,
  "issuerid" BIGINT,
  "sourcename" VARCHAR,
  "importdate" TIMESTAMP,
  "standardcomponentid" VARCHAR,
  "planid" VARCHAR,
  "benefitname" VARCHAR,
  "copayinntier1" VARCHAR,
  "copayinntier2" VARCHAR,
  "copayoutofnet" VARCHAR,
  "coinsinntier1" VARCHAR,
  "coinsinntier2" VARCHAR,
  "coinsoutofnet" VARCHAR,
  "isehb" VARCHAR,
  "iscovered" VARCHAR,
  "quantlimitonsvc" VARCHAR,
  "limitqty" DOUBLE,
  "limitunit" VARCHAR,
  "exclusions" VARCHAR,
  "explanation" VARCHAR,
  "ehbvarreason" VARCHAR,
  "isexclfrominnmoop" VARCHAR,
  "isexclfromoonmoop" VARCHAR
);