Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_benefit_reading_simple·live·mart

Rows

2,115,880

Columns

667

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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'.
2A segment's filed value is the same in every county it serves (rail R-simple).
3Pointer -> medicare_semantic.benefit_reading_simple_v20261018b.
4Owner: the Benefits lane.

Grain

Key	Grain
N/A	1The cells' keys (base_year x lvl x state x county_ssa x bucket x plan_type x parent x per).

Columns (667)

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

Query it

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

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

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