About this Dataset

Allegheny County Restaurant/Food Facility Inspections And Locations

Facilities located within Allegheny County that produce, distribute and sell food products are subject to mandatory, routine inspection by one of the health department's staff of environmental health specialists.

This dataset contains the violation data from the searchable inspection reports posted online here: http://webapps.achd.net/Restaurant/. The inspection date ranges from January 2016 to present. A table of geocoded facility locations is also included. New data will be added monthly.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:15.337988
Tags: _etl, food, health, inspections, public-safety, restaurant, violations

Tables

Geocoded Food Facilities

@usgov.allegheny_county_city_of_pitts_allegheny_county_restau_1e5952df.geocoded_food_facilities

2.37 MB
31,986 rows
23 columns

CREATE TABLE geocoded_food_facilities (
  "n__id" BIGINT  -- Id,
  "id" BIGINT,
  "facility_name" VARCHAR,
  "num" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "municipal" VARCHAR,
  "category_cd" BIGINT,
  "description" VARCHAR,
  "p_code" DOUBLE,
  "fdo" TIMESTAMP,
  "bus_st_date" TIMESTAMP,
  "bus_cl_date" TIMESTAMP,
  "seat_count" DOUBLE,
  "noroom" DOUBLE,
  "sq_feet" DOUBLE,
  "status" BIGINT,
  "placard_st" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE,
  "address" VARCHAR
);