Food Inspections
City of Chicago
@usgov.city_of_chicago_food_inspections
Table 1
@usgov.city_of_chicago_food_inspections.table_1
- 94.55 MB
- 290849 rows
- 17 columns
inspection_idInspection ID | dba_nameDBA Name | aka_nameAKA Name | licenseLicense # | facility_typeFacility Type | riskRisk | addressAddress | cityCity | stateState | zipZip | inspection_dateInspection Date | inspection_typeInspection Type | resultsResults | violationsViolations | latitudeLatitude | longitudeLongitude | locationLocation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1170324 | CAPTAIN HOOKS FISH & CHICKEN/FIREHOUSE GRILL | CAPTAIN HOOKS FISH & CHICKEN FIREHOUSE GRILL | 1804138 | Restaurant | Risk 1 (High) | 5648 W ROOSEVELT | CHICAGO | IL | 60644 | Mon Jun 18 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | Complaint | Pass w/ Conditions | 21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTENTIALLY HAZARDOUS FOODS ARE PREPARED AND SERVED - Comments: OBSERVED NO CERTIFIED FOOD MANAGER ON DUTY WHILE (CHICKEN,FISH,FRENCH FRIES,ETC)IS BEING PREPARED ,SERVED & HANDLED AT THIS TIME.MUST BE ON SITE AT ALL TIMES.(SERIOUS 7-38-012). | 32. FOOD AND … | 41.86567851033532 | -87.76633113301574 | (41.86567851033532, -87.76633113301574) |
| 2614750 | CHICK-FIL-A PULLMAN | CHICK-FIL-A PULLMAN | 3015728 | Restaurant | Risk 1 (High) | 11131 S CORLISS AVE | CHICAGO | IL | 60628 | Mon Mar 31 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | License | Pass | 58. ALLERGEN TRAINING AS REQUIRED - Comments: ALLERGEN CERTIFICATE NEEDED. INSTRUCTED TO OBTAIN AND MAINTAIN. | 41.69195600663339 | -87.60055824712973 | (41.69195600663339, -87.60055824712973) |
| 2609909 | HAPPY MARKET | HAPPY MARKET | 2912802 | Grocery Store | Risk 2 (Medium) | 2334 S WENTWORTH AVE | CHICAGO | IL | 60616 | Thu Jan 02 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | Canvass | Pass w/ Conditions | 2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: UPON ARRIVAL, OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE WHILE OPEN AND OPERATING. INSTRUCTED A CITY OF CHICAGO CERTIFIED FOOD MANAGER MUST BE ON SITE AT ALL TIMES WHILE OPEN AND OPERATING. PRIORITY FOUNDATION VIOLAT… | 41.84995400192252 | -87.63209419559098 | (41.84995400192252, -87.63209419559098) |
| 2609927 | SAT KAIVAL FOOD INC/SUBWAY | SAT KAIVAL FOOD INC/SUBWAY | 2728400 | Restaurant | Risk 1 (High) | 1916 S STATE ST | CHICAGO | IL | 60616 | Thu Jan 02 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | Canvass | Pass | 36. THERMOMETERS PROVIDED & ACCURATE - Comments: OBSERVED NO AMBIENT AIR THERMOMETER INSIDE THE COLD HOLDING UNITS ON SITE. INSTRUCTED TO PROVIDE AND MAINTAIN. | 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED THE TOILET SEAT AND TOILET FIXTURES IN THE WOMEN'S T… | 41.85605269621059 | -87.62731125804903 | (41.85605269621059, -87.62731125804903) |
| 2608378 | Babas Halal | Babas Halal | 2684170 | Restaurant | Risk 1 (High) | 7901 S DAMEN AVE | CHICAGO | IL | 60620 | Tue Dec 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Complaint | Fail | 1. PERSON IN CHARGE PRESENT, DEMONSTRATES KNOWLEDGE, AND PERFORMS DUTIES - Comments: PIC DOESN'T HAVE A CERTIFIED FOOD MANAGERS CERTIFICATE MUST PROVIDE AND MAINTAIN.(PRIORITY FOUNDATION 7-38-012) | 2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: OBSERVED NO CERTIFIED FOOD MANAGER… | 41.750189342293375 | -87.67298583977204 | (41.750189342293375, -87.67298583977204) |
| 2615511 | MAPLEWOOD BREWING COMPANY | MAPLEWOOD BREWING COMPANY | 3016105 | Liquor | Risk 3 (Low) | 2717-2719 N MAPLEWOOD AVE | CHICAGO | IL | 60647 | Thu Apr 10 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | License | Pass | 56. ADEQUATE VENTILATION & LIGHTING; DESIGNATED AREAS USED - Comments: FOUND GAS OVEN NOT UNDER HOOD.MUST RELOCATE OR REMOVE. | 41.93095692249829 | -87.69137628601092 | (41.93095692249829, -87.69137628601092) |
| 2615536 | LIA | LIA | 3015953 | Restaurant | Risk 1 (High) | 11 W ILLINOIS ST | CHICAGO | IL | 60654 | Thu Apr 10 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | License | Pass | 41.8907467911109 | -87.62851094403574 | (41.8907467911109, -87.62851094403574) | |
| 1098818 | HAUGAN ELEMENTARY | HAUGAN ELEMENTARY | 23591 | School | Risk 1 (High) | 4540 N Hamlin AVE | CHICAGO | IL | 60625 | Thu Jan 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Canvass | Pass | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: EXCESSIVE FOOD DEBRIS ON ALL MICROWAVE OVENS, INSIDE STAFF BREAK ROOMS AND KITCHEN, INSTRUCTED TO CLEAN/SANITIZE AND MAINTAIN. ALSO ICE BUILD-UP ON CONDENSER INSIDE WALK IN COOLER IN KITCHEN, INSTRUCTED … | 41.96403524536502 | -87.72316495595534 | (41.96403524536502, -87.72316495595534) |
| 2610482 | DANCEN GRILL RESTAURANT, INC. | DANCEN | 2341747 | Restaurant | Risk 1 (High) | 5114 N LINCOLN AVE | CHICAGO | IL | 60625 | Tue Jan 14 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | Non-Inspection | No Entry | 41.97452873707269 | -87.69233925845519 | (41.97452873707269, -87.69233925845519) | |
| 2610081 | MARYS TAQUERIA AND GROCERY STORE, INC. | MARYS FOOD AND GROCERY STORE | 2326530 | Restaurant | Risk 1 (High) | 1901 S CANALPORT AVE | CHICAGO | IL | 60616 | Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time) | Canvass | Pass | 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED NO HANDWASHING SIGNAGE AT THE HANDWASHING SINK NEAR THE THREE COMPARTMENT SINK IN THE REAR. INSTRUCTED TO PROVIDE AND MAINTAIN. | 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED… | 41.85666310572283 | -87.64178573004398 | (41.85666310572283, -87.64178573004398) |
CREATE TABLE table_1 (
"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
);