# Vlada benefit reading, the simple average across plans (edition v20261018b): each plan segment counted once per cell

`medicare_semantic.vw_benefit_reading_simple` · Medicare Advantage, Part D, Medicaid · status live · 2,115,880 rows

The simple lens beside the member-weighted cells: value = m__ps / m__pn, each plan segment counted once in the cell (national once, state once per state, county once per county), 'plans with reported members'. A segment's filed value is the same in every county it serves (rail R-simple). Pointer -> medicare_semantic.benefit_reading_simple_v20261018b. Owner: the Benefits lane.

**Grain.** The cells' keys (base_year x lvl x state x county_ssa x bucket x plan_type x parent x per).

| column | type | meaning |
|---|---|---|
| base_year | int |  |
| value_year | int |  |
| lvl | varchar(8) |  |
| state | string |  |
| county_ssa | string |  |
| county_name | string |  |
| bucket | string |  |
| plan_type | string |  |
| parent | string |  |
| per | varchar(1) |  |
| plans | bigint |  |
| dental_pct_offered__ps | double |  |
| dental_pct_offered__pn | bigint |  |
| dental_pct_max__ps | double |  |
| dental_pct_max__pn | bigint |  |
| dental_pct_no_max__ps | double |  |
| dental_pct_no_max__pn | bigint |  |
| dental_pct_card__ps | double |  |
| dental_pct_card__pn | bigint |  |
| dental_dollars_pmpm_if__ps | double |  |
| dental_dollars_pmpm_if__pn | bigint |  |
| dental_dollars_pmpm_all__ps | double |  |
| dental_dollars_pmpm_all__pn | bigint |  |
| dental_design_known__ps | double |  |
| dental_design_known__pn | bigint |  |
| hearing_pct_offered__ps | double |  |
| hearing_pct_offered__pn | bigint |  |
| hearing_pct_allowance__ps | double |  |
| hearing_pct_allowance__pn | bigint |  |
| hearing_pct_copay__ps | double |  |
| hearing_pct_copay__pn | bigint |  |
| hearing_pct_card__ps | double |  |
| hearing_pct_card__pn | bigint |  |
| hearing_dollars_pmpm_if__ps | double |  |
| hearing_dollars_pmpm_if__pn | bigint |  |
| hearing_dollars_pmpm_all__ps | double |  |
| hearing_dollars_pmpm_all__pn | bigint |  |
| hearing_design_known__ps | double |  |
| hearing_design_known__pn | bigint |  |
| otc_pct_offered__ps | double |  |
| otc_pct_offered__pn | bigint |  |
| otc_pct_own__ps | double |  |
| otc_pct_own__pn | bigint |  |
| otc_pct_card__ps | double |  |
| otc_pct_card__pn | bigint |  |
| otc_pct_no_amount__ps | double |  |
| otc_pct_no_amount__pn | bigint |  |
| otc_dollars_pmpm_if__ps | double |  |
| otc_dollars_pmpm_if__pn | bigint |  |
| otc_dollars_pmpm_all__ps | double |  |
| otc_dollars_pmpm_all__pn | bigint |  |
| otc_design_known__ps | double |  |
| otc_design_known__pn | bigint |  |
| eyewear_pct_offered__ps | double |  |
| eyewear_pct_offered__pn | bigint |  |
| eyewear_pct_allowance__ps | double |  |
| eyewear_pct_allowance__pn | bigint |  |
| eyewear_pct_card__ps | double |  |
| eyewear_pct_card__pn | bigint |  |
| eyewear_pct_no_max__ps | double |  |
| eyewear_pct_no_max__pn | bigint |  |
| eyewear_dollars_pmpm_if__ps | double |  |
| eyewear_dollars_pmpm_if__pn | bigint |  |
| eyewear_dollars_pmpm_all__ps | double |  |
| eyewear_dollars_pmpm_all__pn | bigint |  |
| eyewear_design_known__ps | double |  |
| eyewear_design_known__pn | bigint |  |
| hearing_copay_per_aid__ps | double |  |
| hearing_copay_per_aid__pn | bigint |  |
| otc_pct_filed_own_zero_card__ps | double |  |
| otc_pct_filed_own_zero_card__pn | bigint |  |
| card_pct_offered__ps | double |  |
| card_pct_offered__pn | bigint |  |
| card_dollars_pmpm_if__ps | double |  |
| card_dollars_pmpm_if__pn | bigint |  |
| card_dollars_pmpm_all__ps | double |  |
| card_dollars_pmpm_all__pn | bigint |  |
| allowance_total_pmpm_all__ps | double |  |
| allowance_total_pmpm_all__pn | bigint |  |
| allowance_total_coverage__ps | double |  |
| allowance_total_coverage__pn | bigint |  |
| giveback_pct_offered__ps | double |  |
| giveback_pct_offered__pn | bigint |  |
| giveback_pct_token__ps | double |  |
| giveback_pct_token__pn | bigint |  |
| giveback_pmpm_if__ps | double |  |
| giveback_pmpm_if__pn | bigint |  |
| premium_pct_zero__ps | double |  |
| premium_pct_zero__pn | bigint |  |
| svc_transportation_pct_offered__ps | double |  |
| svc_transportation_pct_offered__pn | bigint |  |
| svc_transportation_known__ps | double |  |
| svc_transportation_known__pn | bigint |  |
| svc_fitness_pct_offered__ps | double |  |
| svc_fitness_pct_offered__pn | bigint |  |
| svc_fitness_known__ps | double |  |
| svc_fitness_known__pn | bigint |  |
| svc_meals_post_discharge_pct_offered__ps | double |  |
| svc_meals_post_discharge_pct_offered__pn | bigint |  |
| svc_meals_post_discharge_known__ps | double |  |
| svc_meals_post_discharge_known__pn | bigint |  |
| svc_meals_any_pct_offered__ps | double |  |
| svc_meals_any_pct_offered__pn | bigint |  |
| svc_meals_any_known__ps | double |  |
| svc_meals_any_known__pn | bigint |  |
| svc_podiatry_pct_offered__ps | double |  |
| svc_podiatry_pct_offered__pn | bigint |  |
| svc_podiatry_known__ps | double |  |
| svc_podiatry_known__pn | bigint |  |
| svc_transportation_trips__ps | double |  |
| svc_transportation_trips__pn | bigint |  |
| svc_transportation_pct_unlimited__ps | double |  |
| svc_transportation_pct_unlimited__pn | bigint |  |
| svc_podiatry_visits__ps | double |  |
| svc_podiatry_visits__pn | bigint |  |
| deductible_pct_none__ps | double |  |
| deductible_pct_none__pn | bigint |  |
| deductible_pct_partb__ps | double |  |
| deductible_pct_partb__pn | bigint |  |
| deductible_pct_plan__ps | double |  |
| deductible_pct_plan__pn | bigint |  |
| deductible_plan_amount__ps | double |  |
| deductible_plan_amount__pn | bigint |  |
| deductible_design_known__ps | double |  |
| deductible_design_known__pn | bigint |  |
| deductible_pct_scope_oon__ps | double |  |
| deductible_pct_scope_oon__pn | bigint |  |
| premium__ps | double |  |
| premium__pn | bigint |  |
| premium_coverage__ps | double |  |
| premium_coverage__pn | bigint |  |
| moop__ps | double |  |
| moop__pn | bigint |  |
| moop_coverage__ps | double |  |
| moop_coverage__pn | bigint |  |
| medical_deductible__ps | double |  |
| medical_deductible__pn | bigint |  |
| medical_deductible_coverage__ps | double |  |
| medical_deductible_coverage__pn | bigint |  |
| partd_deductible__ps | double |  |
| partd_deductible__pn | bigint |  |
| partd_deductible_coverage__ps | double |  |
| partd_deductible_coverage__pn | bigint |  |
| primary_care__ps | double |  |
| primary_care__pn | bigint |  |
| primary_care_coverage__ps | double |  |
| primary_care_coverage__pn | bigint |  |
| specialist__ps | double |  |
| specialist__pn | bigint |  |
| specialist_coverage__ps | double |  |
| specialist_coverage__pn | bigint |  |
| telehealth__ps | double |  |
| telehealth__pn | bigint |  |
| telehealth_coverage__ps | double |  |
| telehealth_coverage__pn | bigint |  |
| mental_health_ind__ps | double |  |
| mental_health_ind__pn | bigint |  |
| mental_health_ind_coverage__ps | double |  |
| mental_health_ind_coverage__pn | bigint |  |
| er__ps | double |  |
| er__pn | bigint |  |
| er_coverage__ps | double |  |
| er_coverage__pn | bigint |  |
| urgent__ps | double |  |
| urgent__pn | bigint |  |
| urgent_coverage__ps | double |  |
| urgent_coverage__pn | bigint |  |
| ambulance_ground__ps | double |  |
| ambulance_ground__pn | bigint |  |
| ambulance_ground_coverage__ps | double |  |
| ambulance_ground_coverage__pn | bigint |  |
| hosp_5day__ps | double |  |
| hosp_5day__pn | bigint |  |
| hosp_5day_coverage__ps | double |  |
| hosp_5day_coverage__pn | bigint |  |
| inpatient__ps | double |  |
| inpatient__pn | bigint |  |
| inpatient_coverage__ps | double |  |
| inpatient_coverage__pn | bigint |  |
| snf__ps | double |  |
| snf__pn | bigint |  |
| snf_coverage__ps | double |  |
| snf_coverage__pn | bigint |  |
| outpatient_hosp__ps | double |  |
| outpatient_hosp__pn | bigint |  |
| outpatient_hosp_coverage__ps | double |  |
| outpatient_hosp_coverage__pn | bigint |  |
| asc__ps | double |  |
| asc__pn | bigint |  |
| asc_coverage__ps | double |  |
| asc_coverage__pn | bigint |  |
| imaging_complex__ps | double |  |
| imaging_complex__pn | bigint |  |
| imaging_complex_coverage__ps | double |  |
| imaging_complex_coverage__pn | bigint |  |
| radiology__ps | double |  |
| radiology__pn | bigint |  |
| radiology_coverage__ps | double |  |
| radiology_coverage__pn | bigint |  |
| lab__ps | double |  |
| lab__pn | bigint |  |
| lab_coverage__ps | double |  |
| lab_coverage__pn | bigint |  |
| physical_therapy__ps | double |  |
| physical_therapy__pn | bigint |  |
| physical_therapy_coverage__ps | double |  |
| physical_therapy_coverage__pn | bigint |  |
| dme__ps | double |  |
| dme__pn | bigint |  |
| dme_coverage__ps | double |  |
| dme_coverage__pn | bigint |  |
| partb_drugs__ps | double |  |
| partb_drugs__pn | bigint |  |
| partb_drugs_coverage__ps | double |  |
| partb_drugs_coverage__pn | bigint |  |
| partb_insulin__ps | double |  |
| partb_insulin__pn | bigint |  |
| partb_insulin_coverage__ps | double |  |
| partb_insulin_coverage__pn | bigint |  |
| dialysis__ps | double |  |
| dialysis__pn | bigint |  |
| dialysis_coverage__ps | double |  |
| dialysis_coverage__pn | bigint |  |
| partd_tier1_copay__ps | double |  |
| partd_tier1_copay__pn | bigint |  |
| partd_tier1_copay_coverage__ps | double |  |
| partd_tier1_copay_coverage__pn | bigint |  |
| partd_tier2_copay__ps | double |  |
| partd_tier2_copay__pn | bigint |  |
| partd_tier2_copay_coverage__ps | double |  |
| partd_tier2_copay_coverage__pn | bigint |  |
| partd_tier4_coins__ps | double |  |
| partd_tier4_coins__pn | bigint |  |
| partd_tier4_coins_coverage__ps | double |  |
| partd_tier4_coins_coverage__pn | bigint |  |
| partd_tier5_coins__ps | double |  |
| partd_tier5_coins__pn | bigint |  |
| partd_tier5_coins_coverage__ps | double |  |
| partd_tier5_coins_coverage__pn | bigint |  |
| primary_care_pct_copay__ps | double |  |
| primary_care_pct_copay__pn | bigint |  |
| primary_care_pct_coins__ps | double |  |
| primary_care_pct_coins__pn | bigint |  |
| primary_care_coins__ps | double |  |
| primary_care_coins__pn | bigint |  |
| specialist_pct_copay__ps | double |  |
| specialist_pct_copay__pn | bigint |  |
| specialist_pct_coins__ps | double |  |
| specialist_pct_coins__pn | bigint |  |
| specialist_coins__ps | double |  |
| specialist_coins__pn | bigint |  |
| telehealth_pct_copay__ps | double |  |
| telehealth_pct_copay__pn | bigint |  |
| telehealth_pct_coins__ps | double |  |
| telehealth_pct_coins__pn | bigint |  |
| telehealth_coins__ps | double |  |
| telehealth_coins__pn | bigint |  |
| mental_health_ind_pct_copay__ps | double |  |
| mental_health_ind_pct_copay__pn | bigint |  |
| mental_health_ind_pct_coins__ps | double |  |
| mental_health_ind_pct_coins__pn | bigint |  |
| mental_health_ind_coins__ps | double |  |
| mental_health_ind_coins__pn | bigint |  |
| physical_therapy_pct_copay__ps | double |  |
| physical_therapy_pct_copay__pn | bigint |  |
| physical_therapy_pct_coins__ps | double |  |
| physical_therapy_pct_coins__pn | bigint |  |
| physical_therapy_coins__ps | double |  |
| physical_therapy_coins__pn | bigint |  |
| er_pct_copay__ps | double |  |
| er_pct_copay__pn | bigint |  |
| er_pct_coins__ps | double |  |
| er_pct_coins__pn | bigint |  |
| er_coins__ps | double |  |
| er_coins__pn | bigint |  |
| urgent_pct_copay__ps | double |  |
| urgent_pct_copay__pn | bigint |  |
| urgent_pct_coins__ps | double |  |
| urgent_pct_coins__pn | bigint |  |
| urgent_coins__ps | double |  |
| urgent_coins__pn | bigint |  |
| ambulance_ground_pct_copay__ps | double |  |
| ambulance_ground_pct_copay__pn | bigint |  |
| ambulance_ground_pct_coins__ps | double |  |
| ambulance_ground_pct_coins__pn | bigint |  |
| ambulance_ground_coins__ps | double |  |
| ambulance_ground_coins__pn | bigint |  |
| outpatient_hosp_pct_copay__ps | double |  |
| outpatient_hosp_pct_copay__pn | bigint |  |
| outpatient_hosp_pct_coins__ps | double |  |
| outpatient_hosp_pct_coins__pn | bigint |  |
| outpatient_hosp_coins__ps | double |  |
| outpatient_hosp_coins__pn | bigint |  |
| imaging_complex_pct_copay__ps | double |  |
| imaging_complex_pct_copay__pn | bigint |  |
| imaging_complex_pct_coins__ps | double |  |
| imaging_complex_pct_coins__pn | bigint |  |
| imaging_complex_coins__ps | double |  |
| imaging_complex_coins__pn | bigint |  |
| radiology_pct_copay__ps | double |  |
| radiology_pct_copay__pn | bigint |  |
| radiology_pct_coins__ps | double |  |
| radiology_pct_coins__pn | bigint |  |
| radiology_coins__ps | double |  |
| radiology_coins__pn | bigint |  |
| lab_pct_copay__ps | double |  |
| lab_pct_copay__pn | bigint |  |
| lab_pct_coins__ps | double |  |
| lab_pct_coins__pn | bigint |  |
| lab_coins__ps | double |  |
| lab_coins__pn | bigint |  |
| inpatient_pct_copay__ps | double |  |
| inpatient_pct_copay__pn | bigint |  |
| inpatient_pct_coins__ps | double |  |
| inpatient_pct_coins__pn | bigint |  |
| inpatient_coins__ps | double |  |
| inpatient_coins__pn | bigint |  |
| snf_pct_copay__ps | double |  |
| snf_pct_copay__pn | bigint |  |
| snf_pct_coins__ps | double |  |
| snf_pct_coins__pn | bigint |  |
| snf_coins__ps | double |  |
| snf_coins__pn | bigint |  |
| otc_pct_one_pot__ps | double |  |
| otc_pct_one_pot__pn | bigint |  |
| card_pct_dvh_same_pot__ps | double |  |
| card_pct_dvh_same_pot__pn | bigint |  |
| dental_any_pct_offered__ps | double |  |
| dental_any_pct_offered__pn | bigint |  |
| dental_comprehensive_pct_offered__ps | double |  |
| dental_comprehensive_pct_offered__pn | bigint |  |
| svc_transportation_pct_optional_only__ps | double |  |
| svc_transportation_pct_optional_only__pn | bigint |  |
| svc_fitness_pct_optional_only__ps | double |  |
| svc_fitness_pct_optional_only__pn | bigint |  |
| svc_meals_post_discharge_pct_optional_only__ps | double |  |
| svc_meals_post_discharge_pct_optional_only__pn | bigint |  |
| svc_meals_any_pct_optional_only__ps | double |  |
| svc_meals_any_pct_optional_only__pn | bigint |  |
| svc_podiatry_pct_optional_only__ps | double |  |
| svc_podiatry_pct_optional_only__pn | bigint |  |
| allowance_total_pct_no_cap__ps | double |  |
| allowance_total_pct_no_cap__pn | bigint |  |
| otc_pct_d5_pot__ps | double |  |
| otc_pct_d5_pot__pn | bigint |  |
| card_pct_dvh_shared_pot__ps | double |  |
| card_pct_dvh_shared_pot__pn | bigint |  |
| allowance_shared_pot_overlap_pmpm__ps | double |  |
| allowance_shared_pot_overlap_pmpm__pn | bigint |  |
| card_targeted_pct_offered__ps | double |  |
| card_targeted_pct_offered__pn | bigint |  |
| card_targeted_dollars_pmpm_if__ps | double |  |
| card_targeted_dollars_pmpm_if__pn | bigint |  |
| svc_transportation_round_trips__ps | double |  |
| svc_transportation_round_trips__pn | bigint |  |
| moop_pct_not_in_network__ps | double |  |
| moop_pct_not_in_network__pn | bigint |  |
| card_targeted_pct_ssbci__ps | double |  |
| card_targeted_pct_ssbci__pn | bigint |  |
| card_targeted_pct_vbid_uf__ps | double |  |
| card_targeted_pct_vbid_uf__pn | bigint |  |
| card_targeted_pct_no_amount__ps | double |  |
| card_targeted_pct_no_amount__pn | bigint |  |
| card_targeted_pct_pooled_in_card__ps | double |  |
| card_targeted_pct_pooled_in_card__pn | bigint |  |
| card_pct_dvh_kind_only__ps | double |  |
| card_pct_dvh_kind_only__pn | bigint |  |
| allowance_pooled_pct_any__ps | double |  |
| allowance_pooled_pct_any__pn | bigint |  |
| eyewear_pct_preferred_tier__ps | double |  |
| eyewear_pct_preferred_tier__pn | bigint |  |
| eyewear_preferred_dollars_pmpm_if__ps | double |  |
| eyewear_preferred_dollars_pmpm_if__pn | bigint |  |
| dental_pct_d9_added__ps | double |  |
| dental_pct_d9_added__pn | bigint |  |
| dental_pct_max_combined__ps | double |  |
| dental_pct_max_combined__pn | bigint |  |
| card_pays_dental__ps | double |  |
| card_pays_dental__pn | bigint |  |
| card_pays_eyewear__ps | double |  |
| card_pays_eyewear__pn | bigint |  |
| card_pays_hearing__ps | double |  |
| card_pays_hearing__pn | bigint |  |
| card_pays_otc__ps | double |  |
| card_pays_otc__pn | bigint |  |
| card_pays_food_living__ps | double |  |
| card_pays_food_living__pn | bigint |  |
| card_pays_other__ps | double |  |
| card_pays_other__pn | bigint |  |
| card_pct_kind_flex__ps | double |  |
| card_pct_kind_flex__pn | bigint |  |
| card_pct_kind_dvh__ps | double |  |
| card_pct_kind_dvh__pn | bigint |  |
| card_pct_kind_otc__ps | double |  |
| card_pct_kind_otc__pn | bigint |  |
| card_pct_kind_food_living__ps | double |  |
| card_pct_kind_food_living__pn | bigint |  |
| card_pct_kind_wellness__ps | double |  |
| card_pct_kind_wellness__pn | bigint |  |
| dental_pct_cap_plus_card__ps | double |  |
| dental_pct_cap_plus_card__pn | bigint |  |
| hearing_pct_cap_plus_card__ps | double |  |
| hearing_pct_cap_plus_card__pn | bigint |  |
| otc_pct_cap_plus_card__ps | double |  |
| otc_pct_cap_plus_card__pn | bigint |  |
| eyewear_pct_cap_plus_card__ps | double |  |
| eyewear_pct_cap_plus_card__pn | bigint |  |
| primary_care_pct_zero__ps | double |  |
| primary_care_pct_zero__pn | bigint |  |
| specialist_pct_zero__ps | double |  |
| specialist_pct_zero__pn | bigint |  |
| telehealth_pct_zero__ps | double |  |
| telehealth_pct_zero__pn | bigint |  |
| mental_health_ind_pct_zero__ps | double |  |
| mental_health_ind_pct_zero__pn | bigint |  |
| physical_therapy_pct_zero__ps | double |  |
| physical_therapy_pct_zero__pn | bigint |  |
| er_pct_zero__ps | double |  |
| er_pct_zero__pn | bigint |  |
| urgent_pct_zero__ps | double |  |
| urgent_pct_zero__pn | bigint |  |
| ambulance_ground_pct_zero__ps | double |  |
| ambulance_ground_pct_zero__pn | bigint |  |
| outpatient_hosp_pct_zero__ps | double |  |
| outpatient_hosp_pct_zero__pn | bigint |  |
| imaging_complex_pct_zero__ps | double |  |
| imaging_complex_pct_zero__pn | bigint |  |
| radiology_pct_zero__ps | double |  |
| radiology_pct_zero__pn | bigint |  |
| lab_pct_zero__ps | double |  |
| lab_pct_zero__pn | bigint |  |
| inpatient_pct_zero__ps | double |  |
| inpatient_pct_zero__pn | bigint |  |
| snf_pct_zero__ps | double |  |
| snf_pct_zero__pn | bigint |  |
| dsnp_enrolls_full_duals__ps | double |  |
| dsnp_enrolls_full_duals__pn | bigint |  |
| primary_care_dual_effective__ps | double |  |
| primary_care_dual_effective__pn | bigint |  |
| specialist_dual_effective__ps | double |  |
| specialist_dual_effective__pn | bigint |  |
| telehealth_dual_effective__ps | double |  |
| telehealth_dual_effective__pn | bigint |  |
| mental_health_ind_dual_effective__ps | double |  |
| mental_health_ind_dual_effective__pn | bigint |  |
| physical_therapy_dual_effective__ps | double |  |
| physical_therapy_dual_effective__pn | bigint |  |
| er_dual_effective__ps | double |  |
| er_dual_effective__pn | bigint |  |
| urgent_dual_effective__ps | double |  |
| urgent_dual_effective__pn | bigint |  |
| ambulance_ground_dual_effective__ps | double |  |
| ambulance_ground_dual_effective__pn | bigint |  |
| outpatient_hosp_dual_effective__ps | double |  |
| outpatient_hosp_dual_effective__pn | bigint |  |
| imaging_complex_dual_effective__ps | double |  |
| imaging_complex_dual_effective__pn | bigint |  |
| radiology_dual_effective__ps | double |  |
| radiology_dual_effective__pn | bigint |  |
| lab_dual_effective__ps | double |  |
| lab_dual_effective__pn | bigint |  |
| inpatient_dual_effective__ps | double |  |
| inpatient_dual_effective__pn | bigint |  |
| snf_dual_effective__ps | double |  |
| snf_dual_effective__pn | bigint |  |
| moop_dual_effective__ps | double |  |
| moop_dual_effective__pn | bigint |  |
| medical_deductible_dual_effective__ps | double |  |
| medical_deductible_dual_effective__pn | bigint |  |
| telehealth_pct_offered__ps | double |  |
| telehealth_pct_offered__pn | bigint |  |
| primary_care_ll_known__ps | double |  |
| primary_care_ll_known__pn | bigint |  |
| primary_care_llc_from__ps | double |  |
| primary_care_llc_from__pn | bigint |  |
| primary_care_llc_to__ps | double |  |
| primary_care_llc_to__pn | bigint |  |
| primary_care_lli_from__ps | double |  |
| primary_care_lli_from__pn | bigint |  |
| primary_care_lli_to__ps | double |  |
| primary_care_lli_to__pn | bigint |  |
| primary_care_sw_coins__ps | double |  |
| primary_care_sw_coins__pn | bigint |  |
| primary_care_sw_copay__ps | double |  |
| primary_care_sw_copay__pn | bigint |  |
| specialist_ll_known__ps | double |  |
| specialist_ll_known__pn | bigint |  |
| specialist_llc_from__ps | double |  |
| specialist_llc_from__pn | bigint |  |
| specialist_llc_to__ps | double |  |
| specialist_llc_to__pn | bigint |  |
| specialist_lli_from__ps | double |  |
| specialist_lli_from__pn | bigint |  |
| specialist_lli_to__ps | double |  |
| specialist_lli_to__pn | bigint |  |
| specialist_sw_coins__ps | double |  |
| specialist_sw_coins__pn | bigint |  |
| specialist_sw_copay__ps | double |  |
| specialist_sw_copay__pn | bigint |  |
| telehealth_ll_known__ps | double |  |
| telehealth_ll_known__pn | bigint |  |
| telehealth_llc_from__ps | double |  |
| telehealth_llc_from__pn | bigint |  |
| telehealth_llc_to__ps | double |  |
| telehealth_llc_to__pn | bigint |  |
| telehealth_lli_from__ps | double |  |
| telehealth_lli_from__pn | bigint |  |
| telehealth_lli_to__ps | double |  |
| telehealth_lli_to__pn | bigint |  |
| telehealth_sw_coins__ps | double |  |
| telehealth_sw_coins__pn | bigint |  |
| telehealth_sw_copay__ps | double |  |
| telehealth_sw_copay__pn | bigint |  |
| mental_health_ind_ll_known__ps | double |  |
| mental_health_ind_ll_known__pn | bigint |  |
| mental_health_ind_llc_from__ps | double |  |
| mental_health_ind_llc_from__pn | bigint |  |
| mental_health_ind_llc_to__ps | double |  |
| mental_health_ind_llc_to__pn | bigint |  |
| mental_health_ind_lli_from__ps | double |  |
| mental_health_ind_lli_from__pn | bigint |  |
| mental_health_ind_lli_to__ps | double |  |
| mental_health_ind_lli_to__pn | bigint |  |
| mental_health_ind_sw_coins__ps | double |  |
| mental_health_ind_sw_coins__pn | bigint |  |
| mental_health_ind_sw_copay__ps | double |  |
| mental_health_ind_sw_copay__pn | bigint |  |
| physical_therapy_ll_known__ps | double |  |
| physical_therapy_ll_known__pn | bigint |  |
| physical_therapy_llc_from__ps | double |  |
| physical_therapy_llc_from__pn | bigint |  |
| physical_therapy_llc_to__ps | double |  |
| physical_therapy_llc_to__pn | bigint |  |
| physical_therapy_lli_from__ps | double |  |
| physical_therapy_lli_from__pn | bigint |  |
| physical_therapy_lli_to__ps | double |  |
| physical_therapy_lli_to__pn | bigint |  |
| physical_therapy_sw_coins__ps | double |  |
| physical_therapy_sw_coins__pn | bigint |  |
| physical_therapy_sw_copay__ps | double |  |
| physical_therapy_sw_copay__pn | bigint |  |
| er_ll_known__ps | double |  |
| er_ll_known__pn | bigint |  |
| er_llc_from__ps | double |  |
| er_llc_from__pn | bigint |  |
| er_llc_to__ps | double |  |
| er_llc_to__pn | bigint |  |
| er_lli_from__ps | double |  |
| er_lli_from__pn | bigint |  |
| er_lli_to__ps | double |  |
| er_lli_to__pn | bigint |  |
| er_sw_coins__ps | double |  |
| er_sw_coins__pn | bigint |  |
| er_sw_copay__ps | double |  |
| er_sw_copay__pn | bigint |  |
| urgent_ll_known__ps | double |  |
| urgent_ll_known__pn | bigint |  |
| urgent_llc_from__ps | double |  |
| urgent_llc_from__pn | bigint |  |
| urgent_llc_to__ps | double |  |
| urgent_llc_to__pn | bigint |  |
| urgent_lli_from__ps | double |  |
| urgent_lli_from__pn | bigint |  |
| urgent_lli_to__ps | double |  |
| urgent_lli_to__pn | bigint |  |
| urgent_sw_coins__ps | double |  |
| urgent_sw_coins__pn | bigint |  |
| urgent_sw_copay__ps | double |  |
| urgent_sw_copay__pn | bigint |  |
| ambulance_ground_ll_known__ps | double |  |
| ambulance_ground_ll_known__pn | bigint |  |
| ambulance_ground_llc_from__ps | double |  |
| ambulance_ground_llc_from__pn | bigint |  |
| ambulance_ground_llc_to__ps | double |  |
| ambulance_ground_llc_to__pn | bigint |  |
| ambulance_ground_lli_from__ps | double |  |
| ambulance_ground_lli_from__pn | bigint |  |
| ambulance_ground_lli_to__ps | double |  |
| ambulance_ground_lli_to__pn | bigint |  |
| ambulance_ground_sw_coins__ps | double |  |
| ambulance_ground_sw_coins__pn | bigint |  |
| ambulance_ground_sw_copay__ps | double |  |
| ambulance_ground_sw_copay__pn | bigint |  |
| outpatient_hosp_ll_known__ps | double |  |
| outpatient_hosp_ll_known__pn | bigint |  |
| outpatient_hosp_llc_from__ps | double |  |
| outpatient_hosp_llc_from__pn | bigint |  |
| outpatient_hosp_llc_to__ps | double |  |
| outpatient_hosp_llc_to__pn | bigint |  |
| outpatient_hosp_lli_from__ps | double |  |
| outpatient_hosp_lli_from__pn | bigint |  |
| outpatient_hosp_lli_to__ps | double |  |
| outpatient_hosp_lli_to__pn | bigint |  |
| outpatient_hosp_sw_coins__ps | double |  |
| outpatient_hosp_sw_coins__pn | bigint |  |
| outpatient_hosp_sw_copay__ps | double |  |
| outpatient_hosp_sw_copay__pn | bigint |  |
| imaging_complex_ll_known__ps | double |  |
| imaging_complex_ll_known__pn | bigint |  |
| imaging_complex_llc_from__ps | double |  |
| imaging_complex_llc_from__pn | bigint |  |
| imaging_complex_llc_to__ps | double |  |
| imaging_complex_llc_to__pn | bigint |  |
| imaging_complex_lli_from__ps | double |  |
| imaging_complex_lli_from__pn | bigint |  |
| imaging_complex_lli_to__ps | double |  |
| imaging_complex_lli_to__pn | bigint |  |
| imaging_complex_sw_coins__ps | double |  |
| imaging_complex_sw_coins__pn | bigint |  |
| imaging_complex_sw_copay__ps | double |  |
| imaging_complex_sw_copay__pn | bigint |  |
| radiology_ll_known__ps | double |  |
| radiology_ll_known__pn | bigint |  |
| radiology_llc_from__ps | double |  |
| radiology_llc_from__pn | bigint |  |
| radiology_llc_to__ps | double |  |
| radiology_llc_to__pn | bigint |  |
| radiology_lli_from__ps | double |  |
| radiology_lli_from__pn | bigint |  |
| radiology_lli_to__ps | double |  |
| radiology_lli_to__pn | bigint |  |
| radiology_sw_coins__ps | double |  |
| radiology_sw_coins__pn | bigint |  |
| radiology_sw_copay__ps | double |  |
| radiology_sw_copay__pn | bigint |  |
| lab_ll_known__ps | double |  |
| lab_ll_known__pn | bigint |  |
| lab_llc_from__ps | double |  |
| lab_llc_from__pn | bigint |  |
| lab_llc_to__ps | double |  |
| lab_llc_to__pn | bigint |  |
| lab_lli_from__ps | double |  |
| lab_lli_from__pn | bigint |  |
| lab_lli_to__ps | double |  |
| lab_lli_to__pn | bigint |  |
| lab_sw_coins__ps | double |  |
| lab_sw_coins__pn | bigint |  |
| lab_sw_copay__ps | double |  |
| lab_sw_copay__pn | bigint |  |
| inpatient_ll_known__ps | double |  |
| inpatient_ll_known__pn | bigint |  |
| inpatient_llc_from__ps | double |  |
| inpatient_llc_from__pn | bigint |  |
| inpatient_llc_to__ps | double |  |
| inpatient_llc_to__pn | bigint |  |
| inpatient_lli_from__ps | double |  |
| inpatient_lli_from__pn | bigint |  |
| inpatient_lli_to__ps | double |  |
| inpatient_lli_to__pn | bigint |  |
| inpatient_sw_coins__ps | double |  |
| inpatient_sw_coins__pn | bigint |  |
| inpatient_sw_copay__ps | double |  |
| inpatient_sw_copay__pn | bigint |  |
| snf_ll_known__ps | double |  |
| snf_ll_known__pn | bigint |  |
| snf_llc_from__ps | double |  |
| snf_llc_from__pn | bigint |  |
| snf_llc_to__ps | double |  |
| snf_llc_to__pn | bigint |  |
| snf_lli_from__ps | double |  |
| snf_lli_from__pn | bigint |  |
| snf_lli_to__ps | double |  |
| snf_lli_to__pn | bigint |  |
| snf_sw_coins__ps | double |  |
| snf_sw_coins__pn | bigint |  |
| snf_sw_copay__ps | double |  |
| snf_sw_copay__pn | bigint |  |

Tools that read it: get_benefit_change

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