Dataset: New York City Restaurant Inspection(2016 -2022Mar)

About this Dataset

New York City Restaurant Inspection(2016 -2022Mar)

This dataset was obtained from the following url
https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j
It contains food inspections carried out in the five boroughs of New York from 2017 till March 2022 .
The dataset contains 26 columns that describe the data and above 300K records
The original dataset DOHMH_New_York_City_Restaurant_Inspection_Results.csv(144.14 MB) contains info about all five boroughs for past four years till 2022 March.
Bronx.csv -contains infomation about the bronx borough.
Brookyln.csv-contains information about Brookyln
Manhattan.csv-contins information about Manhattan

[Photo by Brad on Unsplash]
(https://unsplash.com/photos/r4mc-NvsFuU?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink)
Inspirations

Number and type of restaurants in the five boroughs.
Has variations in closure occured over the years
Precovid -Postcovid analysis
Maps

Tables

Bronx

@kaggle.minisam_new_york_city_restaurant_inspection20172021.bronx

440.72 KB
32135 rows
11 columns


CREATE TABLE bronx (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "street" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "year" BIGINT
);

Brookyln

@kaggle.minisam_new_york_city_restaurant_inspection20172021.brookyln

1.14 MB
81198 rows
11 columns


CREATE TABLE brookyln (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "street" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "year" BIGINT
);

Dohmh New York City Restaurant Inspection Results

@kaggle.minisam_new_york_city_restaurant_inspection20172021.dohmh_new_york_city_restaurant_inspection_results

12.5 MB
329120 rows
26 columns


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

Manhattan

@kaggle.minisam_new_york_city_restaurant_inspection20172021.manhattan

1.82 MB
129103 rows
11 columns


CREATE TABLE manhattan (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "street" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "year" BIGINT
);

Queens

@kaggle.minisam_new_york_city_restaurant_inspection20172021.queens

1.06 MB
76252 rows
11 columns


CREATE TABLE queens (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "street" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "year" BIGINT
);

Statenisland

@kaggle.minisam_new_york_city_restaurant_inspection20172021.statenisland

144.04 KB
10339 rows
11 columns


CREATE TABLE statenisland (
  "camis" BIGINT,
  "dba" VARCHAR,
  "boro" VARCHAR,
  "street" VARCHAR,
  "cuisine_description" VARCHAR,
  "inspection_date" TIMESTAMP,
  "critical_flag" VARCHAR,
  "score" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "year" BIGINT
);