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

Manhattan

@kaggle.minisam_new_york_city_restaurant_inspection20172021.manhattan

1.82 MB
129103 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
50048586	BILL'S NEW YORK CITY	Manhattan	EAST 54 STREET	American	Mon Nov 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	9	40.760096691349	-73.973129203154	2017
50071467	TGA NYC	Manhattan	WEST 36 STREET	American	Wed Oct 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical		40.753816891372	-73.993362343069	2018
40389356	TOM'S RESTAURANT	Manhattan	BROADWAY	American	Mon Jan 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	36	40.805490185201	-73.965720252196	2022
50012532	KRUSH	Manhattan	WEST 32 STREET	American	Thu Feb 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	22	40.747308389619	-73.985903129221	2018
41679739	FRAME GOURMET EATERY	Manhattan	WEST 33 STREET	American	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	82	40.753092443731	-73.997704456924	2020
50035310	DANTE	Manhattan	MACDOUGAL ST	Italian	Thu Oct 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	23	40.72877111183	-74.001533409377	2017
50098022	DIG INN	Manhattan	PENN PLZ	American	Thu Dec 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	5	40.749394979358	-73.991774762274	2019
41250519	MILANO'S BAR	Manhattan	EAST HOUSTON STREET	Bottled Beverages	Tue Oct 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	11	40.724769118335	-73.994440373167	2019
41341123	VILLA FRESH ITALIAN KITCHEN	Manhattan	8 AVENUE	Pizza	Fri Oct 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	26	40.756185423077	-73.99056473378499	2019
50078345	URBAN BACKYARD	Manhattan	MULBERRY STREET	Coffee/Tea	Thu Aug 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical		40.720690483279	-73.99674956778699	2018


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