{"name":"Joanie's Pizzeria of Long Grove","dba_name":"JOANIE'S PIZZERIA OF LONG GROVE","operating_legal_name":"BLUE HERON ESTATE LLC","declared_type":"Restaurant","address":{"street":"235 Robert Parker Coffin Road","unit":"","city":"Long Grove","region":"IL","postal_code":"60047","country":"US"},"coordinates":{"latitude":42.1792758,"longitude":-87.99709659999999},"phone":"+18474152220","email":"","website":"https://www.joaniespizzerialonggrove.com/","map_url":"","timezone":"America/Chicago","operational_status":"active","cuisines":["American","Fast Food","Pasta","Pizza","Salads"],"price_range":"","attributes":{},"hours":[{"service":"business","text":"Tuesday 11:30-20:30"},{"service":"business","text":"Wednesday 11:30-20:30"},{"service":"business","text":"Thursday 11:30-20:30"},{"service":"business","text":"Friday 11:30-21:30"},{"service":"business","text":"Saturday 11:30-21:30"},{"service":"business","text":"Sunday 11:30-20:30"}],"links":[{"kind":"ordering","url":"https://www.grubhub.com/restaurant/joanies-pizzeria-of-long-grove-235-robert-parker-coffin-rd-long-grove/7493728","provider":"grubhub"}],"resolution_meta":{"coordinates":{"status":"material_conflict","reason":"venue point corroborated within 25m by distinct associated source families","selected_source":"spothopper","alternatives":[{"value":{"latitude":42.178659002072,"longitude":-87.997448787531},"source":"us_census_geocoder"},{"value":{"latitude":42.179275779199386,"longitude":-87.99928528477498},"source":"website embedded map centre"}]}},"field_sources":{"name":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"phone":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"website":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location page"],"last_confirmed_at":"2026-10-27T19:38:55.054301Z"},"cuisines":{"basis":"external_source","via":["https://api-gtm.grubhub.com/restaurants/7493728?hideChoiceCategories=true&version=4&orderType=standard&hideUnavailableMenuItems=false","grubhub"],"last_confirmed_at":"2026-10-27T19:39:30.112592Z"},"dba_name":{"basis":"external_source","via":["https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","IL_LCC"],"last_confirmed_at":"2026-10-27T19:39:48.908716Z"},"timezone":{"basis":"external_source","via":["https://www.spothopperapp.com/api/spots/588337","spothopper"],"last_confirmed_at":"2026-10-27T19:39:34.208895Z"},"coordinates":{"basis":"external_source","via":["https://www.spothopperapp.com/api/spots/588337","spothopper"],"last_confirmed_at":"2026-10-27T19:39:34.208895Z"},"address.city":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"declared_type":{"basis":"external_source","via":["https://www.spothopperapp.com/api/spots/588337","spothopper"],"last_confirmed_at":"2026-10-27T19:39:34.208895Z"},"address.region":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"address.street":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"hours.business":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"address.country":{"basis":"external_source","via":["https://www.spothopperapp.com/api/spots/588337","spothopper"],"last_confirmed_at":"2026-10-27T19:39:34.208895Z"},"operational_status":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:38:55.054301Z"},"address.postal_code":{"basis":"publisher_declared","via":["https://www.joaniespizzerialonggrove.com/","website location card"],"last_confirmed_at":"2026-10-27T19:39:07.437605Z"},"operating_legal_name":{"basis":"external_source","via":["https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","IL_LCC"],"last_confirmed_at":"2026-10-27T19:39:48.908716Z"},"licenses.il_lcc_licenses":{"basis":"external_source","via":["https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","IL_LCC"],"last_confirmed_at":"2026-10-27T19:39:48.908716Z"}},"id":"e2697a48-984b-4123-8074-ffd4d2099bfd","revision":1,"association_status":"accepted","identifiers":[{"provider":"foursquare","kind":"foursquare_id","value":"592230756bdee630c3a0a1cc","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:34.208895Z","last_confirmed_at":"2026-10-27T19:39:34.208895Z"},{"provider":"google","kind":"google_place_id","value":"ChIJhwiUqti8D4gRE_tI9sFDApQ","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:34.208895Z","last_confirmed_at":"2026-10-27T19:39:34.208895Z"},{"provider":"grubhub","kind":"grubhub_restaurant_id","value":"7493728","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:30.112592Z","last_confirmed_at":"2026-10-27T19:39:30.112592Z"},{"provider":"IL_LCC","kind":"liquor_license_id","value":"1A-1128660","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"},{"provider":"IL_LCC","kind":"liquor_license_id","value":"1A-1149830","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"},{"provider":"IL_LCC","kind":"liquor_license_id","value":"4C-1134516","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"},{"provider":"spothopper","kind":"spothopper_spot_id","value":"588337","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-27T19:39:34.208895Z","last_confirmed_at":"2026-10-27T19:39:34.208895Z"}],"licenses":[{"source_id":"il_lcc_licenses","authority":"IL_LCC","jurisdiction":"IL","kind":"liquor_license","number":"1A-1128660","parent_number":"","type":"1A - RETAILER","status":"Ceased","state":"not_current","scope":"operator","state_basis":"date_outside_current_period","licensee":"LONG GROVE PIZZA & BBQ LLC","dba_name":"JOANIES PIZZERIA OF LONG GROVE","issued_date":"2020-11-30","original_issue_date":"","effective_date":"2020-12-01","expiration_date":"2021-11-30","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[{"name":"SHUNIA, JOAN","role":"OWNER","kind":"","email":"","phone":"","share":"100.00%","year":""}],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"},{"source_id":"il_lcc_licenses","authority":"IL_LCC","jurisdiction":"IL","kind":"liquor_license","number":"1A-1149830","parent_number":"","type":"1A - RETAILER","status":"Active","state":"current","scope":"operator","state_basis":"explicit_license_status","licensee":"BLUE HERON ESTATE LLC","dba_name":"JOANIE'S PIZZERIA OF LONG GROVE","issued_date":"2025-11-17","original_issue_date":"","effective_date":"2026-01-01","expiration_date":"2026-12-31","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[{"name":"OKUN, MICHAEL","role":"","kind":"","email":"","phone":"","share":"50.00%","year":""},{"name":"FORSYTHE, GERALD","role":"","kind":"","email":"","phone":"","share":"50.00%","year":""}],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"},{"source_id":"il_lcc_licenses","authority":"IL_LCC","jurisdiction":"IL","kind":"liquor_license","number":"4C-1134516","parent_number":"","type":"4C - SPECIAL USE PERMIT >= 2 DAYS","status":"Expired","state":"not_current","scope":"operator","state_basis":"date_outside_current_period","licensee":"LONG GROVE PIZZA & BBQ LLC","dba_name":"JOANIE'S PIZZERIA OF LONG GROVE","issued_date":"2017-06-22","original_issue_date":"","effective_date":"2017-06-23","expiration_date":"2017-09-24","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[{"name":"SHUNIA, JOAN","role":"OWNER","kind":"","email":"","phone":"","share":"100.00%","year":""}],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://ilccportal.illinois.gov/s/sfsites/aura?r=1&aura.ApexAction.execute=1","first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z"}],"contact_routes":[],"domains":["joaniespizzerialonggrove.com"],"first_seen_at":"2026-10-27T19:39:48.908716Z","last_confirmed_at":"2026-10-27T19:39:48.908716Z","materially_changed_at":"2026-10-27T19:40:09.203136Z"}