Insurer negotiated rates

States K2 Rate filing book: vw_rate_filing_market_v1

medicare_semantic.vw_rate_filing_market_v1·partial·semantic_view

Rows

12,967

Columns

100

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. 212,967 rows (Athena, 2026-10-29).

Columns (100)

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

describe_data_source(source_fqn="medicare_semantic.vw_rate_filing_market_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_rate_filing_market_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_market_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_rate_filing_market_v1
Company names	`issuer_name` 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_market_v1.md · every page in one file: /llms-full.txt