About this Dataset

Rate PUF – PY2025

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: 2025-02-03T21:55:25.188696
Tags: exchange-puf, marketplace-puf, py2025, rate

Tables

Table 1

@usgov.hhs_gov_rate_puf_py2025.table_1

13.88 MB
2,418,441 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
);