Insurer negotiated rates

Covered California enrollment profiles — state publisher history

ca_covered_california_enrollment_profiles·partial·silver

Rows

13,941

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Covered California Open Enrollment, active paid/effective member, Medi-Cal transitioner and special-enrollment profile history with issuer, plan, geography, subsidy and demographic detail.

Grain

Key	Grain
N/A	1One source-native observation within one immutable Covered California workbook, profile family, publisher period, sheet and source cell or row.

Columns (0)

Columns are not in the catalog for this source; describe_data_source("ca_covered_california_enrollment_profiles") reads them live.

Query it

describe_data_source(source_fqn="ca_covered_california_enrollment_profiles")     # the card, live
query_substrate(sql="SELECT * FROM ca_covered_california_enrollment_profiles WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,source_artifact_sha256,profile_family,publisher_period,sheet_name,source_cell_or_row`
Join	`how_to_join(source_fqn="ca_covered_california_enrollment_profiles")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_state_enrollment_observation_v1 WHERE source_id = 'ca_covered_california_enrollment_profiles' (registered 2026-09-25 under w4 vlada_w4_hix_state_enrollment_observation, door RAW). The physical history (medicare_silver.fact_hix_state_artifact_revision_history, source_observation_history, reviewed_current_pointer_history) stays uncatalogued by design; the view is the door.

This page as markdown: /docs-md/data/ca_covered_california_enrollment_profiles.md · every page in one file: /llms-full.txt