Baselight

Rate PUF – PY2022

U.S. Department of Health & Human Services

@usgov.hhs_gov_rate_puf_py2022

Loading...
Loading...

About this Dataset

Rate PUF – PY2022

The Rate PUF (Rate-PUF) is one of the files that comprise the Health Insurance Exchange Public Use Files. The Rate-PUF contains plan-level data on rates based on an eligible subscriber’s age, tobacco use, and geographic location; and family-tier rates.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-10-30T13:05:08.455419
Tags: exchange-puf, marketplace-puf, py2022, rate

Tables

Table 1

@usgov.hhs_gov_rate_puf_py2022.table_1
  • 12.69 MB
  • 2498402 rows
  • 20 columns
Loading...

CREATE TABLE table_1 (
  "businessyear" BIGINT,
  "statecode" VARCHAR,
  "issuerid" BIGINT,
  "sourcename" VARCHAR,
  "importdate" TIMESTAMP,
  "rateeffectivedate" TIMESTAMP,
  "rateexpirationdate" TIMESTAMP,
  "planid" VARCHAR,
  "ratingareaid" VARCHAR,
  "tobacco" VARCHAR,
  "age" VARCHAR,
  "individualrate" DOUBLE,
  "individualtobaccorate" DOUBLE,
  "couple" DOUBLE,
  "primarysubscriberandonedependent" DOUBLE,
  "primarysubscriberandtwodependents" DOUBLE,
  "primarysubscriberandthreeormoredependents" DOUBLE,
  "coupleandonedependent" DOUBLE,
  "coupleandtwodependents" DOUBLE,
  "coupleandthreeormoredependents" DOUBLE
);

Share link

Anyone who has the link will be able to view this.