About this Dataset

1984 Community Profiles: A Descriptive Picture Of Communities In Allegheny County

This compilation includes 8 historical datasets, part of the collection of the Pittsburgh University Library System. Prepared by the Health and Welfare Planning Association, and funded by the Richard King Melon Foundation, the profiles were intended to inform the people, organizations and businesses of Allegheny County about the characteristics of the communities in which they lived, worked and played so they could make better decisions.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:51:05.058656
Tags: 1984, community-profiles, employment, households, housing-units, income, pittsburgh, population

Tables

Civics

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.civics

17.1 KB
218 rows
11 columns


CREATE TABLE civics (
  "community" VARCHAR,
  "n__grad_high_sch" DOUBLE,
  "n__grad_coll" BIGINT,
  "students_k_8" BIGINT,
  "students_9_12" BIGINT,
  "enrolled_coll" BIGINT,
  "reg_voters_1982" BIGINT,
  "n__voted_1982_general" DOUBLE,
  "n__dem" DOUBLE,
  "n__rep" BIGINT,
  "n__ind" DOUBLE
);

Employment By Industry

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.employment_by_industry

22.97 KB
218 rows
23 columns


CREATE TABLE employment_by_industry (
  "community" VARCHAR,
  "n__agri_fish_mining_area" BIGINT,
  "n__agri_fish_mining_city" BIGINT,
  "n__construction_area" BIGINT,
  "n__construction_city" BIGINT,
  "n__manufact_area" BIGINT,
  "n__manufact_city" BIGINT,
  "n__transp_util_comm_area" BIGINT,
  "n__transp_util_comm_city" BIGINT,
  "n__trade_area" BIGINT,
  "n__trade_city" BIGINT,
  "n__fin_ins_real_est_area" BIGINT,
  "n__fin_ins_real_est_city" BIGINT,
  "n__business_svcs_area" BIGINT,
  "n__business_svcs_city" DOUBLE,
  "n__personal_entert_svcs_area" BIGINT,
  "n__personal_entert_svcs_city" BIGINT,
  "n__health_svcs_area" BIGINT,
  "n__health_svcs_city" BIGINT,
  "n__education_area" BIGINT,
  "n__education_city" BIGINT,
  "n__other_prof_svcs_area" BIGINT,
  "n__other_prof_svcs_city" BIGINT
);

Employment By Occupation

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.employment_by_occupation

14.91 KB
218 rows
13 columns


CREATE TABLE employment_by_occupation (
  "community" VARCHAR,
  "n__manager_area" BIGINT,
  "n__manager_city" BIGINT,
  "n__sales_clerical_tech_area" BIGINT,
  "n__sales_clerical_tech_city" BIGINT,
  "n__services_area" BIGINT,
  "n__services_city" BIGINT,
  "n__precision_prod_constr_area" BIGINT,
  "n__precision_prod_constr_city" BIGINT,
  "n__machine_oper_inspectors_area" BIGINT,
  "n__machine_oper_inspectors_city" BIGINT,
  "n__laborers_other_area" BIGINT,
  "n__laborers_other_city" BIGINT
);

Households

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.households

16.38 KB
218 rows
11 columns


CREATE TABLE households (
  "community" VARCHAR,
  "number_families" BIGINT,
  "n__family_children_under18" DOUBLE,
  "number_persons_household" DOUBLE,
  "number_persons_family" DOUBLE,
  "n__moved_last_5yrs" DOUBLE,
  "n__married_couple_family" DOUBLE,
  "n__single_parent_family" DOUBLE,
  "n__single_person" DOUBLE,
  "n__non_family" DOUBLE,
  "n__seniors_live_alone" DOUBLE
);

Housing Units

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.housing_units

17.43 KB
218 rows
10 columns


CREATE TABLE housing_units (
  "community" VARCHAR,
  "total_number" BIGINT,
  "median_value" DOUBLE,
  "median_rent" VARCHAR,
  "renter_occupied" BIGINT,
  "n__renter_occupied" DOUBLE,
  "owner_occupied" BIGINT,
  "n__owner_occupied" DOUBLE,
  "vacant" BIGINT,
  "n__vacant" DOUBLE
);

Income

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.income

25.37 KB
218 rows
20 columns


CREATE TABLE income (
  "community" VARCHAR,
  "median_household" DOUBLE,
  "median_family" DOUBLE,
  "n__earned" VARCHAR,
  "n__self_empl" DOUBLE,
  "n__investment" DOUBLE,
  "n__soc_sec" DOUBLE,
  "n__public_asst" DOUBLE,
  "n__other" DOUBLE,
  "percent_0_4_999" DOUBLE,
  "percent_5_000_9_999" DOUBLE,
  "percent_10_000_14_999" DOUBLE,
  "percent_15_000_19_999" DOUBLE,
  "percent_20_000_24_999" DOUBLE,
  "percent_25_000_34_999" DOUBLE,
  "percent_35_000_49_999" DOUBLE,
  "percent_50_000" DOUBLE,
  "n__fam_below_pov" VARCHAR,
  "n__people_below_pov" DOUBLE,
  "n__elderly_below_pov" DOUBLE
);

Labor Force

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.labor_force

23.11 KB
218 rows
17 columns


CREATE TABLE labor_force (
  "community" VARCHAR,
  "n__women_empl" DOUBLE,
  "n__women_unempl" DOUBLE,
  "n__women_not_labor_force" DOUBLE,
  "n__men_empl" BIGINT,
  "n__men_unempl" BIGINT,
  "n__men_not_labor_force" BIGINT,
  "n__partial_unempl" DOUBLE,
  "n__part_time_empl" DOUBLE,
  "number_fam_no_worker" BIGINT,
  "n__fam_no_worker" DOUBLE,
  "number_fam_one_worker" BIGINT,
  "n__fam_one_worker" BIGINT,
  "number_fam_two_workers" BIGINT,
  "n__fam_two_workers" DOUBLE,
  "n__work_in_pitt" DOUBLE,
  "n__work_out_pitt" DOUBLE
);

Population

@usgov.allegheny_county_city_of_pitts_1984_community_profiles_ba6cbd47.population

23.58 KB
218 rows
20 columns


CREATE TABLE population (
  "community" VARCHAR,
  "pop_total" VARCHAR,
  "n__race_white" DOUBLE,
  "n__race_black" DOUBLE,
  "n__race_other" DOUBLE,
  "n__age_0_4" DOUBLE,
  "n__age_5_18" DOUBLE,
  "n__age_19_44" DOUBLE,
  "n__age_45_64" DOUBLE,
  "n__age_65" DOUBLE,
  "n__fem_married" DOUBLE,
  "n__fem_single" DOUBLE,
  "n__fem_sep" DOUBLE,
  "n__fem_widowed" DOUBLE,
  "n__fem_under15_married" DOUBLE,
  "n__male_married" DOUBLE,
  "n__male_single" DOUBLE,
  "n__male_sep" DOUBLE,
  "n__male_widowed" DOUBLE,
  "n__male_under15_married" DOUBLE
);