West HealthGallupMosaic
West Health mosaic Logo
indicator

Retirement Income & Social Security

Retirement Income & Social Security

Description

Share of Adults Age 65 or Older with Retirement and/or Social Security Income, by Federal Poverty Level, 2023

Data Source

American Community Survey (ACS)

Demographics
Housing
Community Infrastructure
View Details

Calculation Methodology

  1. 1
    Select individuals aged 65 or older using the AGEP column with the condition AGEP >= 65.
  2. 2
    Derive income groups from the columns RETP and SSP as follows: Retirement Income Only if RETP > 0 and SSP = 0; Social Security Income Only if RETP = 0 and SSP > 0; Both Retirement and Social Security Income if RETP > 0 and SSP > 0; Neither Retirement nor Social Security Income if RETP = 0 and SSP = 0.
  3. 3
    Apply the weight column PWGTP to all records to account for survey sampling design.
  4. 4
    Filter data by federal poverty level using the POVPIP column: below 200% FPL for values < 200 and above 200% FPL for values >= 200.
  5. 5
    Aggregate weighted counts by income_groups categories within each STATE to calculate the share of adults with each income group status.
  6. 6
    Present the results as a stacked bar chart showing the distribution of income groups by federal poverty level for adults aged 65 or older.

Source Variables using this Indicator (17)

Visuals Using This Indicator (1)

Visual for Indicator Retirement Income & Social Security for 2023

Share of Adults Age 65 or Older with Retirement and/or Social Security Income, by Federal Poverty Level, 2023

View visualization

Why This Matters

Transparent methodology ensures every insight can be traced, verified, and built upon.

Reproducible Research

Every calculation can be traced back to its source. Our methodology documentation enables researchers to replicate findings and build upon our work.

Accountability

Clear attribution and citation requirements ensure proper credit to data providers and maintain research integrity.

Continuous Improvement

Transparent documentation allows for peer review, feedback, and iterative improvements to our analytical approaches.