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

Bronx

@kaggle.minisam_new_york_city_restaurant_inspection20172021.bronx

440.72 KB
32135 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
41617347	DUNKIN	Bronx	MORRIS PARK AVENUE	Donuts	Fri Aug 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	8	40.849397165034	-73.853348774007	2019
41617347	DUNKIN	Bronx	MORRIS PARK AVENUE	Donuts	Fri Aug 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	8	40.849397165034	-73.853348774007	2019
41261148	EL VALLE RESTAURANT	Bronx	MELROSE AVENUE	Latin American	Mon Aug 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	31	40.818423026006	-73.916686480616	2021
50115730	EJ'S BAKERY & CAFE	Bronx	WEST 261 STREET	Spanish	Thu Mar 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	56	40.910011880808	-73.902671237021	2022
50039107	HEALTHY FRESH	Bronx	MORRIS PARK AVENUE	American	Thu Nov 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	10	40.848619894743	-73.855110781538	2018
40819558	JAKE'S STEAKHOUSE	Bronx	BROADWAY	Steakhouse	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	13	40.891798701882	-73.897243710975	2022
41638086	DUNKIN',' BASKIN ROBBINS	Bronx	EAST KINGSBRIDGE ROAD	Donuts	Thu Aug 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical	21	40.867395347236	-73.89724179416899	2021
50054646	CHINA ONE RESTAURANT	Bronx	EAST GUN HILL ROAD	Chinese	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Critical		40.878808622248	-73.873198063352	2019
50063198	KENNEDY FRIED CHICKEN	Bronx	EAST TREMONT AVENUE	Chicken	Thu Oct 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	13	40.842799997262	-73.885830042064	2019
41545050	PATRICIA'S	Bronx	MORRIS PARK AVENUE	Italian	Tue Nov 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Critical	26	40.8493095734	-73.853536926578	2019


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