Delaware Restaurant Inspection Violations

Detailed Insights into Health Inspection Records and Violations

@kaggle.noeyislearning_delaware_restaurant_inspection_violations

Table List

1 table(358 KB)

Restaurant Inspection Violations

@kaggle.noeyislearning_delaware_restaurant_inspection_violations.restaurant_inspection_violations

358 KB
31713 rows
9 columns

food_establishment_name Food Establishment Name	food_establishment_street_address Food Establishment Street Address	food_establishment_city Food Establishment City	food_establishment_zip_code Food Establishment Zip Code	inspection_date Inspection Date	inspection_type Inspection Type	violation_code Violation Code	violation_description Violation Description	geocoded_location Geocoded Location
1 Village Alliance	31 West 31st Street	Wilmington	19802	Mon May 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	4-204.112	Temperature Measuring Devices-Functionality	31 West 31st Street Wilmington, DE 19802 (39.75707, -75.53127)
1 Village Alliance	31 West 31st Street	Wilmington	19802	Mon May 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	4-302.14	Sanitizing Solutions, Testing Devices	31 West 31st Street Wilmington, DE 19802 (39.75707, -75.53127)
1 Village Alliance	31 West 31st Street	Wilmington	19802	Mon May 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	6-201.17	Walls and Ceilings, Attachments	31 West 31st Street Wilmington, DE 19802 (39.75707, -75.53127)
1 Village Alliance	31 West 31st Street	Wilmington	19802	Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	2-102.12	Certified Food Protection Manager	31 West 31st Street Wilmington, DE 19802 (39.75707, -75.53127)
13 Wingz	639 Phillips St	Seaford	19973	Wed Feb 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	3-307.11	Miscellaneous Sources of Contamination	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)
13 Wingz	639 Phillips St	Seaford	19973	Wed Feb 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	5-202.13	Backflow Prevention, Air Gap	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)
13 Wingz	639 Phillips St	Seaford	19973	Wed Feb 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	6-201.11	Floors, Walls and Ceilings-Cleanability	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)
13 Wingz	639 Phillips St	Seaford	19973	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	2-102.12	Certified Food Protection Manager	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)
13 Wingz	639 Phillips St	Seaford	19973	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	2-201.11	Responsibility of Permit Holder, Person in Charge, and Conditional Employees	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)
13 Wingz	639 Phillips St	Seaford	19973	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Routine	8-201.14	Contents of a HACCP Plan	639 Phillips St Seaford, DE 19973 (38.64581, -75.62518)


CREATE TABLE 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
);