About this Dataset

Covered California Subsidized Qualified Health Plans (QHPs) Enrollees By Federal Poverty Level (FPL)

This dataset includes the number of eligible individuals selected and enrolled in a subsidized Covered California qualified health plans (QHPs) by Federal Poverty Level (FPL) range by reporting period. Covered California reported data is from the California Healthcare Eligibility, Enrollment and Retention System (CalHEERS) and includes eligible individuals who selected and enrolled in a QHP, and paid their first premium. This dataset is part of public reporting requirements set forth by the California Welfare and Institutions Code 14102.5.
Organization: State of California
Last updated: 2025-09-23T12:45:02.622156
Tags: abx1-1, california-department-of-health-care-services, california-eligibility-and-enrollment-report, covered-ca, covered-ca-covered-ca-qhp-eligibility, covered-ca-income-limits, covered-california-enrollment, federal-poverty-level, fpl, iap, insurance-affordability-programs, medi-cal, medi-cal-eligibility, medi-cal-enrollment, plans, qhp, qhp-enrollees, qualified-health-plan-enrollment, susidy

Tables

Covered California Subsidized Qualified Health Plans (QHPs) Enrollees By Federal Poverty Level (FPL)

@usgov.ca_gov_covered_california_subsidized_qualified_health__0b9222b3.covered_california_subsidized_qualified_health_plans_q_193f7ef0

5.73 kB
190 rows
4 columns

CREATE TABLE covered_california_subsidized_qualified_health_plans_q_193f7ef0 (
  "year" BIGINT,
  "quarter_reporting" VARCHAR,
  "federal_poverty_level_fpl_range" VARCHAR  -- Federal Poverty Level (FPL) Range,
  "n__number_of_eligible_individuals_who_selected_plan" BIGINT  -- Number Of Eligible Individuals Who Selected Plan
);