Dataset: Food Establishment Inspection Data

About this Dataset

Food Establishment Inspection Data

This dataset contains detailed information on food establishment inspections conducted in various boroughs of a city. It provides valuable insights into the cleanliness, compliance, and safety of food establishments, helping consumers make informed dining choices.

The dataset includes the unique identifier (CAMIS) for each restaurant, the name of the establishment (DBA), the borough where it is located (BORO), address details (BUILDING, STREET, ZIPCODE), contact information (PHONE), cuisine description (CUISINE DESCRIPTION), inspection date (INSPECTION DATE), actions taken during inspections (ACTION), violation codes (VIOLATION CODE), violation descriptions (VIOLATION DESCRIPTION), critical flag for violations (CRITICAL FLAG), inspection scores (SCORE), grades assigned (GRADE), grade issuance dates (GRADE DATE), record date, and other relevant columns.

The dataset has undergone a thorough cleaning process to ensure consistency, accuracy, and completeness of the data. Duplicate or null values have been removed, and various columns have been standardized in terms of formatting, spelling, and data input. Missing values have been addressed appropriately.

This dataset serves as a valuable resource for researchers, policymakers, and consumers interested in analyzing and understanding the compliance and safety standards of food establishments. It can be used for exploratory data analysis, visualizations, predictive modeling, and identifying trends and patterns related to restaurant inspections and violations.

By utilizing this dataset, stakeholders can gain insights into the performance of food establishments, identify areas for improvement, and promote a healthier and safer dining environment for the community.

Disclaimer: The dataset is based on public inspection data and may not represent real-time information. It is intended for educational and analytical purposes and should not be solely relied upon for making dining decisions.

Tables

N, Cleaned Nyc Restaurant Insp Result

@kaggle.babatundezenith_food_inspection_data.n__cleaned_nyc_restaurant_insp_result

4.29 MB
103426 rows
26 columns


CREATE TABLE n__cleaned_nyc_restaurant_insp_result (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "building" VARCHAR,
  "street" VARCHAR,
  "zipcode" BIGINT,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" VARCHAR,
  "council_district" VARCHAR,
  "census_tract" VARCHAR,
  "bin" VARCHAR,
  "bbl" VARCHAR,
  "nta" VARCHAR
);