Data Dictionary

Column Type Label Description
plan_id text Plan ID
plan_numb text Plan Numb

Permit Plan ID

inspect_id text

Unique Inspection ID

dt_insp date

Date of Inspection

inspector_id text

System generated inspector ID

insp_st_tm text

Inspection Start Time

insp_end_tm text

Inspection End Time

address text

Permit Address Location

city text

Permit Address City

state text

Permit Address State

zip_code text

Permit Address Zip Code

municipal text

Permit Address Municipalty. Includes Ward number for City of Pittsburgh.

building_type text

Based on Permit application

plumber_name text

Plumber who filed for the permit

final_insp_yn text

Final Inspection flag

storm_drain text

Storm Drain Inspected flag

building_drain text

Building drainage inspected flag

water_service text

Water service line inspected flag

storm_sewer text

Storm water sewage line inspected flag

rough_above_ground text

Plumbing inside walls etc above ground inspected flag

water_heater text

Water heater inspected flag

building_sewer text

Building's sewer line outside building inspected flag

water_distribution text

Water line above ground within building

indirect_waste text

Waste that doesn't directly connect to the waste. IE laundry or furnace drain

violations_flag text

Indicator if inspection returned any violations

Additional Information

Field Value
Data last updated November 19, 2024
Metadata last updated November 19, 2024
Created November 9, 2021
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Id89481a55-2d81-4bb9-9e46-2fd4a3aab0ac
Mimetypetext/csv
Package id00af664b-cdd1-444e-bffc-0e3ccb5066f9
Position0
Revision id5bc12ebd-3dcd-4ae4-9014-c9de1cb41e5e
Size9.1 MiB
Stateactive
Url typedatapusher