Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_hos_puf_respondent_v2·live·semantic_view

Rows

2,712,105

Columns

178

History

N/A

Card

nocolumns only

Typed tools

What it is

1Anonymised 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

Key	Grain
N/A	1One row per (puf_file, case_id): one anonymised respondent in one cohort file.

Columns (178)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`puf_file,case_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_hos_puf_respondent_v2")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hos_puf_respondent_v2
Note	Register source cms_hos_puf (w3, serve raw). RAW, through the documented-name view medicare_semantic.vw_hos_puf_respondent_v2 (created 2026-09-30, Athena 0b537b3d; view rows = table rows = 2,712,105, age_group EXCEPT age = 0; pipelines/medicare/semantic/hos_puf_respondent_v2.sql). The physical medicare_silver.hos_puf_respondent is unchanged and not registered. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 0 duplicate (puf_file, case_id); Athena d80723fd, 9d208055). Cell reconciliation PASS on c18a, c22a, c26b, c27b (168 fields each). Registered 2026-09-30.

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