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""
    }
}"