# Medicare HOS public use files, respondent level (documented names), cohorts 18-27

`medicare_semantic.vw_hos_puf_respondent_v2` · Medicare Advantage, Part D, Medicaid · status live · 2,712,105 rows

Anonymised Medicare Advantage HOS respondents per cohort file with the publisher's item codes: VR-12 health status, ADLs, chronic conditions, pain, depression, incontinence, activity, falls, sleep, survey mode and disposition, demographics (age_group, race, sex, education) and the CMS plan region. c27b: 341,557 respondents.

**Grain.** One row per (puf_file, case_id): one anonymised respondent in one cohort file.

| column | type | meaning |
|---|---|---|
| puf_file | string |  |
| cohort_number | int |  |
| puf_type | string |  |
| survey_years | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| parser_artifact_hash | string |  |
| asserted_at | timestamp |  |
| is_current | boolean |  |
| case_id | string |  |
| age_group | string |  |
| race | string |  |
| sex | string |  |
| maritl | string |  |
| educ | string |  |
| bmicat | string |  |
| b_vrgenhth | string |  |
| b_vrmact | string |  |
| b_vrstair | string |  |
| b_vrpaccl | string |  |
| b_vrpwork | string |  |
| b_vrmaccl | string |  |
| b_vrmwork | string |  |
| b_vrpain | string |  |
| b_vrcalm | string |  |
| b_vrenergy | string |  |
| b_vrdown | string |  |
| b_vrsact | string |  |
| b_vrphcmp | string |  |
| b_vrmhcmp | string |  |
| b_adlbth | string |  |
| b_adldrs | string |  |
| b_adleat | string |  |
| b_adlchr | string |  |
| b_adlwlk | string |  |
| b_adltlt | string |  |
| b_difmeals | string |  |
| b_difmoney | string |  |
| b_difmeds | string |  |
| b_hdphy | string |  |
| b_hdmen | string |  |
| b_hdact | string |  |
| b_difsee | string |  |
| b_difhear | string |  |
| b_difremem | string |  |
| b_diferrnd | string |  |
| b_difmprob | string |  |
| b_cchbp | string |  |
| b_cc_cad | string |  |
| b_cc_chf | string |  |
| b_ccmi | string |  |
| b_cchrtoth | string |  |
| b_ccstroke | string |  |
| b_cc_copd | string |  |
| b_ccgi | string |  |
| b_ccosteo | string |  |
| b_ccdiabet | string |  |
| b_ccdep | string |  |
| b_ccanyca | string |  |
| b_cacolon | string |  |
| b_calung | string |  |
| b_cabrst | string |  |
| b_capros | string |  |
| b_caother | string |  |
| b_paindact | string |  |
| b_painsact | string |  |
| b_painrate | string |  |
| b_depnopls | string |  |
| b_depdown | string |  |
| b_cmphth | string |  |
| b_muilkg | string |  |
| b_muidact | string |  |
| b_muitlk | string |  |
| b_muitrt | string |  |
| b_paotlk | string |  |
| b_paoadv | string |  |
| b_frmtlk | string |  |
| b_frmfall | string |  |
| b_frmbal | string |  |
| b_frmprev | string |  |
| b_sleephrs | string |  |
| b_sleepqua | string |  |
| b_speaklng | string |  |
| b_cmpwho | string |  |
| b_srvdisp | string |  |
| b_srvmode | string |  |
| b_pctans | string |  |
| cohort | string |  |
| b_plregcde | string |  |
| b_srvlang | string |  |
| b_pctcmp | string |  |
| mrstat | string |  |
| f_vrgenhth | string |  |
| f_vrmact | string |  |
| f_vrstair | string |  |
| f_vrpaccl | string |  |
| f_vrpwork | string |  |
| f_vrmaccl | string |  |
| f_vrmwork | string |  |
| f_vrpain | string |  |
| f_vrcalm | string |  |
| f_vrenergy | string |  |
| f_vrdown | string |  |
| f_vrsact | string |  |
| f_vrphcmp | string |  |
| f_vrmhcmp | string |  |
| f_adlbth | string |  |
| f_adldrs | string |  |
| f_adleat | string |  |
| f_adlchr | string |  |
| f_adlwlk | string |  |
| f_adltlt | string |  |
| f_difmeals | string |  |
| f_difmoney | string |  |
| f_difmeds | string |  |
| f_hdphy | string |  |
| f_hdmen | string |  |
| f_hdact | string |  |
| f_difsee | string |  |
| f_difhear | string |  |
| f_difremem | string |  |
| f_diferrnd | string |  |
| f_difmprob | string |  |
| f_cchbp | string |  |
| f_cc_cad | string |  |
| f_cc_chf | string |  |
| f_ccmi | string |  |
| f_cchrtoth | string |  |
| f_ccstroke | string |  |
| f_cc_copd | string |  |
| f_ccgi | string |  |
| f_ccosteo | string |  |
| f_ccdiabet | string |  |
| f_ccdep | string |  |
| f_ccanyca | string |  |
| f_cacolon | string |  |
| f_calung | string |  |
| f_cabrst | string |  |
| f_capros | string |  |
| f_caother | string |  |
| f_paindact | string |  |
| f_painsact | string |  |
| f_painrate | string |  |
| f_depnopls | string |  |
| f_depdown | string |  |
| f_cmphth | string |  |
| f_muilkg | string |  |
| f_muidact | string |  |
| f_muitlk | string |  |
| f_muitrt | string |  |
| f_paotlk | string |  |
| f_paoadv | string |  |
| f_frmtlk | string |  |
| f_frmfall | string |  |
| f_frmbal | string |  |
| f_frmprev | string |  |
| f_sleephrs | string |  |
| f_sleepqua | string |  |
| f_speaklng | string |  |
| f_cmpwho | string |  |
| f_srvdisp | string |  |
| f_srvmode | string |  |
| f_pctans | string |  |
| f_srvlang | string |  |
| p_plregcde | string |  |
| sampled | string |  |
| sflag | string |  |
| b_ccarthip | string |  |
| b_ccarthnd | string |  |
| b_ccsciati | string |  |
| b_smoke | string |  |
| f_pctcmp | string |  |
| b_ototest | string |  |
| f_ccarthip | string |  |
| f_ccarthnd | string |  |
| f_ccsciati | string |  |
| f_smoke | string |  |
| f_ototest | string |  |

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