Name: NYC Restaurant Inspections
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NYC Restaurant Inspections

Context:

Restaurant inspections for permitted food establishments in NYC. Restaurants are graded on A-F scale with regular visits by city health department.

Content:

Dataset includes address, cuisine description, inspection date, type, action, violation code and description(s). Data covers all of NYC and starts Jan 1, 2010-Aug 29, 2017.

Acknowledgements:

Data was collected by the NYC Department of Health and is available here.

Inspiration:

Can you predict restaurant closings?
Are certain violations more prominent in certain neighborhoods? By cuisine?
Who gets worse grades--chain restaurants or independent establishments?

Tables

Dohmh New York City Restaurant Inspection Results

@kaggle.new_york_city_nyc_inspections.dohmh_new_york_city_restaurant_inspection_results

8.87 MB
399,918 rows
18 columns

CREATE TABLE dohmh_new_york_city_restaurant_inspection_results (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "building" VARCHAR,
  "street" VARCHAR,
  "zipcode" DOUBLE,
  "phone" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "action" VARCHAR,
  "violation_code" VARCHAR,
  "violation_description" VARCHAR,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "grade" VARCHAR,
  "grade_date" TIMESTAMP,
  "record_date" TIMESTAMP,
  "inspection_type" VARCHAR
);