About this Dataset

Allegheny County Clean Indoor Air Act Exemptions

List and location of all the businesses and social clubs who have received an exemption from the Pennsylvania Clean Indoor Air Act. “The Clean Indoor Air Act, Act 27 of 2008, was signed into law on June 13, 2008. The legislation prohibits smoking in a public place or a workplace and lists examples of what is considered a public place. The bill allows for some exceptions, including a private residence (except those licensed as a child care facility), a private social function where the site involved is under the control of the sponsor (except where the site is owned , leased, or operated by a state or local government agency) and a wholesale or retail tobacco shop. It also imposes penalties for those establishments in noncompliance, as well as those individuals smoking in prohibited areas.”
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:09:51.399057
Tags: achd-dash, ciaa, clean-indoor-air-act, social-determinates-of-health, tobacco

Tables

Clean Indoor Air Act 2015 Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_clean__5db50e05.clean_indoor_air_act_2015_data

44.97 kB
462 rows
13 columns

CREATE TABLE clean_indoor_air_act_2015_data (
  "shape" VARCHAR,
  "bus_type" VARCHAR,
  "status" VARCHAR,
  "establishm" VARCHAR,
  "trade_name" VARCHAR,
  "bus_physic" VARCHAR,
  "bus_phys_1" VARCHAR,
  "bus_phys_2" VARCHAR,
  "bus_phys_3" BIGINT,
  "latitude_a" DOUBLE,
  "longitude" DOUBLE,
  "de_lid_num" DOUBLE,
  "license_nu" VARCHAR
);