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

CREATE TABLE employment_by_industry (
  "community" VARCHAR,
  "n__agri_fish_mining_area" BIGINT  -- %agri Fish Mining Area,
  "n__agri_fish_mining_city" BIGINT  -- %agri Fish Mining City,
  "n__construction_area" BIGINT  -- %construction Area,
  "n__construction_city" BIGINT  -- %construction City,
  "n__manufact_area" BIGINT  -- %manufact Area,
  "n__manufact_city" BIGINT  -- %manufact City,
  "n__transp_util_comm_area" BIGINT  -- %transp Util Comm Area,
  "n__transp_util_comm_city" BIGINT  -- %transp Util Comm City,
  "n__trade_area" BIGINT  -- %trade Area,
  "n__trade_city" BIGINT  -- %trade City,
  "n__fin_ins_real_est_area" BIGINT  -- %fin Ins Real Est Area,
  "n__fin_ins_real_est_city" BIGINT  -- %fin Ins Real Est City,
  "n__business_svcs_area" BIGINT  -- %business Svcs Area,
  "n__business_svcs_city" DOUBLE  -- %business Svcs City,
  "n__personal_entert_svcs_area" BIGINT  -- %personal Entert Svcs Area,
  "n__personal_entert_svcs_city" BIGINT  -- %personal Entert Svcs City,
  "n__health_svcs_area" BIGINT  -- %health Svcs Area,
  "n__health_svcs_city" BIGINT  -- %health Svcs City,
  "n__education_area" BIGINT  -- %education Area,
  "n__education_city" BIGINT  -- %education City,
  "n__other_prof_svcs_area" BIGINT  -- %other Prof Svcs Area,
  "n__other_prof_svcs_city" BIGINT  -- %other Prof Svcs City
);

CREATE TABLE employment_by_occupation (
  "community" VARCHAR,
  "n__manager_area" BIGINT  -- %manager Area,
  "n__manager_city" BIGINT  -- %manager City,
  "n__sales_clerical_tech_area" BIGINT  -- %sales Clerical Tech Area,
  "n__sales_clerical_tech_city" BIGINT  -- %sales Clerical Tech City,
  "n__services_area" BIGINT  -- %services Area,
  "n__services_city" BIGINT  -- %services City,
  "n__precision_prod_constr_area" BIGINT  -- %precision Prod Constr Area,
  "n__precision_prod_constr_city" BIGINT  -- %precision Prod Constr City,
  "n__machine_oper_inspectors_area" BIGINT  -- %machine Oper Inspectors Area,
  "n__machine_oper_inspectors_city" BIGINT  -- %machine Oper Inspectors City,
  "n__laborers_other_area" BIGINT  -- %laborers Other Area,
  "n__laborers_other_city" BIGINT  -- %laborers Other City
);

CREATE TABLE households (
  "community" VARCHAR,
  "number_families" BIGINT,
  "n__family_children_under18" DOUBLE  -- %family Children Under18,
  "number_persons_household" DOUBLE,
  "number_persons_family" DOUBLE,
  "n__moved_last_5yrs" DOUBLE  -- %moved Last 5yrs,
  "n__married_couple_family" DOUBLE  -- %married Couple Family,
  "n__single_parent_family" DOUBLE  -- %single Parent Family,
  "n__single_person" DOUBLE  -- %single Person,
  "n__non_family" DOUBLE  -- %non Family,
  "n__seniors_live_alone" DOUBLE  -- %seniors Live Alone
);

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

CREATE TABLE income (
  "community" VARCHAR,
  "median_household" DOUBLE,
  "median_family" DOUBLE,
  "n__earned" VARCHAR  -- %earned,
  "n__self_empl" DOUBLE  -- %self Empl,
  "n__investment" DOUBLE  -- %investment,
  "n__soc_sec" DOUBLE  -- %soc Sec,
  "n__public_asst" DOUBLE  -- %public Asst,
  "n__other" DOUBLE  -- %other,
  "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  -- Percent 50,000+,
  "n__fam_below_pov" VARCHAR  -- %fam Below Pov,
  "n__people_below_pov" DOUBLE  -- %people Below Pov,
  "n__elderly_below_pov" DOUBLE  -- %elderly Below Pov
);

CREATE TABLE labor_force (
  "community" VARCHAR,
  "n__women_empl" DOUBLE  -- %women Empl,
  "n__women_unempl" DOUBLE  -- %women Unempl,
  "n__women_not_labor_force" DOUBLE  -- %women Not Labor Force,
  "n__men_empl" BIGINT  -- %men Empl,
  "n__men_unempl" BIGINT  -- %men Unempl,
  "n__men_not_labor_force" BIGINT  -- %men Not Labor Force,
  "n__partial_unempl" DOUBLE  -- %partial Unempl,
  "n__part_time_empl" DOUBLE  -- %part Time Empl,
  "number_fam_no_worker" BIGINT,
  "n__fam_no_worker" DOUBLE  -- %fam No Worker,
  "number_fam_one_worker" BIGINT,
  "n__fam_one_worker" BIGINT  -- %fam One Worker,
  "number_fam_two_workers" BIGINT  -- Number Fam Two+ Workers,
  "n__fam_two_workers" DOUBLE  -- %fam Two Workers,
  "n__work_in_pitt" DOUBLE  -- %work In Pitt,
  "n__work_out_pitt" DOUBLE  -- %work Out Pitt
);

CREATE TABLE population (
  "community" VARCHAR,
  "pop_total" VARCHAR,
  "n__race_white" DOUBLE  -- %race White,
  "n__race_black" DOUBLE  -- %race Black,
  "n__race_other" DOUBLE  -- %race Other,
  "n__age_0_4" DOUBLE  -- %age 0-4,
  "n__age_5_18" DOUBLE  -- %age 5-18,
  "n__age_19_44" DOUBLE  -- %age 19-44,
  "n__age_45_64" DOUBLE  -- %age 45-64,
  "n__age_65" DOUBLE  -- %age 65+,
  "n__fem_married" DOUBLE  -- %fem Married,
  "n__fem_single" DOUBLE  -- %fem Single,
  "n__fem_sep" DOUBLE  -- %fem Sep,
  "n__fem_widowed" DOUBLE  -- %fem Widowed,
  "n__fem_under15_married" DOUBLE  -- %fem Under15 Married,
  "n__male_married" DOUBLE  -- %male Married,
  "n__male_single" DOUBLE  -- %male Single,
  "n__male_sep" DOUBLE  -- %male Sep,
  "n__male_widowed" DOUBLE  -- %male Widowed,
  "n__male_under15_married" DOUBLE  -- %male Under15 Married
);