Name: Food-inspection
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Food-inspection

Context

Food quality is very important. This is food inspections dataset.

Content

April 2006 to today. Dataset contains records of inspections on restaurants and its results.

Acknowledgements

Department of Innovation and Technology

Inspiration

Which restaurants serve healthy food and which do not?
What percentage of restaurants are safe to eat? Are there any with very low ratings or harmful to health?

Tables

N 4582bec6–2b4f 4f9e Bc55 Cbaa73117f4c

@kaggle.ishadss_foodinspection.n_4582bec6_2b4f_4f9e_bc55_cbaa73117f4c

25.64 MB
645,684 rows
26 columns

CREATE TABLE n_4582bec6_2b4f_4f9e_bc55_cbaa73117f4c (
  "businessname" VARCHAR,
  "dbaname" VARCHAR,
  "legalowner" VARCHAR,
  "namelast" VARCHAR,
  "namefirst" VARCHAR,
  "licenseno" BIGINT,
  "issdttm" VARCHAR,
  "expdttm" VARCHAR,
  "licstatus" VARCHAR,
  "licensecat" VARCHAR,
  "descript" VARCHAR,
  "result" VARCHAR,
  "resultdttm" VARCHAR,
  "violation" VARCHAR,
  "viollevel" VARCHAR,
  "violdesc" VARCHAR,
  "violdttm" VARCHAR,
  "violstatus" VARCHAR,
  "statusdate" TIMESTAMP,
  "comments" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "property_id" DOUBLE,
  "location" VARCHAR
);