Dataset: Restaurant And Market Health Inspections

About this Dataset

Restaurant And Market Health Inspections

This dataset contains Environmental Health Inspection Results for Restaurants and Markets in the City of Los Angeles. Los Angeles County Environmental Health is responsible for inspections and enforcement activities for all unincorporated areas and 85 of the 88 cities in the County. This dataset is filtered from County data to include only facilities in the City of Los Angeles. The full dataset is available at https://data.lacounty.gov/Health/LOS-ANGELES-COUNTY-RESTAURANT-AND-MARKET-INSPECTIO/6ni6-h5kp.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:03.447164
Tags: grocery, health, inspection, market, restaurant

Tables

Table 1

@usgov.city_of_los_angeles_restaurant_and_market_health_inspections.table_1

2.68 MB
67573 rows
20 columns


CREATE TABLE table_1 (
  "serial_number" VARCHAR,
  "activity_date" VARCHAR,
  "facility_name" VARCHAR,
  "score" BIGINT,
  "grade" VARCHAR,
  "service_code" BIGINT,
  "service_description" VARCHAR,
  "employee_id" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_id" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" VARCHAR,
  "owner_id" VARCHAR,
  "owner_name" VARCHAR,
  "pe_description" VARCHAR,
  "program_element_pe" BIGINT,
  "program_name" VARCHAR,
  "program_status" VARCHAR,
  "record_id" VARCHAR
);