About this Dataset

Delaware Restaurant Inspection Violations Records

Delaware Restaurant Inspection Violations

This dataset provides detailed information on restaurant inspection violations in Delaware over the past two years. It includes the following categories:

Food Establishment Name: Restaurant name
Food Establishment Street Address: Restaurant street address
Food Establishment City: Restaurant city
Food Establishment Zip Code: Restaurant Zip Code
Inspection Date: Date of restaurant inspection conducted by the Division of Public Health - Office of Food Protection
Inspection Type: Inspection visit type: routine, follow-up, or complaint.
Violation Code: The violation code that this restaurant was cited for in this inspection. If no violation code is present, there were no violations for this inspection. There may be numerous violations that a restaurant is cited for in a single visit. If this is the case, there will be multiple rows for this restaurant with the same inspection date.
Violation Description: Description of the violation which corresponds to the violation code.
Geocoded Location: Street address, city, state, and zip code for geolocation purposes

Tables

Delaware Restaurant Inspection Violations

@kaggle.msjahid_delaware_restaurant_inspection_violations_records.delaware_restaurant_inspection_violations

367.8 KB
30586 rows
9 columns


CREATE TABLE delaware_restaurant_inspection_violations (
  "food_establishment_name" VARCHAR,
  "food_establishment_street_address" VARCHAR,
  "food_establishment_city" VARCHAR,
  "food_establishment_zip_code" DOUBLE,
  "inspection_date" TIMESTAMP,
  "inspection_type" VARCHAR,
  "violation_code" VARCHAR,
  "violation_description" VARCHAR,
  "geocoded_location" VARCHAR
);