Delaware Restaurant Inspection Violations
Detailed Insights into Health Inspection Records and Violations
@kaggle.noeyislearning_delaware_restaurant_inspection_violations
Detailed Insights into Health Inspection Records and Violations
@kaggle.noeyislearning_delaware_restaurant_inspection_violations
This dataset provides a comprehensive overview of restaurant inspections and violations in Delaware for the past two years. The data is sourced from the Department of Health and Social Services, Division of Public Health, Office of Food Protection, and offers detailed insights into health inspection records, violation codes, and violation descriptions. The dataset is structured to include key metrics such as restaurant name, street address, city, zip code, inspection date, inspection type, violation code, violation description, and geocoded location, providing a robust foundation for analyzing restaurant health and safety compliance.
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
);Anyone who has the link will be able to view this.