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

Brookyln

@kaggle.minisam_new_york_city_restaurant_inspection20172021.brookyln

1.14 MB
81198 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
50004496	TAQUERIA EL PUENTE	Brooklyn	5 AVENUE	Mexican	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	8	40.616722603617	-74.030313947072	2019
50060330	LUKE'S LOBSTER	Brooklyn	WATER STREET	Seafood	Tue Mar 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	32	40.703228154305	-73.994070693218	2017
41628216	OVI'S PLACE	Brooklyn	AVENUE H	American	Mon Jul 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	23	40.63153662755701	-73.947961949011	2019
50035344	RADHUNI SWEETS & RESTAURANT	Brooklyn	MCDONALD AVENUE	Bangladeshi	Tue Mar 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	17	40.642245743819	-73.97932411873	2019
50043327	HAND PULL NOODLE & DUMPLING HOUSE	Brooklyn	18 AVENUE	Chinese	Thu Mar 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	59	40.615032941977	-73.994301872056	2022
50089507	OH BAGEL	Brooklyn	CONEY ISLAND AVENUE	Jewish/Kosher	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	12	40.614379400049	-73.96319664930999	2019
41080084	TARBOOSH CAFE	Brooklyn	5 AVENUE	Middle Eastern	Fri Mar 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	22	40.631469514168	-74.02183261252	2020
41324657	BUFF PATTY RESTAURANT & BAKERY	Brooklyn	MYRTLE AVENUE	Caribbean	Mon Jun 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	5	40.693167838042	-73.971169325907	2019
50077587	WYCKOFF RESTAURANT	Brooklyn	WYCKOFF AVENUE	Mexican	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	10	40.700554795216	-73.912953764428	2019
50078216	FAMILY PIZZA	Brooklyn	FLATBUSH AVENUE	Pizza	Wed Aug 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	23	40.655791577516	-73.95991204077599	2019


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