You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
shop.id | shop.ts | shop.latitude | shop.longitude | shop.address | shop.address_extend | shop.country | shop.postal_code | shop.phone | shop.store_monday_start | shop.store_monday_end | shop.store_tuesday_start | shop.store_tuesday_end | shop.store_wednesday_start | shop.store_wednesday_end | shop.store_thursday_start | shop.store_thursday_end | shop.store_friday_start | shop.store_friday_end | shop.store_saturday_start | shop.store_saturday_end | shop.store_sunday_start | shop.store_sunday_end | 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 | shop.gas_station_address | shop.gas_station_postal_code | shop.gas_station_latitude | shop.gas_station_longitude | shop.city_x_shop_id | shop.shop_x_store_service_id | shop.shop_x_store_department_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2018-11-21 01:28:38 | 41.3329721 | -73.0819764 | 100 Division Street | 100 Division Street Ansonia, CT | US | 06401 | +1-203-732-3901 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 700 | 2200 | +1-203-732-3907 | +1-844-411-6854 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 1700 | 900 | 1400 | +1-203-734-8878 | 696 Main Street | 06401 | 41.330684 | -73.077243 | { "1": { "city_x_shop.id": 1, "city.id": 1, "city.ts": "2018-11-19 21:44:06", "city.title": "Ansonia", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"1": {
"shop_x_store_service.id": 1,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"2": {
"shop_x_store_service.id": 2,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"3": {
"shop_x_store_service.id": 3,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"4": {
"shop_x_store_service.id": 4,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"5": {
"shop_x_store_service.id": 5,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"6": {
"shop_x_store_service.id": 6,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"7": {
"shop_x_store_service.id": 7,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"8": {
"shop_x_store_service.id": 8,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"9": {
"shop_x_store_service.id": 9,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
}
} |
{
"1": {
"shop_x_store_department.id": 1,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"2": {
"shop_x_store_department.id": 2,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"3": {
"shop_x_store_department.id": 3,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"4": {
"shop_x_store_department.id": 4,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"5": {
"shop_x_store_department.id": 5,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"6": {
"shop_x_store_department.id": 6,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"7": {
"shop_x_store_department.id": 7,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"8": {
"shop_x_store_department.id": 8,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"9": {
"shop_x_store_department.id": 9,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"10": {
"shop_x_store_department.id": 10,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"11": {
"shop_x_store_department.id": 11,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"12": {
"shop_x_store_department.id": 12,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
2 | 2018-11-21 01:29:59 | 41.6304042 | -72.755391 | 1135 Farmington Avenue | 1135 Farmington Avenue Berlin, CT | US | 06037 | +1-860-828-0276 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 600 | 2200 | +1-860-828-0772 | +1-844-411-6430 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-860-828-1359 | 1239 Farmington Ave | 06037 | 41.627791 | -72.754707 | { "2": { "city_x_shop.id": 2, "city.id": 2, "city.ts": "2018-11-19 21:44:06", "city.title": "Berlin", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"47": {
"shop_x_store_service.id": 47,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"48": {
"shop_x_store_service.id": 48,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"49": {
"shop_x_store_service.id": 49,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"50": {
"shop_x_store_service.id": 50,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"51": {
"shop_x_store_service.id": 51,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"52": {
"shop_x_store_service.id": 52,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"53": {
"shop_x_store_service.id": 53,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"54": {
"shop_x_store_service.id": 54,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"46": {
"shop_x_store_service.id": 46,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
}
} |
{
"49": {
"shop_x_store_department.id": 49,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"50": {
"shop_x_store_department.id": 50,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"51": {
"shop_x_store_department.id": 51,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"52": {
"shop_x_store_department.id": 52,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"53": {
"shop_x_store_department.id": 53,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"54": {
"shop_x_store_department.id": 54,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"55": {
"shop_x_store_department.id": 55,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"56": {
"shop_x_store_department.id": 56,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"57": {
"shop_x_store_department.id": 57,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"58": {
"shop_x_store_department.id": 58,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"59": {
"shop_x_store_department.id": 59,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"60": {
"shop_x_store_department.id": 60,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
3 | 2018-11-21 01:31:41 | 41.81563360627324 | -72.71414995193481 | 313 Cottage Grove Rd | 313 Cottage Grove Rd Bloomfield, CT | US | 06002 | +1-860-242-5954 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 0 | +1-860-286-0570 | 47 Jerome Ave | 06002 | 41.830146 | -72.734851 | { "3": { "city_x_shop.id": 3, "city.id": 3, "city.ts": "2018-11-19 21:44:06", "city.title": "Bloomfield", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"55": {
"shop_x_store_service.id": 55,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"56": {
"shop_x_store_service.id": 56,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"57": {
"shop_x_store_service.id": 57,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"58": {
"shop_x_store_service.id": 58,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"59": {
"shop_x_store_service.id": 59,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"60": {
"shop_x_store_service.id": 60,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"61": {
"shop_x_store_service.id": 61,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"63": {
"shop_x_store_service.id": 63,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"62": {
"shop_x_store_service.id": 62,
"store_service.id": 62,
"store_service.ts": "2018-11-21 01:31:41",
"store_service.store_service": "Coinstar Exchange"
}
} |
{
"61": {
"shop_x_store_department.id": 61,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"62": {
"shop_x_store_department.id": 62,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"63": {
"shop_x_store_department.id": 63,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"64": {
"shop_x_store_department.id": 64,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"65": {
"shop_x_store_department.id": 65,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"66": {
"shop_x_store_department.id": 66,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"67": {
"shop_x_store_department.id": 67,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"68": {
"shop_x_store_department.id": 68,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"69": {
"shop_x_store_department.id": 69,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"70": {
"shop_x_store_department.id": 70,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"71": {
"shop_x_store_department.id": 71,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
||||||||||||||||
4 | 2018-11-21 01:31:45 | 41.2977403 | -72.76284 | 22 Leetes Island Rd | 22 Leetes Island Rd Branford, CT | US | 06405 | +1-203-488-1325 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 700 | 2200 | +1-203-481-3392 | +1-844-411-6857 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 1800 | 900 | 1500 | +1-203-488-1956 | 49 Leetes Island Rd | 06405 | 41.29639 | -72.764536 | { "4": { "city_x_shop.id": 4, "city.id": 4, "city.ts": "2018-11-19 21:44:06", "city.title": "Branford", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"65": {
"shop_x_store_service.id": 65,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"66": {
"shop_x_store_service.id": 66,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"67": {
"shop_x_store_service.id": 67,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"68": {
"shop_x_store_service.id": 68,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"69": {
"shop_x_store_service.id": 69,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"70": {
"shop_x_store_service.id": 70,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"71": {
"shop_x_store_service.id": 71,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"72": {
"shop_x_store_service.id": 72,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"74": {
"shop_x_store_service.id": 74,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"64": {
"shop_x_store_service.id": 64,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"73": {
"shop_x_store_service.id": 73,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"72": {
"shop_x_store_department.id": 72,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"73": {
"shop_x_store_department.id": 73,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"74": {
"shop_x_store_department.id": 74,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"75": {
"shop_x_store_department.id": 75,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"76": {
"shop_x_store_department.id": 76,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"77": {
"shop_x_store_department.id": 77,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"78": {
"shop_x_store_department.id": 78,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"79": {
"shop_x_store_department.id": 79,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"80": {
"shop_x_store_department.id": 80,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"81": {
"shop_x_store_department.id": 81,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"82": {
"shop_x_store_department.id": 82,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"83": {
"shop_x_store_department.id": 83,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
5 | 2018-11-21 01:32:09 | 42.024869397577554 | -73.32198143005371 | 11 East Main Street | 11 East Main Street Canaan, CT | US | 06018 | +1-860-824-7990 | 700 | 2300 | 700 | 2300 | 700 | 2300 | 700 | 1700 | 700 | 2300 | 700 | 2300 | 700 | 2100 | +1-860-824-1152 | 3 E Main St | 06018 | 42.024368 | -73.323773 | { "5": { "city_x_shop.id": 5, "city.id": 7, "city.ts": "2018-11-19 21:44:06", "city.title": "Canaan", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"75": {
"shop_x_store_service.id": 75,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"76": {
"shop_x_store_service.id": 76,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"77": {
"shop_x_store_service.id": 77,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"78": {
"shop_x_store_service.id": 78,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"79": {
"shop_x_store_service.id": 79,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"80": {
"shop_x_store_service.id": 80,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
}
} |
{
"84": {
"shop_x_store_department.id": 84,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"85": {
"shop_x_store_department.id": 85,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"86": {
"shop_x_store_department.id": 86,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"87": {
"shop_x_store_department.id": 87,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"88": {
"shop_x_store_department.id": 88,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"89": {
"shop_x_store_department.id": 89,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"90": {
"shop_x_store_department.id": 90,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"91": {
"shop_x_store_department.id": 91,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"92": {
"shop_x_store_department.id": 92,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"93": {
"shop_x_store_department.id": 93,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
||||||||||||||||
6 | 2018-11-21 01:33:00 | 41.50603437294043 | -72.90125548839569 | 275 Highland Avenue | 275 Highland Avenue Cheshire, CT | US | 06410 | +1-203-272-3628 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 0 | +1-203-272-3697 | +1-844-411-6483 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-203-272-2340 | 901 W Main St | 06410 | 41.514678 | -72.92592 | { "6": { "city_x_shop.id": 6, "city.id": 8, "city.ts": "2018-11-19 21:44:06", "city.title": "Cheshire", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"82": {
"shop_x_store_service.id": 82,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"83": {
"shop_x_store_service.id": 83,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"84": {
"shop_x_store_service.id": 84,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"85": {
"shop_x_store_service.id": 85,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"86": {
"shop_x_store_service.id": 86,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"87": {
"shop_x_store_service.id": 87,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"88": {
"shop_x_store_service.id": 88,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"89": {
"shop_x_store_service.id": 89,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"91": {
"shop_x_store_service.id": 91,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"81": {
"shop_x_store_service.id": 81,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"90": {
"shop_x_store_service.id": 90,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"94": {
"shop_x_store_department.id": 94,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"95": {
"shop_x_store_department.id": 95,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"96": {
"shop_x_store_department.id": 96,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"97": {
"shop_x_store_department.id": 97,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"98": {
"shop_x_store_department.id": 98,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"99": {
"shop_x_store_department.id": 99,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"100": {
"shop_x_store_department.id": 100,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"101": {
"shop_x_store_department.id": 101,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"102": {
"shop_x_store_department.id": 102,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"103": {
"shop_x_store_department.id": 103,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"104": {
"shop_x_store_department.id": 104,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"105": {
"shop_x_store_department.id": 105,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
7 | 2018-11-21 01:33:42 | 41.2739546 | -72.5054991 | 215 East Main Street | 215 East Main Street Clinton, CT | US | 06413 | +1-860-669-2228 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2100 | +1-860-669-6636 | +1-844-411-6459 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-860-669-4599 | 196 E Main St | 06413 | 41.273628 | -72.509281 | { "7": { "city_x_shop.id": 7, "city.id": 9, "city.ts": "2018-11-19 21:44:06", "city.title": "Clinton", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"93": {
"shop_x_store_service.id": 93,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"94": {
"shop_x_store_service.id": 94,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"95": {
"shop_x_store_service.id": 95,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"96": {
"shop_x_store_service.id": 96,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"97": {
"shop_x_store_service.id": 97,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"98": {
"shop_x_store_service.id": 98,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"99": {
"shop_x_store_service.id": 99,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"100": {
"shop_x_store_service.id": 100,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"102": {
"shop_x_store_service.id": 102,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"92": {
"shop_x_store_service.id": 92,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"101": {
"shop_x_store_service.id": 101,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"106": {
"shop_x_store_department.id": 106,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"107": {
"shop_x_store_department.id": 107,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"108": {
"shop_x_store_department.id": 108,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"109": {
"shop_x_store_department.id": 109,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"110": {
"shop_x_store_department.id": 110,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"111": {
"shop_x_store_department.id": 111,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"112": {
"shop_x_store_department.id": 112,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"113": {
"shop_x_store_department.id": 113,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"114": {
"shop_x_store_department.id": 114,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"115": {
"shop_x_store_department.id": 115,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"116": {
"shop_x_store_department.id": 116,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"117": {
"shop_x_store_department.id": 117,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
8 | 2018-11-21 01:34:32 | 41.5710847 | -72.3337616 | 99 Linwood Avenue | 99 Linwood Avenue Colchester, CT | US | 06415 | +1-860-537-2361 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2200 | +1-860-537-2570 | +1-844-411-6426 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-860-859-3007 | 2 New London Rd | 06420 | 41.476469 | -72.263976 | { "8": { "city_x_shop.id": 8, "city.id": 10, "city.ts": "2018-11-19 21:44:06", "city.title": "Colchester", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"104": {
"shop_x_store_service.id": 104,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"105": {
"shop_x_store_service.id": 105,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"106": {
"shop_x_store_service.id": 106,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"107": {
"shop_x_store_service.id": 107,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"108": {
"shop_x_store_service.id": 108,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"110": {
"shop_x_store_service.id": 110,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"103": {
"shop_x_store_service.id": 103,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"109": {
"shop_x_store_service.id": 109,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"118": {
"shop_x_store_department.id": 118,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"119": {
"shop_x_store_department.id": 119,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"120": {
"shop_x_store_department.id": 120,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"121": {
"shop_x_store_department.id": 121,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"122": {
"shop_x_store_department.id": 122,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"123": {
"shop_x_store_department.id": 123,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"124": {
"shop_x_store_department.id": 124,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"125": {
"shop_x_store_department.id": 125,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"126": {
"shop_x_store_department.id": 126,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"127": {
"shop_x_store_department.id": 127,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"128": {
"shop_x_store_department.id": 128,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"129": {
"shop_x_store_department.id": 129,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
9 | 2018-11-21 01:34:45 | 41.6018667 | -72.6781392 | 195 West Street | 195 West Street Cromwell, CT | US | 06416 | +1-860-635-8300 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 600 | 2300 | +1-860-635-6303 | +1-844-411-6424 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-860-347-7722 | 436 S Main St | 06457 | 41.562358 | -72.650869 | { "9": { "city_x_shop.id": 9, "city.id": 11, "city.ts": "2018-11-19 21:44:06", "city.title": "Cromwell", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"112": {
"shop_x_store_service.id": 112,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"113": {
"shop_x_store_service.id": 113,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"114": {
"shop_x_store_service.id": 114,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"115": {
"shop_x_store_service.id": 115,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"116": {
"shop_x_store_service.id": 116,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"117": {
"shop_x_store_service.id": 117,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"118": {
"shop_x_store_service.id": 118,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"120": {
"shop_x_store_service.id": 120,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"111": {
"shop_x_store_service.id": 111,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"119": {
"shop_x_store_service.id": 119,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"130": {
"shop_x_store_department.id": 130,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"131": {
"shop_x_store_department.id": 131,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"132": {
"shop_x_store_department.id": 132,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"133": {
"shop_x_store_department.id": 133,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"134": {
"shop_x_store_department.id": 134,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"135": {
"shop_x_store_department.id": 135,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"136": {
"shop_x_store_department.id": 136,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"137": {
"shop_x_store_department.id": 137,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"138": {
"shop_x_store_department.id": 138,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"139": {
"shop_x_store_department.id": 139,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"140": {
"shop_x_store_department.id": 140,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"141": {
"shop_x_store_department.id": 141,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
10 | 2018-11-21 01:34:51 | 41.841567825721164 | -71.88063204288483 | 1094 Killingly Commons Drive | 1094 Killingly Commons Drive Dayville, CT | US | 06241 | +1-860-779-2070 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2200 | +1-860-774-5301 | +1-844-411-6485 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-860-774-9161 | 1095 N Main St | 06241 | 41.841467 | -71.877524 | { "10": { "city_x_shop.id": 10, "city.id": 14, "city.ts": "2018-11-19 21:44:06", "city.title": "Dayville", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"121": {
"shop_x_store_service.id": 121,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"122": {
"shop_x_store_service.id": 122,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"123": {
"shop_x_store_service.id": 123,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"124": {
"shop_x_store_service.id": 124,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"125": {
"shop_x_store_service.id": 125,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
}
} |
{
"142": {
"shop_x_store_department.id": 142,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"143": {
"shop_x_store_department.id": 143,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"144": {
"shop_x_store_department.id": 144,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"145": {
"shop_x_store_department.id": 145,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"146": {
"shop_x_store_department.id": 146,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"147": {
"shop_x_store_department.id": 147,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"148": {
"shop_x_store_department.id": 148,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"149": {
"shop_x_store_department.id": 149,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"150": {
"shop_x_store_department.id": 150,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"151": {
"shop_x_store_department.id": 151,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"152": {
"shop_x_store_department.id": 152,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
11 | 2018-11-21 01:35:14 | 41.584260852342766 | -72.50532925128937 | 11 E High Street | 11 E High Street East Hampton, CT | US | 06424 | +1-860-267-2039 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2200 | +1-860-267-2771 | +1-844-411-6587 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-860-347-7722 | 436 S Main St | 06457 | 41.562358 | -72.650869 | { "11": { "city_x_shop.id": 11, "city.id": 15, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hampton", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"128": {
"shop_x_store_service.id": 128,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"129": {
"shop_x_store_service.id": 129,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"130": {
"shop_x_store_service.id": 130,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"131": {
"shop_x_store_service.id": 131,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"133": {
"shop_x_store_service.id": 133,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"135": {
"shop_x_store_service.id": 135,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"126": {
"shop_x_store_service.id": 126,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"134": {
"shop_x_store_service.id": 134,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
},
"127": {
"shop_x_store_service.id": 127,
"store_service.id": 127,
"store_service.ts": "2018-11-21 01:35:13",
"store_service.store_service": "Check It!"
},
"132": {
"shop_x_store_service.id": 132,
"store_service.id": 132,
"store_service.ts": "2018-11-21 01:35:13",
"store_service.store_service": "A+ Bonus Bucks"
}
} |
{
"153": {
"shop_x_store_department.id": 153,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"154": {
"shop_x_store_department.id": 154,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"155": {
"shop_x_store_department.id": 155,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"156": {
"shop_x_store_department.id": 156,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"157": {
"shop_x_store_department.id": 157,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"158": {
"shop_x_store_department.id": 158,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"159": {
"shop_x_store_department.id": 159,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"160": {
"shop_x_store_department.id": 160,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"161": {
"shop_x_store_department.id": 161,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"162": {
"shop_x_store_department.id": 162,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"163": {
"shop_x_store_department.id": 163,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
12 | 2018-11-21 01:35:26 | 41.7689365 | -72.6038742 | 940 Silver Lane | 940 Silver Lane East Hartford, CT | US | 06118 | +1-860-569-7050 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 700 | 2200 | +1-860-569-7135 | +1-844-411-6481 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 2000 | 900 | 1700 | 900 | 1400 | +1-860-568-8819 | 1475 Silver Ln | 06118 | 41.76556 | -72.578614 | { "12": { "city_x_shop.id": 12, "city.id": 16, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hartford", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"137": {
"shop_x_store_service.id": 137,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"138": {
"shop_x_store_service.id": 138,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"139": {
"shop_x_store_service.id": 139,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"140": {
"shop_x_store_service.id": 140,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"141": {
"shop_x_store_service.id": 141,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"142": {
"shop_x_store_service.id": 142,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"143": {
"shop_x_store_service.id": 143,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"145": {
"shop_x_store_service.id": 145,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"136": {
"shop_x_store_service.id": 136,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"144": {
"shop_x_store_service.id": 144,
"store_service.id": 62,
"store_service.ts": "2018-11-21 01:31:41",
"store_service.store_service": "Coinstar Exchange"
}
} |
{
"164": {
"shop_x_store_department.id": 164,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"165": {
"shop_x_store_department.id": 165,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"166": {
"shop_x_store_department.id": 166,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"167": {
"shop_x_store_department.id": 167,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"168": {
"shop_x_store_department.id": 168,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"169": {
"shop_x_store_department.id": 169,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"170": {
"shop_x_store_department.id": 170,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"171": {
"shop_x_store_department.id": 171,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"172": {
"shop_x_store_department.id": 172,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"173": {
"shop_x_store_department.id": 173,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"174": {
"shop_x_store_department.id": 174,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
13 | 2018-11-21 01:35:44 | 41.278201549852476 | -72.86928623914713 | 370 Hemingway Avenue | 370 Hemingway Avenue East Haven, CT | US | 06512 | +1-203-468-7012 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 700 | 2200 | +1-203-468-1113 | +1-844-411-6480 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1800 | 900 | 1500 | +1-203-467-3661 | 1183 Townsend Ave | 06512 | 41.288601 | -72.892192 | { "13": { "city_x_shop.id": 13, "city.id": 17, "city.ts": "2018-11-19 21:44:06", "city.title": "East Haven", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"146": {
"shop_x_store_service.id": 146,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"147": {
"shop_x_store_service.id": 147,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"148": {
"shop_x_store_service.id": 148,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"149": {
"shop_x_store_service.id": 149,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"150": {
"shop_x_store_service.id": 150,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"151": {
"shop_x_store_service.id": 151,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"152": {
"shop_x_store_service.id": 152,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"153": {
"shop_x_store_service.id": 153,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"154": {
"shop_x_store_service.id": 154,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
}
} |
{
"175": {
"shop_x_store_department.id": 175,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"176": {
"shop_x_store_department.id": 176,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"177": {
"shop_x_store_department.id": 177,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"178": {
"shop_x_store_department.id": 178,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"179": {
"shop_x_store_department.id": 179,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"180": {
"shop_x_store_department.id": 180,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"181": {
"shop_x_store_department.id": 181,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"182": {
"shop_x_store_department.id": 182,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"183": {
"shop_x_store_department.id": 183,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"184": {
"shop_x_store_department.id": 184,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"185": {
"shop_x_store_department.id": 185,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
14 | 2018-11-21 01:35:48 | 41.3567313 | -72.2117045 | 248 Flanders Road | 248 Flanders Road East Lyme, CT | US | 06333 | +1-860-691-2146 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2200 | +1-860-739-5957 | +1-844-411-6468 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-860-739-6065 | 113 Boston Post Rd | 06333 | 41.366317 | -72.210211 | { "14": { "city_x_shop.id": 14, "city.id": 18, "city.ts": "2018-11-19 21:44:06", "city.title": "East Lyme", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"155": {
"shop_x_store_service.id": 155,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"156": {
"shop_x_store_service.id": 156,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"157": {
"shop_x_store_service.id": 157,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"158": {
"shop_x_store_service.id": 158,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"159": {
"shop_x_store_service.id": 159,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"160": {
"shop_x_store_service.id": 160,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"161": {
"shop_x_store_service.id": 161,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"163": {
"shop_x_store_service.id": 163,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"165": {
"shop_x_store_service.id": 165,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"164": {
"shop_x_store_service.id": 164,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
},
"162": {
"shop_x_store_service.id": 162,
"store_service.id": 162,
"store_service.ts": "2018-11-21 01:35:48",
"store_service.store_service": "WiFi"
},
"166": {
"shop_x_store_service.id": 166,
"store_service.id": 166,
"store_service.ts": "2018-11-21 01:35:48",
"store_service.store_service": "Weigh It!"
},
"167": {
"shop_x_store_service.id": 167,
"store_service.id": 167,
"store_service.ts": "2018-11-21 01:35:48",
"store_service.store_service": "Starbucks"
}
} |
{
"186": {
"shop_x_store_department.id": 186,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"187": {
"shop_x_store_department.id": 187,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"188": {
"shop_x_store_department.id": 188,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"189": {
"shop_x_store_department.id": 189,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"190": {
"shop_x_store_department.id": 190,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"191": {
"shop_x_store_department.id": 191,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"192": {
"shop_x_store_department.id": 192,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"193": {
"shop_x_store_department.id": 193,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"194": {
"shop_x_store_department.id": 194,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"195": {
"shop_x_store_department.id": 195,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"196": {
"shop_x_store_department.id": 196,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"197": {
"shop_x_store_department.id": 197,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
15 | 2018-11-21 01:36:25 | 41.9882281 | -72.5744876 | 54 Hazard Avenue | 54 Hazard Avenue Enfield, CT | US | 06082 | +1-860-741-2200 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 0 | +1-860-741-2230 | +1-844-411-6586 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-860-763-2120 | 241 Hazard Ave | 06082 | 41.987373 | -72.544645 | { "15": { "city_x_shop.id": 15, "city.id": 19, "city.ts": "2018-11-19 21:44:06", "city.title": "Enfield", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"169": {
"shop_x_store_service.id": 169,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"170": {
"shop_x_store_service.id": 170,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"171": {
"shop_x_store_service.id": 171,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"172": {
"shop_x_store_service.id": 172,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"173": {
"shop_x_store_service.id": 173,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"174": {
"shop_x_store_service.id": 174,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"175": {
"shop_x_store_service.id": 175,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"177": {
"shop_x_store_service.id": 177,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"168": {
"shop_x_store_service.id": 168,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"176": {
"shop_x_store_service.id": 176,
"store_service.id": 62,
"store_service.ts": "2018-11-21 01:31:41",
"store_service.store_service": "Coinstar Exchange"
}
} |
{
"198": {
"shop_x_store_department.id": 198,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"199": {
"shop_x_store_department.id": 199,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"200": {
"shop_x_store_department.id": 200,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"201": {
"shop_x_store_department.id": 201,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"202": {
"shop_x_store_department.id": 202,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"203": {
"shop_x_store_department.id": 203,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"204": {
"shop_x_store_department.id": 204,
"store_department.id": 7,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Gas Station"
},
"205": {
"shop_x_store_department.id": 205,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"206": {
"shop_x_store_department.id": 206,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"207": {
"shop_x_store_department.id": 207,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"208": {
"shop_x_store_department.id": 208,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"209": {
"shop_x_store_department.id": 209,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
16 | 2018-11-21 01:36:41 | 41.9359142 | -72.7890747 | 120 Salmon Brook Street | 120 Salmon Brook Street Granby, CT | US | 06035 | +1-860-844-8331 | 600 | 2300 | 600 | 2300 | 600 | 2300 | 700 | 1700 | 600 | 2300 | 600 | 2300 | 700 | 2300 | +1-860-844-8346 | +1-844-411-6428 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1500 | +1-860-627-8010 | 80 Ella Grasso Tpke | 06096 | 41.920243 | -72.671617 | { "16": { "city_x_shop.id": 16, "city.id": 22, "city.ts": "2018-11-19 21:44:06", "city.title": "Granby", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"179": {
"shop_x_store_service.id": 179,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"180": {
"shop_x_store_service.id": 180,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"181": {
"shop_x_store_service.id": 181,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"182": {
"shop_x_store_service.id": 182,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"183": {
"shop_x_store_service.id": 183,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"184": {
"shop_x_store_service.id": 184,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"185": {
"shop_x_store_service.id": 185,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"186": {
"shop_x_store_service.id": 186,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"187": {
"shop_x_store_service.id": 187,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"178": {
"shop_x_store_service.id": 178,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
}
} |
{
"210": {
"shop_x_store_department.id": 210,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"211": {
"shop_x_store_department.id": 211,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"212": {
"shop_x_store_department.id": 212,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"213": {
"shop_x_store_department.id": 213,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"214": {
"shop_x_store_department.id": 214,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"215": {
"shop_x_store_department.id": 215,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"216": {
"shop_x_store_department.id": 216,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"217": {
"shop_x_store_department.id": 217,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"218": {
"shop_x_store_department.id": 218,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"219": {
"shop_x_store_department.id": 219,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"220": {
"shop_x_store_department.id": 220,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
17 | 2018-11-21 01:36:51 | 41.36820180883829 | -72.06630527973175 | 220 Route 12 | 220 Route 12 Groton, CT | US | 06340 | +1-860-445-4440 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 2200 | +1-860-445-8807 | +1-844-411-6474 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-860-445-1080 | 294 Route 12 | 06340 | 41.370322 | -72.07084 | { "17": { "city_x_shop.id": 17, "city.id": 24, "city.ts": "2018-11-19 21:44:06", "city.title": "Groton", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"189": {
"shop_x_store_service.id": 189,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"190": {
"shop_x_store_service.id": 190,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"191": {
"shop_x_store_service.id": 191,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"192": {
"shop_x_store_service.id": 192,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"193": {
"shop_x_store_service.id": 193,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"194": {
"shop_x_store_service.id": 194,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"195": {
"shop_x_store_service.id": 195,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"198": {
"shop_x_store_service.id": 198,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"188": {
"shop_x_store_service.id": 188,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"197": {
"shop_x_store_service.id": 197,
"store_service.id": 62,
"store_service.ts": "2018-11-21 01:31:41",
"store_service.store_service": "Coinstar Exchange"
},
"196": {
"shop_x_store_service.id": 196,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
},
"199": {
"shop_x_store_service.id": 199,
"store_service.id": 167,
"store_service.ts": "2018-11-21 01:35:48",
"store_service.store_service": "Starbucks"
}
} |
{
"221": {
"shop_x_store_department.id": 221,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"222": {
"shop_x_store_department.id": 222,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"223": {
"shop_x_store_department.id": 223,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"224": {
"shop_x_store_department.id": 224,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"225": {
"shop_x_store_department.id": 225,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"226": {
"shop_x_store_department.id": 226,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"227": {
"shop_x_store_department.id": 227,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"228": {
"shop_x_store_department.id": 228,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"229": {
"shop_x_store_department.id": 229,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"230": {
"shop_x_store_department.id": 230,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"231": {
"shop_x_store_department.id": 231,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
18 | 2018-11-21 01:38:30 | 41.3722929 | -72.9141683 | 2335 Dixwell Avenue | 2335 Dixwell Avenue Hamden, CT | US | 06514 | +1-203-248-9615 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | 1700 | 0 | 0 | 0 | 0 | 0 | 0 | +1-203-248-9631 | +1-844-411-6420 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 1800 | 900 | 1600 | +1-203-248-8320 | 1994 Whitney Ave | 06517 | 41.370839 | -72.90662 | { "18": { "city_x_shop.id": 18, "city.id": 25, "city.ts": "2018-11-19 21:44:06", "city.title": "Hamden", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"201": {
"shop_x_store_service.id": 201,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"202": {
"shop_x_store_service.id": 202,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"203": {
"shop_x_store_service.id": 203,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"204": {
"shop_x_store_service.id": 204,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"205": {
"shop_x_store_service.id": 205,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"206": {
"shop_x_store_service.id": 206,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"207": {
"shop_x_store_service.id": 207,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"208": {
"shop_x_store_service.id": 208,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"210": {
"shop_x_store_service.id": 210,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"209": {
"shop_x_store_service.id": 209,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
},
"200": {
"shop_x_store_service.id": 200,
"store_service.id": 200,
"store_service.ts": "2018-11-21 01:38:30",
"store_service.store_service": "Dunkin Donuts"
}
} |
{
"232": {
"shop_x_store_department.id": 232,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"233": {
"shop_x_store_department.id": 233,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"234": {
"shop_x_store_department.id": 234,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"235": {
"shop_x_store_department.id": 235,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"236": {
"shop_x_store_department.id": 236,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"237": {
"shop_x_store_department.id": 237,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"238": {
"shop_x_store_department.id": 238,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"239": {
"shop_x_store_department.id": 239,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"240": {
"shop_x_store_department.id": 240,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"241": {
"shop_x_store_department.id": 241,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"242": {
"shop_x_store_department.id": 242,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
19 | 2018-11-21 01:39:50 | 41.7518143 | -72.7085742 | 150 New Park Avenue | 150 New Park Avenue Hartford, CT | US | 06106 | +1-860-232-8777 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 700 | 0 | +1-860-232-8848 | +1-844-411-6445 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 2100 | 900 | 1700 | 900 | 1500 | +1-860-236-0286 | 195 Prospect Ave | 06106 | 41.751444 | -72.715469 | { "19": { "city_x_shop.id": 19, "city.id": 26, "city.ts": "2018-11-19 21:44:06", "city.title": "Hartford", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"212": {
"shop_x_store_service.id": 212,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"213": {
"shop_x_store_service.id": 213,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"214": {
"shop_x_store_service.id": 214,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"215": {
"shop_x_store_service.id": 215,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"216": {
"shop_x_store_service.id": 216,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"217": {
"shop_x_store_service.id": 217,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"219": {
"shop_x_store_service.id": 219,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"218": {
"shop_x_store_service.id": 218,
"store_service.id": 62,
"store_service.ts": "2018-11-21 01:31:41",
"store_service.store_service": "Coinstar Exchange"
},
"211": {
"shop_x_store_service.id": 211,
"store_service.id": 200,
"store_service.ts": "2018-11-21 01:38:30",
"store_service.store_service": "Dunkin Donuts"
}
} |
{
"243": {
"shop_x_store_department.id": 243,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"244": {
"shop_x_store_department.id": 244,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"245": {
"shop_x_store_department.id": 245,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"246": {
"shop_x_store_department.id": 246,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"247": {
"shop_x_store_department.id": 247,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"248": {
"shop_x_store_department.id": 248,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"249": {
"shop_x_store_department.id": 249,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"250": {
"shop_x_store_department.id": 250,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"251": {
"shop_x_store_department.id": 251,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"252": {
"shop_x_store_department.id": 252,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"253": {
"shop_x_store_department.id": 253,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
20 | 2018-11-21 01:40:04 | 41.277576673416256 | -72.59650155901915 | 128 Samson Rock Road | 128 Samson Rock Road Madison, CT | US | 06443 | +1-203-245-7204 | 600 | 0 | 600 | 0 | 600 | 0 | 700 | 1700 | 600 | 0 | 600 | 0 | 600 | 2100 | +1-203-245-7467 | +1-844-411-6438 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 800 | 2000 | 900 | 1700 | 900 | 1700 | +1-203-245-2585 | 646 Boston Post Rd | 06443 | 41.279116 | -72.597311 | { "20": { "city_x_shop.id": 20, "city.id": 28, "city.ts": "2018-11-19 21:44:06", "city.title": "Madison", "city.count": "1", "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" } } | {
"221": {
"shop_x_store_service.id": 221,
"store_service.id": 1,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "People's United Bank"
},
"222": {
"shop_x_store_service.id": 222,
"store_service.id": 2,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Peapod"
},
"223": {
"shop_x_store_service.id": 223,
"store_service.id": 3,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "SCAN IT! Mobile"
},
"224": {
"shop_x_store_service.id": 224,
"store_service.id": 4,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "RedBox"
},
"225": {
"shop_x_store_service.id": 225,
"store_service.id": 5,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "UPromise"
},
"226": {
"shop_x_store_service.id": 226,
"store_service.id": 6,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Blue Rhino"
},
"227": {
"shop_x_store_service.id": 227,
"store_service.id": 7,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Western Union"
},
"228": {
"shop_x_store_service.id": 228,
"store_service.id": 8,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Order It!"
},
"230": {
"shop_x_store_service.id": 230,
"store_service.id": 9,
"store_service.ts": "2018-11-21 01:16:21",
"store_service.store_service": "Coinstar"
},
"220": {
"shop_x_store_service.id": 220,
"store_service.id": 46,
"store_service.ts": "2018-11-21 01:29:59",
"store_service.store_service": "Flu Vaccination"
},
"229": {
"shop_x_store_service.id": 229,
"store_service.id": 73,
"store_service.ts": "2018-11-21 01:31:45",
"store_service.store_service": "Pick-up (Attended)"
}
} |
{
"254": {
"shop_x_store_department.id": 254,
"store_department.id": 1,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Florist Shop"
},
"255": {
"shop_x_store_department.id": 255,
"store_department.id": 2,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Baby Shop"
},
"256": {
"shop_x_store_department.id": 256,
"store_department.id": 3,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Pet Shop"
},
"257": {
"shop_x_store_department.id": 257,
"store_department.id": 4,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Seafood Shop"
},
"258": {
"shop_x_store_department.id": 258,
"store_department.id": 5,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Produce Shop"
},
"259": {
"shop_x_store_department.id": 259,
"store_department.id": 6,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Butcher Shop"
},
"260": {
"shop_x_store_department.id": 260,
"store_department.id": 8,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Beauty Shop"
},
"261": {
"shop_x_store_department.id": 261,
"store_department.id": 9,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "Natural Foods"
},
"262": {
"shop_x_store_department.id": 262,
"store_department.id": 10,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "In-Store Pharmacy"
},
"263": {
"shop_x_store_department.id": 263,
"store_department.id": 11,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Bake Shop"
},
"264": {
"shop_x_store_department.id": 264,
"store_department.id": 12,
"store_department.ts": "2018-11-21 01:18:33",
"store_department.store_department": "The Deli Shop"
}
} |
shop.id | shop.ts | shop.latitude | shop.longitude | shop.address | shop.address_extend | shop.country | shop.postal_code | shop.phone | shop.store_monday_start | shop.store_monday_end | shop.store_tuesday_start | shop.store_tuesday_end | shop.store_wednesday_start | shop.store_wednesday_end | shop.store_thursday_start | shop.store_thursday_end | shop.store_friday_start | shop.store_friday_end | shop.store_saturday_start | shop.store_saturday_end | shop.store_sunday_start | shop.store_sunday_end | 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 | shop.gas_station_address | shop.gas_station_postal_code | shop.gas_station_latitude | shop.gas_station_longitude | shop.city_x_shop_id | shop.shop_x_store_service_id | shop.shop_x_store_department_id |