About this Dataset

Rate PUF - PY2024

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: 2023-10-30T11:35:55.280634
Tags: exchange-puf, marketplace-puf, py2024, rate

Tables

Table 1

@usgov.hhs_gov_rate_puf_py2024.table_1

14.78 MB
2,608,212 rows
20 columns

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
);