# Medicare Advantage Geographic Variation, national and state, 2016-2023

`medicare_silver.fact_ma_geographic_variation` · Medicare Advantage, Part D, Medicaid · status live · 432 rows

MA enrollees' demographics and service use per state and nationally per year, 2016-2023, from encounter data: users, share of enrollees (a proportion 0-1) and stays / days / events per 1,000 for 15 service types. 2023 national: 31,848,969 full-year MA enrollees, 13.29% with an inpatient stay, 205.16 stays per 1,000.

**Grain.** One row per (year, state, bene_geo_cd) per release; is_current marks the newest release.

| column | type | meaning |
|---|---|---|
| publisher_version | string |  |
| year | int |  |
| bene_geo_lvl | string |  |
| state | string |  |
| bene_geo_cd | string |  |
| benes_ma_cnt | bigint |  |
| bene_avg_age | double |  |
| bene_feml_pct | double |  |
| bene_male_pct | double |  |
| bene_race_wht_pct | double |  |
| bene_race_black_pct | double |  |
| bene_race_hspnc_pct | double |  |
| bene_race_othr_pct | double |  |
| bene_dual_pct | double |  |
| benes_ip_stay_cnt | bigint |  |
| benes_ip_pct | double |  |
| ip_stays_per_1000_benes | double |  |
| ip_days_per_1000_benes | double |  |
| benes_irf_cnt | bigint |  |
| benes_irf_pct | double |  |
| irf_stays_per_1000_benes | double |  |
| irf_days_per_1000_benes | double |  |
| benes_ltc_cnt | bigint |  |
| benes_ltc_pct | double |  |
| ltc_stays_per_1000_benes | double |  |
| ltc_days_per_1000_benes | double |  |
| benes_snf_cnt | bigint |  |
| benes_snf_pct | double |  |
| snf_stays_per_1000_benes | double |  |
| snf_days_per_1000_benes | double |  |
| benes_em_cnt | bigint |  |
| benes_em_pct | double |  |
| em_events_per_1000_benes | double |  |
| benes_prcdrs_cnt | bigint |  |
| benes_prcdrs_pct | double |  |
| prcdrs_events_per_1000_benes | double |  |
| benes_tests_cnt | bigint |  |
| benes_tests_pct | double |  |
| tests_events_per_1000_benes | double |  |
| benes_imgng_cnt | bigint |  |
| benes_imgng_pct | double |  |
| imgng_events_per_1000_benes | double |  |
| benes_dme_cnt | bigint |  |
| benes_dme_pct | double |  |
| dme_events_per_1000_benes | double |  |
| benes_amblnc_cnt | bigint |  |
| benes_amblnc_pct | double |  |
| amblnc_events_per_1000_benes | double |  |
| benes_trtmnt_cnt | bigint |  |
| benes_trtmnt_pct | double |  |
| trtmnt_events_per_1000_benes | double |  |
| benes_op_dlys_cnt | bigint |  |
| benes_op_dlys_pct | double |  |
| op_dlys_visits_per_1000_benes | double |  |
| benes_fqhc_rhc_cnt | bigint |  |
| benes_fqhc_rhc_pct | double |  |
| fqhc_rhc_visits_per_1000_benes | double |  |
| benes_op_cnt | bigint |  |
| benes_op_pct | double |  |
| op_visits_per_1000_benes | double |  |
| benes_er_visits_cnt | bigint |  |
| benes_er_visits_pct | double |  |
| er_visits_per_1000_benes | double |  |
| suppressed_measure_count | int |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

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