# PBP optional supplemental premium and MOOP (cleaned view)

`medicare_semantic.vw_pbp_optional_supplemental` · Medicare Advantage, Part D, Medicaid · status live · 40,968 rows

Premium and MOOP of each optional supplemental package per plan and plan year from PBP section D-OPT, 2018 on.

**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 | double |  |
| report_year | double |  |
| quarter | double |  |
| optional_package_identifier | string |  |
| package_name | string |  |
| monthly_premium | double |  |
| covered_benefit_codes | string |  |
| offers_dental | boolean |  |
| offers_vision | boolean |  |
| offers_hearing | boolean |  |
| offers_point_of_service | boolean |  |
| covered_categories | string |  |
| package_max_benefit_amount | double |  |
| package_max_period_label | string |  |
| package_deductible_amount | double |  |
| package_applies_to_moop | boolean |  |
| offered_status | varchar(29) |  |
| source_pbp_section | varchar(5) |  |
| source_silver_table | varchar(33) |  |
| source_url | string |  |
| sha256_content_hash | string |  |

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