About this Dataset

Licensed Businesses, Contractors & Trades

Current and historical business licenses for the City of Pittsburgh ranging from entertainment to contract workers.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:50:38.143399
Tags: _etl, amusement, businesses, contractors, economy, entertainment, improvement, licenses, local, signs, trades

Tables

Trade Licenses

@usgov.allegheny_county_city_of_pitts_licensed_businesses_con_7b4959ab.trade_licenses

227.71 kB
4,379 rows
10 columns

CREATE TABLE trade_licenses (
  "n__id" BIGINT  -- Id,
  "license_number" VARCHAR,
  "license_type_name" VARCHAR,
  "naics_code" BIGINT,
  "business_name" VARCHAR,
  "license_state" VARCHAR,
  "initial_issue_date" TIMESTAMP,
  "most_recent_issue_date" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP
);