# States K2 Rate filing book: vw_rate_filing_market_v1

`medicare_semantic.vw_rate_filing_market_v1` · Insurer negotiated rates · status partial · 12,967 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. 12,967 rows (Athena, 2026-10-29).

| column | type | meaning |
|---|---|---|
| schema_era | varchar(24) |  |
| plan_year | int |  |
| filing_id | string |  |
| hios_issuer_id | string |  |
| issuer_name | string |  |
| state_code | string |  |
| market | string |  |
| effective_date | date |  |
| filing_cycle | string |  |
| filing_status | string |  |
| status_date_raw | string |  |
| serff_tracking_number | string |  |
| experience_begin_raw | string |  |
| experience_end_raw | string |  |
| experience_member_months | double |  |
| experience_premium_pmpm | double |  |
| experience_allowed_claims_pmpm | double |  |
| experience_incurred_claims_pmpm | double |  |
| experience_index_rate_pmpm | double |  |
| applied_credibility | double |  |
| projected_index_rate_pmpm | double |  |
| projected_member_months | double |  |
| yr1_trend_cost_inpatient | double |  |
| yr1_trend_util_inpatient | double |  |
| yr1_trend_cost_outpatient | double |  |
| yr1_trend_util_outpatient | double |  |
| yr1_trend_cost_professional | double |  |
| yr1_trend_util_professional | double |  |
| yr1_trend_cost_other_medical | double |  |
| yr1_trend_util_other_medical | double |  |
| yr1_trend_cost_capitation | double |  |
| yr1_trend_util_capitation | double |  |
| yr1_trend_cost_rx | double |  |
| yr1_trend_util_rx | double |  |
| yr2_trend_cost_inpatient | double |  |
| yr2_trend_util_inpatient | double |  |
| yr2_trend_cost_outpatient | double |  |
| yr2_trend_util_outpatient | double |  |
| yr2_trend_cost_professional | double |  |
| yr2_trend_util_professional | double |  |
| yr2_trend_cost_other_medical | double |  |
| yr2_trend_util_other_medical | double |  |
| yr2_trend_cost_capitation | double |  |
| yr2_trend_util_capitation | double |  |
| yr2_trend_cost_rx | double |  |
| yr2_trend_util_rx | double |  |
| trended_ehb_allowed_pmpm | double |  |
| morbidity_adjustment | double |  |
| demographic_shift | double |  |
| plan_design_change | double |  |
| other_adjustment | double |  |
| adjusted_trended_ehb_allowed_pmpm | double |  |
| manual_ehb_allowed_pmpm | double |  |
| projected_reinsurance_pmpm | double |  |
| projected_risk_adjustment_pmpm | double |  |
| exchange_user_fee_pct | double |  |
| market_adjusted_index_rate_pmpm | double |  |
| trend_cost_inpatient_2014_2019 | double |  |
| trend_util_inpatient_2014_2019 | double |  |
| morbidity_inpatient_2014_2019 | double |  |
| trend_cost_outpatient_2014_2019 | double |  |
| trend_util_outpatient_2014_2019 | double |  |
| morbidity_outpatient_2014_2019 | double |  |
| trend_cost_professional_2014_2019 | double |  |
| trend_util_professional_2014_2019 | double |  |
| morbidity_professional_2014_2019 | double |  |
| trend_cost_other_medical_2014_2019 | double |  |
| trend_util_other_medical_2014_2019 | double |  |
| morbidity_other_medical_2014_2019 | double |  |
| trend_cost_capitation_2014_2019 | double |  |
| trend_util_capitation_2014_2019 | double |  |
| morbidity_capitation_2014_2019 | double |  |
| trend_cost_rx_2014_2019 | double |  |
| trend_util_rx_2014_2019 | double |  |
| morbidity_rx_2014_2019 | double |  |
| paid_to_allowed_2014_2019 | double |  |
| projected_risk_adjustment_pmpm_2014_2019 | double |  |
| projected_reinsurance_pmpm_2014_2019 | double |  |
| admin_load_pct_2014_2019 | double |  |
| profit_risk_load_pct_2014_2019 | double |  |
| taxes_fees_pct_2014_2019 | double |  |
| single_risk_pool_gross_premium_pmpm_2014_2019 | double |  |
| plan_rows | bigint |  |
| plans_rate_change_placeholder | bigint |  |
| plans_with_projected_months | bigint |  |
| plan_projected_member_months | double |  |
| current_enrollment | double |  |
| current_enrollment_on_exchange | double |  |
| rate_change_last_filed | double |  |
| rate_change_first_filed | double |  |
| plan_rate_change_min | double |  |
| plan_rate_change_max | double |  |
| plans_with_determination | bigint |  |
| plans_found_unreasonable | bigint |  |
| artifact_id | string |  |
| sha256_content_hash | string |  |
| source_url | string |  |
| archive_member | string |  |
| source_row_number | bigint |  |
| asserted_at | date |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_rate_filing_market_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_rate_filing_market_v1")` first.