Data Dictionary

Kolumna Typ Label Opis
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

Dodatkowe informacje

Pole Wartość
Data last updated 21 marca 2025
Metadata last updated 21 marca 2025
Created 9 listopada 2021
Format CSV
Licencja 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