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&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 100, "time": 0.00498000000000000005162537064506977912969887256622314453125 }, "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": { "21": { "shop.id": 21, "shop.ts": "2018-11-21 01:40:50", "shop.latitude": 41.778996822788627696354524232447147369384765625, "shop.longitude": -72.5372636318206787109375, "shop.address": "318 West Middle Turnpike", "shop.address_extend": "318 West Middle Turnpike Manchester, CT", "shop.country": "US", "shop.postal_code": "06040", "shop.phone": "+1-860-645-8050", "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-647-0325", "shop.pharmacy_fax": "+1-844-411-6479", "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-649-2337", "shop.gas_station_address": "404 Hartford Road", "shop.gas_station_postal_code": "06040", "shop.gas_station_latitude": 41.76427000000000333557181875221431255340576171875, "shop.gas_station_longitude": -72.539207000000004654793883673846721649169921875, "shop.city_x_shop_id": { "21": { "city_x_shop.id": 21, "city.id": 29, "city.ts": "2018-11-19 21:44:06", "city.title": "Manchester", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "231": { "shop_x_store_service.id": 231, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "232": { "shop_x_store_service.id": 232, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "233": { "shop_x_store_service.id": 233, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "234": { "shop_x_store_service.id": 234, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "235": { "shop_x_store_service.id": 235, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "237": { "shop_x_store_service.id": 237, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "236": { "shop_x_store_service.id": 236, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" }, "238": { "shop_x_store_service.id": 238, "store_service.id": 238, "store_service.ts": "2018-11-21 01:40:50", "store_service.store_service": "Fastcare Clinic" } }, "shop.shop_x_store_department_id": { "265": { "shop_x_store_department.id": 265, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "266": { "shop_x_store_department.id": 266, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "267": { "shop_x_store_department.id": 267, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "268": { "shop_x_store_department.id": 268, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "269": { "shop_x_store_department.id": 269, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "270": { "shop_x_store_department.id": 270, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "271": { "shop_x_store_department.id": 271, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "272": { "shop_x_store_department.id": 272, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "273": { "shop_x_store_department.id": 273, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "274": { "shop_x_store_department.id": 274, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "275": { "shop_x_store_department.id": 275, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "276": { "shop_x_store_department.id": 276, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "22": { "shop.id": 22, "shop.ts": "2018-11-21 01:40:57", "shop.latitude": 41.545597066431611210646224208176136016845703125, "shop.longitude": -72.636988162994384765625, "shop.address": "416 East Main Street", "shop.address_extend": "416 East Main Street Middletown, CT", "shop.country": "US", "shop.postal_code": "06457", "shop.phone": "+1-860-346-0160", "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-346-1779", "shop.pharmacy_fax": "+1-844-411-6437", "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": { "22": { "city_x_shop.id": 22, "city.id": 31, "city.ts": "2018-11-19 21:44:06", "city.title": "Middletown", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "240": { "shop_x_store_service.id": 240, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "241": { "shop_x_store_service.id": 241, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "242": { "shop_x_store_service.id": 242, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "243": { "shop_x_store_service.id": 243, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "244": { "shop_x_store_service.id": 244, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "245": { "shop_x_store_service.id": 245, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "246": { "shop_x_store_service.id": 246, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "248": { "shop_x_store_service.id": 248, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "239": { "shop_x_store_service.id": 239, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "247": { "shop_x_store_service.id": 247, "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": { "277": { "shop_x_store_department.id": 277, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "278": { "shop_x_store_department.id": 278, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "279": { "shop_x_store_department.id": 279, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "280": { "shop_x_store_department.id": 280, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "281": { "shop_x_store_department.id": 281, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "282": { "shop_x_store_department.id": 282, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "283": { "shop_x_store_department.id": 283, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "284": { "shop_x_store_department.id": 284, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "285": { "shop_x_store_department.id": 285, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "286": { "shop_x_store_department.id": 286, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "287": { "shop_x_store_department.id": 287, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "23": { "shop.id": 23, "shop.ts": "2018-11-21 01:41:07", "shop.latitude": 41.31457149999999955980456434190273284912109375, "shop.longitude": -73.2164996999999999616193235851824283599853515625, "shop.address": "470 Monroe Turnpike", "shop.address_extend": "470 Monroe Turnpike Monroe, CT", "shop.country": "US", "shop.postal_code": "06468", "shop.phone": "+1-203-268-0589", "shop.store_monday_start": 700, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 2200, "shop.store_saturday_start": 700, "shop.store_saturday_end": 2200, "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-203-261-0661", "shop.gas_station_address": "536 Monroe Tpke", "shop.gas_station_postal_code": "06468", "shop.gas_station_latitude": 41.31866099999999875080902711488306522369384765625, "shop.gas_station_longitude": -73.2142050000000068621375248767435550689697265625, "shop.city_x_shop_id": { "23": { "city_x_shop.id": 23, "city.id": 33, "city.ts": "2018-11-19 21:44:06", "city.title": "Monroe", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "249": { "shop_x_store_service.id": 249, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "251": { "shop_x_store_service.id": 251, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "252": { "shop_x_store_service.id": 252, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "253": { "shop_x_store_service.id": 253, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "254": { "shop_x_store_service.id": 254, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "250": { "shop_x_store_service.id": 250, "store_service.id": 127, "store_service.ts": "2018-11-21 01:35:13", "store_service.store_service": "Check It!" } }, "shop.shop_x_store_department_id": { "288": { "shop_x_store_department.id": 288, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "289": { "shop_x_store_department.id": 289, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "290": { "shop_x_store_department.id": 290, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "291": { "shop_x_store_department.id": 291, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "292": { "shop_x_store_department.id": 292, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "293": { "shop_x_store_department.id": 293, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "294": { "shop_x_store_department.id": 294, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "295": { "shop_x_store_department.id": 295, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "296": { "shop_x_store_department.id": 296, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "297": { "shop_x_store_department.id": 297, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "24": { "shop.id": 24, "shop.ts": "2018-11-21 01:41:15", "shop.latitude": 41.49391469999999770834619994275271892547607421875, "shop.longitude": -73.07932429999999612846295349299907684326171875, "shop.address": "727 Rubber Avenue", "shop.address_extend": "727 Rubber Avenue Naugatuck, CT", "shop.country": "US", "shop.postal_code": "06770", "shop.phone": "+1-203-729-4182", "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-203-723-6939", "shop.pharmacy_fax": "+1-844-411-6422", "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-758-2009", "shop.gas_station_address": "504 Middlebury Rd", "shop.gas_station_postal_code": "06762", "shop.gas_station_latitude": 41.53813199999999739020495326258242130279541015625, "shop.gas_station_longitude": -73.1053050000000013142198440618813037872314453125, "shop.city_x_shop_id": { "24": { "city_x_shop.id": 24, "city.id": 34, "city.ts": "2018-11-19 21:44:06", "city.title": "Naugatuck", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "256": { "shop_x_store_service.id": 256, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "257": { "shop_x_store_service.id": 257, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "258": { "shop_x_store_service.id": 258, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "259": { "shop_x_store_service.id": 259, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "260": { "shop_x_store_service.id": 260, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "261": { "shop_x_store_service.id": 261, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "262": { "shop_x_store_service.id": 262, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "264": { "shop_x_store_service.id": 264, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "255": { "shop_x_store_service.id": 255, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "263": { "shop_x_store_service.id": 263, "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": { "298": { "shop_x_store_department.id": 298, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "299": { "shop_x_store_department.id": 299, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "300": { "shop_x_store_department.id": 300, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "301": { "shop_x_store_department.id": 301, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "302": { "shop_x_store_department.id": 302, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "303": { "shop_x_store_department.id": 303, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "304": { "shop_x_store_department.id": 304, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "305": { "shop_x_store_department.id": 305, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "306": { "shop_x_store_department.id": 306, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "307": { "shop_x_store_department.id": 307, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "308": { "shop_x_store_department.id": 308, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "309": { "shop_x_store_department.id": 309, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "25": { "shop.id": 25, "shop.ts": "2018-11-21 01:41:16", "shop.latitude": 41.66880054117722664841494406573474407196044921875, "shop.longitude": -72.804972231388092041015625, "shop.address": "1309 Corbin Avenue", "shop.address_extend": "1309 Corbin Avenue New Britain, CT", "shop.country": "US", "shop.postal_code": "06053", "shop.phone": "+1-860-348-9856", "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-348-9830", "shop.pharmacy_fax": "+1-844-411-6454", "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-827-9327", "shop.gas_station_address": "1144 Corbin Ave", "shop.gas_station_postal_code": "06053", "shop.gas_station_latitude": 41.66620400000000046247805585153400897979736328125, "shop.gas_station_longitude": -72.8069679999999976871549733914434909820556640625, "shop.city_x_shop_id": { "25": { "city_x_shop.id": 25, "city.id": 35, "city.ts": "2018-11-19 21:44:06", "city.title": "New Britain", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "266": { "shop_x_store_service.id": 266, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "267": { "shop_x_store_service.id": 267, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "268": { "shop_x_store_service.id": 268, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "269": { "shop_x_store_service.id": 269, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "270": { "shop_x_store_service.id": 270, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "271": { "shop_x_store_service.id": 271, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "272": { "shop_x_store_service.id": 272, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "274": { "shop_x_store_service.id": 274, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "265": { "shop_x_store_service.id": 265, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "273": { "shop_x_store_service.id": 273, "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": { "310": { "shop_x_store_department.id": 310, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "312": { "shop_x_store_department.id": 312, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "313": { "shop_x_store_department.id": 313, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "314": { "shop_x_store_department.id": 314, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "315": { "shop_x_store_department.id": 315, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "316": { "shop_x_store_department.id": 316, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "317": { "shop_x_store_department.id": 317, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "318": { "shop_x_store_department.id": 318, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "321": { "shop_x_store_department.id": 321, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "322": { "shop_x_store_department.id": 322, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "323": { "shop_x_store_department.id": 323, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" }, "311": { "shop_x_store_department.id": 311, "store_department.id": 311, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Seafood" }, "319": { "shop_x_store_department.id": 319, "store_department.id": 319, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Baby" }, "320": { "shop_x_store_department.id": 320, "store_department.id": 320, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Pet" } } }, "26": { "shop.id": 26, "shop.ts": "2018-11-21 01:41:29", "shop.latitude": 41.46849755234268997128310729749500751495361328125, "shop.longitude": -73.4845983982086181640625, "shop.address": "25 State Route 39", "shop.address_extend": "25 State Route 39 New Fairfield, CT", "shop.country": "US", "shop.postal_code": "06812", "shop.phone": "+1-203-312-0482", "shop.store_monday_start": 700, "shop.store_monday_end": 0, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 0, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 0, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 0, "shop.store_saturday_start": 700, "shop.store_saturday_end": 0, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-312-9818", "shop.pharmacy_fax": "+1-844-411-6588", "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": 800, "shop.pharmacy_saturday_end": 1700, "shop.pharmacy_sunday_start": 800, "shop.pharmacy_sunday_end": 1700, "shop.gas_station_phone": "+1-845-878-3456", "shop.gas_station_address": "2597 Rt 22", "shop.gas_station_postal_code": 12563, "shop.gas_station_latitude": 41.48405699999999995952748577110469341278076171875, "shop.gas_station_longitude": -73.5760049999999949932316667400300502777099609375, "shop.city_x_shop_id": { "26": { "city_x_shop.id": 26, "city.id": 36, "city.ts": "2018-11-19 21:44:06", "city.title": "New Fairfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "276": { "shop_x_store_service.id": 276, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "277": { "shop_x_store_service.id": 277, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "278": { "shop_x_store_service.id": 278, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "279": { "shop_x_store_service.id": 279, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "281": { "shop_x_store_service.id": 281, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "282": { "shop_x_store_service.id": 282, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "275": { "shop_x_store_service.id": 275, "store_service.id": 127, "store_service.ts": "2018-11-21 01:35:13", "store_service.store_service": "Check It!" }, "280": { "shop_x_store_service.id": 280, "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": { "324": { "shop_x_store_department.id": 324, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "325": { "shop_x_store_department.id": 325, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "326": { "shop_x_store_department.id": 326, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "327": { "shop_x_store_department.id": 327, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "328": { "shop_x_store_department.id": 328, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "329": { "shop_x_store_department.id": 329, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "330": { "shop_x_store_department.id": 330, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "331": { "shop_x_store_department.id": 331, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "332": { "shop_x_store_department.id": 332, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "333": { "shop_x_store_department.id": 333, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "334": { "shop_x_store_department.id": 334, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "27": { "shop.id": 27, "shop.ts": "2018-11-21 01:41:41", "shop.latitude": 41.55037260000000287618604488670825958251953125, "shop.longitude": -73.4192019999999985202521202154457569122314453125, "shop.address": "180 Danbury Road", "shop.address_extend": "180 Danbury Road New Milford, CT", "shop.country": "US", "shop.postal_code": "06776", "shop.phone": "+1-860-355-3234", "shop.store_monday_start": 600, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2200, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "+1-860-355-3763", "shop.pharmacy_fax": "+1-844-411-6475", "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-203-775-0622", "shop.gas_station_address": "819 Federal Rd", "shop.gas_station_postal_code": "06804", "shop.gas_station_latitude": 41.48283500000000145746525959111750125885009765625, "shop.gas_station_longitude": -73.40938199999999369538272731006145477294921875, "shop.city_x_shop_id": { "27": { "city_x_shop.id": 27, "city.id": 38, "city.ts": "2018-11-19 21:44:06", "city.title": "New Milford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "283": { "shop_x_store_service.id": 283, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "284": { "shop_x_store_service.id": 284, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "285": { "shop_x_store_service.id": 285, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "286": { "shop_x_store_service.id": 286, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "287": { "shop_x_store_service.id": 287, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "288": { "shop_x_store_service.id": 288, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "289": { "shop_x_store_service.id": 289, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "290": { "shop_x_store_service.id": 290, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "291": { "shop_x_store_service.id": 291, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" } }, "shop.shop_x_store_department_id": { "335": { "shop_x_store_department.id": 335, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "336": { "shop_x_store_department.id": 336, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "337": { "shop_x_store_department.id": 337, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "338": { "shop_x_store_department.id": 338, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "339": { "shop_x_store_department.id": 339, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "340": { "shop_x_store_department.id": 340, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "341": { "shop_x_store_department.id": 341, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "342": { "shop_x_store_department.id": 342, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "343": { "shop_x_store_department.id": 343, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "344": { "shop_x_store_department.id": 344, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "345": { "shop_x_store_department.id": 345, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "346": { "shop_x_store_department.id": 346, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "28": { "shop.id": 28, "shop.ts": "2018-11-21 01:41:57", "shop.latitude": 41.3722074336953227202684502117335796356201171875, "shop.longitude": -73.273680210113525390625, "shop.address": "228 South Main Street", "shop.address_extend": "228 South Main Street Newtown, CT", "shop.country": "US", "shop.postal_code": "06470", "shop.phone": "+1-203-270-0177", "shop.store_monday_start": 600, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2200, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-270-0827", "shop.pharmacy_fax": "+1-844-411-6855", "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-426-5750", "shop.gas_station_address": "286 S Main St", "shop.gas_station_postal_code": "06470", "shop.gas_station_latitude": 41.36603699999999861347532714717090129852294921875, "shop.gas_station_longitude": -73.2708659999999980527718435041606426239013671875, "shop.city_x_shop_id": { "28": { "city_x_shop.id": 28, "city.id": 40, "city.ts": "2018-11-19 21:44:06", "city.title": "Newtown", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "292": { "shop_x_store_service.id": 292, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "293": { "shop_x_store_service.id": 293, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "294": { "shop_x_store_service.id": 294, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "295": { "shop_x_store_service.id": 295, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "296": { "shop_x_store_service.id": 296, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "297": { "shop_x_store_service.id": 297, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "298": { "shop_x_store_service.id": 298, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "299": { "shop_x_store_service.id": 299, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "301": { "shop_x_store_service.id": 301, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "300": { "shop_x_store_service.id": 300, "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": { "347": { "shop_x_store_department.id": 347, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "348": { "shop_x_store_department.id": 348, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "349": { "shop_x_store_department.id": 349, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "350": { "shop_x_store_department.id": 350, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "351": { "shop_x_store_department.id": 351, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "352": { "shop_x_store_department.id": 352, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "353": { "shop_x_store_department.id": 353, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "354": { "shop_x_store_department.id": 354, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "355": { "shop_x_store_department.id": 355, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "356": { "shop_x_store_department.id": 356, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "357": { "shop_x_store_department.id": 357, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "29": { "shop.id": 29, "shop.ts": "2018-11-21 01:42:39", "shop.latitude": 41.39380537598881204530698596499860286712646484375, "shop.longitude": -72.86025524139398612533113919198513031005859375, "shop.address": "79 Washington Avenue", "shop.address_extend": "79 Washington Avenue North Haven, CT", "shop.country": "US", "shop.postal_code": "06473", "shop.phone": "+1-203-234-1757", "shop.store_monday_start": 600, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 600, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 600, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 600, "shop.store_friday_end": 2200, "shop.store_saturday_start": 600, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "shop.pharmacy_phone": "+1-203-234-7461", "shop.pharmacy_fax": "+1-844-411-6482", "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-800-800-8000", "shop.gas_station_address": "195 State Street", "shop.gas_station_postal_code": "06473", "shop.gas_station_latitude": 41.37929299999999699366526328958570957183837890625, "shop.gas_station_longitude": -72.877913000000006604750524275004863739013671875, "shop.city_x_shop_id": { "29": { "city_x_shop.id": 29, "city.id": 41, "city.ts": "2018-11-19 21:44:06", "city.title": "North Haven", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "303": { "shop_x_store_service.id": 303, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "304": { "shop_x_store_service.id": 304, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "305": { "shop_x_store_service.id": 305, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "306": { "shop_x_store_service.id": 306, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "307": { "shop_x_store_service.id": 307, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "308": { "shop_x_store_service.id": 308, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "309": { "shop_x_store_service.id": 309, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "311": { "shop_x_store_service.id": 311, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "302": { "shop_x_store_service.id": 302, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "310": { "shop_x_store_service.id": 310, "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": { "358": { "shop_x_store_department.id": 358, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "359": { "shop_x_store_department.id": 359, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "360": { "shop_x_store_department.id": 360, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "361": { "shop_x_store_department.id": 361, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "362": { "shop_x_store_department.id": 362, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "363": { "shop_x_store_department.id": 363, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "364": { "shop_x_store_department.id": 364, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "365": { "shop_x_store_department.id": 365, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "366": { "shop_x_store_department.id": 366, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "367": { "shop_x_store_department.id": 367, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "368": { "shop_x_store_department.id": 368, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "369": { "shop_x_store_department.id": 369, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "30": { "shop.id": 30, "shop.ts": "2018-11-21 01:42:58", "shop.latitude": 41.54515479999999882920747040770947933197021484375, "shop.longitude": -72.0919903000000061865648603998124599456787109375, "shop.address": "70 Town Street", "shop.address_extend": "70 Town Street Norwich, CT", "shop.country": "US", "shop.postal_code": "06360", "shop.phone": "+1-860-887-1611", "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": 2200, "shop.pharmacy_phone": "+1-860-887-1615", "shop.pharmacy_fax": "+1-844-411-6431", "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-887-0321", "shop.gas_station_address": "168 W Town St", "shop.gas_station_postal_code": "06360", "shop.gas_station_latitude": 41.5548509999999993169694789685308933258056640625, "shop.gas_station_longitude": -72.10759899999999333886080421507358551025390625, "shop.city_x_shop_id": { "30": { "city_x_shop.id": 30, "city.id": 43, "city.ts": "2018-11-19 21:44:06", "city.title": "Norwich", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "313": { "shop_x_store_service.id": 313, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "314": { "shop_x_store_service.id": 314, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "315": { "shop_x_store_service.id": 315, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "316": { "shop_x_store_service.id": 316, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "317": { "shop_x_store_service.id": 317, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "318": { "shop_x_store_service.id": 318, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "319": { "shop_x_store_service.id": 319, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "320": { "shop_x_store_service.id": 320, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "323": { "shop_x_store_service.id": 323, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "312": { "shop_x_store_service.id": 312, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "322": { "shop_x_store_service.id": 322, "store_service.id": 62, "store_service.ts": "2018-11-21 01:31:41", "store_service.store_service": "Coinstar Exchange" }, "321": { "shop_x_store_service.id": 321, "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": { "370": { "shop_x_store_department.id": 370, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "371": { "shop_x_store_department.id": 371, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "372": { "shop_x_store_department.id": 372, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "373": { "shop_x_store_department.id": 373, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "374": { "shop_x_store_department.id": 374, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "375": { "shop_x_store_department.id": 375, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "376": { "shop_x_store_department.id": 376, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "377": { "shop_x_store_department.id": 377, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "378": { "shop_x_store_department.id": 378, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "379": { "shop_x_store_department.id": 379, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "380": { "shop_x_store_department.id": 380, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "381": { "shop_x_store_department.id": 381, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "31": { "shop.id": 31, "shop.ts": "2018-11-21 01:43:20", "shop.latitude": 41.29705790885765992470624041743576526641845703125, "shop.longitude": -72.38380372524255790267488919198513031005859375, "shop.address": "665 Boston Post Road", "shop.address_extend": "665 Boston Post Road Old Saybrook, CT", "shop.country": "US", "shop.postal_code": "06475", "shop.phone": "+1-860-388-6354", "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-388-6461", "shop.pharmacy_fax": "+1-844-411-6478", "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-388-5233", "shop.gas_station_address": "1090 Boston Post Rd", "shop.gas_station_postal_code": "06475", "shop.gas_station_latitude": 41.28779200000000315640136250294744968414306640625, "shop.gas_station_longitude": -72.3905429999999938672772259451448917388916015625, "shop.city_x_shop_id": { "31": { "city_x_shop.id": 31, "city.id": 44, "city.ts": "2018-11-19 21:44:06", "city.title": "Old Saybrook", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "324": { "shop_x_store_service.id": 324, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "325": { "shop_x_store_service.id": 325, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "326": { "shop_x_store_service.id": 326, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "327": { "shop_x_store_service.id": 327, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "328": { "shop_x_store_service.id": 328, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "329": { "shop_x_store_service.id": 329, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "330": { "shop_x_store_service.id": 330, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "331": { "shop_x_store_service.id": 331, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "333": { "shop_x_store_service.id": 333, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "332": { "shop_x_store_service.id": 332, "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": { "382": { "shop_x_store_department.id": 382, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "383": { "shop_x_store_department.id": 383, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "384": { "shop_x_store_department.id": 384, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "385": { "shop_x_store_department.id": 385, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "386": { "shop_x_store_department.id": 386, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "387": { "shop_x_store_department.id": 387, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "388": { "shop_x_store_department.id": 388, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "389": { "shop_x_store_department.id": 389, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "390": { "shop_x_store_department.id": 390, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "391": { "shop_x_store_department.id": 391, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "392": { "shop_x_store_department.id": 392, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "32": { "shop.id": 32, "shop.ts": "2018-11-21 01:43:32", "shop.latitude": 41.4067502999999987878254614770412445068359375, "shop.longitude": -71.846535799999998062048689462244510650634765625, "shop.address": "91 Voluntown Road", "shop.address_extend": "91 Voluntown Road Pawcatuck, CT", "shop.country": "US", "shop.postal_code": "06379", "shop.phone": "+1-860-535-8234", "shop.store_monday_start": 700, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 2200, "shop.store_saturday_start": 700, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2200, "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-599-8689", "shop.gas_station_address": "466 Liberty Street", "shop.gas_station_postal_code": "06379", "shop.gas_station_latitude": 41.40513899999999836154529475606977939605712890625, "shop.gas_station_longitude": -71.8505930000000034851836971938610076904296875, "shop.city_x_shop_id": { "32": { "city_x_shop.id": 32, "city.id": 45, "city.ts": "2018-11-19 21:44:06", "city.title": "Pawcatuck", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "334": { "shop_x_store_service.id": 334, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "335": { "shop_x_store_service.id": 335, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "336": { "shop_x_store_service.id": 336, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "337": { "shop_x_store_service.id": 337, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "339": { "shop_x_store_service.id": 339, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "338": { "shop_x_store_service.id": 338, "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": { "393": { "shop_x_store_department.id": 393, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "394": { "shop_x_store_department.id": 394, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "395": { "shop_x_store_department.id": 395, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "396": { "shop_x_store_department.id": 396, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "397": { "shop_x_store_department.id": 397, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "398": { "shop_x_store_department.id": 398, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "399": { "shop_x_store_department.id": 399, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "400": { "shop_x_store_department.id": 400, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "401": { "shop_x_store_department.id": 401, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "402": { "shop_x_store_department.id": 402, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "33": { "shop.id": 33, "shop.ts": "2018-11-21 01:43:38", "shop.latitude": 41.9274577471246487903044908307492733001708984375, "shop.longitude": -71.87741339206695556640625, "shop.address": "60 Providence Turnpike", "shop.address_extend": "60 Providence Turnpike Putnam, CT", "shop.country": "US", "shop.postal_code": "06260", "shop.phone": "+1-860-963-2640", "shop.store_monday_start": 700, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 2200, "shop.store_saturday_start": 700, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "+1-860-963-2642", "shop.pharmacy_fax": "+1-844-411-6501", "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-779-3888", "shop.gas_station_address": "439 Hartford Pike", "shop.gas_station_postal_code": "06241", "shop.gas_station_latitude": 41.84558899999999681540430174209177494049072265625, "shop.gas_station_longitude": -71.88848400000000538057065568864345550537109375, "shop.city_x_shop_id": { "33": { "city_x_shop.id": 33, "city.id": 46, "city.ts": "2018-11-19 21:44:06", "city.title": "Putnam", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "341": { "shop_x_store_service.id": 341, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "343": { "shop_x_store_service.id": 343, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "344": { "shop_x_store_service.id": 344, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "345": { "shop_x_store_service.id": 345, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "346": { "shop_x_store_service.id": 346, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "347": { "shop_x_store_service.id": 347, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "340": { "shop_x_store_service.id": 340, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "342": { "shop_x_store_service.id": 342, "store_service.id": 127, "store_service.ts": "2018-11-21 01:35:13", "store_service.store_service": "Check It!" } }, "shop.shop_x_store_department_id": { "403": { "shop_x_store_department.id": 403, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "404": { "shop_x_store_department.id": 404, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "405": { "shop_x_store_department.id": 405, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "406": { "shop_x_store_department.id": 406, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "407": { "shop_x_store_department.id": 407, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "408": { "shop_x_store_department.id": 408, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "409": { "shop_x_store_department.id": 409, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "410": { "shop_x_store_department.id": 410, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "411": { "shop_x_store_department.id": 411, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "412": { "shop_x_store_department.id": 412, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "413": { "shop_x_store_department.id": 413, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "414": { "shop_x_store_department.id": 414, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "34": { "shop.id": 34, "shop.ts": "2018-11-21 01:43:56", "shop.latitude": 41.2948130061269154111869283951818943023681640625, "shop.longitude": -73.49516093730926513671875, "shop.address": "125 Danbury Road", "shop.address_extend": "125 Danbury Road Ridgefield, CT", "shop.country": "US", "shop.postal_code": "06877", "shop.phone": "+1-203-438-7317", "shop.store_monday_start": 700, "shop.store_monday_end": 2200, "shop.store_tuesday_start": 700, "shop.store_tuesday_end": 2200, "shop.store_wednesday_start": 700, "shop.store_wednesday_end": 2200, "shop.store_thursday_start": 700, "shop.store_thursday_end": 1700, "shop.store_friday_start": 700, "shop.store_friday_end": 2200, "shop.store_saturday_start": 700, "shop.store_saturday_end": 2200, "shop.store_sunday_start": 700, "shop.store_sunday_end": 2100, "shop.pharmacy_phone": "+1-203-438-0340", "shop.pharmacy_fax": "+1-844-411-6462", "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-438-2433", "shop.gas_station_address": "130 Danbury Rd", "shop.gas_station_postal_code": "06877", "shop.gas_station_latitude": 41.294724999999999681676854379475116729736328125, "shop.gas_station_longitude": -73.49268200000000206273398362100124359130859375, "shop.city_x_shop_id": { "34": { "city_x_shop.id": 34, "city.id": 47, "city.ts": "2018-11-19 21:44:06", "city.title": "Ridgefield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "350": { "shop_x_store_service.id": 350, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "351": { "shop_x_store_service.id": 351, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "352": { "shop_x_store_service.id": 352, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "353": { "shop_x_store_service.id": 353, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "354": { "shop_x_store_service.id": 354, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "355": { "shop_x_store_service.id": 355, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "356": { "shop_x_store_service.id": 356, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "358": { "shop_x_store_service.id": 358, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "349": { "shop_x_store_service.id": 349, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "357": { "shop_x_store_service.id": 357, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "348": { "shop_x_store_service.id": 348, "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": { "415": { "shop_x_store_department.id": 415, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "416": { "shop_x_store_department.id": 416, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "417": { "shop_x_store_department.id": 417, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "418": { "shop_x_store_department.id": 418, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "419": { "shop_x_store_department.id": 419, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "420": { "shop_x_store_department.id": 420, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "421": { "shop_x_store_department.id": 421, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "422": { "shop_x_store_department.id": 422, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "423": { "shop_x_store_department.id": 423, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "424": { "shop_x_store_department.id": 424, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "425": { "shop_x_store_department.id": 425, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "35": { "shop.id": 35, "shop.ts": "2018-11-21 01:44:32", "shop.latitude": 41.6809813432865183813191833905875682830810546875, "shop.longitude": -72.65748560428619384765625, "shop.address": "80 Town Line Road", "shop.address_extend": "80 Town Line Road Rocky Hill, CT", "shop.country": "US", "shop.postal_code": "06067", "shop.phone": "+1-860-563-1169", "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-563-4462", "shop.pharmacy_fax": "+1-844-411-6444", "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-529-1369", "shop.gas_station_address": "1380 Silas Deane Highway", "shop.gas_station_postal_code": "06067", "shop.gas_station_latitude": 41.68234100000000097452357294969260692596435546875, "shop.gas_station_longitude": -72.6537780000000026348061510361731052398681640625, "shop.city_x_shop_id": { "35": { "city_x_shop.id": 35, "city.id": 48, "city.ts": "2018-11-19 21:44:06", "city.title": "Rocky Hill", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "359": { "shop_x_store_service.id": 359, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "360": { "shop_x_store_service.id": 360, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "361": { "shop_x_store_service.id": 361, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "362": { "shop_x_store_service.id": 362, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "363": { "shop_x_store_service.id": 363, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "364": { "shop_x_store_service.id": 364, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "365": { "shop_x_store_service.id": 365, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "367": { "shop_x_store_service.id": 367, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "366": { "shop_x_store_service.id": 366, "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": { "426": { "shop_x_store_department.id": 426, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "427": { "shop_x_store_department.id": 427, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "428": { "shop_x_store_department.id": 428, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "429": { "shop_x_store_department.id": 429, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "430": { "shop_x_store_department.id": 430, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "431": { "shop_x_store_department.id": 431, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "432": { "shop_x_store_department.id": 432, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "433": { "shop_x_store_department.id": 433, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "434": { "shop_x_store_department.id": 434, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "435": { "shop_x_store_department.id": 435, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "436": { "shop_x_store_department.id": 436, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "36": { "shop.id": 36, "shop.ts": "2018-11-21 01:45:00", "shop.latitude": 41.39784660000000116042428999207913875579833984375, "shop.longitude": -73.0736988000000025067492970265448093414306640625, "shop.address": "15 Franklin Street", "shop.address_extend": "15 Franklin Street Seymour, CT", "shop.country": "US", "shop.postal_code": "06483", "shop.phone": "+1-203-881-2641", "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-203-881-2756", "shop.pharmacy_fax": "+1-844-411-6421", "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-999-9999", "shop.gas_station_address": "2 New Haven Rd", "shop.gas_station_postal_code": "06483", "shop.gas_station_latitude": 41.39744499999999760575519758276641368865966796875, "shop.gas_station_longitude": -73.0703319999999933997969492338597774505615234375, "shop.city_x_shop_id": { "36": { "city_x_shop.id": 36, "city.id": 49, "city.ts": "2018-11-19 21:44:06", "city.title": "Seymour", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "369": { "shop_x_store_service.id": 369, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "370": { "shop_x_store_service.id": 370, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "371": { "shop_x_store_service.id": 371, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "372": { "shop_x_store_service.id": 372, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "373": { "shop_x_store_service.id": 373, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "374": { "shop_x_store_service.id": 374, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "375": { "shop_x_store_service.id": 375, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "376": { "shop_x_store_service.id": 376, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "377": { "shop_x_store_service.id": 377, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "368": { "shop_x_store_service.id": 368, "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": { "437": { "shop_x_store_department.id": 437, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "438": { "shop_x_store_department.id": 438, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "439": { "shop_x_store_department.id": 439, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "440": { "shop_x_store_department.id": 440, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "441": { "shop_x_store_department.id": 441, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "442": { "shop_x_store_department.id": 442, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "443": { "shop_x_store_department.id": 443, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "444": { "shop_x_store_department.id": 444, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "445": { "shop_x_store_department.id": 445, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "446": { "shop_x_store_department.id": 446, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "447": { "shop_x_store_department.id": 447, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "448": { "shop_x_store_department.id": 448, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "37": { "shop.id": 37, "shop.ts": "2018-11-21 01:45:07", "shop.latitude": 41.26373980000000329937392962165176868438720703125, "shop.longitude": -73.1324469000000050300513976253569126129150390625, "shop.address": "898 Bridgeport Avenue", "shop.address_extend": "898 Bridgeport Avenue Shelton, CT", "shop.country": "US", "shop.postal_code": "06484", "shop.phone": "+1-203-929-7516", "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": 0, "shop.pharmacy_phone": "+1-203-929-3887", "shop.pharmacy_fax": "+1-844-411-6441", "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": 1800, "shop.gas_station_phone": "+1-203-261-1043", "shop.gas_station_address": "648 White Plains Rd", "shop.gas_station_postal_code": "06611", "shop.gas_station_latitude": 41.2397050000000007230482879094779491424560546875, "shop.gas_station_longitude": -73.1867859999999978981577442027628421783447265625, "shop.city_x_shop_id": { "37": { "city_x_shop.id": 37, "city.id": 50, "city.ts": "2018-11-19 21:44:06", "city.title": "Shelton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "380": { "shop_x_store_service.id": 380, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "381": { "shop_x_store_service.id": 381, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "382": { "shop_x_store_service.id": 382, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "383": { "shop_x_store_service.id": 383, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "384": { "shop_x_store_service.id": 384, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "385": { "shop_x_store_service.id": 385, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "386": { "shop_x_store_service.id": 386, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "387": { "shop_x_store_service.id": 387, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "389": { "shop_x_store_service.id": 389, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "379": { "shop_x_store_service.id": 379, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "388": { "shop_x_store_service.id": 388, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "378": { "shop_x_store_service.id": 378, "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": { "449": { "shop_x_store_department.id": 449, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "450": { "shop_x_store_department.id": 450, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "451": { "shop_x_store_department.id": 451, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "452": { "shop_x_store_department.id": 452, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "453": { "shop_x_store_department.id": 453, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "454": { "shop_x_store_department.id": 454, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "455": { "shop_x_store_department.id": 455, "store_department.id": 7, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Gas Station" }, "456": { "shop_x_store_department.id": 456, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "457": { "shop_x_store_department.id": 457, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "458": { "shop_x_store_department.id": 458, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "459": { "shop_x_store_department.id": 459, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "460": { "shop_x_store_department.id": 460, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "38": { "shop.id": 38, "shop.ts": "2018-11-21 01:46:18", "shop.latitude": 41.81929173504629915214536595158278942108154296875, "shop.longitude": -72.86307156085968017578125, "shop.address": "498 Bushy Hill Road", "shop.address_extend": "498 Bushy Hill Road Simsbury, CT", "shop.country": "US", "shop.postal_code": "06070", "shop.phone": "+1-860-651-4787", "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-651-9843", "shop.pharmacy_fax": "+1-844-224-6922", "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-658-7232", "shop.gas_station_address": "12 Albany Tpke", "shop.gas_station_postal_code": "06092", "shop.gas_station_latitude": 41.817262999999996964106685481965541839599609375, "shop.gas_station_longitude": -72.866928999999998950443114154040813446044921875, "shop.city_x_shop_id": { "38": { "city_x_shop.id": 38, "city.id": 51, "city.ts": "2018-11-19 21:44:06", "city.title": "Simsbury", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "390": { "shop_x_store_service.id": 390, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "391": { "shop_x_store_service.id": 391, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "392": { "shop_x_store_service.id": 392, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "393": { "shop_x_store_service.id": 393, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "394": { "shop_x_store_service.id": 394, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "395": { "shop_x_store_service.id": 395, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "396": { "shop_x_store_service.id": 396, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "397": { "shop_x_store_service.id": 397, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "399": { "shop_x_store_service.id": 399, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "398": { "shop_x_store_service.id": 398, "store_service.id": 73, "store_service.ts": "2018-11-21 01:31:45", "store_service.store_service": "Pick-up (Attended)" }, "400": { "shop_x_store_service.id": 400, "store_service.id": 238, "store_service.ts": "2018-11-21 01:40:50", "store_service.store_service": "Fastcare Clinic" } }, "shop.shop_x_store_department_id": { "461": { "shop_x_store_department.id": 461, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "463": { "shop_x_store_department.id": 463, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "464": { "shop_x_store_department.id": 464, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "465": { "shop_x_store_department.id": 465, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "466": { "shop_x_store_department.id": 466, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "467": { "shop_x_store_department.id": 467, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "468": { "shop_x_store_department.id": 468, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "469": { "shop_x_store_department.id": 469, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "472": { "shop_x_store_department.id": 472, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "473": { "shop_x_store_department.id": 473, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "474": { "shop_x_store_department.id": 474, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" }, "462": { "shop_x_store_department.id": 462, "store_department.id": 311, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Seafood" }, "470": { "shop_x_store_department.id": 470, "store_department.id": 319, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Baby" }, "471": { "shop_x_store_department.id": 471, "store_department.id": 320, "store_department.ts": "2018-11-21 01:41:16", "store_department.store_department": "Pet" } } }, "39": { "shop.id": 39, "shop.ts": "2018-11-21 01:46:54", "shop.latitude": 41.82476100000000229783836402930319309234619140625, "shop.longitude": -72.5550635999999968817064655013382434844970703125, "shop.address": "1739 Ellington Road", "shop.address_extend": "1739 Ellington Road South Windsor, CT", "shop.country": "US", "shop.postal_code": "06074", "shop.phone": "+1-860-648-4026", "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": 2200, "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-646-4906", "shop.gas_station_address": "95 Buckland St", "shop.gas_station_postal_code": "06042", "shop.gas_station_latitude": 41.7993579999999980145730660296976566314697265625, "shop.gas_station_longitude": -72.55040800000000444924808107316493988037109375, "shop.city_x_shop_id": { "39": { "city_x_shop.id": 39, "city.id": 52, "city.ts": "2018-11-19 21:44:06", "city.title": "South Windsor", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "401": { "shop_x_store_service.id": 401, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "402": { "shop_x_store_service.id": 402, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "403": { "shop_x_store_service.id": 403, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "404": { "shop_x_store_service.id": 404, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "405": { "shop_x_store_service.id": 405, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "406": { "shop_x_store_service.id": 406, "store_service.id": 6, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Blue Rhino" }, "407": { "shop_x_store_service.id": 407, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "408": { "shop_x_store_service.id": 408, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "410": { "shop_x_store_service.id": 410, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "409": { "shop_x_store_service.id": 409, "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": { "475": { "shop_x_store_department.id": 475, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "476": { "shop_x_store_department.id": 476, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "477": { "shop_x_store_department.id": 477, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "478": { "shop_x_store_department.id": 478, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "479": { "shop_x_store_department.id": 479, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "480": { "shop_x_store_department.id": 480, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "481": { "shop_x_store_department.id": 481, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "482": { "shop_x_store_department.id": 482, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "483": { "shop_x_store_department.id": 483, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "484": { "shop_x_store_department.id": 484, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } }, "40": { "shop.id": 40, "shop.ts": "2018-11-21 01:47:07", "shop.latitude": 41.47911261935998794569968595169484615325927734375, "shop.longitude": -73.20896923542028389420011080801486968994140625, "shop.address": "100 Main Street North", "shop.address_extend": "100 Main Street North Southbury, CT", "shop.country": "US", "shop.postal_code": "06488", "shop.phone": "+1-203-262-4555", "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-203-262-4559", "shop.pharmacy_fax": "+1-844-411-6435", "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-264-4420", "shop.gas_station_address": "121 Main St N", "shop.gas_station_postal_code": "06488", "shop.gas_station_latitude": 41.48003800000000040881786844693124294281005859375, "shop.gas_station_longitude": -73.21377699999999322244548238813877105712890625, "shop.city_x_shop_id": { "40": { "city_x_shop.id": 40, "city.id": 53, "city.ts": "2018-11-19 21:44:06", "city.title": "Southbury", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } }, "shop.shop_x_store_service_id": { "412": { "shop_x_store_service.id": 412, "store_service.id": 1, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "People's United Bank" }, "413": { "shop_x_store_service.id": 413, "store_service.id": 2, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Peapod" }, "414": { "shop_x_store_service.id": 414, "store_service.id": 3, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "SCAN IT! Mobile" }, "416": { "shop_x_store_service.id": 416, "store_service.id": 4, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "RedBox" }, "417": { "shop_x_store_service.id": 417, "store_service.id": 5, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "UPromise" }, "418": { "shop_x_store_service.id": 418, "store_service.id": 7, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Western Union" }, "419": { "shop_x_store_service.id": 419, "store_service.id": 8, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Order It!" }, "420": { "shop_x_store_service.id": 420, "store_service.id": 9, "store_service.ts": "2018-11-21 01:16:21", "store_service.store_service": "Coinstar" }, "411": { "shop_x_store_service.id": 411, "store_service.id": 46, "store_service.ts": "2018-11-21 01:29:59", "store_service.store_service": "Flu Vaccination" }, "415": { "shop_x_store_service.id": 415, "store_service.id": 415, "store_service.ts": "2018-11-21 01:47:07", "store_service.store_service": "Scan It!" } }, "shop.shop_x_store_department_id": { "485": { "shop_x_store_department.id": 485, "store_department.id": 1, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Florist Shop" }, "486": { "shop_x_store_department.id": 486, "store_department.id": 2, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Baby Shop" }, "487": { "shop_x_store_department.id": 487, "store_department.id": 3, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Pet Shop" }, "488": { "shop_x_store_department.id": 488, "store_department.id": 4, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Seafood Shop" }, "489": { "shop_x_store_department.id": 489, "store_department.id": 5, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Produce Shop" }, "490": { "shop_x_store_department.id": 490, "store_department.id": 6, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Butcher Shop" }, "491": { "shop_x_store_department.id": 491, "store_department.id": 8, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Beauty Shop" }, "492": { "shop_x_store_department.id": 492, "store_department.id": 9, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "Natural Foods" }, "493": { "shop_x_store_department.id": 493, "store_department.id": 10, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "In-Store Pharmacy" }, "494": { "shop_x_store_department.id": 494, "store_department.id": 11, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Bake Shop" }, "495": { "shop_x_store_department.id": 495, "store_department.id": 12, "store_department.ts": "2018-11-21 01:18:33", "store_department.store_department": "The Deli Shop" } } } } } }