About this Dataset

Division Of Tenement House Inspection Annual Reports 1907/1913

This data was prepared by Rosalie Garfinkle as a course project for LIS 2970 Open Government Data in the Master of Library Program at the University of Pittsburgh.

These six historical datasets are transcribed from the annual reports done by the Division of Tenement House Inspection for the Bureau/Department of Public Health of the City of Pittsburgh. The goal of this Division was to canvas working-class housing and improve the living conditions of these tenement houses. Reports were published each year from 1907 to 1913 (with 1907 only showing data for ten months of the year, March-December). In 1914, the Division of Tenement House Inspection and the Division of Sanitary Inspection were combined and began to work together. For a more in-depth history of the Bureau/Department of Public Health and the reports from the Division of Tenement House Inspection, see the readme file included here.

The six datasets included here are data on the violations corrected in tenements houses from 1907-1913; a summary of inspections conducted from 1907-1913; a record of tenement houses in the city in 1912, the number of apartments in houses in 1912; height of tenement houses by story for the front and rear of the building in 1912.

For all 1912 datasets, please refer to this map linked below for context regarding the wards listed in the data.

This data was published by the Department of Public Health and obtained through the University of Pittsburgh’s Archives & Special Collections.

A guide to data from the City's health department can be found here: https://digital.library.pitt.edu/islandora/object/pitt:US-PPiU-ais197428/from_search/3debdacfbde1f422c76e36d68ea54a7f-3
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:12:32.719242
Tags: archives, community-profiles, historic-pittsburgh, history, housing, housing-units, violations

Tables

Data Dictionary For Height Of Tenement Houses By Story 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.data_dictionary_for_height_of_tenement_houses_by_story_1912

4.31 KB
7 rows
4 columns


CREATE TABLE data_dictionary_for_height_of_tenement_houses_by_story_1912 (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "field_description" VARCHAR,
  "example" BIGINT
);

Data Dictionary For Record Of Tenement Houses 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.data_dictionary_for_record_of_tenement_houses_1912

4.23 KB
7 rows
4 columns


CREATE TABLE data_dictionary_for_record_of_tenement_houses_1912 (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "field_description" VARCHAR,
  "example" BIGINT
);

Data Dictionary For Summary Of Inspections Conducted

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.data_dictionary_for_summary_of_inspections_conducted

5.35 KB
5 rows
5 columns


CREATE TABLE data_dictionary_for_summary_of_inspections_conducted (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "field_description" VARCHAR,
  "example" VARCHAR,
  "notes" VARCHAR
);

Data Dictionary For Violations Corrected

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.data_dictionary_for_violations_corrected

9.91 KB
81 rows
5 columns


CREATE TABLE data_dictionary_for_violations_corrected (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "field_description" VARCHAR,
  "example" DOUBLE,
  "notes" VARCHAR
);

Height Of Tenement Houses By Story (Front) 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.height_of_tenement_houses_by_story_front_1912

6.57 KB
27 rows
7 columns


CREATE TABLE height_of_tenement_houses_by_story_front_1912 (
  "ward" BIGINT,
  "one_story_buildings" BIGINT,
  "two_story_buildings" BIGINT,
  "three_story_buildings" BIGINT,
  "four_story_buildings" BIGINT,
  "five_story_buildings" BIGINT,
  "six_story_buildings" BIGINT
);

Height Of Tenement Houses By Story (Rear) 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.height_of_tenement_houses_by_story_rear_1912

6.61 KB
27 rows
7 columns


CREATE TABLE height_of_tenement_houses_by_story_rear_1912 (
  "ward" BIGINT,
  "one_story_buildings" BIGINT,
  "two_story_buildings" BIGINT,
  "three_story_buildings" BIGINT,
  "four_story_buildings" BIGINT,
  "five_story_buildings" BIGINT,
  "six_story_buildings" BIGINT
);

Data Dictionary For Number Of Apartments In A Tenement House 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.n__dictionary_for_number_of_apartments_in_a_tenement_house_1912

4.35 KB
14 rows
4 columns


CREATE TABLE n__dictionary_for_number_of_apartments_in_a_tenement_house_1912 (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "field_description" VARCHAR,
  "example" BIGINT
);

Number Of Apartments In A Tenement House 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.number_of_apartments_in_a_tenement_house_1912

11.78 KB
27 rows
14 columns


CREATE TABLE number_of_apartments_in_a_tenement_house_1912 (
  "ward" BIGINT,
  "three_apartments" BIGINT,
  "four_apartments" BIGINT,
  "five_apartments" BIGINT,
  "six_apartments" BIGINT,
  "seven_apartments" BIGINT,
  "eight_apartments" BIGINT,
  "nine_apartments" BIGINT,
  "ten_apartments" BIGINT,
  "eleven_apartments" BIGINT,
  "twelve_apartments" BIGINT,
  "thirteen_apartments" BIGINT,
  "fourteen_apartments" BIGINT,
  "fifteen_or_more_apartments" BIGINT
);

Record Of Tenement Houses In Pittsburgh 1912

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.record_of_tenement_houses_in_pittsburgh_1912

6.68 KB
27 rows
7 columns


CREATE TABLE record_of_tenement_houses_in_pittsburgh_1912 (
  "ward" BIGINT,
  "total_tenement_houses_in_pittsburgh" BIGINT,
  "actually_occupied" BIGINT,
  "vacant" BIGINT,
  "wood_construction" BIGINT,
  "brick_construction" BIGINT,
  "stone_construction" BIGINT
);

Summary Of Inspections Conducted 1907/1913

@usgov.allegheny_county_city_of_pitts_division_of_tenement_ho_2b53f366.summary_of_inspections_conducted_1907_1913

4.61 KB
5 rows
5 columns


CREATE TABLE summary_of_inspections_conducted_1907_1913 (
  "year" VARCHAR,
  "houses_inspected" BIGINT,
  "violations_found" VARCHAR,
  "complaints_investigated" VARCHAR,
  "violations_corrected" BIGINT
);