Medicare Advantage, Part D, Medicaid

Vlada benefit reading cells (edition v20261018b): every benefit number by national / state / county x product type x plan type x parent x base year x view, as weighted sums

medicare_semantic.vw_benefit_reading_cells·live·mart

Rows

2,115,880

Columns

708

History

N/A

Card

nocolumns only

Typed tools

What it is

1The benefit reading's member-weighted cells (Benefits lane, edition v20261018b, BENEFIT-READING.md): every metric of the benefit engine atoms (benefit_engine_atoms_v20261018b) rolled up by GROUPING SETS, kept as weighted sums so any reader reproduces the published figure: value = m__s / m__w, measurable = m__w / members, coverage = m__c / members.
2Edition v20261018b adds, beside every v20261015d column (identical, rail R-cells): what each card pays for (card_pays_*), the card kinds, each allowance's card role (<b>_pct_cap_plus_card = an own dollar cap AND a card that also pays it), the cost-share $0 leg (<m>_pct_zero), the D-SNP full-dual lens (<m>_dual_effective, dsnp_enrolls_full_duals).
3Registry of every number: ops/sb_llm/benefit_reading_registry.yaml.
4Pointer -> medicare_semantic.benefit_company_cells_v20261018b.
5Owner: the Benefits lane.

Grain

Key	Grain
N/A	1One row per base_year (2022-2026) x lvl x state x county_ssa x bucket ('ALL' = a parent's overall) x plan_type ('ALL') x parent ('ALL' = the market) x per ('b' = that year's members, 'f' = base members who continue, 'n' = those members in their next-year plan; base 2026 'n' = 2027).

Columns (708)

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)
`members`	double
`plans`	bigint
`dental_pct_offered__s`	double
`dental_pct_offered__w`	double
`dental_pct_max__s`	double
`dental_pct_max__w`	double
`dental_pct_no_max__s`	double
`dental_pct_no_max__w`	double
`dental_pct_card__s`	double
`dental_pct_card__w`	double
`dental_dollars_pmpm_if__s`	double
`dental_dollars_pmpm_if__w`	double
`dental_dollars_pmpm_all__s`	double
`dental_dollars_pmpm_all__w`	double
`dental_design_known__s`	double
`dental_design_known__w`	double
`hearing_pct_offered__s`	double
`hearing_pct_offered__w`	double
`hearing_pct_allowance__s`	double
`hearing_pct_allowance__w`	double
`hearing_pct_copay__s`	double
`hearing_pct_copay__w`	double
`hearing_pct_card__s`	double
`hearing_pct_card__w`	double
`hearing_dollars_pmpm_if__s`	double
`hearing_dollars_pmpm_if__w`	double
`hearing_dollars_pmpm_all__s`	double
`hearing_dollars_pmpm_all__w`	double
`hearing_design_known__s`	double
`hearing_design_known__w`	double
`otc_pct_offered__s`	double
`otc_pct_offered__w`	double
`otc_pct_own__s`	double
`otc_pct_own__w`	double
`otc_pct_card__s`	double
`otc_pct_card__w`	double
`otc_pct_no_amount__s`	double
`otc_pct_no_amount__w`	double
`otc_dollars_pmpm_if__s`	double
`otc_dollars_pmpm_if__w`	double
`otc_dollars_pmpm_all__s`	double
`otc_dollars_pmpm_all__w`	double
`otc_design_known__s`	double
`otc_design_known__w`	double
`eyewear_pct_offered__s`	double
`eyewear_pct_offered__w`	double
`eyewear_pct_allowance__s`	double
`eyewear_pct_allowance__w`	double
`eyewear_pct_card__s`	double
`eyewear_pct_card__w`	double
`eyewear_pct_no_max__s`	double
`eyewear_pct_no_max__w`	double
`eyewear_dollars_pmpm_if__s`	double
`eyewear_dollars_pmpm_if__w`	double
`eyewear_dollars_pmpm_all__s`	double
`eyewear_dollars_pmpm_all__w`	double
`eyewear_design_known__s`	double
`eyewear_design_known__w`	double
`hearing_copay_per_aid__s`	double
`hearing_copay_per_aid__w`	double
`otc_pct_filed_own_zero_card__s`	double
`otc_pct_filed_own_zero_card__w`	double
`card_pct_offered__s`	double
`card_pct_offered__w`	double
`card_dollars_pmpm_if__s`	double
`card_dollars_pmpm_if__w`	double
`card_dollars_pmpm_all__s`	double
`card_dollars_pmpm_all__w`	double
`allowance_total_pmpm_all__s`	double
`allowance_total_pmpm_all__w`	double
`giveback_pct_offered__s`	double
`giveback_pct_offered__w`	double
`giveback_pct_token__s`	double
`giveback_pct_token__w`	double
`giveback_pmpm_if__s`	double
`giveback_pmpm_if__w`	double
`premium_pct_zero__s`	double
`premium_pct_zero__w`	double
`svc_transportation_pct_offered__s`	double
`svc_transportation_pct_offered__w`	double
`svc_transportation_known__s`	double
`svc_transportation_known__w`	double
`svc_fitness_pct_offered__s`	double
`svc_fitness_pct_offered__w`	double
`svc_fitness_known__s`	double
`svc_fitness_known__w`	double
`svc_meals_post_discharge_pct_offered__s`	double
`svc_meals_post_discharge_pct_offered__w`	double
`svc_meals_post_discharge_known__s`	double
`svc_meals_post_discharge_known__w`	double
`svc_meals_any_pct_offered__s`	double
`svc_meals_any_pct_offered__w`	double
`svc_meals_any_known__s`	double
`svc_meals_any_known__w`	double
`svc_podiatry_pct_offered__s`	double
`svc_podiatry_pct_offered__w`	double
`svc_podiatry_known__s`	double
`svc_podiatry_known__w`	double
`svc_transportation_trips__s`	double
`svc_transportation_trips__w`	double
`svc_transportation_pct_unlimited__s`	double
`svc_transportation_pct_unlimited__w`	double
`svc_podiatry_visits__s`	double
`svc_podiatry_visits__w`	double
`deductible_pct_none__s`	double
`deductible_pct_none__w`	double
`deductible_pct_partb__s`	double
`deductible_pct_partb__w`	double
`deductible_pct_plan__s`	double
`deductible_pct_plan__w`	double
`deductible_plan_amount__s`	double
`deductible_plan_amount__w`	double
`deductible_design_known__s`	double
`deductible_design_known__w`	double
`deductible_pct_scope_oon__s`	double
`deductible_pct_scope_oon__w`	double
`premium__s`	double
`premium__w`	double
`moop__s`	double
`moop__w`	double
`medical_deductible__s`	double
`medical_deductible__w`	double
`partd_deductible__s`	double
`partd_deductible__w`	double
`primary_care__s`	double
`primary_care__w`	double
`specialist__s`	double
`specialist__w`	double
`telehealth__s`	double
`telehealth__w`	double
`mental_health_ind__s`	double
`mental_health_ind__w`	double
`er__s`	double
`er__w`	double
`urgent__s`	double
`urgent__w`	double
`ambulance_ground__s`	double
`ambulance_ground__w`	double
`hosp_5day__s`	double
`hosp_5day__w`	double
`inpatient__s`	double
`inpatient__w`	double
`snf__s`	double
`snf__w`	double
`outpatient_hosp__s`	double
`outpatient_hosp__w`	double
`asc__s`	double
`asc__w`	double
`imaging_complex__s`	double
`imaging_complex__w`	double
`radiology__s`	double
`radiology__w`	double
`lab__s`	double
`lab__w`	double
`physical_therapy__s`	double
`physical_therapy__w`	double
`dme__s`	double
`dme__w`	double
`partb_drugs__s`	double
`partb_drugs__w`	double
`partb_insulin__s`	double
`partb_insulin__w`	double
`dialysis__s`	double
`dialysis__w`	double
`partd_tier1_copay__s`	double
`partd_tier1_copay__w`	double
`partd_tier2_copay__s`	double
`partd_tier2_copay__w`	double
`partd_tier4_coins__s`	double
`partd_tier4_coins__w`	double
`partd_tier5_coins__s`	double
`partd_tier5_coins__w`	double
`primary_care_pct_copay__s`	double
`primary_care_pct_copay__w`	double
`primary_care_pct_coins__s`	double
`primary_care_pct_coins__w`	double
`primary_care_coins__s`	double
`primary_care_coins__w`	double
`specialist_pct_copay__s`	double
`specialist_pct_copay__w`	double
`specialist_pct_coins__s`	double
`specialist_pct_coins__w`	double
`specialist_coins__s`	double
`specialist_coins__w`	double
`telehealth_pct_copay__s`	double
`telehealth_pct_copay__w`	double
`telehealth_pct_coins__s`	double
`telehealth_pct_coins__w`	double
`telehealth_coins__s`	double
`telehealth_coins__w`	double
`mental_health_ind_pct_copay__s`	double
`mental_health_ind_pct_copay__w`	double
`mental_health_ind_pct_coins__s`	double
`mental_health_ind_pct_coins__w`	double
`mental_health_ind_coins__s`	double
`mental_health_ind_coins__w`	double
`physical_therapy_pct_copay__s`	double
`physical_therapy_pct_copay__w`	double
`physical_therapy_pct_coins__s`	double
`physical_therapy_pct_coins__w`	double
`physical_therapy_coins__s`	double
`physical_therapy_coins__w`	double
`er_pct_copay__s`	double
`er_pct_copay__w`	double
`er_pct_coins__s`	double
`er_pct_coins__w`	double
`er_coins__s`	double
`er_coins__w`	double
`urgent_pct_copay__s`	double
`urgent_pct_copay__w`	double
`urgent_pct_coins__s`	double
`urgent_pct_coins__w`	double
`urgent_coins__s`	double
`urgent_coins__w`	double
`ambulance_ground_pct_copay__s`	double
`ambulance_ground_pct_copay__w`	double
`ambulance_ground_pct_coins__s`	double
`ambulance_ground_pct_coins__w`	double
`ambulance_ground_coins__s`	double
`ambulance_ground_coins__w`	double
`outpatient_hosp_pct_copay__s`	double
`outpatient_hosp_pct_copay__w`	double
`outpatient_hosp_pct_coins__s`	double
`outpatient_hosp_pct_coins__w`	double
`outpatient_hosp_coins__s`	double
`outpatient_hosp_coins__w`	double
`imaging_complex_pct_copay__s`	double
`imaging_complex_pct_copay__w`	double
`imaging_complex_pct_coins__s`	double
`imaging_complex_pct_coins__w`	double
`imaging_complex_coins__s`	double
`imaging_complex_coins__w`	double
`radiology_pct_copay__s`	double
`radiology_pct_copay__w`	double
`radiology_pct_coins__s`	double
`radiology_pct_coins__w`	double
`radiology_coins__s`	double
`radiology_coins__w`	double
`lab_pct_copay__s`	double
`lab_pct_copay__w`	double
`lab_pct_coins__s`	double
`lab_pct_coins__w`	double
`lab_coins__s`	double
`lab_coins__w`	double
`inpatient_pct_copay__s`	double
`inpatient_pct_copay__w`	double
`inpatient_pct_coins__s`	double
`inpatient_pct_coins__w`	double
`inpatient_coins__s`	double
`inpatient_coins__w`	double
`snf_pct_copay__s`	double
`snf_pct_copay__w`	double
`snf_pct_coins__s`	double
`snf_pct_coins__w`	double
`snf_coins__s`	double
`snf_coins__w`	double
`otc_pct_one_pot__s`	double
`otc_pct_one_pot__w`	double
`card_pct_dvh_same_pot__s`	double
`card_pct_dvh_same_pot__w`	double
`dental_any_pct_offered__s`	double
`dental_any_pct_offered__w`	double
`dental_comprehensive_pct_offered__s`	double
`dental_comprehensive_pct_offered__w`	double
`svc_transportation_pct_optional_only__s`	double
`svc_transportation_pct_optional_only__w`	double
`svc_fitness_pct_optional_only__s`	double
`svc_fitness_pct_optional_only__w`	double
`svc_meals_post_discharge_pct_optional_only__s`	double
`svc_meals_post_discharge_pct_optional_only__w`	double
`svc_meals_any_pct_optional_only__s`	double
`svc_meals_any_pct_optional_only__w`	double
`svc_podiatry_pct_optional_only__s`	double
`svc_podiatry_pct_optional_only__w`	double
`allowance_total_pct_no_cap__s`	double
`allowance_total_pct_no_cap__w`	double
`otc_pct_d5_pot__s`	double
`otc_pct_d5_pot__w`	double
`card_pct_dvh_shared_pot__s`	double
`card_pct_dvh_shared_pot__w`	double
`allowance_shared_pot_overlap_pmpm__s`	double
`allowance_shared_pot_overlap_pmpm__w`	double
`card_targeted_pct_offered__s`	double
`card_targeted_pct_offered__w`	double
`card_targeted_dollars_pmpm_if__s`	double
`card_targeted_dollars_pmpm_if__w`	double
`svc_transportation_round_trips__s`	double
`svc_transportation_round_trips__w`	double
`moop_pct_not_in_network__s`	double
`moop_pct_not_in_network__w`	double
`card_targeted_pct_ssbci__s`	double
`card_targeted_pct_ssbci__w`	double
`card_targeted_pct_vbid_uf__s`	double
`card_targeted_pct_vbid_uf__w`	double
`card_targeted_pct_no_amount__s`	double
`card_targeted_pct_no_amount__w`	double
`card_targeted_pct_pooled_in_card__s`	double
`card_targeted_pct_pooled_in_card__w`	double
`card_pct_dvh_kind_only__s`	double
`card_pct_dvh_kind_only__w`	double
`allowance_pooled_pct_any__s`	double
`allowance_pooled_pct_any__w`	double
`eyewear_pct_preferred_tier__s`	double
`eyewear_pct_preferred_tier__w`	double
`eyewear_preferred_dollars_pmpm_if__s`	double
`eyewear_preferred_dollars_pmpm_if__w`	double
`dental_pct_d9_added__s`	double
`dental_pct_d9_added__w`	double
`dental_pct_max_combined__s`	double
`dental_pct_max_combined__w`	double
`card_pays_dental__s`	double
`card_pays_dental__w`	double
`card_pays_eyewear__s`	double
`card_pays_eyewear__w`	double
`card_pays_hearing__s`	double
`card_pays_hearing__w`	double
`card_pays_otc__s`	double
`card_pays_otc__w`	double
`card_pays_food_living__s`	double
`card_pays_food_living__w`	double
`card_pays_other__s`	double
`card_pays_other__w`	double
`card_pct_kind_flex__s`	double
`card_pct_kind_flex__w`	double
`card_pct_kind_dvh__s`	double
`card_pct_kind_dvh__w`	double
`card_pct_kind_otc__s`	double
`card_pct_kind_otc__w`	double
`card_pct_kind_food_living__s`	double
`card_pct_kind_food_living__w`	double
`card_pct_kind_wellness__s`	double
`card_pct_kind_wellness__w`	double
`dental_pct_cap_plus_card__s`	double
`dental_pct_cap_plus_card__w`	double
`hearing_pct_cap_plus_card__s`	double
`hearing_pct_cap_plus_card__w`	double
`otc_pct_cap_plus_card__s`	double
`otc_pct_cap_plus_card__w`	double
`eyewear_pct_cap_plus_card__s`	double
`eyewear_pct_cap_plus_card__w`	double
`primary_care_pct_zero__s`	double
`primary_care_pct_zero__w`	double
`specialist_pct_zero__s`	double
`specialist_pct_zero__w`	double
`telehealth_pct_zero__s`	double
`telehealth_pct_zero__w`	double
`mental_health_ind_pct_zero__s`	double
`mental_health_ind_pct_zero__w`	double
`physical_therapy_pct_zero__s`	double
`physical_therapy_pct_zero__w`	double
`er_pct_zero__s`	double
`er_pct_zero__w`	double
`urgent_pct_zero__s`	double
`urgent_pct_zero__w`	double
`ambulance_ground_pct_zero__s`	double
`ambulance_ground_pct_zero__w`	double
`outpatient_hosp_pct_zero__s`	double
`outpatient_hosp_pct_zero__w`	double
`imaging_complex_pct_zero__s`	double
`imaging_complex_pct_zero__w`	double
`radiology_pct_zero__s`	double
`radiology_pct_zero__w`	double
`lab_pct_zero__s`	double
`lab_pct_zero__w`	double
`inpatient_pct_zero__s`	double
`inpatient_pct_zero__w`	double
`snf_pct_zero__s`	double
`snf_pct_zero__w`	double
`dsnp_enrolls_full_duals__s`	double
`dsnp_enrolls_full_duals__w`	double
`primary_care_dual_effective__s`	double
`primary_care_dual_effective__w`	double
`specialist_dual_effective__s`	double
`specialist_dual_effective__w`	double
`telehealth_dual_effective__s`	double
`telehealth_dual_effective__w`	double
`mental_health_ind_dual_effective__s`	double
`mental_health_ind_dual_effective__w`	double
`physical_therapy_dual_effective__s`	double
`physical_therapy_dual_effective__w`	double
`er_dual_effective__s`	double
`er_dual_effective__w`	double
`urgent_dual_effective__s`	double
`urgent_dual_effective__w`	double
`ambulance_ground_dual_effective__s`	double
`ambulance_ground_dual_effective__w`	double
`outpatient_hosp_dual_effective__s`	double
`outpatient_hosp_dual_effective__w`	double
`imaging_complex_dual_effective__s`	double
`imaging_complex_dual_effective__w`	double
`radiology_dual_effective__s`	double
`radiology_dual_effective__w`	double
`lab_dual_effective__s`	double
`lab_dual_effective__w`	double
`inpatient_dual_effective__s`	double
`inpatient_dual_effective__w`	double
`snf_dual_effective__s`	double
`snf_dual_effective__w`	double
`moop_dual_effective__s`	double
`moop_dual_effective__w`	double
`medical_deductible_dual_effective__s`	double
`medical_deductible_dual_effective__w`	double
`telehealth_pct_offered__s`	double
`telehealth_pct_offered__w`	double
`primary_care_ll_known__s`	double
`primary_care_ll_known__w`	double
`primary_care_llc_from__s`	double
`primary_care_llc_from__w`	double
`primary_care_llc_to__s`	double
`primary_care_llc_to__w`	double
`primary_care_lli_from__s`	double
`primary_care_lli_from__w`	double
`primary_care_lli_to__s`	double
`primary_care_lli_to__w`	double
`primary_care_sw_coins__s`	double
`primary_care_sw_coins__w`	double
`primary_care_sw_copay__s`	double
`primary_care_sw_copay__w`	double
`specialist_ll_known__s`	double
`specialist_ll_known__w`	double
`specialist_llc_from__s`	double
`specialist_llc_from__w`	double
`specialist_llc_to__s`	double
`specialist_llc_to__w`	double
`specialist_lli_from__s`	double
`specialist_lli_from__w`	double
`specialist_lli_to__s`	double
`specialist_lli_to__w`	double
`specialist_sw_coins__s`	double
`specialist_sw_coins__w`	double
`specialist_sw_copay__s`	double
`specialist_sw_copay__w`	double
`telehealth_ll_known__s`	double
`telehealth_ll_known__w`	double
`telehealth_llc_from__s`	double
`telehealth_llc_from__w`	double
`telehealth_llc_to__s`	double
`telehealth_llc_to__w`	double
`telehealth_lli_from__s`	double
`telehealth_lli_from__w`	double
`telehealth_lli_to__s`	double
`telehealth_lli_to__w`	double
`telehealth_sw_coins__s`	double
`telehealth_sw_coins__w`	double
`telehealth_sw_copay__s`	double
`telehealth_sw_copay__w`	double
`mental_health_ind_ll_known__s`	double
`mental_health_ind_ll_known__w`	double
`mental_health_ind_llc_from__s`	double
`mental_health_ind_llc_from__w`	double
`mental_health_ind_llc_to__s`	double
`mental_health_ind_llc_to__w`	double
`mental_health_ind_lli_from__s`	double
`mental_health_ind_lli_from__w`	double
`mental_health_ind_lli_to__s`	double
`mental_health_ind_lli_to__w`	double
`mental_health_ind_sw_coins__s`	double
`mental_health_ind_sw_coins__w`	double
`mental_health_ind_sw_copay__s`	double
`mental_health_ind_sw_copay__w`	double
`physical_therapy_ll_known__s`	double
`physical_therapy_ll_known__w`	double
`physical_therapy_llc_from__s`	double
`physical_therapy_llc_from__w`	double
`physical_therapy_llc_to__s`	double
`physical_therapy_llc_to__w`	double
`physical_therapy_lli_from__s`	double
`physical_therapy_lli_from__w`	double
`physical_therapy_lli_to__s`	double
`physical_therapy_lli_to__w`	double
`physical_therapy_sw_coins__s`	double
`physical_therapy_sw_coins__w`	double
`physical_therapy_sw_copay__s`	double
`physical_therapy_sw_copay__w`	double
`er_ll_known__s`	double
`er_ll_known__w`	double
`er_llc_from__s`	double
`er_llc_from__w`	double
`er_llc_to__s`	double
`er_llc_to__w`	double
`er_lli_from__s`	double
`er_lli_from__w`	double
`er_lli_to__s`	double
`er_lli_to__w`	double
`er_sw_coins__s`	double
`er_sw_coins__w`	double
`er_sw_copay__s`	double
`er_sw_copay__w`	double
`urgent_ll_known__s`	double
`urgent_ll_known__w`	double
`urgent_llc_from__s`	double
`urgent_llc_from__w`	double
`urgent_llc_to__s`	double
`urgent_llc_to__w`	double
`urgent_lli_from__s`	double
`urgent_lli_from__w`	double
`urgent_lli_to__s`	double
`urgent_lli_to__w`	double
`urgent_sw_coins__s`	double
`urgent_sw_coins__w`	double
`urgent_sw_copay__s`	double
`urgent_sw_copay__w`	double
`ambulance_ground_ll_known__s`	double
`ambulance_ground_ll_known__w`	double
`ambulance_ground_llc_from__s`	double
`ambulance_ground_llc_from__w`	double
`ambulance_ground_llc_to__s`	double
`ambulance_ground_llc_to__w`	double
`ambulance_ground_lli_from__s`	double
`ambulance_ground_lli_from__w`	double
`ambulance_ground_lli_to__s`	double
`ambulance_ground_lli_to__w`	double
`ambulance_ground_sw_coins__s`	double
`ambulance_ground_sw_coins__w`	double
`ambulance_ground_sw_copay__s`	double
`ambulance_ground_sw_copay__w`	double
`outpatient_hosp_ll_known__s`	double
`outpatient_hosp_ll_known__w`	double
`outpatient_hosp_llc_from__s`	double
`outpatient_hosp_llc_from__w`	double
`outpatient_hosp_llc_to__s`	double
`outpatient_hosp_llc_to__w`	double
`outpatient_hosp_lli_from__s`	double
`outpatient_hosp_lli_from__w`	double
`outpatient_hosp_lli_to__s`	double
`outpatient_hosp_lli_to__w`	double
`outpatient_hosp_sw_coins__s`	double
`outpatient_hosp_sw_coins__w`	double
`outpatient_hosp_sw_copay__s`	double
`outpatient_hosp_sw_copay__w`	double
`imaging_complex_ll_known__s`	double
`imaging_complex_ll_known__w`	double
`imaging_complex_llc_from__s`	double
`imaging_complex_llc_from__w`	double
`imaging_complex_llc_to__s`	double
`imaging_complex_llc_to__w`	double
`imaging_complex_lli_from__s`	double
`imaging_complex_lli_from__w`	double
`imaging_complex_lli_to__s`	double
`imaging_complex_lli_to__w`	double
`imaging_complex_sw_coins__s`	double
`imaging_complex_sw_coins__w`	double
`imaging_complex_sw_copay__s`	double
`imaging_complex_sw_copay__w`	double
`radiology_ll_known__s`	double
`radiology_ll_known__w`	double
`radiology_llc_from__s`	double
`radiology_llc_from__w`	double
`radiology_llc_to__s`	double
`radiology_llc_to__w`	double
`radiology_lli_from__s`	double
`radiology_lli_from__w`	double
`radiology_lli_to__s`	double
`radiology_lli_to__w`	double
`radiology_sw_coins__s`	double
`radiology_sw_coins__w`	double
`radiology_sw_copay__s`	double
`radiology_sw_copay__w`	double
`lab_ll_known__s`	double
`lab_ll_known__w`	double
`lab_llc_from__s`	double
`lab_llc_from__w`	double
`lab_llc_to__s`	double
`lab_llc_to__w`	double
`lab_lli_from__s`	double
`lab_lli_from__w`	double
`lab_lli_to__s`	double
`lab_lli_to__w`	double
`lab_sw_coins__s`	double
`lab_sw_coins__w`	double
`lab_sw_copay__s`	double
`lab_sw_copay__w`	double
`inpatient_ll_known__s`	double
`inpatient_ll_known__w`	double
`inpatient_llc_from__s`	double
`inpatient_llc_from__w`	double
`inpatient_llc_to__s`	double
`inpatient_llc_to__w`	double
`inpatient_lli_from__s`	double
`inpatient_lli_from__w`	double
`inpatient_lli_to__s`	double
`inpatient_lli_to__w`	double
`inpatient_sw_coins__s`	double
`inpatient_sw_coins__w`	double
`inpatient_sw_copay__s`	double
`inpatient_sw_copay__w`	double
`snf_ll_known__s`	double
`snf_ll_known__w`	double
`snf_llc_from__s`	double
`snf_llc_from__w`	double
`snf_llc_to__s`	double
`snf_llc_to__w`	double
`snf_lli_from__s`	double
`snf_lli_from__w`	double
`snf_lli_to__s`	double
`snf_lli_to__w`	double
`snf_sw_coins__s`	double
`snf_sw_coins__w`	double
`snf_sw_copay__s`	double
`snf_sw_copay__w`	double
`dental_st_dedicated__s`	double
`dental_st_dedicated__w`	double
`dental_st_pooled_card__s`	double
`dental_st_pooled_card__w`	double
`dental_st_offered_no_max__s`	double
`dental_st_offered_no_max__w`	double
`dental_st_optional_rider__s`	double
`dental_st_optional_rider__w`	double
`dental_st_period_unknown__s`	double
`dental_st_period_unknown__w`	double
`dental_st_not_offered__s`	double
`dental_st_not_offered__w`	double
`dental_st_not_filed__s`	double
`dental_st_not_filed__w`	double
`dental_st_other__s`	double
`dental_st_other__w`	double
`eyewear_st_dedicated__s`	double
`eyewear_st_dedicated__w`	double
`eyewear_st_pooled_card__s`	double
`eyewear_st_pooled_card__w`	double
`eyewear_st_offered_no_max__s`	double
`eyewear_st_offered_no_max__w`	double
`eyewear_st_period_unknown__s`	double
`eyewear_st_period_unknown__w`	double
`eyewear_st_not_offered__s`	double
`eyewear_st_not_offered__w`	double
`eyewear_st_not_filed__s`	double
`eyewear_st_not_filed__w`	double
`eyewear_st_other__s`	double
`eyewear_st_other__w`	double
`hearing_st_dedicated__s`	double
`hearing_st_dedicated__w`	double
`hearing_st_pooled_card__s`	double
`hearing_st_pooled_card__w`	double
`hearing_st_offered_no_max__s`	double
`hearing_st_offered_no_max__w`	double
`hearing_st_period_unknown__s`	double
`hearing_st_period_unknown__w`	double
`hearing_st_not_offered__s`	double
`hearing_st_not_offered__w`	double
`hearing_st_not_filed__s`	double
`hearing_st_not_filed__w`	double
`hearing_st_other__s`	double
`hearing_st_other__w`	double
`otc_st_dedicated__s`	double
`otc_st_dedicated__w`	double
`otc_st_pooled_card__s`	double
`otc_st_pooled_card__w`	double
`otc_st_offered_no_max__s`	double
`otc_st_offered_no_max__w`	double
`otc_st_not_offered__s`	double
`otc_st_not_offered__w`	double
`otc_st_not_filed__s`	double
`otc_st_not_filed__w`	double
`otc_st_other__s`	double
`otc_st_other__w`	double
`giveback_st_filed__s`	double
`giveback_st_filed__w`	double
`giveback_st_not_filed__s`	double
`giveback_st_not_filed__w`	double
`giveback_st_other__s`	double
`giveback_st_other__w`	double
`dental_pkg_mand_only__s`	double
`dental_pkg_mand_only__w`	double
`dental_pkg_mand_and_rider__s`	double
`dental_pkg_mand_and_rider__w`	double
`dental_pkg_rider_only__s`	double
`dental_pkg_rider_only__w`	double
`dental_pkg_none__s`	double
`dental_pkg_none__w`	double
`premium__c`	double
`moop__c`	double
`medical_deductible__c`	double
`partd_deductible__c`	double
`primary_care__c`	double
`specialist__c`	double
`telehealth__c`	double
`mental_health_ind__c`	double
`er__c`	double
`urgent__c`	double
`ambulance_ground__c`	double
`hosp_5day__c`	double
`inpatient__c`	double
`snf__c`	double
`outpatient_hosp__c`	double
`asc__c`	double
`imaging_complex__c`	double
`radiology__c`	double
`lab__c`	double
`physical_therapy__c`	double
`dme__c`	double
`partb_drugs__c`	double
`partb_insulin__c`	double
`dialysis__c`	double
`partd_tier1_copay__c`	double
`partd_tier2_copay__c`	double
`partd_tier4_coins__c`	double
`partd_tier5_coins__c`	double

Query it

describe_data_source(source_fqn="medicare_semantic.vw_benefit_reading_cells")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_benefit_reading_cells 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_cells")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_benefit_reading_cells

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