About this Dataset

Allegheny County Plumbers

All master plumbers must be registered with the Allegheny County Health Department. Only Registered Master Plumbers who possess a current plumbing license or owner/occupant of an existing single family dwelling may apply for a plumbing permit. Plumbing permits are required to construct, enlarge, alter, repair, move, demolish or change occupancy of a building or structure.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:12.833558
Tags: _etl, health, plumbing

Tables

Plumbers

@usgov.allegheny_county_city_of_pitts_allegheny_county_plumbers.plumbers

36.94 kB
1,291 rows
7 columns

CREATE TABLE plumbers (
  "n__id" BIGINT  -- Id,
  "registration_number" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE
);