You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 100 }, "api": { "title": "Stop And Shop Information In USA 1", "desc": "Stop And Shop Information include location,business time & service content", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/main/list/?app=html-json" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/main/list/2/?app=html-json" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 100, "time": 0.004870000000000000196787031114808996790088713169097900390625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 413, "pages_total": 21 }, "struct": { "stem": { "0": "shop" }, "leaf": "shop.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "shop.id": 1, "shop.ts": "2018-11-21 01:28:38", "shop.latitude": 41.33297209999999921592461760155856609344482421875, "shop.longitude": -73.081976400000002058732206933200359344482421875, "shop.address": "100 Division Street", "shop.address_extend": "100 Division Street Ansonia, CT", "shop.country": "US", "shop.postal_code": "06401", "shop.phone": "+1-203-732-3901", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-732-3907", "shop.pharmacy_fax": "+1-844-411-6854", "shop.pharmacy_monday_start": 900, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 900, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 900, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 900, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 900, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1400, "shop.gas_station_phone": "+1-203-734-8878", "shop.gas_station_address": "696 Main Street", "shop.gas_station_postal_code": "06401", "shop.gas_station_latitude": 41.33068399999999797955752001143991947174072265625, "shop.gas_station_longitude": -73.0772429999999957317413645796477794647216796875, "shop.city_x_shop_id": { "1": { "city_x_shop.id": 1, "city.id": 1, "city.ts": "2018-11-19 21:44:06", "city.title": "Ansonia", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "1": { "shop_x_store_service.id": 1, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "2": { "shop_x_store_service.id": 2, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "3": { "shop_x_store_service.id": 3, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "4": { "shop_x_store_service.id": 4, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "5": { "shop_x_store_service.id": 5, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "6": { "shop_x_store_service.id": 6, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "7": { "shop_x_store_service.id": 7, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "8": { "shop_x_store_service.id": 8, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "9": { "shop_x_store_service.id": 9, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" } }, "shop.shop_x_store_department_id": { "1": { "shop_x_store_department.id": 1, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "2": { "shop_x_store_department.id": 2, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "3": { "shop_x_store_department.id": 3, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "4": { "shop_x_store_department.id": 4, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "5": { "shop_x_store_department.id": 5, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "6": { "shop_x_store_department.id": 6, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "7": { "shop_x_store_department.id": 7, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "8": { "shop_x_store_department.id": 8, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "9": { "shop_x_store_department.id": 9, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "10": { "shop_x_store_department.id": 10, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "11": { "shop_x_store_department.id": 11, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "12": { "shop_x_store_department.id": 12, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "2": { "shop.id": 2, "shop.ts": "2018-11-21 01:29:59", "shop.latitude": 41.6304042000000009693394531495869159698486328125, "shop.longitude": -72.755391000000003032255335710942745208740234375, "shop.address": "1135 Farmington Avenue", "shop.address_extend": "1135 Farmington Avenue Berlin, CT", "shop.country": "US", "shop.postal_code": "06037", "shop.phone": "+1-860-828-0276", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 600, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-828-0772", "shop.pharmacy_fax": "+1-844-411-6430", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-828-1359", "shop.gas_station_address": "1239 Farmington Ave", "shop.gas_station_postal_code": "06037", "shop.gas_station_latitude": 41.6277910000000019863364286720752716064453125, "shop.gas_station_longitude": -72.75470699999999624196789227426052093505859375, "shop.city_x_shop_id": { "2": { "city_x_shop.id": 2, "city.id": 2, "city.ts": "2018-11-19 21:44:06", "city.title": "Berlin", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "47": { "shop_x_store_service.id": 47, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "48": { "shop_x_store_service.id": 48, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "49": { "shop_x_store_service.id": 49, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "50": { "shop_x_store_service.id": 50, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "51": { "shop_x_store_service.id": 51, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "52": { "shop_x_store_service.id": 52, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "53": { "shop_x_store_service.id": 53, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "54": { "shop_x_store_service.id": 54, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "46": { "shop_x_store_service.id": 46, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" } }, "shop.shop_x_store_department_id": { "49": { "shop_x_store_department.id": 49, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "50": { "shop_x_store_department.id": 50, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "51": { "shop_x_store_department.id": 51, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "52": { "shop_x_store_department.id": 52, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "53": { "shop_x_store_department.id": 53, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "54": { "shop_x_store_department.id": 54, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "55": { "shop_x_store_department.id": 55, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "56": { "shop_x_store_department.id": 56, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "57": { "shop_x_store_department.id": 57, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "58": { "shop_x_store_department.id": 58, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "59": { "shop_x_store_department.id": 59, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "60": { "shop_x_store_department.id": 60, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "3": { "shop.id": 3, "shop.ts": "2018-11-21 01:31:41", "shop.latitude": 41.8156336062732378877626615576446056365966796875, "shop.longitude": -72.714149951934814453125, "shop.address": "313 Cottage Grove Rd", "shop.address_extend": "313 Cottage Grove Rd Bloomfield, CT", "shop.country": "US", "shop.postal_code": "06002", "shop.phone": "+1-860-242-5954", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 0, "shop.pharmacy_phone": "", "shop.pharmacy_fax": "", "shop.pharmacy_monday_start": "", "shop.pharmacy_monday_end": "", "shop.pharmacy_tuesday_start": "", "shop.pharmacy_tuesday_end": "", "shop.pharmacy_wednesday_start": "", "shop.pharmacy_wednesday_end": "", "shop.pharmacy_thursday_start": "", "shop.pharmacy_thursday_end": "", "shop.pharmacy_friday_start": "", "shop.pharmacy_friday_end": "", "shop.pharmacy_saturday_start": "", "shop.pharmacy_saturday_end": "", "shop.pharmacy_sunday_start": "", "shop.pharmacy_sunday_end": "", "shop.gas_station_phone": "+1-860-286-0570", "shop.gas_station_address": "47 Jerome Ave", "shop.gas_station_postal_code": "06002", "shop.gas_station_latitude": 41.8301459999999991623553796671330928802490234375, "shop.gas_station_longitude": -72.7348510000000061381797422654926776885986328125, "shop.city_x_shop_id": { "3": { "city_x_shop.id": 3, "city.id": 3, "city.ts": "2018-11-19 21:44:06", "city.title": "Bloomfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "55": { "shop_x_store_service.id": 55, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "56": { "shop_x_store_service.id": 56, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "57": { "shop_x_store_service.id": 57, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "58": { "shop_x_store_service.id": 58, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "59": { "shop_x_store_service.id": 59, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "60": { "shop_x_store_service.id": 60, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "61": { "shop_x_store_service.id": 61, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "63": { "shop_x_store_service.id": 63, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "62": { "shop_x_store_service.id": 62, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" } }, "shop.shop_x_store_department_id": { "61": { "shop_x_store_department.id": 61, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "62": { "shop_x_store_department.id": 62, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "63": { "shop_x_store_department.id": 63, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "64": { "shop_x_store_department.id": 64, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "65": { "shop_x_store_department.id": 65, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "66": { "shop_x_store_department.id": 66, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "67": { "shop_x_store_department.id": 67, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "68": { "shop_x_store_department.id": 68, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "69": { "shop_x_store_department.id": 69, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "70": { "shop_x_store_department.id": 70, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "71": { "shop_x_store_department.id": 71, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "4": { "shop.id": 4, "shop.ts": "2018-11-21 01:31:45", "shop.latitude": 41.2977403000000009569703252054750919342041015625, "shop.longitude": -72.7628399999999970759745338000357151031494140625, "shop.address": "22 Leetes Island Rd", "shop.address_extend": "22 Leetes Island Rd Branford, CT", "shop.country": "US", "shop.postal_code": "06405", "shop.phone": "+1-203-488-1325", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-481-3392", "shop.pharmacy_fax": "+1-844-411-6857", "shop.pharmacy_monday_start": 900, "shop.pharmacy_monday_end": 2100, "shop.pharmacy_tuesday_start": 900, "shop.pharmacy_tuesday_end": 2100, "shop.pharmacy_wednesday_start": 900, "shop.pharmacy_wednesday_end": 2100, "shop.pharmacy_thursday_start": 900, "shop.pharmacy_thursday_end": 2100, "shop.pharmacy_friday_start": 900, "shop.pharmacy_friday_end": 2100, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1800, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-203-488-1956", "shop.gas_station_address": "49 Leetes Island Rd", "shop.gas_station_postal_code": "06405", "shop.gas_station_latitude": 41.296390000000002373781171627342700958251953125, "shop.gas_station_longitude": -72.7645360000000067657310864888131618499755859375, "shop.city_x_shop_id": { "4": { "city_x_shop.id": 4, "city.id": 4, "city.ts": "2018-11-19 21:44:06", "city.title": "Branford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "65": { "shop_x_store_service.id": 65, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "66": { "shop_x_store_service.id": 66, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "67": { "shop_x_store_service.id": 67, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "68": { "shop_x_store_service.id": 68, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "69": { "shop_x_store_service.id": 69, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "70": { "shop_x_store_service.id": 70, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "71": { "shop_x_store_service.id": 71, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "72": { "shop_x_store_service.id": 72, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "74": { "shop_x_store_service.id": 74, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "64": { "shop_x_store_service.id": 64, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "73": { "shop_x_store_service.id": 73, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "72": { "shop_x_store_department.id": 72, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "73": { "shop_x_store_department.id": 73, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "74": { "shop_x_store_department.id": 74, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "75": { "shop_x_store_department.id": 75, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "76": { "shop_x_store_department.id": 76, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "77": { "shop_x_store_department.id": 77, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "78": { "shop_x_store_department.id": 78, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "79": { "shop_x_store_department.id": 79, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "80": { "shop_x_store_department.id": 80, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "81": { "shop_x_store_department.id": 81, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "82": { "shop_x_store_department.id": 82, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "83": { "shop_x_store_department.id": 83, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "5": { "shop.id": 5, "shop.ts": "2018-11-21 01:32:09", "shop.latitude": 42.02486939757755379787340643815696239471435546875, "shop.longitude": -73.3219814300537109375, "shop.address": "11 East Main Street", "shop.address_extend": "11 East Main Street Canaan, CT", "shop.country": "US", "shop.postal_code": "06018", "shop.phone": "+1-860-824-7990", "shop.store_monday_start": 700, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 2300, "shop.store_saturday_start": 700, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "", "shop.pharmacy_fax": "", "shop.pharmacy_monday_start": "", "shop.pharmacy_monday_end": "", "shop.pharmacy_tuesday_start": "", "shop.pharmacy_tuesday_end": "", "shop.pharmacy_wednesday_start": "", "shop.pharmacy_wednesday_end": "", "shop.pharmacy_thursday_start": "", "shop.pharmacy_thursday_end": "", "shop.pharmacy_friday_start": "", "shop.pharmacy_friday_end": "", "shop.pharmacy_saturday_start": "", "shop.pharmacy_saturday_end": "", "shop.pharmacy_sunday_start": "", "shop.pharmacy_sunday_end": "", "shop.gas_station_phone": "+1-860-824-1152", "shop.gas_station_address": "3 E Main St", "shop.gas_station_postal_code": "06018", "shop.gas_station_latitude": 42.02436800000000260979504673741757869720458984375, "shop.gas_station_longitude": -73.3237730000000027530404622666537761688232421875, "shop.city_x_shop_id": { "5": { "city_x_shop.id": 5, "city.id": 7, "city.ts": "2018-11-19 21:44:06", "city.title": "Canaan", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "75": { "shop_x_store_service.id": 75, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "76": { "shop_x_store_service.id": 76, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "77": { "shop_x_store_service.id": 77, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "78": { "shop_x_store_service.id": 78, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "79": { "shop_x_store_service.id": 79, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "80": { "shop_x_store_service.id": 80, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" } }, "shop.shop_x_store_department_id": { "84": { "shop_x_store_department.id": 84, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "85": { "shop_x_store_department.id": 85, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "86": { "shop_x_store_department.id": 86, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "87": { "shop_x_store_department.id": 87, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "88": { "shop_x_store_department.id": 88, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "89": { "shop_x_store_department.id": 89, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "90": { "shop_x_store_department.id": 90, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "91": { "shop_x_store_department.id": 91, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "92": { "shop_x_store_department.id": 92, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "93": { "shop_x_store_department.id": 93, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "6": { "shop.id": 6, "shop.ts": "2018-11-21 01:33:00", "shop.latitude": 41.50603437294042663552318117581307888031005859375, "shop.longitude": -72.90125548839569091796875, "shop.address": "275 Highland Avenue", "shop.address_extend": "275 Highland Avenue Cheshire, CT", "shop.country": "US", "shop.postal_code": "06410", "shop.phone": "+1-203-272-3628", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 0, "shop.pharmacy_phone": "+1-203-272-3697", "shop.pharmacy_fax": "+1-844-411-6483", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-203-272-2340", "shop.gas_station_address": "901 W Main St", "shop.gas_station_postal_code": "06410", "shop.gas_station_latitude": 41.51467800000000352156348526477813720703125, "shop.gas_station_longitude": -72.9259200000000049612935981713235378265380859375, "shop.city_x_shop_id": { "6": { "city_x_shop.id": 6, "city.id": 8, "city.ts": "2018-11-19 21:44:06", "city.title": "Cheshire", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "82": { "shop_x_store_service.id": 82, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "83": { "shop_x_store_service.id": 83, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "84": { "shop_x_store_service.id": 84, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "85": { "shop_x_store_service.id": 85, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "86": { "shop_x_store_service.id": 86, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "87": { "shop_x_store_service.id": 87, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "88": { "shop_x_store_service.id": 88, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "89": { "shop_x_store_service.id": 89, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "91": { "shop_x_store_service.id": 91, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "81": { "shop_x_store_service.id": 81, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "90": { "shop_x_store_service.id": 90, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "94": { "shop_x_store_department.id": 94, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "95": { "shop_x_store_department.id": 95, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "96": { "shop_x_store_department.id": 96, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "97": { "shop_x_store_department.id": 97, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "98": { "shop_x_store_department.id": 98, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "99": { "shop_x_store_department.id": 99, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "100": { "shop_x_store_department.id": 100, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "101": { "shop_x_store_department.id": 101, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "102": { "shop_x_store_department.id": 102, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "103": { "shop_x_store_department.id": 103, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "104": { "shop_x_store_department.id": 104, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "105": { "shop_x_store_department.id": 105, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "7": { "shop.id": 7, "shop.ts": "2018-11-21 01:33:42", "shop.latitude": 41.27395460000000326772351399995386600494384765625, "shop.longitude": -72.5054990999999944278897601179778575897216796875, "shop.address": "215 East Main Street", "shop.address_extend": "215 East Main Street Clinton, CT", "shop.country": "US", "shop.postal_code": "06413", "shop.phone": "+1-860-669-2228", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "+1-860-669-6636", "shop.pharmacy_fax": "+1-844-411-6459", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-860-669-4599", "shop.gas_station_address": "196 E Main St", "shop.gas_station_postal_code": "06413", "shop.gas_station_latitude": 41.273628000000002202796167694032192230224609375, "shop.gas_station_longitude": -72.5092810000000014269971870817244052886962890625, "shop.city_x_shop_id": { "7": { "city_x_shop.id": 7, "city.id": 9, "city.ts": "2018-11-19 21:44:06", "city.title": "Clinton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "93": { "shop_x_store_service.id": 93, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "94": { "shop_x_store_service.id": 94, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "95": { "shop_x_store_service.id": 95, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "96": { "shop_x_store_service.id": 96, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "97": { "shop_x_store_service.id": 97, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "98": { "shop_x_store_service.id": 98, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "99": { "shop_x_store_service.id": 99, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "100": { "shop_x_store_service.id": 100, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "102": { "shop_x_store_service.id": 102, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "92": { "shop_x_store_service.id": 92, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "101": { "shop_x_store_service.id": 101, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "106": { "shop_x_store_department.id": 106, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "107": { "shop_x_store_department.id": 107, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "108": { "shop_x_store_department.id": 108, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "109": { "shop_x_store_department.id": 109, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "110": { "shop_x_store_department.id": 110, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "111": { "shop_x_store_department.id": 111, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "112": { "shop_x_store_department.id": 112, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "113": { "shop_x_store_department.id": 113, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "114": { "shop_x_store_department.id": 114, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "115": { "shop_x_store_department.id": 115, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "116": { "shop_x_store_department.id": 116, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "117": { "shop_x_store_department.id": 117, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "8": { "shop.id": 8, "shop.ts": "2018-11-21 01:34:32", "shop.latitude": 41.571084700000000111685949377715587615966796875, "shop.longitude": -72.3337616000000025451299734413623809814453125, "shop.address": "99 Linwood Avenue", "shop.address_extend": "99 Linwood Avenue Colchester, CT", "shop.country": "US", "shop.postal_code": "06415", "shop.phone": "+1-860-537-2361", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-537-2570", "shop.pharmacy_fax": "+1-844-411-6426", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-860-859-3007", "shop.gas_station_address": "2 New London Rd", "shop.gas_station_postal_code": "06420", "shop.gas_station_latitude": 41.47646900000000158570401254110038280487060546875, "shop.gas_station_longitude": -72.2639759999999995443431544117629528045654296875, "shop.city_x_shop_id": { "8": { "city_x_shop.id": 8, "city.id": 10, "city.ts": "2018-11-19 21:44:06", "city.title": "Colchester", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "104": { "shop_x_store_service.id": 104, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "105": { "shop_x_store_service.id": 105, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "106": { "shop_x_store_service.id": 106, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "107": { "shop_x_store_service.id": 107, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "108": { "shop_x_store_service.id": 108, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "110": { "shop_x_store_service.id": 110, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "103": { "shop_x_store_service.id": 103, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "109": { "shop_x_store_service.id": 109, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "118": { "shop_x_store_department.id": 118, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "119": { "shop_x_store_department.id": 119, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "120": { "shop_x_store_department.id": 120, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "121": { "shop_x_store_department.id": 121, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "122": { "shop_x_store_department.id": 122, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "123": { "shop_x_store_department.id": 123, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "124": { "shop_x_store_department.id": 124, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "125": { "shop_x_store_department.id": 125, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "126": { "shop_x_store_department.id": 126, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "127": { "shop_x_store_department.id": 127, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "128": { "shop_x_store_department.id": 128, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "129": { "shop_x_store_department.id": 129, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "9": { "shop.id": 9, "shop.ts": "2018-11-21 01:34:45", "shop.latitude": 41.6018667000000021971573005430400371551513671875, "shop.longitude": -72.678139200000003938839654438197612762451171875, "shop.address": "195 West Street", "shop.address_extend": "195 West Street Cromwell, CT", "shop.country": "US", "shop.postal_code": "06416", "shop.phone": "+1-860-635-8300", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 600, "shop.store_sunday_end": 2300, "shop.pharmacy_phone": "+1-860-635-6303", "shop.pharmacy_fax": "+1-844-411-6424", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-860-347-7722", "shop.gas_station_address": "436 S Main St", "shop.gas_station_postal_code": "06457", "shop.gas_station_latitude": 41.5623580000000032441676012240350246429443359375, "shop.gas_station_longitude": -72.65086900000000014188117347657680511474609375, "shop.city_x_shop_id": { "9": { "city_x_shop.id": 9, "city.id": 11, "city.ts": "2018-11-19 21:44:06", "city.title": "Cromwell", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "112": { "shop_x_store_service.id": 112, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "113": { "shop_x_store_service.id": 113, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "114": { "shop_x_store_service.id": 114, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "115": { "shop_x_store_service.id": 115, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "116": { "shop_x_store_service.id": 116, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "117": { "shop_x_store_service.id": 117, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "118": { "shop_x_store_service.id": 118, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "120": { "shop_x_store_service.id": 120, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "111": { "shop_x_store_service.id": 111, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "119": { "shop_x_store_service.id": 119, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "130": { "shop_x_store_department.id": 130, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "131": { "shop_x_store_department.id": 131, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "132": { "shop_x_store_department.id": 132, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "133": { "shop_x_store_department.id": 133, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "134": { "shop_x_store_department.id": 134, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "135": { "shop_x_store_department.id": 135, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "136": { "shop_x_store_department.id": 136, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "137": { "shop_x_store_department.id": 137, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "138": { "shop_x_store_department.id": 138, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "139": { "shop_x_store_department.id": 139, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "140": { "shop_x_store_department.id": 140, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "141": { "shop_x_store_department.id": 141, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "10": { "shop.id": 10, "shop.ts": "2018-11-21 01:34:51", "shop.latitude": 41.84156782572116384244509390555322170257568359375, "shop.longitude": -71.88063204288482666015625, "shop.address": "1094 Killingly Commons Drive", "shop.address_extend": "1094 Killingly Commons Drive Dayville, CT", "shop.country": "US", "shop.postal_code": "06241", "shop.phone": "+1-860-779-2070", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-774-5301", "shop.pharmacy_fax": "+1-844-411-6485", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-774-9161", "shop.gas_station_address": "1095 N Main St", "shop.gas_station_postal_code": "06241", "shop.gas_station_latitude": 41.84146700000000151931089931167662143707275390625, "shop.gas_station_longitude": -71.87752399999999397550709545612335205078125, "shop.city_x_shop_id": { "10": { "city_x_shop.id": 10, "city.id": 14, "city.ts": "2018-11-19 21:44:06", "city.title": "Dayville", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "121": { "shop_x_store_service.id": 121, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "122": { "shop_x_store_service.id": 122, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "123": { "shop_x_store_service.id": 123, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "124": { "shop_x_store_service.id": 124, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "125": { "shop_x_store_service.id": 125, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" } }, "shop.shop_x_store_department_id": { "142": { "shop_x_store_department.id": 142, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "143": { "shop_x_store_department.id": 143, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "144": { "shop_x_store_department.id": 144, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "145": { "shop_x_store_department.id": 145, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "146": { "shop_x_store_department.id": 146, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "147": { "shop_x_store_department.id": 147, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "148": { "shop_x_store_department.id": 148, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "149": { "shop_x_store_department.id": 149, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "150": { "shop_x_store_department.id": 150, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "151": { "shop_x_store_department.id": 151, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "152": { "shop_x_store_department.id": 152, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "11": { "shop.id": 11, "shop.ts": "2018-11-21 01:35:14", "shop.latitude": 41.58426085234276570190559141337871551513671875, "shop.longitude": -72.50532925128936767578125, "shop.address": "11 E High Street", "shop.address_extend": "11 E High Street East Hampton, CT", "shop.country": "US", "shop.postal_code": "06424", "shop.phone": "+1-860-267-2039", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-267-2771", "shop.pharmacy_fax": "+1-844-411-6587", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-347-7722", "shop.gas_station_address": "436 S Main St", "shop.gas_station_postal_code": "06457", "shop.gas_station_latitude": 41.5623580000000032441676012240350246429443359375, "shop.gas_station_longitude": -72.65086900000000014188117347657680511474609375, "shop.city_x_shop_id": { "11": { "city_x_shop.id": 11, "city.id": 15, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hampton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "128": { "shop_x_store_service.id": 128, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "129": { "shop_x_store_service.id": 129, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "130": { "shop_x_store_service.id": 130, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "131": { "shop_x_store_service.id": 131, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "133": { "shop_x_store_service.id": 133, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "135": { "shop_x_store_service.id": 135, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "126": { "shop_x_store_service.id": 126, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "134": { "shop_x_store_service.id": 134, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "127": { "shop_x_store_service.id": 127, "store_service.id": 127, "store_service.ts": "2018-11-21 01:35:13", "store_service.store_service": "Check It!" }, "132": { "shop_x_store_service.id": 132, "store_service.id": 132, "store_service.ts": "2018-11-21 01:35:13", "store_service.store_service": "A+ Bonus Bucks" } }, "shop.shop_x_store_department_id": { "153": { "shop_x_store_department.id": 153, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "154": { "shop_x_store_department.id": 154, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "155": { "shop_x_store_department.id": 155, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "156": { "shop_x_store_department.id": 156, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "157": { "shop_x_store_department.id": 157, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "158": { "shop_x_store_department.id": 158, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "159": { "shop_x_store_department.id": 159, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "160": { "shop_x_store_department.id": 160, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "161": { "shop_x_store_department.id": 161, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "162": { "shop_x_store_department.id": 162, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "163": { "shop_x_store_department.id": 163, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "12": { "shop.id": 12, "shop.ts": "2018-11-21 01:35:26", "shop.latitude": 41.76893650000000235422703553922474384307861328125, "shop.longitude": -72.60387420000000702202669344842433929443359375, "shop.address": "940 Silver Lane", "shop.address_extend": "940 Silver Lane East Hartford, CT", "shop.country": "US", "shop.postal_code": "06118", "shop.phone": "+1-860-569-7050", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-569-7135", "shop.pharmacy_fax": "+1-844-411-6481", "shop.pharmacy_monday_start": 900, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 900, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 900, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 900, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 900, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1400, "shop.gas_station_phone": "+1-860-568-8819", "shop.gas_station_address": "1475 Silver Ln", "shop.gas_station_postal_code": "06118", "shop.gas_station_latitude": 41.76556000000000068439476308412849903106689453125, "shop.gas_station_longitude": -72.5786140000000017380443750880658626556396484375, "shop.city_x_shop_id": { "12": { "city_x_shop.id": 12, "city.id": 16, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hartford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "137": { "shop_x_store_service.id": 137, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "138": { "shop_x_store_service.id": 138, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "139": { "shop_x_store_service.id": 139, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "140": { "shop_x_store_service.id": 140, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "141": { "shop_x_store_service.id": 141, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "142": { "shop_x_store_service.id": 142, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "143": { "shop_x_store_service.id": 143, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "145": { "shop_x_store_service.id": 145, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "136": { "shop_x_store_service.id": 136, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "144": { "shop_x_store_service.id": 144, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" } }, "shop.shop_x_store_department_id": { "164": { "shop_x_store_department.id": 164, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "165": { "shop_x_store_department.id": 165, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "166": { "shop_x_store_department.id": 166, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "167": { "shop_x_store_department.id": 167, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "168": { "shop_x_store_department.id": 168, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "169": { "shop_x_store_department.id": 169, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "170": { "shop_x_store_department.id": 170, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "171": { "shop_x_store_department.id": 171, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "172": { "shop_x_store_department.id": 172, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "173": { "shop_x_store_department.id": 173, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "174": { "shop_x_store_department.id": 174, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "13": { "shop.id": 13, "shop.ts": "2018-11-21 01:35:44", "shop.latitude": 41.27820154985247569356943131424486637115478515625, "shop.longitude": -72.86928623914712943587801419198513031005859375, "shop.address": "370 Hemingway Avenue", "shop.address_extend": "370 Hemingway Avenue East Haven, CT", "shop.country": "US", "shop.postal_code": "06512", "shop.phone": "+1-203-468-7012", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-468-1113", "shop.pharmacy_fax": "+1-844-411-6480", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1800, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-203-467-3661", "shop.gas_station_address": "1183 Townsend Ave", "shop.gas_station_postal_code": "06512", "shop.gas_station_latitude": 41.288600999999999885403667576611042022705078125, "shop.gas_station_longitude": -72.892191999999994322934071533381938934326171875, "shop.city_x_shop_id": { "13": { "city_x_shop.id": 13, "city.id": 17, "city.ts": "2018-11-19 21:44:06", "city.title": "East Haven", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "146": { "shop_x_store_service.id": 146, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "147": { "shop_x_store_service.id": 147, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "148": { "shop_x_store_service.id": 148, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "149": { "shop_x_store_service.id": 149, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "150": { "shop_x_store_service.id": 150, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "151": { "shop_x_store_service.id": 151, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "152": { "shop_x_store_service.id": 152, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "153": { "shop_x_store_service.id": 153, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "154": { "shop_x_store_service.id": 154, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" } }, "shop.shop_x_store_department_id": { "175": { "shop_x_store_department.id": 175, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "176": { "shop_x_store_department.id": 176, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "177": { "shop_x_store_department.id": 177, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "178": { "shop_x_store_department.id": 178, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "179": { "shop_x_store_department.id": 179, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "180": { "shop_x_store_department.id": 180, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "181": { "shop_x_store_department.id": 181, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "182": { "shop_x_store_department.id": 182, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "183": { "shop_x_store_department.id": 183, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "184": { "shop_x_store_department.id": 184, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "185": { "shop_x_store_department.id": 185, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "14": { "shop.id": 14, "shop.ts": "2018-11-21 01:35:48", "shop.latitude": 41.35673129999999986239345162175595760345458984375, "shop.longitude": -72.21170449999999618739821016788482666015625, "shop.address": "248 Flanders Road", "shop.address_extend": "248 Flanders Road East Lyme, CT", "shop.country": "US", "shop.postal_code": "06333", "shop.phone": "+1-860-691-2146", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-739-5957", "shop.pharmacy_fax": "+1-844-411-6468", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-860-739-6065", "shop.gas_station_address": "113 Boston Post Rd", "shop.gas_station_postal_code": "06333", "shop.gas_station_latitude": 41.36631700000000222416929318569600582122802734375, "shop.gas_station_longitude": -72.2102110000000010359144653193652629852294921875, "shop.city_x_shop_id": { "14": { "city_x_shop.id": 14, "city.id": 18, "city.ts": "2018-11-19 21:44:06", "city.title": "East Lyme", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "155": { "shop_x_store_service.id": 155, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "156": { "shop_x_store_service.id": 156, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "157": { "shop_x_store_service.id": 157, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "158": { "shop_x_store_service.id": 158, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "159": { "shop_x_store_service.id": 159, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "160": { "shop_x_store_service.id": 160, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "161": { "shop_x_store_service.id": 161, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "163": { "shop_x_store_service.id": 163, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "165": { "shop_x_store_service.id": 165, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "164": { "shop_x_store_service.id": 164, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "162": { "shop_x_store_service.id": 162, "store_service.id": 162, "store_service.ts": "2018-11-21 01:35:48", "store_service.store_service": "WiFi" }, "166": { "shop_x_store_service.id": 166, "store_service.id": 166, "store_service.ts": "2018-11-21 01:35:48", "store_service.store_service": "Weigh It!" }, "167": { "shop_x_store_service.id": 167, "store_service.id": 167, "store_service.ts": "2018-11-21 01:35:48", "store_service.store_service": "Starbucks" } }, "shop.shop_x_store_department_id": { "186": { "shop_x_store_department.id": 186, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "187": { "shop_x_store_department.id": 187, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "188": { "shop_x_store_department.id": 188, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "189": { "shop_x_store_department.id": 189, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "190": { "shop_x_store_department.id": 190, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "191": { "shop_x_store_department.id": 191, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "192": { "shop_x_store_department.id": 192, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "193": { "shop_x_store_department.id": 193, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "194": { "shop_x_store_department.id": 194, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "195": { "shop_x_store_department.id": 195, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "196": { "shop_x_store_department.id": 196, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "197": { "shop_x_store_department.id": 197, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "15": { "shop.id": 15, "shop.ts": "2018-11-21 01:36:25", "shop.latitude": 41.9882281000000006088157533667981624603271484375, "shop.longitude": -72.5744875999999976556864567101001739501953125, "shop.address": "54 Hazard Avenue", "shop.address_extend": "54 Hazard Avenue Enfield, CT", "shop.country": "US", "shop.postal_code": "06082", "shop.phone": "+1-860-741-2200", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 0, "shop.pharmacy_phone": "+1-860-741-2230", "shop.pharmacy_fax": "+1-844-411-6586", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-763-2120", "shop.gas_station_address": "241 Hazard Ave", "shop.gas_station_postal_code": "06082", "shop.gas_station_latitude": 41.98737299999999805777406436391174793243408203125, "shop.gas_station_longitude": -72.54464500000000271029421128332614898681640625, "shop.city_x_shop_id": { "15": { "city_x_shop.id": 15, "city.id": 19, "city.ts": "2018-11-19 21:44:06", "city.title": "Enfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "169": { "shop_x_store_service.id": 169, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "170": { "shop_x_store_service.id": 170, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "171": { "shop_x_store_service.id": 171, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "172": { "shop_x_store_service.id": 172, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "173": { "shop_x_store_service.id": 173, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "174": { "shop_x_store_service.id": 174, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "175": { "shop_x_store_service.id": 175, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "177": { "shop_x_store_service.id": 177, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "168": { "shop_x_store_service.id": 168, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "176": { "shop_x_store_service.id": 176, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" } }, "shop.shop_x_store_department_id": { "198": { "shop_x_store_department.id": 198, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "199": { "shop_x_store_department.id": 199, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "200": { "shop_x_store_department.id": 200, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "201": { "shop_x_store_department.id": 201, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "202": { "shop_x_store_department.id": 202, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "203": { "shop_x_store_department.id": 203, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "204": { "shop_x_store_department.id": 204, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "205": { "shop_x_store_department.id": 205, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "206": { "shop_x_store_department.id": 206, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "207": { "shop_x_store_department.id": 207, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "208": { "shop_x_store_department.id": 208, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "209": { "shop_x_store_department.id": 209, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "16": { "shop.id": 16, "shop.ts": "2018-11-21 01:36:41", "shop.latitude": 41.9359141999999991412551025860011577606201171875, "shop.longitude": -72.7890747000000004618414095602929592132568359375, "shop.address": "120 Salmon Brook Street", "shop.address_extend": "120 Salmon Brook Street Granby, CT", "shop.country": "US", "shop.postal_code": "06035", "shop.phone": "+1-860-844-8331", "shop.store_monday_start": 600, "shop.store_monday_end": 2300, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2300, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2300, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2300, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2300, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2300, "shop.pharmacy_phone": "+1-860-844-8346", "shop.pharmacy_fax": "+1-844-411-6428", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-627-8010", "shop.gas_station_address": "80 Ella Grasso Tpke", "shop.gas_station_postal_code": "06096", "shop.gas_station_latitude": 41.920242999999999256033333949744701385498046875, "shop.gas_station_longitude": -72.671616999999997688064468093216419219970703125, "shop.city_x_shop_id": { "16": { "city_x_shop.id": 16, "city.id": 22, "city.ts": "2018-11-19 21:44:06", "city.title": "Granby", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "179": { "shop_x_store_service.id": 179, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "180": { "shop_x_store_service.id": 180, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "181": { "shop_x_store_service.id": 181, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "182": { "shop_x_store_service.id": 182, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "183": { "shop_x_store_service.id": 183, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "184": { "shop_x_store_service.id": 184, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "185": { "shop_x_store_service.id": 185, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "186": { "shop_x_store_service.id": 186, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "187": { "shop_x_store_service.id": 187, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "178": { "shop_x_store_service.id": 178, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" } }, "shop.shop_x_store_department_id": { "210": { "shop_x_store_department.id": 210, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "211": { "shop_x_store_department.id": 211, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "212": { "shop_x_store_department.id": 212, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "213": { "shop_x_store_department.id": 213, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "214": { "shop_x_store_department.id": 214, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "215": { "shop_x_store_department.id": 215, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "216": { "shop_x_store_department.id": 216, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "217": { "shop_x_store_department.id": 217, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "218": { "shop_x_store_department.id": 218, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "219": { "shop_x_store_department.id": 219, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "220": { "shop_x_store_department.id": 220, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "17": { "shop.id": 17, "shop.ts": "2018-11-21 01:36:51", "shop.latitude": 41.3682018088382932319291285239160060882568359375, "shop.longitude": -72.06630527973175048828125, "shop.address": "220 Route 12", "shop.address_extend": "220 Route 12 Groton, CT", "shop.country": "US", "shop.postal_code": "06340", "shop.phone": "+1-860-445-4440", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-860-445-8807", "shop.pharmacy_fax": "+1-844-411-6474", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-860-445-1080", "shop.gas_station_address": "294 Route 12", "shop.gas_station_postal_code": "06340", "shop.gas_station_latitude": 41.3703220000000015943442122079432010650634765625, "shop.gas_station_longitude": -72.070840000000004010871634818613529205322265625, "shop.city_x_shop_id": { "17": { "city_x_shop.id": 17, "city.id": 24, "city.ts": "2018-11-19 21:44:06", "city.title": "Groton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "189": { "shop_x_store_service.id": 189, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "190": { "shop_x_store_service.id": 190, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "191": { "shop_x_store_service.id": 191, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "192": { "shop_x_store_service.id": 192, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "193": { "shop_x_store_service.id": 193, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "194": { "shop_x_store_service.id": 194, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "195": { "shop_x_store_service.id": 195, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "198": { "shop_x_store_service.id": 198, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "188": { "shop_x_store_service.id": 188, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "197": { "shop_x_store_service.id": 197, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" }, "196": { "shop_x_store_service.id": 196, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "199": { "shop_x_store_service.id": 199, "store_service.id": 167, "store_service.ts": "2018-11-21 01:35:48", "store_service.store_service": "Starbucks" } }, "shop.shop_x_store_department_id": { "221": { "shop_x_store_department.id": 221, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "222": { "shop_x_store_department.id": 222, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "223": { "shop_x_store_department.id": 223, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "224": { "shop_x_store_department.id": 224, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "225": { "shop_x_store_department.id": 225, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "226": { "shop_x_store_department.id": 226, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "227": { "shop_x_store_department.id": 227, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "228": { "shop_x_store_department.id": 228, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "229": { "shop_x_store_department.id": 229, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "230": { "shop_x_store_department.id": 230, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "231": { "shop_x_store_department.id": 231, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "18": { "shop.id": 18, "shop.ts": "2018-11-21 01:38:30", "shop.latitude": 41.37229289999999792826201883144676685333251953125, "shop.longitude": -72.914168300000000044747139327228069305419921875, "shop.address": "2335 Dixwell Avenue", "shop.address_extend": "2335 Dixwell Avenue Hamden, CT", "shop.country": "US", "shop.postal_code": "06514", "shop.phone": "+1-203-248-9615", "shop.store_monday_start": 0, "shop.store_monday_end": 0, "shop.store_tuesday_start": 0, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 0, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 0, "shop.store_friday_end": 0, "shop.store_saturday_start": 0, "shop.store_saturday_end": 0, "shop.store_sunday_start": 0, "shop.store_sunday_end": 0, "shop.pharmacy_phone": "+1-203-248-9631", "shop.pharmacy_fax": "+1-844-411-6420", "shop.pharmacy_monday_start": 900, "shop.pharmacy_monday_end": 2100, "shop.pharmacy_tuesday_start": 900, "shop.pharmacy_tuesday_end": 2100, "shop.pharmacy_wednesday_start": 900, "shop.pharmacy_wednesday_end": 2100, "shop.pharmacy_thursday_start": 900, "shop.pharmacy_thursday_end": 2100, "shop.pharmacy_friday_start": 900, "shop.pharmacy_friday_end": 2100, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1800, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1600, "shop.gas_station_phone": "+1-203-248-8320", "shop.gas_station_address": "1994 Whitney Ave", "shop.gas_station_postal_code": "06517", "shop.gas_station_latitude": 41.37083899999999658803062629885971546173095703125, "shop.gas_station_longitude": -72.906620000000003756213118322193622589111328125, "shop.city_x_shop_id": { "18": { "city_x_shop.id": 18, "city.id": 25, "city.ts": "2018-11-19 21:44:06", "city.title": "Hamden", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "201": { "shop_x_store_service.id": 201, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "202": { "shop_x_store_service.id": 202, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "203": { "shop_x_store_service.id": 203, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "204": { "shop_x_store_service.id": 204, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "205": { "shop_x_store_service.id": 205, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "206": { "shop_x_store_service.id": 206, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "207": { "shop_x_store_service.id": 207, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "208": { "shop_x_store_service.id": 208, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "210": { "shop_x_store_service.id": 210, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "209": { "shop_x_store_service.id": 209, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "200": { "shop_x_store_service.id": 200, "store_service.id": 200, "store_service.ts": "2018-11-21 01:38:30", "store_service.store_service": "Dunkin Donuts" } }, "shop.shop_x_store_department_id": { "232": { "shop_x_store_department.id": 232, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "233": { "shop_x_store_department.id": 233, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "234": { "shop_x_store_department.id": 234, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "235": { "shop_x_store_department.id": 235, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "236": { "shop_x_store_department.id": 236, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "237": { "shop_x_store_department.id": 237, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "238": { "shop_x_store_department.id": 238, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "239": { "shop_x_store_department.id": 239, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "240": { "shop_x_store_department.id": 240, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "241": { "shop_x_store_department.id": 241, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "242": { "shop_x_store_department.id": 242, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "19": { "shop.id": 19, "shop.ts": "2018-11-21 01:39:50", "shop.latitude": 41.75181429999999949131961329840123653411865234375, "shop.longitude": -72.7085742000000010420990292914211750030517578125, "shop.address": "150 New Park Avenue", "shop.address_extend": "150 New Park Avenue Hartford, CT", "shop.country": "US", "shop.postal_code": "06106", "shop.phone": "+1-860-232-8777", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 0, "shop.pharmacy_phone": "+1-860-232-8848", "shop.pharmacy_fax": "+1-844-411-6445", "shop.pharmacy_monday_start": 900, "shop.pharmacy_monday_end": 2100, "shop.pharmacy_tuesday_start": 900, "shop.pharmacy_tuesday_end": 2100, "shop.pharmacy_wednesday_start": 900, "shop.pharmacy_wednesday_end": 2100, "shop.pharmacy_thursday_start": 900, "shop.pharmacy_thursday_end": 2100, "shop.pharmacy_friday_start": 900, "shop.pharmacy_friday_end": 2100, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1500, "shop.gas_station_phone": "+1-860-236-0286", "shop.gas_station_address": "195 Prospect Ave", "shop.gas_station_postal_code": "06106", "shop.gas_station_latitude": 41.75144399999999933470462565310299396514892578125, "shop.gas_station_longitude": -72.7154689999999988003764883615076541900634765625, "shop.city_x_shop_id": { "19": { "city_x_shop.id": 19, "city.id": 26, "city.ts": "2018-11-19 21:44:06", "city.title": "Hartford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "212": { "shop_x_store_service.id": 212, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "213": { "shop_x_store_service.id": 213, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "214": { "shop_x_store_service.id": 214, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "215": { "shop_x_store_service.id": 215, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "216": { "shop_x_store_service.id": 216, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "217": { "shop_x_store_service.id": 217, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "219": { "shop_x_store_service.id": 219, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "218": { "shop_x_store_service.id": 218, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" }, "211": { "shop_x_store_service.id": 211, "store_service.id": 200, "store_service.ts": "2018-11-21 01:38:30", "store_service.store_service": "Dunkin Donuts" } }, "shop.shop_x_store_department_id": { "243": { "shop_x_store_department.id": 243, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "244": { "shop_x_store_department.id": 244, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "245": { "shop_x_store_department.id": 245, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "246": { "shop_x_store_department.id": 246, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "247": { "shop_x_store_department.id": 247, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "248": { "shop_x_store_department.id": 248, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "249": { "shop_x_store_department.id": 249, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "250": { "shop_x_store_department.id": 250, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "251": { "shop_x_store_department.id": 251, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "252": { "shop_x_store_department.id": 252, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "253": { "shop_x_store_department.id": 253, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "20": { "shop.id": 20, "shop.ts": "2018-11-21 01:40:04", "shop.latitude": 41.27757667341625591461706790141761302947998046875, "shop.longitude": -72.59650155901914558853604830801486968994140625, "shop.address": "128 Samson Rock Road", "shop.address_extend": "128 Samson Rock Road Madison, CT", "shop.country": "US", "shop.postal_code": "06443", "shop.phone": "+1-203-245-7204", "shop.store_monday_start": 600, "shop.store_monday_end": 0, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 0, "shop.store_saturday_start": 600, "shop.store_saturday_end": 0, "shop.store_sunday_start": 600, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "+1-203-245-7467", "shop.pharmacy_fax": "+1-844-411-6438", "shop.pharmacy_monday_start": 800, "shop.pharmacy_monday_end": 2000, "shop.pharmacy_tuesday_start": 800, "shop.pharmacy_tuesday_end": 2000, "shop.pharmacy_wednesday_start": 800, "shop.pharmacy_wednesday_end": 2000, "shop.pharmacy_thursday_start": 800, "shop.pharmacy_thursday_end": 2000, "shop.pharmacy_friday_start": 800, "shop.pharmacy_friday_end": 2000, "shop.pharmacy_saturday_start": 900, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 900, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-203-245-2585", "shop.gas_station_address": "646 Boston Post Rd", "shop.gas_station_postal_code": "06443", "shop.gas_station_latitude": 41.2791160000000019181243260391056537628173828125, "shop.gas_station_longitude": -72.5973110000000048103174776770174503326416015625, "shop.city_x_shop_id": { "20": { "city_x_shop.id": 20, "city.id": 28, "city.ts": "2018-11-19 21:44:06", "city.title": "Madison", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "221": { "shop_x_store_service.id": 221, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "222": { "shop_x_store_service.id": 222, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "223": { "shop_x_store_service.id": 223, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "224": { "shop_x_store_service.id": 224, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "225": { "shop_x_store_service.id": 225, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "226": { "shop_x_store_service.id": 226, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "227": { "shop_x_store_service.id": 227, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "228": { "shop_x_store_service.id": 228, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "230": { "shop_x_store_service.id": 230, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "220": { "shop_x_store_service.id": 220, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "229": { "shop_x_store_service.id": 229, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" } }, "shop.shop_x_store_department_id": { "254": { "shop_x_store_department.id": 254, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "255": { "shop_x_store_department.id": 255, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "256": { "shop_x_store_department.id": 256, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "257": { "shop_x_store_department.id": 257, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "258": { "shop_x_store_department.id": 258, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "259": { "shop_x_store_department.id": 259, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "260": { "shop_x_store_department.id": 260, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "261": { "shop_x_store_department.id": 261, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "262": { "shop_x_store_department.id": 262, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "263": { "shop_x_store_department.id": 263, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "264": { "shop_x_store_department.id": 264, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } } } } }