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

Queens

@kaggle.minisam_new_york_city_restaurant_inspection20172021.queens

1.06 MB
76252 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
41663033	EL ENCANTO CENTRO-AMERICANO RESTAURANT	Queens	JAMAICA AVENUE	Latin American	Wed Oct 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	29	40.701926595592	-73.805259829829	2021
41657408	BUBBA'S BISTRO	Queens	DITMARS BLVD	Creole/Cajun	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	22	40.775759193197	-73.91015436697799	2019
50014424	EL COYOTE	Queens	AUSTIN STREET	Mexican	Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	12	40.720826739746	-73.84660157278499	2018
41243875	ANIL'S ROTI SHOP	Queens	LIBERTY AVENUE	Caribbean	Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	11	40.688156948248	-73.819222287372	2019
50050663	HE JI NOODLE HOUSE	Queens	ROOSEVELT AVENUE	Chinese	Tue Jun 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	9	40.758501995257	-73.83324180898799	2018
50051163	HOME MADE BAKLAWA	Queens	STEINWAY STREET	Bakery Products/Desserts	Wed Aug 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	4	40.76848367892	-73.911229224144	2016
50058133	WENDY'S	Queens	NORTHERN BLVD	Hamburgers	Tue Mar 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	7	40.761468620827	-73.761474940957	2019
50052257	TITAHS DELI GROCERY	Queens	NORTHERN BLVD	Spanish	Sat Mar 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	32	40.757766870679	-73.862593348455	2019
50093195	O'SAKE ROCKAWAY JAPANESE RESTAURANT	Queens	BEACH 116 STREET	Japanese	Wed Oct 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	27	40.580649341811	-73.83770158716999	2019
40515124	RENEE'S KITCHENETTE	Queens	ROOSEVELT AVENUE	Filipino	Sat Jan 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	16	40.746342714386	-73.89609751706101	2020


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