# Plan premium by year, from the CMS Landscape (cleaned view)

`medicare_semantic.vw_pbp_plan_premium` · Medicare Advantage, Part D, Medicaid · status live · 81,375 rows

Monthly premium per plan and year, 2007 to 2027, built from the CMS Landscape (not the PBP filing): consolidated, Part C and Part D premium, the Part B premium reduction, and monthly_premium_basis naming which Landscape leg the number came from. Evidence grade cms_published.

**Grain.** One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| version | int |  |
| report_year | int |  |
| quarter | int |  |
| benefit_category | string |  |
| cost_share_string | string |  |
| copay_amount | double |  |
| coinsurance_pct | double |  |
| limit_text | string |  |
| auth_required | boolean |  |
| referral_required | boolean |  |
| network_type | varchar(10) |  |
| max_oop_applies | boolean |  |
| limit_quantity | double |  |
| limit_unit | string |  |
| limit_period_code | string |  |
| limit_period_label | string |  |
| limit_quantity_per_year | double |  |
| benefit_amount | double |  |
| benefit_amount_kind | varchar(20) |  |
| benefit_amount_period_code | varchar(7) |  |
| benefit_amount_period_label | varchar(9) |  |
| benefit_amount_annualized | double |  |
| benefit_amount_pmpm | double |  |
| normalization_status | varchar(24) |  |
| normalization_basis | varchar(29) |  |
| aggregation_policy | varchar(41) |  |
| offered_status | varchar(15) |  |
| numeric_amount_observability | varchar(31) |  |
| null_amount_reason | varchar(30) |  |
| annualization_policy | varchar(17) |  |
| combined_limit_policy | varchar(29) |  |
| consumer_document_reconciliation_status | varchar(11) |  |
| confidence_tier | varchar(23) |  |
| consolidated_premium | double |  |
| consolidated_premium_distinct_count | bigint |  |
| consolidated_premium_raw | string |  |
| low_income_premium_subsidy_amount | double |  |
| low_income_premium_subsidy_basis | varchar(87) |  |
| low_income_premium_subsidy_region_amount_count | bigint |  |
| monthly_premium | double |  |
| monthly_premium_basis | varchar(32) |  |
| monthly_premium_full_lis | double |  |
| monthly_premium_full_lis_basis | varchar(73) |  |
| part_b_only_plan_premium | double |  |
| part_b_premium_reduction | double |  |
| part_b_premium_reduction_amount | double |  |
| part_b_premium_reduction_offered | boolean |  |
| part_c_premium | double |  |
| part_c_premium_distinct_count | bigint |  |
| part_c_premium_raw | string |  |
| part_d_basic_premium | double |  |
| part_d_lips_cms_pays | double |  |
| part_d_low_income_beneficiary_premium | double |  |
| part_d_premium | double |  |
| part_d_premium_distinct_count | bigint |  |
| part_d_premium_raw | string |  |
| part_d_supplemental_premium | double |  |
| plan_premium_present | boolean |  |
| plan_premium_sub_benefit | string |  |
| premium_amount | double |  |
| section_d_plan_premium | double |  |
| source_pbp_section | varchar(11) |  |
| source_silver_table | varchar(33) |  |
| lmi_authorities | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |

Tools that read it: get_pbp_benefit

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