About this Dataset

Allegheny County Asbestos Permits

Current asbestos permit data issued by the County for commercial building demolitions and renovations as required by the EPA. This file is updated daily and can be downloaded below.

If you're looking for the documents themselves, click on the link directly below to navigate to Allegheny County's Open Document Portal. Here you can search for printable PDFs of the applications and permits for posting at job sites. Start with the 'Select Search Type' drop down field. http://documents.alleghenycounty.us/publicaccess/DatasourceTemplate.aspx
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:49.432204
Tags: _etl, health, inspections, permits, properties, public-safety, violations

Tables

Asbestos Permits Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_asbest_42dfa810.asbestos_permits_data

725.37 kB
9,273 rows
22 columns

CREATE TABLE asbestos_permits_data (
  "n__id" BIGINT  -- Id,
  "permit_number" VARCHAR,
  "s_name" VARCHAR,
  "s_address" VARCHAR,
  "city" VARCHAR,
  "z_code" VARCHAR,
  "p_fee" DOUBLE,
  "pa_license_no" VARCHAR,
  "contractor_name" VARCHAR,
  "permit_specifications" VARCHAR,
  "square_feet" DOUBLE,
  "is_the_building_occupied" VARCHAR,
  "i_date" TIMESTAMP,
  "e_date" VARCHAR,
  "achd_inspector" VARCHAR,
  "job_complete" VARCHAR,
  "is_permit_date_extended" VARCHAR,
  "permit_o_e_date" VARCHAR,
  "project_type" VARCHAR,
  "status" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);