About this Dataset

A Community Profile Of Pittsburgh Neighborhoods, 1974

These data include four historical datasets that were transcribed from the Community Profiles of Pittsburgh reports, which were published in 1974. The Community Profiles were prepared for 71 Pittsburgh neighborhoods by the City of Pittsburgh's Department of City Planning and include demographic information, housing, socio-economic conditions, and community facilities.

The four datasets included here are data on building permits issued in 1972, arrests for major crimes in 1972, public assistance given in 1972, and community facilities serving and located in Pittsburgh neighborhoods.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:37.370871
Tags: archives, arrests, building-permits, community-facilities, crimes, historic-pittsburgh, history, neighborhood-indicators, parks, public-assistance, recreation

Tables

Building Permits Issued, 1972

@usgov.allegheny_county_city_of_pitts_a_community_profile_of__505d57ab.building_permits_issued_1972

10.75 kB
71 rows
9 columns

CREATE TABLE building_permits_issued_1972 (
  "neighborhood" VARCHAR,
  "number_permits_housing" BIGINT,
  "costs_housing" BIGINT,
  "number_permits_other_structures" BIGINT,
  "costs_other_structures" BIGINT,
  "number_permits_extensions_additions" BIGINT,
  "costs_extensions_additions" BIGINT,
  "number_permits_alterations" BIGINT,
  "costs_alterations" BIGINT
);

Community Facilities, 1974

@usgov.allegheny_county_city_of_pitts_a_community_profile_of__505d57ab.community_facilities_1974

11.64 kB
837 rows
3 columns

CREATE TABLE community_facilities_1974 (
  "neighborhood" VARCHAR,
  "facility_name" VARCHAR,
  "facility_subtype" VARCHAR
);

Persons Receiving Public Assistance, 1972

@usgov.allegheny_county_city_of_pitts_a_community_profile_of__505d57ab.persons_receiving_public_assistance_1972

13.87 kB
71 rows
11 columns

CREATE TABLE persons_receiving_public_assistance_1972 (
  "neighborhood" VARCHAR,
  "number_assistance_age" BIGINT,
  "percentage_assistance_age" DOUBLE,
  "number_assistance_blindness" BIGINT,
  "percentage_assistance_blindness" DOUBLE,
  "number_aid_children" BIGINT,
  "percentage_aid_children" DOUBLE,
  "number_general_assistance" BIGINT,
  "percentage_general_assistance" DOUBLE,
  "number_aid_disability" BIGINT,
  "percentage_aid_disability" DOUBLE
);