New York City Restaurant Inspection(2016 -2022Mar)

Get to know your Big Apple eateries

@kaggle.minisam_new_york_city_restaurant_inspection20172021

Table List

6 tables(17.09 MB)

Bronx

Brookyln

Dohmh New York City Restaurant Inspection Results

Manhattan

Queens

Statenisland

Statenisland

@kaggle.minisam_new_york_city_restaurant_inspection20172021.statenisland

144.04 KB
10339 rows
11 columns

camis CAMIS	dba DBA	boro BORO	street STREET	cuisine_description CUISINE DESCRIPTION	inspection_date INSPECTION DATE	critical_flag CRITICAL FLAG	score SCORE	latitude Latitude	longitude Longitude	year Year
50093364	HOLLAND BAY RESTAURANT	Staten Island	VICTORY BOULEVARD	Caribbean	Mon Oct 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	10	40.6379464502	-74.079422975372	2019
50093208	TORINO PIZZA	Staten Island	RICHMOND ROAD	Pizza	Tue Oct 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	12	40.588890283047	-74.101913944944	2019
50080344	MONA'S CUISINE	Staten Island	TARGEE STREET	Caribbean	Wed Mar 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	6	40.618462785224	-74.084900015424	2020
41182682	SARKU JAPAN	Staten Island	RICHMOND AVENUE	Japanese	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	25	40.582297419955	-74.169052592685	2019
50086033	SOFIA'S TAQUERIA	Staten Island	BAY STREET	Tex-Mex	Mon Mar 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	12	40.618692742536	-74.069512349538	2019
50008767	MR. PIZZA	Staten Island	RICHMOND AVENUE	Pizza	Mon Jun 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	13	40.591427332393	-74.164787505238	2017
41629524	COMMONS CAFE	Staten Island	TELEPORT DRIVE	American	Tue Nov 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	19	40.603713212982	-74.179273342418	2017
50056843	LIBERTY TAVERN	Staten Island	FOREST AVENUE	American	Tue Jul 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	75	40.630981415993	-74.10211897576801	2019
50079799	TOMMY'S TAVERN & TAP	Staten Island	RICHMOND AVENUE	American	Tue Mar 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	11	40.582297419955	-74.169052592685	2019
40883049	DUNKIN	Staten Island	BAY STREET	Donuts	Fri Feb 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	10	40.61530441605	-74.067023519598	2019


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