State Of Aging In Allegheny County Survey by US Government | Demographics and Population Studies

About this Dataset

State Of Aging In Allegheny County Survey

For more than three decades UCSUR has documented the status of older adults in the County along multiple life domains. Every decade we issue a comprehensive report on aging in Allegheny County and this report represents our most recent effort. It documents important shifts in the demographic profile of the population in the last three decades, characterizes the current status of the elderly in multiple life domains, and looks ahead to the future of aging in the County. This report is unique in that we examine not only those aged 65 and older, but also the next generation old persons, the Baby Boomers. Collaborators on this project include the Allegheny County Area Agency on Aging, the United Way of Allegheny County, and the Aging Institute of UPMC Senior Services and the University of Pittsburgh.

The purpose of this report is to provide a comprehensive analysis of aging in Allegheny County. To this end, we integrate survey data collected from a representative sample of older county residents with secondary data available from Federal, State, and County agencies to characterize older individuals on multiple dimensions, including demographic change and population projections, income, work and retirement, neighborhoods and housing, health, senior service use, transportation, volunteering, happiness and life satisfaction, among others. Since baby boomers represent the future of aging in the County we include data for those aged 55-64 as well as those aged 65 and older.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:57.569990
Tags: aging, allegheny-county, gerontology, older-adults, survey

Tables

Survey Results

@usgov.allegheny_county_city_of_pitts_state_of_aging_in_alleg_b89162c4.survey_results

507.98 KB
1049 rows
381 columns


CREATE TABLE survey_results (
  "id" BIGINT,
  "happy1" BIGINT,
  "happy2" BIGINT,
  "work1" BIGINT,
  "work2" VARCHAR,
  "work3" VARCHAR,
  "work4" VARCHAR,
  "work6" VARCHAR,
  "work7" VARCHAR,
  "work5" VARCHAR,
  "work8_1" VARCHAR,
  "work8_2" VARCHAR,
  "work8_3" VARCHAR,
  "work8_4" VARCHAR,
  "work8_5" VARCHAR,
  "work8_6" VARCHAR,
  "work8_7" VARCHAR,
  "work8open" VARCHAR,
  "work8_8" VARCHAR,
  "work8_9" VARCHAR,
  "work8_10" VARCHAR,
  "work9" VARCHAR,
  "work10" VARCHAR,
  "work11" VARCHAR,
  "work12" VARCHAR,
  "work13" VARCHAR,
  "work14" VARCHAR,
  "work15" VARCHAR,
  "conf1" BIGINT,
  "conf2" BIGINT,
  "conf3" BIGINT,
  "conf4" BIGINT,
  "conf5" BIGINT,
  "conf6" BIGINT,
  "conf7open" VARCHAR,
  "conf8" BIGINT,
  "conf9" BIGINT,
  "conf10" BIGINT,
  "conf11" BIGINT,
  "inc1" BIGINT,
  "inc2" BIGINT,
  "inc3" BIGINT,
  "inc4" BIGINT,
  "inc5" BIGINT,
  "inc6" BIGINT,
  "inc7" BIGINT,
  "inc8" BIGINT,
  "inc9" BIGINT,
  "inc10" VARCHAR,
  "inc11" VARCHAR,
  "inc12" VARCHAR,
  "inc13" VARCHAR,
  "inc14" VARCHAR,
  "inc15" BIGINT,
  "inc16" BIGINT,
  "inc17" BIGINT,
  "inc18" BIGINT,
  "inc19" BIGINT,
  "inc20" BIGINT,
  "liv1" BIGINT,
  "liv1open" VARCHAR,
  "liv2" VARCHAR,
  "liv3" VARCHAR,
  "liv4_1" VARCHAR,
  "liv4_2" VARCHAR,
  "liv4_3" VARCHAR,
  "liv4_4" VARCHAR,
  "liv4_5" VARCHAR,
  "liv4_6" VARCHAR,
  "liv4_7" VARCHAR,
  "liv4_8" VARCHAR,
  "liv5" VARCHAR,
  "liv6" BIGINT,
  "liv7" BIGINT,
  "liv7open" VARCHAR,
  "liv8" BIGINT,
  "liv8open" VARCHAR,
  "liv8a" VARCHAR,
  "liv9" BIGINT,
  "liv9a" BIGINT,
  "liv9b" BIGINT,
  "liv10" BIGINT,
  "liv11" VARCHAR,
  "liv12" VARCHAR,
  "liv13open" VARCHAR,
  "liv14" VARCHAR,
  "liv14open" VARCHAR,
  "liv14a" VARCHAR,
  "liv15" VARCHAR,
  "liv15open" VARCHAR,
  "liv15a" VARCHAR,
  "liv16_1" VARCHAR,
  "liv16_2" VARCHAR,
  "liv16_3" VARCHAR,
  "liv16_4" VARCHAR,
  "liv16_5" VARCHAR,
  "liv16_6" VARCHAR,
  "liv16_7" VARCHAR,
  "liv16_8" VARCHAR,
  "liv16open" VARCHAR
);

Data Dictionary

@usgov.allegheny_county_city_of_pitts_state_of_aging_in_alleg_b89162c4.data_dictionary

25.4 KB
1797 rows
10 columns


CREATE TABLE data_dictionary (
  "variable" VARCHAR,
  "position" DOUBLE,
  "label" VARCHAR,
  "measurement_level" VARCHAR,
  "role" VARCHAR,
  "column_width" DOUBLE,
  "alignment" VARCHAR,
  "print_format" VARCHAR,
  "write_format" VARCHAR,
  "missing_values" VARCHAR
);