Medicare Advantage, Part D, Medicaid

Vlada benefit reading, a contract against its closest contracts on their shared counties (edition v20261018b)

medicare_semantic.vw_benefit_reading_matched·live·mart

Rows

33,306

Columns

787

History

N/A

Card

nocolumns only

Typed tools

What it is

1Both sides on the counties both serve with the product and plan type, where both carry the number; side B re-weighted to side A's members in each county. value = a_<m>__s / a_<m>__w and b_<m>__s / b_<m>__w.
2Pointer -> medicare_semantic.benefit_reading_matched_v20261018b.
3Owner: the Benefits lane.

Grain

Key	Grain
N/A	1One row per base_year x bucket x plan_type x contract_id x match_contract_id (top 5) x per.

Columns (787)

Column	Type	Meaning
`base_year`	int
`value_year`	int
`bucket`	string
`plan_type`	string
`contract_id`	string
`parent_a`	string
`match_contract_id`	string
`parent_b`	string
`match_rank`	bigint
`jaccard`	double
`overlap_share_a`	double
`per`	varchar(1)
`counties`	bigint
`members_a`	double
`members_b`	double
`a_dental_pct_offered__s`	double
`a_dental_pct_offered__w`	double
`b_dental_pct_offered__s`	double
`b_dental_pct_offered__w`	double
`a_dental_pct_max__s`	double
`a_dental_pct_max__w`	double
`b_dental_pct_max__s`	double
`b_dental_pct_max__w`	double
`a_dental_pct_no_max__s`	double
`a_dental_pct_no_max__w`	double
`b_dental_pct_no_max__s`	double
`b_dental_pct_no_max__w`	double
`a_dental_pct_card__s`	double
`a_dental_pct_card__w`	double
`b_dental_pct_card__s`	double
`b_dental_pct_card__w`	double
`a_dental_design_known__s`	double
`a_dental_design_known__w`	double
`b_dental_design_known__s`	double
`b_dental_design_known__w`	double
`a_dental_dollars_pmpm_if__s`	double
`a_dental_dollars_pmpm_if__w`	double
`b_dental_dollars_pmpm_if__s`	double
`b_dental_dollars_pmpm_if__w`	double
`a_dental_dollars_pmpm_all__s`	double
`a_dental_dollars_pmpm_all__w`	double
`b_dental_dollars_pmpm_all__s`	double
`b_dental_dollars_pmpm_all__w`	double
`a_hearing_pct_offered__s`	double
`a_hearing_pct_offered__w`	double
`b_hearing_pct_offered__s`	double
`b_hearing_pct_offered__w`	double
`a_hearing_pct_allowance__s`	double
`a_hearing_pct_allowance__w`	double
`b_hearing_pct_allowance__s`	double
`b_hearing_pct_allowance__w`	double
`a_hearing_pct_copay__s`	double
`a_hearing_pct_copay__w`	double
`b_hearing_pct_copay__s`	double
`b_hearing_pct_copay__w`	double
`a_hearing_pct_card__s`	double
`a_hearing_pct_card__w`	double
`b_hearing_pct_card__s`	double
`b_hearing_pct_card__w`	double
`a_hearing_design_known__s`	double
`a_hearing_design_known__w`	double
`b_hearing_design_known__s`	double
`b_hearing_design_known__w`	double
`a_hearing_dollars_pmpm_if__s`	double
`a_hearing_dollars_pmpm_if__w`	double
`b_hearing_dollars_pmpm_if__s`	double
`b_hearing_dollars_pmpm_if__w`	double
`a_hearing_dollars_pmpm_all__s`	double
`a_hearing_dollars_pmpm_all__w`	double
`b_hearing_dollars_pmpm_all__s`	double
`b_hearing_dollars_pmpm_all__w`	double
`a_otc_pct_offered__s`	double
`a_otc_pct_offered__w`	double
`b_otc_pct_offered__s`	double
`b_otc_pct_offered__w`	double
`a_otc_pct_own__s`	double
`a_otc_pct_own__w`	double
`b_otc_pct_own__s`	double
`b_otc_pct_own__w`	double
`a_otc_pct_card__s`	double
`a_otc_pct_card__w`	double
`b_otc_pct_card__s`	double
`b_otc_pct_card__w`	double
`a_otc_pct_no_amount__s`	double
`a_otc_pct_no_amount__w`	double
`b_otc_pct_no_amount__s`	double
`b_otc_pct_no_amount__w`	double
`a_otc_design_known__s`	double
`a_otc_design_known__w`	double
`b_otc_design_known__s`	double
`b_otc_design_known__w`	double
`a_otc_dollars_pmpm_if__s`	double
`a_otc_dollars_pmpm_if__w`	double
`b_otc_dollars_pmpm_if__s`	double
`b_otc_dollars_pmpm_if__w`	double
`a_otc_dollars_pmpm_all__s`	double
`a_otc_dollars_pmpm_all__w`	double
`b_otc_dollars_pmpm_all__s`	double
`b_otc_dollars_pmpm_all__w`	double
`a_eyewear_pct_offered__s`	double
`a_eyewear_pct_offered__w`	double
`b_eyewear_pct_offered__s`	double
`b_eyewear_pct_offered__w`	double
`a_eyewear_pct_allowance__s`	double
`a_eyewear_pct_allowance__w`	double
`b_eyewear_pct_allowance__s`	double
`b_eyewear_pct_allowance__w`	double
`a_eyewear_pct_card__s`	double
`a_eyewear_pct_card__w`	double
`b_eyewear_pct_card__s`	double
`b_eyewear_pct_card__w`	double
`a_eyewear_pct_no_max__s`	double
`a_eyewear_pct_no_max__w`	double
`b_eyewear_pct_no_max__s`	double
`b_eyewear_pct_no_max__w`	double
`a_eyewear_design_known__s`	double
`a_eyewear_design_known__w`	double
`b_eyewear_design_known__s`	double
`b_eyewear_design_known__w`	double
`a_eyewear_dollars_pmpm_if__s`	double
`a_eyewear_dollars_pmpm_if__w`	double
`b_eyewear_dollars_pmpm_if__s`	double
`b_eyewear_dollars_pmpm_if__w`	double
`a_eyewear_dollars_pmpm_all__s`	double
`a_eyewear_dollars_pmpm_all__w`	double
`b_eyewear_dollars_pmpm_all__s`	double
`b_eyewear_dollars_pmpm_all__w`	double
`a_hearing_copay_per_aid__s`	double
`a_hearing_copay_per_aid__w`	double
`b_hearing_copay_per_aid__s`	double
`b_hearing_copay_per_aid__w`	double
`a_otc_pct_filed_own_zero_card__s`	double
`a_otc_pct_filed_own_zero_card__w`	double
`b_otc_pct_filed_own_zero_card__s`	double
`b_otc_pct_filed_own_zero_card__w`	double
`a_otc_pct_one_pot__s`	double
`a_otc_pct_one_pot__w`	double
`b_otc_pct_one_pot__s`	double
`b_otc_pct_one_pot__w`	double
`a_otc_pct_d5_pot__s`	double
`a_otc_pct_d5_pot__w`	double
`b_otc_pct_d5_pot__s`	double
`b_otc_pct_d5_pot__w`	double
`a_dental_any_pct_offered__s`	double
`a_dental_any_pct_offered__w`	double
`b_dental_any_pct_offered__s`	double
`b_dental_any_pct_offered__w`	double
`a_eyewear_pct_preferred_tier__s`	double
`a_eyewear_pct_preferred_tier__w`	double
`b_eyewear_pct_preferred_tier__s`	double
`b_eyewear_pct_preferred_tier__w`	double
`a_eyewear_preferred_dollars_pmpm_if__s`	double
`a_eyewear_preferred_dollars_pmpm_if__w`	double
`b_eyewear_preferred_dollars_pmpm_if__s`	double
`b_eyewear_preferred_dollars_pmpm_if__w`	double
`a_card_pct_offered__s`	double
`a_card_pct_offered__w`	double
`b_card_pct_offered__s`	double
`b_card_pct_offered__w`	double
`a_card_dollars_pmpm_if__s`	double
`a_card_dollars_pmpm_if__w`	double
`b_card_dollars_pmpm_if__s`	double
`b_card_dollars_pmpm_if__w`	double
`a_card_dollars_pmpm_all__s`	double
`a_card_dollars_pmpm_all__w`	double
`b_card_dollars_pmpm_all__s`	double
`b_card_dollars_pmpm_all__w`	double
`a_card_pct_dvh_kind_only__s`	double
`a_card_pct_dvh_kind_only__w`	double
`b_card_pct_dvh_kind_only__s`	double
`b_card_pct_dvh_kind_only__w`	double
`a_card_pct_dvh_same_pot__s`	double
`a_card_pct_dvh_same_pot__w`	double
`b_card_pct_dvh_same_pot__s`	double
`b_card_pct_dvh_same_pot__w`	double
`a_card_pct_dvh_shared_pot__s`	double
`a_card_pct_dvh_shared_pot__w`	double
`b_card_pct_dvh_shared_pot__s`	double
`b_card_pct_dvh_shared_pot__w`	double
`a_allowance_pooled_pct_any__s`	double
`a_allowance_pooled_pct_any__w`	double
`b_allowance_pooled_pct_any__s`	double
`b_allowance_pooled_pct_any__w`	double
`a_card_targeted_pct_offered__s`	double
`a_card_targeted_pct_offered__w`	double
`b_card_targeted_pct_offered__s`	double
`b_card_targeted_pct_offered__w`	double
`a_card_targeted_dollars_pmpm_if__s`	double
`a_card_targeted_dollars_pmpm_if__w`	double
`b_card_targeted_dollars_pmpm_if__s`	double
`b_card_targeted_dollars_pmpm_if__w`	double
`a_card_targeted_pct_ssbci__s`	double
`a_card_targeted_pct_ssbci__w`	double
`b_card_targeted_pct_ssbci__s`	double
`b_card_targeted_pct_ssbci__w`	double
`a_card_targeted_pct_vbid_uf__s`	double
`a_card_targeted_pct_vbid_uf__w`	double
`b_card_targeted_pct_vbid_uf__s`	double
`b_card_targeted_pct_vbid_uf__w`	double
`a_card_targeted_pct_no_amount__s`	double
`a_card_targeted_pct_no_amount__w`	double
`b_card_targeted_pct_no_amount__s`	double
`b_card_targeted_pct_no_amount__w`	double
`a_card_targeted_pct_pooled_in_card__s`	double
`a_card_targeted_pct_pooled_in_card__w`	double
`b_card_targeted_pct_pooled_in_card__s`	double
`b_card_targeted_pct_pooled_in_card__w`	double
`a_allowance_total_pmpm_all__s`	double
`a_allowance_total_pmpm_all__w`	double
`b_allowance_total_pmpm_all__s`	double
`b_allowance_total_pmpm_all__w`	double
`a_allowance_total_pct_no_cap__s`	double
`a_allowance_total_pct_no_cap__w`	double
`b_allowance_total_pct_no_cap__s`	double
`b_allowance_total_pct_no_cap__w`	double
`a_allowance_shared_pot_overlap_pmpm__s`	double
`a_allowance_shared_pot_overlap_pmpm__w`	double
`b_allowance_shared_pot_overlap_pmpm__s`	double
`b_allowance_shared_pot_overlap_pmpm__w`	double
`a_giveback_pct_offered__s`	double
`a_giveback_pct_offered__w`	double
`b_giveback_pct_offered__s`	double
`b_giveback_pct_offered__w`	double
`a_giveback_pct_token__s`	double
`a_giveback_pct_token__w`	double
`b_giveback_pct_token__s`	double
`b_giveback_pct_token__w`	double
`a_giveback_pmpm_if__s`	double
`a_giveback_pmpm_if__w`	double
`b_giveback_pmpm_if__s`	double
`b_giveback_pmpm_if__w`	double
`a_premium_pct_zero__s`	double
`a_premium_pct_zero__w`	double
`b_premium_pct_zero__s`	double
`b_premium_pct_zero__w`	double
`a_deductible_pct_none__s`	double
`a_deductible_pct_none__w`	double
`b_deductible_pct_none__s`	double
`b_deductible_pct_none__w`	double
`a_deductible_pct_plan__s`	double
`a_deductible_pct_plan__w`	double
`b_deductible_pct_plan__s`	double
`b_deductible_pct_plan__w`	double
`a_deductible_pct_partb__s`	double
`a_deductible_pct_partb__w`	double
`b_deductible_pct_partb__s`	double
`b_deductible_pct_partb__w`	double
`a_deductible_pct_scope_oon__s`	double
`a_deductible_pct_scope_oon__w`	double
`b_deductible_pct_scope_oon__s`	double
`b_deductible_pct_scope_oon__w`	double
`a_deductible_plan_amount__s`	double
`a_deductible_plan_amount__w`	double
`b_deductible_plan_amount__s`	double
`b_deductible_plan_amount__w`	double
`a_deductible_design_known__s`	double
`a_deductible_design_known__w`	double
`b_deductible_design_known__s`	double
`b_deductible_design_known__w`	double
`a_svc_transportation_pct_offered__s`	double
`a_svc_transportation_pct_offered__w`	double
`b_svc_transportation_pct_offered__s`	double
`b_svc_transportation_pct_offered__w`	double
`a_svc_transportation_pct_optional_only__s`	double
`a_svc_transportation_pct_optional_only__w`	double
`b_svc_transportation_pct_optional_only__s`	double
`b_svc_transportation_pct_optional_only__w`	double
`a_svc_fitness_pct_offered__s`	double
`a_svc_fitness_pct_offered__w`	double
`b_svc_fitness_pct_offered__s`	double
`b_svc_fitness_pct_offered__w`	double
`a_svc_fitness_pct_optional_only__s`	double
`a_svc_fitness_pct_optional_only__w`	double
`b_svc_fitness_pct_optional_only__s`	double
`b_svc_fitness_pct_optional_only__w`	double
`a_svc_meals_post_discharge_pct_offered__s`	double
`a_svc_meals_post_discharge_pct_offered__w`	double
`b_svc_meals_post_discharge_pct_offered__s`	double
`b_svc_meals_post_discharge_pct_offered__w`	double
`a_svc_meals_post_discharge_pct_optional_only__s`	double
`a_svc_meals_post_discharge_pct_optional_only__w`	double
`b_svc_meals_post_discharge_pct_optional_only__s`	double
`b_svc_meals_post_discharge_pct_optional_only__w`	double
`a_svc_meals_any_pct_offered__s`	double
`a_svc_meals_any_pct_offered__w`	double
`b_svc_meals_any_pct_offered__s`	double
`b_svc_meals_any_pct_offered__w`	double
`a_svc_meals_any_pct_optional_only__s`	double
`a_svc_meals_any_pct_optional_only__w`	double
`b_svc_meals_any_pct_optional_only__s`	double
`b_svc_meals_any_pct_optional_only__w`	double
`a_svc_podiatry_pct_offered__s`	double
`a_svc_podiatry_pct_offered__w`	double
`b_svc_podiatry_pct_offered__s`	double
`b_svc_podiatry_pct_offered__w`	double
`a_svc_podiatry_pct_optional_only__s`	double
`a_svc_podiatry_pct_optional_only__w`	double
`b_svc_podiatry_pct_optional_only__s`	double
`b_svc_podiatry_pct_optional_only__w`	double
`a_svc_transportation_trips__s`	double
`a_svc_transportation_trips__w`	double
`b_svc_transportation_trips__s`	double
`b_svc_transportation_trips__w`	double
`a_svc_transportation_round_trips__s`	double
`a_svc_transportation_round_trips__w`	double
`b_svc_transportation_round_trips__s`	double
`b_svc_transportation_round_trips__w`	double
`a_svc_transportation_pct_unlimited__s`	double
`a_svc_transportation_pct_unlimited__w`	double
`b_svc_transportation_pct_unlimited__s`	double
`b_svc_transportation_pct_unlimited__w`	double
`a_svc_podiatry_visits__s`	double
`a_svc_podiatry_visits__w`	double
`b_svc_podiatry_visits__s`	double
`b_svc_podiatry_visits__w`	double
`a_premium__s`	double
`a_premium__w`	double
`b_premium__s`	double
`b_premium__w`	double
`a_moop__s`	double
`a_moop__w`	double
`b_moop__s`	double
`b_moop__w`	double
`a_medical_deductible__s`	double
`a_medical_deductible__w`	double
`b_medical_deductible__s`	double
`b_medical_deductible__w`	double
`a_partd_deductible__s`	double
`a_partd_deductible__w`	double
`b_partd_deductible__s`	double
`b_partd_deductible__w`	double
`a_primary_care__s`	double
`a_primary_care__w`	double
`b_primary_care__s`	double
`b_primary_care__w`	double
`a_specialist__s`	double
`a_specialist__w`	double
`b_specialist__s`	double
`b_specialist__w`	double
`a_telehealth__s`	double
`a_telehealth__w`	double
`b_telehealth__s`	double
`b_telehealth__w`	double
`a_mental_health_ind__s`	double
`a_mental_health_ind__w`	double
`b_mental_health_ind__s`	double
`b_mental_health_ind__w`	double
`a_er__s`	double
`a_er__w`	double
`b_er__s`	double
`b_er__w`	double
`a_urgent__s`	double
`a_urgent__w`	double
`b_urgent__s`	double
`b_urgent__w`	double
`a_ambulance_ground__s`	double
`a_ambulance_ground__w`	double
`b_ambulance_ground__s`	double
`b_ambulance_ground__w`	double
`a_hosp_5day__s`	double
`a_hosp_5day__w`	double
`b_hosp_5day__s`	double
`b_hosp_5day__w`	double
`a_inpatient__s`	double
`a_inpatient__w`	double
`b_inpatient__s`	double
`b_inpatient__w`	double
`a_snf__s`	double
`a_snf__w`	double
`b_snf__s`	double
`b_snf__w`	double
`a_outpatient_hosp__s`	double
`a_outpatient_hosp__w`	double
`b_outpatient_hosp__s`	double
`b_outpatient_hosp__w`	double
`a_asc__s`	double
`a_asc__w`	double
`b_asc__s`	double
`b_asc__w`	double
`a_imaging_complex__s`	double
`a_imaging_complex__w`	double
`b_imaging_complex__s`	double
`b_imaging_complex__w`	double
`a_radiology__s`	double
`a_radiology__w`	double
`b_radiology__s`	double
`b_radiology__w`	double
`a_lab__s`	double
`a_lab__w`	double
`b_lab__s`	double
`b_lab__w`	double
`a_physical_therapy__s`	double
`a_physical_therapy__w`	double
`b_physical_therapy__s`	double
`b_physical_therapy__w`	double
`a_dme__s`	double
`a_dme__w`	double
`b_dme__s`	double
`b_dme__w`	double
`a_partb_drugs__s`	double
`a_partb_drugs__w`	double
`b_partb_drugs__s`	double
`b_partb_drugs__w`	double
`a_partb_insulin__s`	double
`a_partb_insulin__w`	double
`b_partb_insulin__s`	double
`b_partb_insulin__w`	double
`a_dialysis__s`	double
`a_dialysis__w`	double
`b_dialysis__s`	double
`b_dialysis__w`	double
`a_partd_tier1_copay__s`	double
`a_partd_tier1_copay__w`	double
`b_partd_tier1_copay__s`	double
`b_partd_tier1_copay__w`	double
`a_partd_tier2_copay__s`	double
`a_partd_tier2_copay__w`	double
`b_partd_tier2_copay__s`	double
`b_partd_tier2_copay__w`	double
`a_partd_tier4_coins__s`	double
`a_partd_tier4_coins__w`	double
`b_partd_tier4_coins__s`	double
`b_partd_tier4_coins__w`	double
`a_partd_tier5_coins__s`	double
`a_partd_tier5_coins__w`	double
`b_partd_tier5_coins__s`	double
`b_partd_tier5_coins__w`	double
`a_primary_care_pct_copay__s`	double
`a_primary_care_pct_copay__w`	double
`b_primary_care_pct_copay__s`	double
`b_primary_care_pct_copay__w`	double
`a_primary_care_pct_coins__s`	double
`a_primary_care_pct_coins__w`	double
`b_primary_care_pct_coins__s`	double
`b_primary_care_pct_coins__w`	double
`a_primary_care_coins__s`	double
`a_primary_care_coins__w`	double
`b_primary_care_coins__s`	double
`b_primary_care_coins__w`	double
`a_specialist_pct_copay__s`	double
`a_specialist_pct_copay__w`	double
`b_specialist_pct_copay__s`	double
`b_specialist_pct_copay__w`	double
`a_specialist_pct_coins__s`	double
`a_specialist_pct_coins__w`	double
`b_specialist_pct_coins__s`	double
`b_specialist_pct_coins__w`	double
`a_specialist_coins__s`	double
`a_specialist_coins__w`	double
`b_specialist_coins__s`	double
`b_specialist_coins__w`	double
`a_telehealth_pct_copay__s`	double
`a_telehealth_pct_copay__w`	double
`b_telehealth_pct_copay__s`	double
`b_telehealth_pct_copay__w`	double
`a_telehealth_pct_coins__s`	double
`a_telehealth_pct_coins__w`	double
`b_telehealth_pct_coins__s`	double
`b_telehealth_pct_coins__w`	double
`a_telehealth_coins__s`	double
`a_telehealth_coins__w`	double
`b_telehealth_coins__s`	double
`b_telehealth_coins__w`	double
`a_mental_health_ind_pct_copay__s`	double
`a_mental_health_ind_pct_copay__w`	double
`b_mental_health_ind_pct_copay__s`	double
`b_mental_health_ind_pct_copay__w`	double
`a_mental_health_ind_pct_coins__s`	double
`a_mental_health_ind_pct_coins__w`	double
`b_mental_health_ind_pct_coins__s`	double
`b_mental_health_ind_pct_coins__w`	double
`a_mental_health_ind_coins__s`	double
`a_mental_health_ind_coins__w`	double
`b_mental_health_ind_coins__s`	double
`b_mental_health_ind_coins__w`	double
`a_physical_therapy_pct_copay__s`	double
`a_physical_therapy_pct_copay__w`	double
`b_physical_therapy_pct_copay__s`	double
`b_physical_therapy_pct_copay__w`	double
`a_physical_therapy_pct_coins__s`	double
`a_physical_therapy_pct_coins__w`	double
`b_physical_therapy_pct_coins__s`	double
`b_physical_therapy_pct_coins__w`	double
`a_physical_therapy_coins__s`	double
`a_physical_therapy_coins__w`	double
`b_physical_therapy_coins__s`	double
`b_physical_therapy_coins__w`	double
`a_er_pct_copay__s`	double
`a_er_pct_copay__w`	double
`b_er_pct_copay__s`	double
`b_er_pct_copay__w`	double
`a_er_pct_coins__s`	double
`a_er_pct_coins__w`	double
`b_er_pct_coins__s`	double
`b_er_pct_coins__w`	double
`a_er_coins__s`	double
`a_er_coins__w`	double
`b_er_coins__s`	double
`b_er_coins__w`	double
`a_urgent_pct_copay__s`	double
`a_urgent_pct_copay__w`	double
`b_urgent_pct_copay__s`	double
`b_urgent_pct_copay__w`	double
`a_urgent_pct_coins__s`	double
`a_urgent_pct_coins__w`	double
`b_urgent_pct_coins__s`	double
`b_urgent_pct_coins__w`	double
`a_urgent_coins__s`	double
`a_urgent_coins__w`	double
`b_urgent_coins__s`	double
`b_urgent_coins__w`	double
`a_ambulance_ground_pct_copay__s`	double
`a_ambulance_ground_pct_copay__w`	double
`b_ambulance_ground_pct_copay__s`	double
`b_ambulance_ground_pct_copay__w`	double
`a_ambulance_ground_pct_coins__s`	double
`a_ambulance_ground_pct_coins__w`	double
`b_ambulance_ground_pct_coins__s`	double
`b_ambulance_ground_pct_coins__w`	double
`a_ambulance_ground_coins__s`	double
`a_ambulance_ground_coins__w`	double
`b_ambulance_ground_coins__s`	double
`b_ambulance_ground_coins__w`	double
`a_outpatient_hosp_pct_copay__s`	double
`a_outpatient_hosp_pct_copay__w`	double
`b_outpatient_hosp_pct_copay__s`	double
`b_outpatient_hosp_pct_copay__w`	double
`a_outpatient_hosp_pct_coins__s`	double
`a_outpatient_hosp_pct_coins__w`	double
`b_outpatient_hosp_pct_coins__s`	double
`b_outpatient_hosp_pct_coins__w`	double
`a_outpatient_hosp_coins__s`	double
`a_outpatient_hosp_coins__w`	double
`b_outpatient_hosp_coins__s`	double
`b_outpatient_hosp_coins__w`	double
`a_imaging_complex_pct_copay__s`	double
`a_imaging_complex_pct_copay__w`	double
`b_imaging_complex_pct_copay__s`	double
`b_imaging_complex_pct_copay__w`	double
`a_imaging_complex_pct_coins__s`	double
`a_imaging_complex_pct_coins__w`	double
`b_imaging_complex_pct_coins__s`	double
`b_imaging_complex_pct_coins__w`	double
`a_imaging_complex_coins__s`	double
`a_imaging_complex_coins__w`	double
`b_imaging_complex_coins__s`	double
`b_imaging_complex_coins__w`	double
`a_radiology_pct_copay__s`	double
`a_radiology_pct_copay__w`	double
`b_radiology_pct_copay__s`	double
`b_radiology_pct_copay__w`	double
`a_radiology_pct_coins__s`	double
`a_radiology_pct_coins__w`	double
`b_radiology_pct_coins__s`	double
`b_radiology_pct_coins__w`	double
`a_radiology_coins__s`	double
`a_radiology_coins__w`	double
`b_radiology_coins__s`	double
`b_radiology_coins__w`	double
`a_lab_pct_copay__s`	double
`a_lab_pct_copay__w`	double
`b_lab_pct_copay__s`	double
`b_lab_pct_copay__w`	double
`a_lab_pct_coins__s`	double
`a_lab_pct_coins__w`	double
`b_lab_pct_coins__s`	double
`b_lab_pct_coins__w`	double
`a_lab_coins__s`	double
`a_lab_coins__w`	double
`b_lab_coins__s`	double
`b_lab_coins__w`	double
`a_inpatient_pct_copay__s`	double
`a_inpatient_pct_copay__w`	double
`b_inpatient_pct_copay__s`	double
`b_inpatient_pct_copay__w`	double
`a_inpatient_pct_coins__s`	double
`a_inpatient_pct_coins__w`	double
`b_inpatient_pct_coins__s`	double
`b_inpatient_pct_coins__w`	double
`a_inpatient_coins__s`	double
`a_inpatient_coins__w`	double
`b_inpatient_coins__s`	double
`b_inpatient_coins__w`	double
`a_snf_pct_copay__s`	double
`a_snf_pct_copay__w`	double
`b_snf_pct_copay__s`	double
`b_snf_pct_copay__w`	double
`a_snf_pct_coins__s`	double
`a_snf_pct_coins__w`	double
`b_snf_pct_coins__s`	double
`b_snf_pct_coins__w`	double
`a_snf_coins__s`	double
`a_snf_coins__w`	double
`b_snf_coins__s`	double
`b_snf_coins__w`	double
`a_telehealth_pct_offered__s`	double
`a_telehealth_pct_offered__w`	double
`b_telehealth_pct_offered__s`	double
`b_telehealth_pct_offered__w`	double
`a_moop_pct_not_in_network__s`	double
`a_moop_pct_not_in_network__w`	double
`b_moop_pct_not_in_network__s`	double
`b_moop_pct_not_in_network__w`	double
`a_dental_pct_cap_plus_card__s`	double
`a_dental_pct_cap_plus_card__w`	double
`b_dental_pct_cap_plus_card__s`	double
`b_dental_pct_cap_plus_card__w`	double
`a_hearing_pct_cap_plus_card__s`	double
`a_hearing_pct_cap_plus_card__w`	double
`b_hearing_pct_cap_plus_card__s`	double
`b_hearing_pct_cap_plus_card__w`	double
`a_otc_pct_cap_plus_card__s`	double
`a_otc_pct_cap_plus_card__w`	double
`b_otc_pct_cap_plus_card__s`	double
`b_otc_pct_cap_plus_card__w`	double
`a_eyewear_pct_cap_plus_card__s`	double
`a_eyewear_pct_cap_plus_card__w`	double
`b_eyewear_pct_cap_plus_card__s`	double
`b_eyewear_pct_cap_plus_card__w`	double
`a_card_pays_dental__s`	double
`a_card_pays_dental__w`	double
`b_card_pays_dental__s`	double
`b_card_pays_dental__w`	double
`a_card_pays_eyewear__s`	double
`a_card_pays_eyewear__w`	double
`b_card_pays_eyewear__s`	double
`b_card_pays_eyewear__w`	double
`a_card_pays_hearing__s`	double
`a_card_pays_hearing__w`	double
`b_card_pays_hearing__s`	double
`b_card_pays_hearing__w`	double
`a_card_pays_otc__s`	double
`a_card_pays_otc__w`	double
`b_card_pays_otc__s`	double
`b_card_pays_otc__w`	double
`a_card_pays_food_living__s`	double
`a_card_pays_food_living__w`	double
`b_card_pays_food_living__s`	double
`b_card_pays_food_living__w`	double
`a_card_pays_other__s`	double
`a_card_pays_other__w`	double
`b_card_pays_other__s`	double
`b_card_pays_other__w`	double
`a_card_pct_kind_flex__s`	double
`a_card_pct_kind_flex__w`	double
`b_card_pct_kind_flex__s`	double
`b_card_pct_kind_flex__w`	double
`a_card_pct_kind_dvh__s`	double
`a_card_pct_kind_dvh__w`	double
`b_card_pct_kind_dvh__s`	double
`b_card_pct_kind_dvh__w`	double
`a_card_pct_kind_otc__s`	double
`a_card_pct_kind_otc__w`	double
`b_card_pct_kind_otc__s`	double
`b_card_pct_kind_otc__w`	double
`a_card_pct_kind_food_living__s`	double
`a_card_pct_kind_food_living__w`	double
`b_card_pct_kind_food_living__s`	double
`b_card_pct_kind_food_living__w`	double
`a_card_pct_kind_wellness__s`	double
`a_card_pct_kind_wellness__w`	double
`b_card_pct_kind_wellness__s`	double
`b_card_pct_kind_wellness__w`	double
`a_primary_care_pct_zero__s`	double
`a_primary_care_pct_zero__w`	double
`b_primary_care_pct_zero__s`	double
`b_primary_care_pct_zero__w`	double
`a_specialist_pct_zero__s`	double
`a_specialist_pct_zero__w`	double
`b_specialist_pct_zero__s`	double
`b_specialist_pct_zero__w`	double
`a_telehealth_pct_zero__s`	double
`a_telehealth_pct_zero__w`	double
`b_telehealth_pct_zero__s`	double
`b_telehealth_pct_zero__w`	double
`a_mental_health_ind_pct_zero__s`	double
`a_mental_health_ind_pct_zero__w`	double
`b_mental_health_ind_pct_zero__s`	double
`b_mental_health_ind_pct_zero__w`	double
`a_physical_therapy_pct_zero__s`	double
`a_physical_therapy_pct_zero__w`	double
`b_physical_therapy_pct_zero__s`	double
`b_physical_therapy_pct_zero__w`	double
`a_er_pct_zero__s`	double
`a_er_pct_zero__w`	double
`b_er_pct_zero__s`	double
`b_er_pct_zero__w`	double
`a_urgent_pct_zero__s`	double
`a_urgent_pct_zero__w`	double
`b_urgent_pct_zero__s`	double
`b_urgent_pct_zero__w`	double
`a_ambulance_ground_pct_zero__s`	double
`a_ambulance_ground_pct_zero__w`	double
`b_ambulance_ground_pct_zero__s`	double
`b_ambulance_ground_pct_zero__w`	double
`a_outpatient_hosp_pct_zero__s`	double
`a_outpatient_hosp_pct_zero__w`	double
`b_outpatient_hosp_pct_zero__s`	double
`b_outpatient_hosp_pct_zero__w`	double
`a_imaging_complex_pct_zero__s`	double
`a_imaging_complex_pct_zero__w`	double
`b_imaging_complex_pct_zero__s`	double
`b_imaging_complex_pct_zero__w`	double
`a_radiology_pct_zero__s`	double
`a_radiology_pct_zero__w`	double
`b_radiology_pct_zero__s`	double
`b_radiology_pct_zero__w`	double
`a_lab_pct_zero__s`	double
`a_lab_pct_zero__w`	double
`b_lab_pct_zero__s`	double
`b_lab_pct_zero__w`	double
`a_inpatient_pct_zero__s`	double
`a_inpatient_pct_zero__w`	double
`b_inpatient_pct_zero__s`	double
`b_inpatient_pct_zero__w`	double
`a_snf_pct_zero__s`	double
`a_snf_pct_zero__w`	double
`b_snf_pct_zero__s`	double
`b_snf_pct_zero__w`	double
`a_dsnp_enrolls_full_duals__s`	double
`a_dsnp_enrolls_full_duals__w`	double
`b_dsnp_enrolls_full_duals__s`	double
`b_dsnp_enrolls_full_duals__w`	double
`a_primary_care_dual_effective__s`	double
`a_primary_care_dual_effective__w`	double
`b_primary_care_dual_effective__s`	double
`b_primary_care_dual_effective__w`	double
`a_specialist_dual_effective__s`	double
`a_specialist_dual_effective__w`	double
`b_specialist_dual_effective__s`	double
`b_specialist_dual_effective__w`	double
`a_telehealth_dual_effective__s`	double
`a_telehealth_dual_effective__w`	double
`b_telehealth_dual_effective__s`	double
`b_telehealth_dual_effective__w`	double
`a_mental_health_ind_dual_effective__s`	double
`a_mental_health_ind_dual_effective__w`	double
`b_mental_health_ind_dual_effective__s`	double
`b_mental_health_ind_dual_effective__w`	double
`a_physical_therapy_dual_effective__s`	double
`a_physical_therapy_dual_effective__w`	double
`b_physical_therapy_dual_effective__s`	double
`b_physical_therapy_dual_effective__w`	double
`a_er_dual_effective__s`	double
`a_er_dual_effective__w`	double
`b_er_dual_effective__s`	double
`b_er_dual_effective__w`	double
`a_urgent_dual_effective__s`	double
`a_urgent_dual_effective__w`	double
`b_urgent_dual_effective__s`	double
`b_urgent_dual_effective__w`	double
`a_ambulance_ground_dual_effective__s`	double
`a_ambulance_ground_dual_effective__w`	double
`b_ambulance_ground_dual_effective__s`	double
`b_ambulance_ground_dual_effective__w`	double
`a_outpatient_hosp_dual_effective__s`	double
`a_outpatient_hosp_dual_effective__w`	double
`b_outpatient_hosp_dual_effective__s`	double
`b_outpatient_hosp_dual_effective__w`	double
`a_imaging_complex_dual_effective__s`	double
`a_imaging_complex_dual_effective__w`	double
`b_imaging_complex_dual_effective__s`	double
`b_imaging_complex_dual_effective__w`	double
`a_radiology_dual_effective__s`	double
`a_radiology_dual_effective__w`	double
`b_radiology_dual_effective__s`	double
`b_radiology_dual_effective__w`	double
`a_lab_dual_effective__s`	double
`a_lab_dual_effective__w`	double
`b_lab_dual_effective__s`	double
`b_lab_dual_effective__w`	double
`a_inpatient_dual_effective__s`	double
`a_inpatient_dual_effective__w`	double
`b_inpatient_dual_effective__s`	double
`b_inpatient_dual_effective__w`	double
`a_snf_dual_effective__s`	double
`a_snf_dual_effective__w`	double
`b_snf_dual_effective__s`	double
`b_snf_dual_effective__w`	double
`a_moop_dual_effective__s`	double
`a_moop_dual_effective__w`	double
`b_moop_dual_effective__s`	double
`b_moop_dual_effective__w`	double
`a_medical_deductible_dual_effective__s`	double
`a_medical_deductible_dual_effective__w`	double
`b_medical_deductible_dual_effective__s`	double
`b_medical_deductible_dual_effective__w`	double

Query it

describe_data_source(source_fqn="medicare_semantic.vw_benefit_reading_matched")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_benefit_reading_matched WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	get_benefit_change
Identity key	`base_year,bucket,plan_type,contract_id,match_contract_id,per`
Join	`how_to_join(source_fqn="medicare_semantic.vw_benefit_reading_matched")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_benefit_reading_matched

This page as markdown: /docs-md/data/medicare_semantic_vw_benefit_reading_matched.md · every page in one file: /llms-full.txt