# States K2 Rate filing book: vw_rate_filing_yoy_drivers_v1

`medicare_semantic.vw_rate_filing_yoy_drivers_v1` · Insurer negotiated rates · status partial · 11,187 rows

Marketplace 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.** 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. 11,187 rows (Athena, 2026-10-29).

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_rate_filing_yoy_drivers_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_rate_filing_yoy_drivers_v1")` first.