Chicago Restaurant Inspections

~154k Rows of Inspections Data

@kaggle.chicago_chi_restaurant_inspections

Table List

1 table(50.65 MB)

Food Inspections

@kaggle.chicago_chi_restaurant_inspections.food_inspections

50.65 MB
153810 rows
17 columns

inspection_id Inspection ID	dba_name DBA Name	aka_name AKA Name	license License #	facility_type Facility Type	risk Risk	address Address	city City	state State	zip Zip	inspection_date Inspection Date	inspection_type Inspection Type	results Results	violations Violations	latitude Latitude	longitude Longitude	location Location
2079132	MARRIOT MARQUIS CHICAGO	MARRIOT MARQUIS CHICAGO	2517328	Restaurant	Risk 1 (High)	2121 S PRAIRIE AVE	CHICAGO	IL	60616	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License	Pass	nan	41.853650885040594	-87.62053358114167	(41.853650885040594, -87.62053358114167)
2079129	JET'S PIZZA	JET'S PIZZA	2522268	Restaurant	Risk 2 (Medium)	1025 W MADISON ST	CHICAGO	IL	60607	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License	Not Ready	nan	41.88157249576794	-87.65305233593274	(41.88157249576794, -87.65305233593274)
2079125	ROOM 1520	ROOM 1520	2446638	Special Event	Risk 3 (Low)	301 N JUSTINE ST	CHICAGO	IL	60607	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License Re-Inspection	Not Ready	8. SANITIZING RINSE FOR EQUIPMENT AND UTENSILS: CLEAN, PROPER TEMPERATURE, CONCENTRATION, EXPOSURE TIME - Comments: NO DISH WASHING FACILITIES ON SITE, (NO THREE COMPARTMENT SINK, WITH GREASE TRAP, OR DISHMACHINE), INSTRUCTED TO PROVIDE, \| 11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, DESIGNED, AND …	41.88657652150854	-87.66532812140231	(41.88657652150854, -87.66532812140231)
2079123	MARRIOT MARQUIS CHICAGO	MARRIOT MARQUIS CHICAGO	2517338	Restaurant	Risk 1 (High)	2121 S PRAIRIE AVE	CHICAGO	IL	60616	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License	Pass	35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: MUST PROVIDE OVERHEAD PROTECTION FOR COFFEE/TEA STATION OUTSIDE OF BALLROOM ON 4TH FL. AND ON 2ND FL. OUTSIDE OF BANQUET KITCHEN IN COORIDOR. \| 34. FLOORS: CONSTRUCTE…	41.853650885040594	-87.62053358114167	(41.853650885040594, -87.62053358114167)
2079105	CHARTWELLS	CICS WEST BELDEN CAMPUS	2549079	CHARTER SCHOOL	Risk 1 (High)	2245 N MCVICKER AVE	CHICAGO	IL	60639	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License Re-Inspection	Pass	18. NO EVIDENCE OF RODENT OR INSECT OUTER OPENINGS PROTECTED/RODENT PROOFED, A WRITTEN LOG SHALL BE MAINTAINED AVAILABLE TO THE INSPECTORS - Comments: VIOLATION CORRECTED \| 31. CLEAN MULTI-USE UTENSILS AND SINGLE SERVICE ARTICLES PROPERLY STORED: NO REUSE OF SINGLE SERVICE ARTICLES - Comments: Inspe…	41.921675488910864	-87.7767113569357	(41.921675488910864, -87.7767113569357)
2079104	SHRIMP'S FISH CHICKEN	SHRIMP'S FISH CHICKEN	2549497	Restaurant	Risk 2 (Medium)	4355 S COTTAGE GROVE AVE	CHICAGO	IL	60653	Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	License	Fail	2. FACILITIES TO MAINTAIN PROPER TEMPERATURE - Comments: WALK-IN FREEZER AND REACH-IN FREEZER NOT MAINTAINING PROPER TEMPERATURE. INSTRUCTED MANAGER TO TURN ON ALL FREEZERS. ALL FREEZERS MUST BE OPERABLE AND MAINTAIN PROPER TEMPERATURE. CRITICAL VIOATION 7-38-005A \| 11. ADEQUATE NUMBER, CONVENIENT, …	41.81519729173754	-87.60653088909952	(41.81519729173754, -87.60653088909952)
2079091	ART'S DRIVE INN	ART'S DRIVE INN	64682	Restaurant	Risk 1 (High)	1333 W NORTH AVE	CHICAGO	IL	60622	Fri Aug 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Canvass	Fail	2. FACILITIES TO MAINTAIN PROPER TEMPERATURE - Comments: FACILITIES DO NOT MAINTAIN PROPER TEMPERATURE. OBSERVED THE WALK-IN COOLER WITH AN AIR TEMPERATURE OF 48F AND THE 3 DOOR PREP COOLER WITH AN AIR TEMPERATURE OF 43.9F. BOTH COOLERS WERE USED TO STORE POTENTIALLY HAZARDOUS FOODS SUCH AS EGGS A…	41.910600662840906	-87.66186347385191	(41.910600662840906, -87.66186347385191)
2079087	VINCENT	VINCENT	51614	Restaurant	Risk 1 (High)	1475 W BALMORAL AVE	CHICAGO	IL	60640	Fri Aug 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Complaint	Fail	12. HAND WASHING FACILITIES: WITH SOAP AND SANITARY HAND DRYING DEVICES, CONVENIENT AND ACCESSIBLE TO FOOD PREP AREA - Comments: NO PAPER TOWELS AT BOTH PREP AREA EXPOSED HAND SINKS AND SOAP UNABLE TO DISPENSE AT 1ST FLOOR PREP EXPOSED HAND SINK WHILE EMPLOYEES WERE NOTED PREPARING FOODS. MUST HAVE …	41.97974413741576	-87.6677375923677	(41.979744137415764, -87.6677375923677)
2079083	CAPTAIN HOOKS OF DAN RYAN	CAPTAIN HOOKS OF DAN RYAN	2192934	Restaurant	Risk 2 (Medium)	205 W 87TH ST	CHICAGO	IL	60620	Fri Aug 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Complaint Re-Inspection	Pass	18. NO EVIDENCE OF RODENT OR INSECT OUTER OPENINGS PROTECTED/RODENT PROOFED, A WRITTEN LOG SHALL BE MAINTAINED AVAILABLE TO THE INSPECTORS - Comments: FRONT AND REAR DOORS REPAIRED. \| 19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE AREA; CLEAN, RODENT PROOF, ALL CONTAINERS COVERED - Comments: OUTSIDE G…	41.73603017519755	-87.6290945085756	(41.73603017519755, -87.6290945085756)
2079036	JIBARITO'S Y MAS	JIBARITO'S Y MAS	2452249	Restaurant	Risk 1 (High)	3400 W FULLERTON AVE	CHICAGO	IL	60647	Fri Aug 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Canvass	Out of Business	nan	41.92476960356357	-87.71216993271977	(41.92476960356357, -87.71216993271977)


CREATE TABLE food_inspections (
  "inspection_id" BIGINT,
  "dba_name" VARCHAR,
  "aka_name" VARCHAR,
  "license" DOUBLE,
  "facility_type" VARCHAR,
  "risk" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "inspection_date" TIMESTAMP,
  "inspection_type" VARCHAR,
  "results" VARCHAR,
  "violations" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);