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, 2020

Data Source

American Community Survey (ACS)

Demographics
Housing
Community Infrastructure

Calculation Methodology

  1. 1
    Filter the dataset to include individuals aged 65 or older using the column AGEP.
  2. 2
    Derive income group categories 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 poverty level filter using the column POVPIP to separate groups below 200% FPL (POVPIP < 200) and above 200% FPL (POVPIP >= 200).
  4. 4
    Use the column STATE to group data by state for aggregation.
  5. 5
    Apply the weight column PWGTP to calculate weighted counts for each income group within each state and poverty level category.
  6. 6
    Calculate the share of adults aged 65 or older in each income group by dividing the weighted count of each group by the total weighted population aged 65 or older within the same state and poverty level category.

Source Variables using this Indicator (17)

Visuals Using This Indicator (1)

Visual for Indicator Retirement Income & Social Security for 2020

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

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.