West HealthGallupMosaic
West Health mosaic Logo
indicator

Income Sources

Income Sources

Description

Age Distribution of Various Types of Income Sources, 2023

Data Source

American Community Survey (ACS)

Demographics
Housing
Community Infrastructure
View Details

Calculation Methodology

  1. 1
    Select records from the ACS dataset using the columns AGEP, RETP, SSP, FS, TYPEHUGQ, WAGP, STATE, and PWGTP.
  2. 2
    Derive age groups from AGEP by binning into ranges: 18-34, 35-49, 50-64, 65-79, and 80+, corresponding to labels Age 18-34, Age 35-49, Age 50-64, Age 65-79, and Age 80+.
  3. 3
    Identify Public Benefits recipients where FS=1 and TYPEHUGQ=1.
  4. 4
    Identify Social Security recipients where SSP > 0.
  5. 5
    Identify Retirement Income recipients where RETP > 0.
  6. 6
    Identify Earnings from Work recipients where WAGP > 0.
  7. 7
    Calculate weighted counts for each income source category by age group using the weight column PWGTP.
  8. 8
    Aggregate the weighted counts by AGEP bins to produce the stacked bar chart showing the age distribution of income sources.

Source Variables using this Indicator (24)

Visuals Using This Indicator (1)

Visual for Indicator Income Sources for 2023

Age Distribution of Various Types of Income Sources, 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.