Insurer negotiated rates

States K2 Rate filing book: vw_rate_filing_yoy_drivers_v1

medicare_semantic.vw_rate_filing_yoy_drivers_v1·partial·semantic_view

Rows

11,187

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Marketplace product K2 (Rate filing book) of the States lane: the ACA rate filing book: every filing in the CMS Unified Rate Review PUF, by issuer x state x market, with the build-up and the year-over-year drivers. vw_rate_review_puf_current_v1 is the PUF's current bytes per plan year (filter plan_year and worksheet). vw_rate_filing_market_v1 is one row per filing with its build-up; vw_rate_filing_yoy_drivers_v1 sets each issuer x state x market against its prior year with the parent. schema_era changes column meaning (G54 in 2016); -9.99 is a placeholder, not a value (docs/context_library/commercial/rate_review_puf.md).

Grain

Key	Grain
N/A	1The ACA rate filing book: every filing in the CMS Unified Rate Review PUF, by issuer x state x market, with the build-up and the year-over-year drivers. 211,187 rows (Athena, 2026-10-29).

Columns (57)

Column	Type	Meaning
`plan_year`	int
`hios_issuer_id`	string
`issuer_name`	string
`state_code`	string
`market`	string
`schema_era`	varchar(24)
`has_prior_year`	boolean
`era_boundary`	boolean
`parent_id_as_now`	string
`parent_name_as_now`	string
`parent_resolution_status`	string
`filing_id`	string
`prior_filing_id`	string
`rate_change_first_filed`	double
`rate_change_last_filed`	double
`revision_during_review`	double
`prior_rate_change_last_filed`	double
`projected_member_months`	double
`prior_projected_member_months`	double
`projected_member_months_growth`	double
`current_enrollment`	double
`experience_allowed_claims_pmpm`	double
`prior_experience_allowed_claims_pmpm`	double
`experience_allowed_claims_growth`	double
`experience_loss_ratio`	double
`prior_experience_loss_ratio`	double
`applied_credibility`	double
`prior_applied_credibility`	double
`projected_index_rate_pmpm`	double
`prior_projected_index_rate_pmpm`	double
`projected_index_rate_growth`	double
`projection_over_experience`	double
`morbidity_adjustment`	double
`demographic_shift`	double
`plan_design_change`	double
`other_adjustment`	double
`yr1_trend_cost_inpatient`	double
`yr1_trend_cost_outpatient`	double
`yr1_trend_cost_professional`	double
`yr1_trend_cost_rx`	double
`yr1_trend_util_inpatient`	double
`yr1_trend_util_rx`	double
`projected_risk_adjustment_pmpm`	double
`projected_risk_adjustment_pmpm_change`	double
`projected_reinsurance_pmpm`	double
`projected_reinsurance_pmpm_change`	double
`exchange_user_fee_pct`	double
`exchange_user_fee_change`	double
`market_adjusted_index_rate_pmpm`	double
`market_adjusted_index_rate_growth`	double
`admin_load_pct_2014_2019`	double
`profit_risk_load_pct_2014_2019`	double
`taxes_fees_pct_2014_2019`	double
`projected_risk_adjustment_pmpm_2014_2019`	double
`projected_reinsurance_pmpm_2014_2019`	double
`artifact_id`	string
`asserted_at`	date

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_semantic.vw_rate_filing_yoy_drivers_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_rate_filing_yoy_drivers_v1
Company names	`issuer_name` `parent_name_as_now` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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