You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 100 }, "api": { "title": "Rite Aid Stores in the United Sates", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 100, "time": 0.00728999999999999960531571474575684987939894199371337890625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 2136, "pages_total": 107 }, "struct": { "stem": { "0": "rite_aid_store" }, "leaf": "rite_aid_store.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "28": { "rite_aid_store.id": 28, "rite_aid_store.ts": "2018-01-11 03:44:47", "rite_aid_store.title": "Rite Aid #07066 Luverne", "rite_aid_store.address_street": "1402 South Forest Avenue", "rite_aid_store.telephone": "(334) 335-6188", "rite_aid_store.latitude": 31.696968860839195514245147933252155780792236328125, "rite_aid_store.address_locality": "Luverne", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36049, "rite_aid_store.longitude": -86.26677274703985176529386080801486968994140625, "rite_aid_store.city_x_rite_aid_store_id": { "28": { "city_x_rite_aid_store.id": 28, "city.id": 28, "city.ts": "2018-01-11 03:25:14", "city.title": "Luverne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "155": { "rite_aid_store_x_service_offered.id": 155, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "156": { "rite_aid_store_x_service_offered.id": 156, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "157": { "rite_aid_store_x_service_offered.id": 157, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "158": { "rite_aid_store_x_service_offered.id": 158, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "159": { "rite_aid_store_x_service_offered.id": 159, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "160": { "rite_aid_store_x_service_offered.id": 160, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "161": { "rite_aid_store_x_service_offered.id": 161, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "241": { "rite_aid_store_x_immunization.id": 241, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "242": { "rite_aid_store_x_immunization.id": 242, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "243": { "rite_aid_store_x_immunization.id": 243, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "244": { "rite_aid_store_x_immunization.id": 244, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "245": { "rite_aid_store_x_immunization.id": 245, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "246": { "rite_aid_store_x_immunization.id": 246, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "247": { "rite_aid_store_x_immunization.id": 247, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "248": { "rite_aid_store_x_immunization.id": 248, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "249": { "rite_aid_store_x_immunization.id": 249, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "250": { "rite_aid_store_x_immunization.id": 250, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "251": { "rite_aid_store_x_immunization.id": 251, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "252": { "rite_aid_store_x_immunization.id": 252, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "141": { "rite_aid_store_x_store_hour.id": 141, "store_hour.id": 1, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 8:00 PM" }, "142": { "rite_aid_store_x_store_hour.id": 142, "store_hour.id": 2, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "143": { "rite_aid_store_x_store_hour.id": 143, "store_hour.id": 3, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "144": { "rite_aid_store_x_store_hour.id": 144, "store_hour.id": 4, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 8:00 PM" }, "145": { "rite_aid_store_x_store_hour.id": 145, "store_hour.id": 5, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 8:00 PM" }, "146": { "rite_aid_store_x_store_hour.id": 146, "store_hour.id": 6, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 8:00 PM" }, "147": { "rite_aid_store_x_store_hour.id": 147, "store_hour.id": 7, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 8:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "141": { "rite_aid_store_x_pharmacy_hour.id": 141, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "142": { "rite_aid_store_x_pharmacy_hour.id": 142, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "143": { "rite_aid_store_x_pharmacy_hour.id": 143, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "144": { "rite_aid_store_x_pharmacy_hour.id": 144, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "145": { "rite_aid_store_x_pharmacy_hour.id": 145, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "146": { "rite_aid_store_x_pharmacy_hour.id": 146, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "147": { "rite_aid_store_x_pharmacy_hour.id": 147, "pharmacy_hour.id": 147, "pharmacy_hour.ts": "2018-01-11 03:44:47", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "12:00 PM - 6:00 PM" } } }, "30": { "rite_aid_store.id": 30, "rite_aid_store.ts": "2018-01-11 03:45:09", "rite_aid_store.title": "Rite Aid #07055 Meridianville", "rite_aid_store.address_street": "12290 Hwy 231-431 North", "rite_aid_store.telephone": "(256) 828-1000", "rite_aid_store.latitude": 34.87031300000000300087776849977672100067138671875, "rite_aid_store.address_locality": "Meridianville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35759, "rite_aid_store.longitude": -86.569424999999995407051756046712398529052734375, "rite_aid_store.city_x_rite_aid_store_id": { "30": { "city_x_rite_aid_store.id": 30, "city.id": 30, "city.ts": "2018-01-11 03:25:14", "city.title": "Meridianville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "163": { "rite_aid_store_x_service_offered.id": 163, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "164": { "rite_aid_store_x_service_offered.id": 164, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "165": { "rite_aid_store_x_service_offered.id": 165, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "166": { "rite_aid_store_x_service_offered.id": 166, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "162": { "rite_aid_store_x_service_offered.id": 162, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "167": { "rite_aid_store_x_service_offered.id": 167, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "168": { "rite_aid_store_x_service_offered.id": 168, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "253": { "rite_aid_store_x_immunization.id": 253, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "254": { "rite_aid_store_x_immunization.id": 254, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "255": { "rite_aid_store_x_immunization.id": 255, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "256": { "rite_aid_store_x_immunization.id": 256, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "257": { "rite_aid_store_x_immunization.id": 257, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "258": { "rite_aid_store_x_immunization.id": 258, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "259": { "rite_aid_store_x_immunization.id": 259, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "260": { "rite_aid_store_x_immunization.id": 260, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "261": { "rite_aid_store_x_immunization.id": 261, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "262": { "rite_aid_store_x_immunization.id": 262, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "263": { "rite_aid_store_x_immunization.id": 263, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "264": { "rite_aid_store_x_immunization.id": 264, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "148": { "rite_aid_store_x_store_hour.id": 148, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "149": { "rite_aid_store_x_store_hour.id": 149, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "150": { "rite_aid_store_x_store_hour.id": 150, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "151": { "rite_aid_store_x_store_hour.id": 151, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "152": { "rite_aid_store_x_store_hour.id": 152, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "153": { "rite_aid_store_x_store_hour.id": 153, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "154": { "rite_aid_store_x_store_hour.id": 154, "store_hour.id": 98, "store_hour.ts": "2018-01-11 03:43:01", "store_hour.key": "Sunday", "store_hour.value": "9:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "148": { "rite_aid_store_x_pharmacy_hour.id": 148, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "149": { "rite_aid_store_x_pharmacy_hour.id": 149, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "150": { "rite_aid_store_x_pharmacy_hour.id": 150, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "151": { "rite_aid_store_x_pharmacy_hour.id": 151, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "152": { "rite_aid_store_x_pharmacy_hour.id": 152, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "153": { "rite_aid_store_x_pharmacy_hour.id": 153, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "154": { "rite_aid_store_x_pharmacy_hour.id": 154, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "31": { "rite_aid_store.id": 31, "rite_aid_store.ts": "2018-01-11 03:45:17", "rite_aid_store.title": "Rite Aid #07067 Millbrook", "rite_aid_store.address_street": "3741 Highway 14", "rite_aid_store.telephone": "(334) 285-6648", "rite_aid_store.latitude": 32.5179049999999989495336194522678852081298828125, "rite_aid_store.address_locality": "Millbrook", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36054, "rite_aid_store.longitude": -86.374763999999998986822902224957942962646484375, "rite_aid_store.city_x_rite_aid_store_id": { "31": { "city_x_rite_aid_store.id": 31, "city.id": 31, "city.ts": "2018-01-11 03:25:14", "city.title": "Millbrook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "170": { "rite_aid_store_x_service_offered.id": 170, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "171": { "rite_aid_store_x_service_offered.id": 171, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "172": { "rite_aid_store_x_service_offered.id": 172, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "173": { "rite_aid_store_x_service_offered.id": 173, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "174": { "rite_aid_store_x_service_offered.id": 174, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "169": { "rite_aid_store_x_service_offered.id": 169, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "176": { "rite_aid_store_x_service_offered.id": 176, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "177": { "rite_aid_store_x_service_offered.id": 177, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "175": { "rite_aid_store_x_service_offered.id": 175, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "265": { "rite_aid_store_x_immunization.id": 265, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "266": { "rite_aid_store_x_immunization.id": 266, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "267": { "rite_aid_store_x_immunization.id": 267, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "268": { "rite_aid_store_x_immunization.id": 268, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "269": { "rite_aid_store_x_immunization.id": 269, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "270": { "rite_aid_store_x_immunization.id": 270, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "271": { "rite_aid_store_x_immunization.id": 271, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "272": { "rite_aid_store_x_immunization.id": 272, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "273": { "rite_aid_store_x_immunization.id": 273, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "274": { "rite_aid_store_x_immunization.id": 274, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "275": { "rite_aid_store_x_immunization.id": 275, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "276": { "rite_aid_store_x_immunization.id": 276, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "155": { "rite_aid_store_x_store_hour.id": 155, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "156": { "rite_aid_store_x_store_hour.id": 156, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "157": { "rite_aid_store_x_store_hour.id": 157, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "158": { "rite_aid_store_x_store_hour.id": 158, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "159": { "rite_aid_store_x_store_hour.id": 159, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "160": { "rite_aid_store_x_store_hour.id": 160, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "161": { "rite_aid_store_x_store_hour.id": 161, "store_hour.id": 14, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "155": { "rite_aid_store_x_pharmacy_hour.id": 155, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "156": { "rite_aid_store_x_pharmacy_hour.id": 156, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "157": { "rite_aid_store_x_pharmacy_hour.id": 157, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "158": { "rite_aid_store_x_pharmacy_hour.id": 158, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "159": { "rite_aid_store_x_pharmacy_hour.id": 159, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "160": { "rite_aid_store_x_pharmacy_hour.id": 160, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "161": { "rite_aid_store_x_pharmacy_hour.id": 161, "pharmacy_hour.id": 147, "pharmacy_hour.ts": "2018-01-11 03:44:47", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "12:00 PM - 6:00 PM" } } }, "33": { "rite_aid_store.id": 33, "rite_aid_store.ts": "2018-01-11 03:45:29", "rite_aid_store.title": "Rite Aid #07097 Monroeville", "rite_aid_store.address_street": "1818 South Alabama Avenue", "rite_aid_store.telephone": "(251) 743-3253", "rite_aid_store.latitude": 31.50061075706070568003269727341830730438232421875, "rite_aid_store.address_locality": "Monroeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36460, "rite_aid_store.longitude": -87.320426263077024486847221851348876953125, "rite_aid_store.city_x_rite_aid_store_id": { "33": { "city_x_rite_aid_store.id": 33, "city.id": 33, "city.ts": "2018-01-11 03:25:14", "city.title": "Monroeville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "178": { "rite_aid_store_x_service_offered.id": 178, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "179": { "rite_aid_store_x_service_offered.id": 179, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "180": { "rite_aid_store_x_service_offered.id": 180, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "181": { "rite_aid_store_x_service_offered.id": 181, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "182": { "rite_aid_store_x_service_offered.id": 182, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "277": { "rite_aid_store_x_immunization.id": 277, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "278": { "rite_aid_store_x_immunization.id": 278, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "279": { "rite_aid_store_x_immunization.id": 279, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "280": { "rite_aid_store_x_immunization.id": 280, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "281": { "rite_aid_store_x_immunization.id": 281, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "282": { "rite_aid_store_x_immunization.id": 282, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "283": { "rite_aid_store_x_immunization.id": 283, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "284": { "rite_aid_store_x_immunization.id": 284, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "285": { "rite_aid_store_x_immunization.id": 285, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "286": { "rite_aid_store_x_immunization.id": 286, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "287": { "rite_aid_store_x_immunization.id": 287, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "288": { "rite_aid_store_x_immunization.id": 288, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "162": { "rite_aid_store_x_store_hour.id": 162, "store_hour.id": 1, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 8:00 PM" }, "163": { "rite_aid_store_x_store_hour.id": 163, "store_hour.id": 2, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "164": { "rite_aid_store_x_store_hour.id": 164, "store_hour.id": 3, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "165": { "rite_aid_store_x_store_hour.id": 165, "store_hour.id": 4, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 8:00 PM" }, "166": { "rite_aid_store_x_store_hour.id": 166, "store_hour.id": 5, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 8:00 PM" }, "167": { "rite_aid_store_x_store_hour.id": 167, "store_hour.id": 6, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 8:00 PM" }, "168": { "rite_aid_store_x_store_hour.id": 168, "store_hour.id": 7, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 8:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "162": { "rite_aid_store_x_pharmacy_hour.id": 162, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "163": { "rite_aid_store_x_pharmacy_hour.id": 163, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "164": { "rite_aid_store_x_pharmacy_hour.id": 164, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "165": { "rite_aid_store_x_pharmacy_hour.id": 165, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "166": { "rite_aid_store_x_pharmacy_hour.id": 166, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "167": { "rite_aid_store_x_pharmacy_hour.id": 167, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "168": { "rite_aid_store_x_pharmacy_hour.id": 168, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "35": { "rite_aid_store.id": 35, "rite_aid_store.ts": "2018-01-11 03:45:42", "rite_aid_store.title": "Rite Aid #07021 Mountain Brook", "rite_aid_store.address_street": "2711 Culver Road", "rite_aid_store.telephone": "(205) 879-3466", "rite_aid_store.latitude": 33.48551499999999947476680972613394260406494140625, "rite_aid_store.address_locality": "Mountain Brook", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35223, "rite_aid_store.longitude": -86.7734180000000066002030507661402225494384765625, "rite_aid_store.city_x_rite_aid_store_id": { "35": { "city_x_rite_aid_store.id": 35, "city.id": 35, "city.ts": "2018-01-11 03:25:14", "city.title": "Mountain Brook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "184": { "rite_aid_store_x_service_offered.id": 184, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "185": { "rite_aid_store_x_service_offered.id": 185, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "186": { "rite_aid_store_x_service_offered.id": 186, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "187": { "rite_aid_store_x_service_offered.id": 187, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "189": { "rite_aid_store_x_service_offered.id": 189, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "190": { "rite_aid_store_x_service_offered.id": 190, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "183": { "rite_aid_store_x_service_offered.id": 183, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" }, "188": { "rite_aid_store_x_service_offered.id": 188, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "289": { "rite_aid_store_x_immunization.id": 289, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "290": { "rite_aid_store_x_immunization.id": 290, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "291": { "rite_aid_store_x_immunization.id": 291, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "292": { "rite_aid_store_x_immunization.id": 292, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "293": { "rite_aid_store_x_immunization.id": 293, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "294": { "rite_aid_store_x_immunization.id": 294, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "295": { "rite_aid_store_x_immunization.id": 295, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "296": { "rite_aid_store_x_immunization.id": 296, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "297": { "rite_aid_store_x_immunization.id": 297, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "298": { "rite_aid_store_x_immunization.id": 298, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "299": { "rite_aid_store_x_immunization.id": 299, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "300": { "rite_aid_store_x_immunization.id": 300, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "169": { "rite_aid_store_x_store_hour.id": 169, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "170": { "rite_aid_store_x_store_hour.id": 170, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "171": { "rite_aid_store_x_store_hour.id": 171, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "172": { "rite_aid_store_x_store_hour.id": 172, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "173": { "rite_aid_store_x_store_hour.id": 173, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "174": { "rite_aid_store_x_store_hour.id": 174, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" }, "175": { "rite_aid_store_x_store_hour.id": 175, "store_hour.id": 133, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "174": { "rite_aid_store_x_pharmacy_hour.id": 174, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "175": { "rite_aid_store_x_pharmacy_hour.id": 175, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "169": { "rite_aid_store_x_pharmacy_hour.id": 169, "pharmacy_hour.id": 8, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "170": { "rite_aid_store_x_pharmacy_hour.id": 170, "pharmacy_hour.id": 9, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "171": { "rite_aid_store_x_pharmacy_hour.id": 171, "pharmacy_hour.id": 10, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "172": { "rite_aid_store_x_pharmacy_hour.id": 172, "pharmacy_hour.id": 11, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "173": { "rite_aid_store_x_pharmacy_hour.id": 173, "pharmacy_hour.id": 12, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" } } }, "36": { "rite_aid_store.id": 36, "rite_aid_store.ts": "2018-01-11 03:45:48", "rite_aid_store.title": "Rite Aid #07041 Northport", "rite_aid_store.address_street": "2300 McFarland Blvd", "rite_aid_store.telephone": "(205) 339-2700", "rite_aid_store.latitude": 33.24095899999999659257809980772435665130615234375, "rite_aid_store.address_locality": "Northport", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35476, "rite_aid_store.longitude": -87.5800770000000028403519536368548870086669921875, "rite_aid_store.city_x_rite_aid_store_id": { "36": { "city_x_rite_aid_store.id": 36, "city.id": 36, "city.ts": "2018-01-11 03:25:14", "city.title": "Northport", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "192": { "rite_aid_store_x_service_offered.id": 192, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "193": { "rite_aid_store_x_service_offered.id": 193, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "194": { "rite_aid_store_x_service_offered.id": 194, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "195": { "rite_aid_store_x_service_offered.id": 195, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "196": { "rite_aid_store_x_service_offered.id": 196, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "197": { "rite_aid_store_x_service_offered.id": 197, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "198": { "rite_aid_store_x_service_offered.id": 198, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "191": { "rite_aid_store_x_service_offered.id": 191, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "301": { "rite_aid_store_x_immunization.id": 301, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "302": { "rite_aid_store_x_immunization.id": 302, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "303": { "rite_aid_store_x_immunization.id": 303, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "304": { "rite_aid_store_x_immunization.id": 304, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "305": { "rite_aid_store_x_immunization.id": 305, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "306": { "rite_aid_store_x_immunization.id": 306, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "307": { "rite_aid_store_x_immunization.id": 307, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "308": { "rite_aid_store_x_immunization.id": 308, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "309": { "rite_aid_store_x_immunization.id": 309, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "310": { "rite_aid_store_x_immunization.id": 310, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "311": { "rite_aid_store_x_immunization.id": 311, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "312": { "rite_aid_store_x_immunization.id": 312, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "176": { "rite_aid_store_x_store_hour.id": 176, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "177": { "rite_aid_store_x_store_hour.id": 177, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "178": { "rite_aid_store_x_store_hour.id": 178, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "179": { "rite_aid_store_x_store_hour.id": 179, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "180": { "rite_aid_store_x_store_hour.id": 180, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "181": { "rite_aid_store_x_store_hour.id": 181, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" }, "182": { "rite_aid_store_x_store_hour.id": 182, "store_hour.id": 133, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "176": { "rite_aid_store_x_pharmacy_hour.id": 176, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "177": { "rite_aid_store_x_pharmacy_hour.id": 177, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "178": { "rite_aid_store_x_pharmacy_hour.id": 178, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "179": { "rite_aid_store_x_pharmacy_hour.id": 179, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "180": { "rite_aid_store_x_pharmacy_hour.id": 180, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "181": { "rite_aid_store_x_pharmacy_hour.id": 181, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "182": { "rite_aid_store_x_pharmacy_hour.id": 182, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "37": { "rite_aid_store.id": 37, "rite_aid_store.ts": "2018-01-11 03:45:51", "rite_aid_store.title": "Rite Aid #07098 Opp", "rite_aid_store.address_street": "509 East Cummings Avenue", "rite_aid_store.telephone": "(334) 493-6563", "rite_aid_store.latitude": 31.279635138364227486817981116473674774169921875, "rite_aid_store.address_locality": "Opp", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36467, "rite_aid_store.longitude": -86.2486302852630615234375, "rite_aid_store.city_x_rite_aid_store_id": { "37": { "city_x_rite_aid_store.id": 37, "city.id": 37, "city.ts": "2018-01-11 03:25:14", "city.title": "Opp", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "199": { "rite_aid_store_x_service_offered.id": 199, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "200": { "rite_aid_store_x_service_offered.id": 200, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "201": { "rite_aid_store_x_service_offered.id": 201, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "202": { "rite_aid_store_x_service_offered.id": 202, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "203": { "rite_aid_store_x_service_offered.id": 203, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "204": { "rite_aid_store_x_service_offered.id": 204, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "313": { "rite_aid_store_x_immunization.id": 313, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "314": { "rite_aid_store_x_immunization.id": 314, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "315": { "rite_aid_store_x_immunization.id": 315, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "316": { "rite_aid_store_x_immunization.id": 316, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "317": { "rite_aid_store_x_immunization.id": 317, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "318": { "rite_aid_store_x_immunization.id": 318, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "319": { "rite_aid_store_x_immunization.id": 319, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "320": { "rite_aid_store_x_immunization.id": 320, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "321": { "rite_aid_store_x_immunization.id": 321, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "322": { "rite_aid_store_x_immunization.id": 322, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "323": { "rite_aid_store_x_immunization.id": 323, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "324": { "rite_aid_store_x_immunization.id": 324, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "183": { "rite_aid_store_x_store_hour.id": 183, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "184": { "rite_aid_store_x_store_hour.id": 184, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "185": { "rite_aid_store_x_store_hour.id": 185, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "186": { "rite_aid_store_x_store_hour.id": 186, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "187": { "rite_aid_store_x_store_hour.id": 187, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "188": { "rite_aid_store_x_store_hour.id": 188, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "189": { "rite_aid_store_x_store_hour.id": 189, "store_hour.id": 14, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "183": { "rite_aid_store_x_pharmacy_hour.id": 183, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "184": { "rite_aid_store_x_pharmacy_hour.id": 184, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "185": { "rite_aid_store_x_pharmacy_hour.id": 185, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "186": { "rite_aid_store_x_pharmacy_hour.id": 186, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "187": { "rite_aid_store_x_pharmacy_hour.id": 187, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "188": { "rite_aid_store_x_pharmacy_hour.id": 188, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "189": { "rite_aid_store_x_pharmacy_hour.id": 189, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "38": { "rite_aid_store.id": 38, "rite_aid_store.ts": "2018-01-11 03:46:00", "rite_aid_store.title": "Rite Aid #07108 Orange Beach", "rite_aid_store.address_street": "25801 Perdido Beach Boulevard", "rite_aid_store.telephone": "(251) 981-7019", "rite_aid_store.latitude": 30.270414104278618339094464317895472049713134765625, "rite_aid_store.address_locality": "Orange Beach", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36561, "rite_aid_store.longitude": -87.5854218006134033203125, "rite_aid_store.city_x_rite_aid_store_id": { "38": { "city_x_rite_aid_store.id": 38, "city.id": 38, "city.ts": "2018-01-11 03:25:14", "city.title": "Orange Beach", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "206": { "rite_aid_store_x_service_offered.id": 206, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "207": { "rite_aid_store_x_service_offered.id": 207, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "208": { "rite_aid_store_x_service_offered.id": 208, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "209": { "rite_aid_store_x_service_offered.id": 209, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "205": { "rite_aid_store_x_service_offered.id": 205, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "211": { "rite_aid_store_x_service_offered.id": 211, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "212": { "rite_aid_store_x_service_offered.id": 212, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "210": { "rite_aid_store_x_service_offered.id": 210, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" }, "213": { "rite_aid_store_x_service_offered.id": 213, "service_offered.id": 213, "service_offered.ts": "2018-01-11 03:46:00", "service_offered.value": "Video Remote Interpreting(VRI)" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "325": { "rite_aid_store_x_immunization.id": 325, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "326": { "rite_aid_store_x_immunization.id": 326, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "327": { "rite_aid_store_x_immunization.id": 327, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "328": { "rite_aid_store_x_immunization.id": 328, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "329": { "rite_aid_store_x_immunization.id": 329, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "330": { "rite_aid_store_x_immunization.id": 330, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "331": { "rite_aid_store_x_immunization.id": 331, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "332": { "rite_aid_store_x_immunization.id": 332, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "333": { "rite_aid_store_x_immunization.id": 333, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "334": { "rite_aid_store_x_immunization.id": 334, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "335": { "rite_aid_store_x_immunization.id": 335, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "336": { "rite_aid_store_x_immunization.id": 336, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "190": { "rite_aid_store_x_store_hour.id": 190, "store_hour.id": 22, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Monday", "store_hour.value": "7:00 AM - 10:00 PM" }, "191": { "rite_aid_store_x_store_hour.id": 191, "store_hour.id": 23, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Tuesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "192": { "rite_aid_store_x_store_hour.id": 192, "store_hour.id": 24, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Wednesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "193": { "rite_aid_store_x_store_hour.id": 193, "store_hour.id": 25, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Thursday", "store_hour.value": "7:00 AM - 10:00 PM" }, "194": { "rite_aid_store_x_store_hour.id": 194, "store_hour.id": 26, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Friday", "store_hour.value": "7:00 AM - 10:00 PM" }, "195": { "rite_aid_store_x_store_hour.id": 195, "store_hour.id": 27, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Saturday", "store_hour.value": "7:00 AM - 10:00 PM" }, "196": { "rite_aid_store_x_store_hour.id": 196, "store_hour.id": 28, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Sunday", "store_hour.value": "7:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "195": { "rite_aid_store_x_pharmacy_hour.id": 195, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "196": { "rite_aid_store_x_pharmacy_hour.id": 196, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "190": { "rite_aid_store_x_pharmacy_hour.id": 190, "pharmacy_hour.id": 8, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "191": { "rite_aid_store_x_pharmacy_hour.id": 191, "pharmacy_hour.id": 9, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "192": { "rite_aid_store_x_pharmacy_hour.id": 192, "pharmacy_hour.id": 10, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "193": { "rite_aid_store_x_pharmacy_hour.id": 193, "pharmacy_hour.id": 11, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" }, "194": { "rite_aid_store_x_pharmacy_hour.id": 194, "pharmacy_hour.id": 12, "pharmacy_hour.ts": "2018-01-11 03:41:17", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "9:00 AM - 9:00 PM" } } }, "39": { "rite_aid_store.id": 39, "rite_aid_store.ts": "2018-01-11 03:46:04", "rite_aid_store.title": "Rite Aid #07056 Owens Cross Roads", "rite_aid_store.address_street": "6707 US Hwy 431", "rite_aid_store.telephone": "(256) 533-5883", "rite_aid_store.latitude": 34.65955000000000296722646453417837619781494140625, "rite_aid_store.address_locality": "Owens Cross Roads", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35763, "rite_aid_store.longitude": -86.4811499999999995225152815692126750946044921875, "rite_aid_store.city_x_rite_aid_store_id": { "39": { "city_x_rite_aid_store.id": 39, "city.id": 39, "city.ts": "2018-01-11 03:25:14", "city.title": "Owens Cross Roads", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "215": { "rite_aid_store_x_service_offered.id": 215, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "216": { "rite_aid_store_x_service_offered.id": 216, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "217": { "rite_aid_store_x_service_offered.id": 217, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "218": { "rite_aid_store_x_service_offered.id": 218, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "214": { "rite_aid_store_x_service_offered.id": 214, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "219": { "rite_aid_store_x_service_offered.id": 219, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "220": { "rite_aid_store_x_service_offered.id": 220, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "337": { "rite_aid_store_x_immunization.id": 337, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "338": { "rite_aid_store_x_immunization.id": 338, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "339": { "rite_aid_store_x_immunization.id": 339, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "340": { "rite_aid_store_x_immunization.id": 340, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "341": { "rite_aid_store_x_immunization.id": 341, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "342": { "rite_aid_store_x_immunization.id": 342, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "343": { "rite_aid_store_x_immunization.id": 343, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "344": { "rite_aid_store_x_immunization.id": 344, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "345": { "rite_aid_store_x_immunization.id": 345, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "346": { "rite_aid_store_x_immunization.id": 346, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "347": { "rite_aid_store_x_immunization.id": 347, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "348": { "rite_aid_store_x_immunization.id": 348, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "203": { "rite_aid_store_x_store_hour.id": 203, "store_hour.id": 98, "store_hour.ts": "2018-01-11 03:43:01", "store_hour.key": "Sunday", "store_hour.value": "9:00 AM - 9:00 PM" }, "197": { "rite_aid_store_x_store_hour.id": 197, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "198": { "rite_aid_store_x_store_hour.id": 198, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "199": { "rite_aid_store_x_store_hour.id": 199, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "200": { "rite_aid_store_x_store_hour.id": 200, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "201": { "rite_aid_store_x_store_hour.id": 201, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "202": { "rite_aid_store_x_store_hour.id": 202, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "202": { "rite_aid_store_x_pharmacy_hour.id": 202, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "203": { "rite_aid_store_x_pharmacy_hour.id": 203, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "197": { "rite_aid_store_x_pharmacy_hour.id": 197, "pharmacy_hour.id": 22, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "198": { "rite_aid_store_x_pharmacy_hour.id": 198, "pharmacy_hour.id": 23, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "199": { "rite_aid_store_x_pharmacy_hour.id": 199, "pharmacy_hour.id": 24, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "200": { "rite_aid_store_x_pharmacy_hour.id": 200, "pharmacy_hour.id": 25, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "201": { "rite_aid_store_x_pharmacy_hour.id": 201, "pharmacy_hour.id": 26, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" } } }, "41": { "rite_aid_store.id": 41, "rite_aid_store.ts": "2018-01-11 03:46:15", "rite_aid_store.title": "Rite Aid #07025 Pelham", "rite_aid_store.address_street": "2101 Pelham Parkway", "rite_aid_store.telephone": "(205) 985-4995", "rite_aid_store.latitude": 33.34567200000000042336978367529809474945068359375, "rite_aid_store.address_locality": "Pelham", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35124, "rite_aid_store.longitude": -86.795175999999997884515323676168918609619140625, "rite_aid_store.city_x_rite_aid_store_id": { "41": { "city_x_rite_aid_store.id": 41, "city.id": 41, "city.ts": "2018-01-11 03:25:14", "city.title": "Pelham", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "222": { "rite_aid_store_x_service_offered.id": 222, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "223": { "rite_aid_store_x_service_offered.id": 223, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "224": { "rite_aid_store_x_service_offered.id": 224, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "225": { "rite_aid_store_x_service_offered.id": 225, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "226": { "rite_aid_store_x_service_offered.id": 226, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "221": { "rite_aid_store_x_service_offered.id": 221, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "227": { "rite_aid_store_x_service_offered.id": 227, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "228": { "rite_aid_store_x_service_offered.id": 228, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "349": { "rite_aid_store_x_immunization.id": 349, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "350": { "rite_aid_store_x_immunization.id": 350, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "351": { "rite_aid_store_x_immunization.id": 351, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "352": { "rite_aid_store_x_immunization.id": 352, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "353": { "rite_aid_store_x_immunization.id": 353, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "354": { "rite_aid_store_x_immunization.id": 354, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "355": { "rite_aid_store_x_immunization.id": 355, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "356": { "rite_aid_store_x_immunization.id": 356, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "357": { "rite_aid_store_x_immunization.id": 357, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "358": { "rite_aid_store_x_immunization.id": 358, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "359": { "rite_aid_store_x_immunization.id": 359, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "360": { "rite_aid_store_x_immunization.id": 360, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "210": { "rite_aid_store_x_store_hour.id": 210, "store_hour.id": 14, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 9:00 PM" }, "204": { "rite_aid_store_x_store_hour.id": 204, "store_hour.id": 43, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Monday", "store_hour.value": "7:00 AM - 9:00 PM" }, "205": { "rite_aid_store_x_store_hour.id": 205, "store_hour.id": 44, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Tuesday", "store_hour.value": "7:00 AM - 9:00 PM" }, "206": { "rite_aid_store_x_store_hour.id": 206, "store_hour.id": 45, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Wednesday", "store_hour.value": "7:00 AM - 9:00 PM" }, "207": { "rite_aid_store_x_store_hour.id": 207, "store_hour.id": 46, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Thursday", "store_hour.value": "7:00 AM - 9:00 PM" }, "208": { "rite_aid_store_x_store_hour.id": 208, "store_hour.id": 47, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Friday", "store_hour.value": "7:00 AM - 9:00 PM" }, "209": { "rite_aid_store_x_store_hour.id": 209, "store_hour.id": 48, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Saturday", "store_hour.value": "7:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "204": { "rite_aid_store_x_pharmacy_hour.id": 204, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "205": { "rite_aid_store_x_pharmacy_hour.id": 205, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "206": { "rite_aid_store_x_pharmacy_hour.id": 206, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "207": { "rite_aid_store_x_pharmacy_hour.id": 207, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "208": { "rite_aid_store_x_pharmacy_hour.id": 208, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "209": { "rite_aid_store_x_pharmacy_hour.id": 209, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "210": { "rite_aid_store_x_pharmacy_hour.id": 210, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "42": { "rite_aid_store.id": 42, "rite_aid_store.ts": "2018-01-11 03:46:21", "rite_aid_store.title": "Rite Aid #07010 Pinson", "rite_aid_store.address_street": "4689 Pinson Blvd", "rite_aid_store.telephone": "(205) 680-2751", "rite_aid_store.latitude": 33.69481799999999793726601637899875640869140625, "rite_aid_store.address_locality": "Pinson", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35126, "rite_aid_store.longitude": -86.6810200000000037334757507778704166412353515625, "rite_aid_store.city_x_rite_aid_store_id": { "42": { "city_x_rite_aid_store.id": 42, "city.id": 42, "city.ts": "2018-01-11 03:25:14", "city.title": "Pinson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "230": { "rite_aid_store_x_service_offered.id": 230, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "231": { "rite_aid_store_x_service_offered.id": 231, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "232": { "rite_aid_store_x_service_offered.id": 232, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "233": { "rite_aid_store_x_service_offered.id": 233, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "234": { "rite_aid_store_x_service_offered.id": 234, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "229": { "rite_aid_store_x_service_offered.id": 229, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "235": { "rite_aid_store_x_service_offered.id": 235, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "236": { "rite_aid_store_x_service_offered.id": 236, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "361": { "rite_aid_store_x_immunization.id": 361, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "362": { "rite_aid_store_x_immunization.id": 362, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "363": { "rite_aid_store_x_immunization.id": 363, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "364": { "rite_aid_store_x_immunization.id": 364, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "365": { "rite_aid_store_x_immunization.id": 365, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "366": { "rite_aid_store_x_immunization.id": 366, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "367": { "rite_aid_store_x_immunization.id": 367, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "368": { "rite_aid_store_x_immunization.id": 368, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "369": { "rite_aid_store_x_immunization.id": 369, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "370": { "rite_aid_store_x_immunization.id": 370, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "371": { "rite_aid_store_x_immunization.id": 371, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "372": { "rite_aid_store_x_immunization.id": 372, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "211": { "rite_aid_store_x_store_hour.id": 211, "store_hour.id": 43, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Monday", "store_hour.value": "7:00 AM - 9:00 PM" }, "212": { "rite_aid_store_x_store_hour.id": 212, "store_hour.id": 44, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Tuesday", "store_hour.value": "7:00 AM - 9:00 PM" }, "213": { "rite_aid_store_x_store_hour.id": 213, "store_hour.id": 45, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Wednesday", "store_hour.value": "7:00 AM - 9:00 PM" }, "214": { "rite_aid_store_x_store_hour.id": 214, "store_hour.id": 46, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Thursday", "store_hour.value": "7:00 AM - 9:00 PM" }, "215": { "rite_aid_store_x_store_hour.id": 215, "store_hour.id": 47, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Friday", "store_hour.value": "7:00 AM - 9:00 PM" }, "216": { "rite_aid_store_x_store_hour.id": 216, "store_hour.id": 48, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Saturday", "store_hour.value": "7:00 AM - 9:00 PM" }, "217": { "rite_aid_store_x_store_hour.id": 217, "store_hour.id": 98, "store_hour.ts": "2018-01-11 03:43:01", "store_hour.key": "Sunday", "store_hour.value": "9:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "217": { "rite_aid_store_x_pharmacy_hour.id": 217, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "216": { "rite_aid_store_x_pharmacy_hour.id": 216, "pharmacy_hour.id": 20, "pharmacy_hour.ts": "2018-01-11 03:41:24", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "8:00 AM - 6:00 PM" }, "211": { "rite_aid_store_x_pharmacy_hour.id": 211, "pharmacy_hour.id": 22, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "212": { "rite_aid_store_x_pharmacy_hour.id": 212, "pharmacy_hour.id": 23, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "213": { "rite_aid_store_x_pharmacy_hour.id": 213, "pharmacy_hour.id": 24, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "214": { "rite_aid_store_x_pharmacy_hour.id": 214, "pharmacy_hour.id": 25, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "215": { "rite_aid_store_x_pharmacy_hour.id": 215, "pharmacy_hour.id": 26, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" } } }, "43": { "rite_aid_store.id": 43, "rite_aid_store.ts": "2018-01-11 03:46:26", "rite_aid_store.title": "Rite Aid #07172 Prattville", "rite_aid_store.address_street": "606 South Memorial Drive", "rite_aid_store.telephone": "(334) 365-1600", "rite_aid_store.latitude": 32.46121260000000319223545375280082225799560546875, "rite_aid_store.address_locality": "Prattville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36067, "rite_aid_store.longitude": -86.4515937000000036505298339761793613433837890625, "rite_aid_store.city_x_rite_aid_store_id": { "43": { "city_x_rite_aid_store.id": 43, "city.id": 43, "city.ts": "2018-01-11 03:25:14", "city.title": "Prattville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "237": { "rite_aid_store_x_service_offered.id": 237, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "238": { "rite_aid_store_x_service_offered.id": 238, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "239": { "rite_aid_store_x_service_offered.id": 239, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "240": { "rite_aid_store_x_service_offered.id": 240, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "241": { "rite_aid_store_x_service_offered.id": 241, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "242": { "rite_aid_store_x_service_offered.id": 242, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "243": { "rite_aid_store_x_service_offered.id": 243, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "373": { "rite_aid_store_x_immunization.id": 373, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "374": { "rite_aid_store_x_immunization.id": 374, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "375": { "rite_aid_store_x_immunization.id": 375, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "376": { "rite_aid_store_x_immunization.id": 376, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "377": { "rite_aid_store_x_immunization.id": 377, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "378": { "rite_aid_store_x_immunization.id": 378, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "379": { "rite_aid_store_x_immunization.id": 379, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "380": { "rite_aid_store_x_immunization.id": 380, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "381": { "rite_aid_store_x_immunization.id": 381, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "382": { "rite_aid_store_x_immunization.id": 382, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "383": { "rite_aid_store_x_immunization.id": 383, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "384": { "rite_aid_store_x_immunization.id": 384, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "218": { "rite_aid_store_x_store_hour.id": 218, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "219": { "rite_aid_store_x_store_hour.id": 219, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "220": { "rite_aid_store_x_store_hour.id": 220, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "221": { "rite_aid_store_x_store_hour.id": 221, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "222": { "rite_aid_store_x_store_hour.id": 222, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "223": { "rite_aid_store_x_store_hour.id": 223, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" }, "224": { "rite_aid_store_x_store_hour.id": 224, "store_hour.id": 133, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "218": { "rite_aid_store_x_pharmacy_hour.id": 218, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "219": { "rite_aid_store_x_pharmacy_hour.id": 219, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "220": { "rite_aid_store_x_pharmacy_hour.id": 220, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "221": { "rite_aid_store_x_pharmacy_hour.id": 221, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "222": { "rite_aid_store_x_pharmacy_hour.id": 222, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "223": { "rite_aid_store_x_pharmacy_hour.id": 223, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "224": { "rite_aid_store_x_pharmacy_hour.id": 224, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "44": { "rite_aid_store.id": 44, "rite_aid_store.ts": "2018-01-11 03:46:33", "rite_aid_store.title": "Rite Aid #07126 Prichard", "rite_aid_store.address_street": "4739 Saint Stephens Road", "rite_aid_store.telephone": "(251) 457-6666", "rite_aid_store.latitude": 30.7666329999999987876435625366866588592529296875, "rite_aid_store.address_locality": "Prichard", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36613, "rite_aid_store.longitude": -88.1318270000000012487362255342304706573486328125, "rite_aid_store.city_x_rite_aid_store_id": { "44": { "city_x_rite_aid_store.id": 44, "city.id": 44, "city.ts": "2018-01-11 03:25:14", "city.title": "Prichard", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "244": { "rite_aid_store_x_service_offered.id": 244, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "245": { "rite_aid_store_x_service_offered.id": 245, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "246": { "rite_aid_store_x_service_offered.id": 246, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "247": { "rite_aid_store_x_service_offered.id": 247, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "385": { "rite_aid_store_x_immunization.id": 385, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "386": { "rite_aid_store_x_immunization.id": 386, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "387": { "rite_aid_store_x_immunization.id": 387, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "388": { "rite_aid_store_x_immunization.id": 388, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "389": { "rite_aid_store_x_immunization.id": 389, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "390": { "rite_aid_store_x_immunization.id": 390, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "391": { "rite_aid_store_x_immunization.id": 391, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "392": { "rite_aid_store_x_immunization.id": 392, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "393": { "rite_aid_store_x_immunization.id": 393, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "394": { "rite_aid_store_x_immunization.id": 394, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "395": { "rite_aid_store_x_immunization.id": 395, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "396": { "rite_aid_store_x_immunization.id": 396, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "225": { "rite_aid_store_x_store_hour.id": 225, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "226": { "rite_aid_store_x_store_hour.id": 226, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "227": { "rite_aid_store_x_store_hour.id": 227, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "228": { "rite_aid_store_x_store_hour.id": 228, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "229": { "rite_aid_store_x_store_hour.id": 229, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "230": { "rite_aid_store_x_store_hour.id": 230, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "231": { "rite_aid_store_x_store_hour.id": 231, "store_hour.id": 14, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "225": { "rite_aid_store_x_pharmacy_hour.id": 225, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "226": { "rite_aid_store_x_pharmacy_hour.id": 226, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "227": { "rite_aid_store_x_pharmacy_hour.id": 227, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "228": { "rite_aid_store_x_pharmacy_hour.id": 228, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "229": { "rite_aid_store_x_pharmacy_hour.id": 229, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "230": { "rite_aid_store_x_pharmacy_hour.id": 230, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "231": { "rite_aid_store_x_pharmacy_hour.id": 231, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "45": { "rite_aid_store.id": 45, "rite_aid_store.ts": "2018-01-11 03:46:38", "rite_aid_store.title": "Rite Aid #07062 Rainsville", "rite_aid_store.address_street": "42 McCurdy Avenue N", "rite_aid_store.telephone": "(256) 638-4414", "rite_aid_store.latitude": 34.49417100000000147019818541593849658966064453125, "rite_aid_store.address_locality": "Rainsville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35986, "rite_aid_store.longitude": -85.8465326999999973622834659181535243988037109375, "rite_aid_store.city_x_rite_aid_store_id": { "45": { "city_x_rite_aid_store.id": 45, "city.id": 45, "city.ts": "2018-01-11 03:25:14", "city.title": "Rainsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "248": { "rite_aid_store_x_service_offered.id": 248, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "249": { "rite_aid_store_x_service_offered.id": 249, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "250": { "rite_aid_store_x_service_offered.id": 250, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "251": { "rite_aid_store_x_service_offered.id": 251, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "252": { "rite_aid_store_x_service_offered.id": 252, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "253": { "rite_aid_store_x_service_offered.id": 253, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "397": { "rite_aid_store_x_immunization.id": 397, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "398": { "rite_aid_store_x_immunization.id": 398, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "399": { "rite_aid_store_x_immunization.id": 399, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "400": { "rite_aid_store_x_immunization.id": 400, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "401": { "rite_aid_store_x_immunization.id": 401, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "402": { "rite_aid_store_x_immunization.id": 402, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "403": { "rite_aid_store_x_immunization.id": 403, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "404": { "rite_aid_store_x_immunization.id": 404, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "405": { "rite_aid_store_x_immunization.id": 405, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "406": { "rite_aid_store_x_immunization.id": 406, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "407": { "rite_aid_store_x_immunization.id": 407, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "408": { "rite_aid_store_x_immunization.id": 408, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "232": { "rite_aid_store_x_store_hour.id": 232, "store_hour.id": 1, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 8:00 PM" }, "233": { "rite_aid_store_x_store_hour.id": 233, "store_hour.id": 2, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "234": { "rite_aid_store_x_store_hour.id": 234, "store_hour.id": 3, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 8:00 PM" }, "235": { "rite_aid_store_x_store_hour.id": 235, "store_hour.id": 4, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 8:00 PM" }, "236": { "rite_aid_store_x_store_hour.id": 236, "store_hour.id": 5, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 8:00 PM" }, "237": { "rite_aid_store_x_store_hour.id": 237, "store_hour.id": 6, "store_hour.ts": "2018-01-11 03:41:14", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 8:00 PM" }, "238": { "rite_aid_store_x_store_hour.id": 238, "store_hour.id": 91, "store_hour.ts": "2018-01-11 03:42:53", "store_hour.key": "Sunday", "store_hour.value": "9:00 AM - 8:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "232": { "rite_aid_store_x_pharmacy_hour.id": 232, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "233": { "rite_aid_store_x_pharmacy_hour.id": 233, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "234": { "rite_aid_store_x_pharmacy_hour.id": 234, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "235": { "rite_aid_store_x_pharmacy_hour.id": 235, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "236": { "rite_aid_store_x_pharmacy_hour.id": 236, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "237": { "rite_aid_store_x_pharmacy_hour.id": 237, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "238": { "rite_aid_store_x_pharmacy_hour.id": 238, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "46": { "rite_aid_store.id": 46, "rite_aid_store.ts": "2018-01-11 03:46:43", "rite_aid_store.title": "Rite Aid #07109 Robertsdale", "rite_aid_store.address_street": "21951 State Hwy 59 S", "rite_aid_store.telephone": "(251) 947-5777", "rite_aid_store.latitude": 30.5451920000000001209627953357994556427001953125, "rite_aid_store.address_locality": "Robertsdale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36567, "rite_aid_store.longitude": -87.709834000000000742147676646709442138671875, "rite_aid_store.city_x_rite_aid_store_id": { "46": { "city_x_rite_aid_store.id": 46, "city.id": 46, "city.ts": "2018-01-11 03:25:14", "city.title": "Robertsdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "254": { "rite_aid_store_x_service_offered.id": 254, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "255": { "rite_aid_store_x_service_offered.id": 255, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "256": { "rite_aid_store_x_service_offered.id": 256, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "257": { "rite_aid_store_x_service_offered.id": 257, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "258": { "rite_aid_store_x_service_offered.id": 258, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "409": { "rite_aid_store_x_immunization.id": 409, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "410": { "rite_aid_store_x_immunization.id": 410, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "411": { "rite_aid_store_x_immunization.id": 411, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "412": { "rite_aid_store_x_immunization.id": 412, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "413": { "rite_aid_store_x_immunization.id": 413, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "414": { "rite_aid_store_x_immunization.id": 414, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "415": { "rite_aid_store_x_immunization.id": 415, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "416": { "rite_aid_store_x_immunization.id": 416, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "417": { "rite_aid_store_x_immunization.id": 417, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "418": { "rite_aid_store_x_immunization.id": 418, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "419": { "rite_aid_store_x_immunization.id": 419, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "420": { "rite_aid_store_x_immunization.id": 420, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "239": { "rite_aid_store_x_store_hour.id": 239, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "240": { "rite_aid_store_x_store_hour.id": 240, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "241": { "rite_aid_store_x_store_hour.id": 241, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "242": { "rite_aid_store_x_store_hour.id": 242, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "243": { "rite_aid_store_x_store_hour.id": 243, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "244": { "rite_aid_store_x_store_hour.id": 244, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" }, "245": { "rite_aid_store_x_store_hour.id": 245, "store_hour.id": 133, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "239": { "rite_aid_store_x_pharmacy_hour.id": 239, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "240": { "rite_aid_store_x_pharmacy_hour.id": 240, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "241": { "rite_aid_store_x_pharmacy_hour.id": 241, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "242": { "rite_aid_store_x_pharmacy_hour.id": 242, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "243": { "rite_aid_store_x_pharmacy_hour.id": 243, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "244": { "rite_aid_store_x_pharmacy_hour.id": 244, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "245": { "rite_aid_store_x_pharmacy_hour.id": 245, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "47": { "rite_aid_store.id": 47, "rite_aid_store.ts": "2018-01-11 03:46:50", "rite_aid_store.title": "Rite Aid #07181 Saraland", "rite_aid_store.address_street": "13 Shelton Beach Road", "rite_aid_store.telephone": "(251) 675-7094", "rite_aid_store.latitude": 30.823187999999998254452293622307479381561279296875, "rite_aid_store.address_locality": "Saraland", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36571, "rite_aid_store.longitude": -88.071203999999994493919075466692447662353515625, "rite_aid_store.city_x_rite_aid_store_id": { "47": { "city_x_rite_aid_store.id": 47, "city.id": 47, "city.ts": "2018-01-11 03:25:14", "city.title": "Saraland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "259": { "rite_aid_store_x_service_offered.id": 259, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "260": { "rite_aid_store_x_service_offered.id": 260, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "261": { "rite_aid_store_x_service_offered.id": 261, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "262": { "rite_aid_store_x_service_offered.id": 262, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "263": { "rite_aid_store_x_service_offered.id": 263, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "264": { "rite_aid_store_x_service_offered.id": 264, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "421": { "rite_aid_store_x_immunization.id": 421, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "422": { "rite_aid_store_x_immunization.id": 422, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "423": { "rite_aid_store_x_immunization.id": 423, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "424": { "rite_aid_store_x_immunization.id": 424, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "425": { "rite_aid_store_x_immunization.id": 425, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "426": { "rite_aid_store_x_immunization.id": 426, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "427": { "rite_aid_store_x_immunization.id": 427, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "428": { "rite_aid_store_x_immunization.id": 428, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "429": { "rite_aid_store_x_immunization.id": 429, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "430": { "rite_aid_store_x_immunization.id": 430, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "431": { "rite_aid_store_x_immunization.id": 431, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "432": { "rite_aid_store_x_immunization.id": 432, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "246": { "rite_aid_store_x_store_hour.id": 246, "store_hour.id": 22, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Monday", "store_hour.value": "7:00 AM - 10:00 PM" }, "247": { "rite_aid_store_x_store_hour.id": 247, "store_hour.id": 23, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Tuesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "248": { "rite_aid_store_x_store_hour.id": 248, "store_hour.id": 24, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Wednesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "249": { "rite_aid_store_x_store_hour.id": 249, "store_hour.id": 25, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Thursday", "store_hour.value": "7:00 AM - 10:00 PM" }, "250": { "rite_aid_store_x_store_hour.id": 250, "store_hour.id": 26, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Friday", "store_hour.value": "7:00 AM - 10:00 PM" }, "251": { "rite_aid_store_x_store_hour.id": 251, "store_hour.id": 27, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Saturday", "store_hour.value": "7:00 AM - 10:00 PM" }, "252": { "rite_aid_store_x_store_hour.id": 252, "store_hour.id": 28, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Sunday", "store_hour.value": "7:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "246": { "rite_aid_store_x_pharmacy_hour.id": 246, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "247": { "rite_aid_store_x_pharmacy_hour.id": 247, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "248": { "rite_aid_store_x_pharmacy_hour.id": 248, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "249": { "rite_aid_store_x_pharmacy_hour.id": 249, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "250": { "rite_aid_store_x_pharmacy_hour.id": 250, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "251": { "rite_aid_store_x_pharmacy_hour.id": 251, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "252": { "rite_aid_store_x_pharmacy_hour.id": 252, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "48": { "rite_aid_store.id": 48, "rite_aid_store.ts": "2018-01-11 03:46:52", "rite_aid_store.title": "Rite Aid #07111 Semmes", "rite_aid_store.address_street": "7880 Moffett Road", "rite_aid_store.telephone": "(251) 645-1983", "rite_aid_store.latitude": 30.76458099999999973306330502964556217193603515625, "rite_aid_store.address_locality": "Semmes", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36575, "rite_aid_store.longitude": -88.2272009999999937690517981536686420440673828125, "rite_aid_store.city_x_rite_aid_store_id": { "48": { "city_x_rite_aid_store.id": 48, "city.id": 48, "city.ts": "2018-01-11 03:25:14", "city.title": "Semmes", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "266": { "rite_aid_store_x_service_offered.id": 266, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "267": { "rite_aid_store_x_service_offered.id": 267, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "268": { "rite_aid_store_x_service_offered.id": 268, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "269": { "rite_aid_store_x_service_offered.id": 269, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "265": { "rite_aid_store_x_service_offered.id": 265, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "270": { "rite_aid_store_x_service_offered.id": 270, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "271": { "rite_aid_store_x_service_offered.id": 271, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "433": { "rite_aid_store_x_immunization.id": 433, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "434": { "rite_aid_store_x_immunization.id": 434, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "435": { "rite_aid_store_x_immunization.id": 435, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "436": { "rite_aid_store_x_immunization.id": 436, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "437": { "rite_aid_store_x_immunization.id": 437, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "438": { "rite_aid_store_x_immunization.id": 438, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "439": { "rite_aid_store_x_immunization.id": 439, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "440": { "rite_aid_store_x_immunization.id": 440, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "441": { "rite_aid_store_x_immunization.id": 441, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "442": { "rite_aid_store_x_immunization.id": 442, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "443": { "rite_aid_store_x_immunization.id": 443, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "444": { "rite_aid_store_x_immunization.id": 444, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "253": { "rite_aid_store_x_store_hour.id": 253, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "254": { "rite_aid_store_x_store_hour.id": 254, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "255": { "rite_aid_store_x_store_hour.id": 255, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "256": { "rite_aid_store_x_store_hour.id": 256, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "257": { "rite_aid_store_x_store_hour.id": 257, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "258": { "rite_aid_store_x_store_hour.id": 258, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "259": { "rite_aid_store_x_store_hour.id": 259, "store_hour.id": 14, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "253": { "rite_aid_store_x_pharmacy_hour.id": 253, "pharmacy_hour.id": 1, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "254": { "rite_aid_store_x_pharmacy_hour.id": 254, "pharmacy_hour.id": 2, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "255": { "rite_aid_store_x_pharmacy_hour.id": 255, "pharmacy_hour.id": 3, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "256": { "rite_aid_store_x_pharmacy_hour.id": 256, "pharmacy_hour.id": 4, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "257": { "rite_aid_store_x_pharmacy_hour.id": 257, "pharmacy_hour.id": 5, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" }, "258": { "rite_aid_store_x_pharmacy_hour.id": 258, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "259": { "rite_aid_store_x_pharmacy_hour.id": 259, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" } } }, "49": { "rite_aid_store.id": 49, "rite_aid_store.ts": "2018-01-11 03:46:58", "rite_aid_store.title": "Rite Aid #07051 Sheffield", "rite_aid_store.address_street": "805 South Montgomery Avenue", "rite_aid_store.telephone": "(256) 383-1970", "rite_aid_store.latitude": 34.74990389140352675667600124143064022064208984375, "rite_aid_store.address_locality": "Sheffield", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35660, "rite_aid_store.longitude": -87.6981215254272683523595333099365234375, "rite_aid_store.city_x_rite_aid_store_id": { "49": { "city_x_rite_aid_store.id": 49, "city.id": 49, "city.ts": "2018-01-11 03:25:14", "city.title": "Sheffield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "273": { "rite_aid_store_x_service_offered.id": 273, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "274": { "rite_aid_store_x_service_offered.id": 274, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "275": { "rite_aid_store_x_service_offered.id": 275, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "276": { "rite_aid_store_x_service_offered.id": 276, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "272": { "rite_aid_store_x_service_offered.id": 272, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "278": { "rite_aid_store_x_service_offered.id": 278, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "279": { "rite_aid_store_x_service_offered.id": 279, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "277": { "rite_aid_store_x_service_offered.id": 277, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "445": { "rite_aid_store_x_immunization.id": 445, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "446": { "rite_aid_store_x_immunization.id": 446, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "447": { "rite_aid_store_x_immunization.id": 447, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "448": { "rite_aid_store_x_immunization.id": 448, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "449": { "rite_aid_store_x_immunization.id": 449, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "450": { "rite_aid_store_x_immunization.id": 450, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "451": { "rite_aid_store_x_immunization.id": 451, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "452": { "rite_aid_store_x_immunization.id": 452, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "453": { "rite_aid_store_x_immunization.id": 453, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "454": { "rite_aid_store_x_immunization.id": 454, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "455": { "rite_aid_store_x_immunization.id": 455, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "456": { "rite_aid_store_x_immunization.id": 456, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "260": { "rite_aid_store_x_store_hour.id": 260, "store_hour.id": 8, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 9:00 PM" }, "261": { "rite_aid_store_x_store_hour.id": 261, "store_hour.id": 9, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "262": { "rite_aid_store_x_store_hour.id": 262, "store_hour.id": 10, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 9:00 PM" }, "263": { "rite_aid_store_x_store_hour.id": 263, "store_hour.id": 11, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 9:00 PM" }, "264": { "rite_aid_store_x_store_hour.id": 264, "store_hour.id": 12, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 9:00 PM" }, "265": { "rite_aid_store_x_store_hour.id": 265, "store_hour.id": 13, "store_hour.ts": "2018-01-11 03:41:17", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 9:00 PM" }, "266": { "rite_aid_store_x_store_hour.id": 266, "store_hour.id": 98, "store_hour.ts": "2018-01-11 03:43:01", "store_hour.key": "Sunday", "store_hour.value": "9:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "260": { "rite_aid_store_x_pharmacy_hour.id": 260, "pharmacy_hour.id": 22, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "261": { "rite_aid_store_x_pharmacy_hour.id": 261, "pharmacy_hour.id": 23, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "262": { "rite_aid_store_x_pharmacy_hour.id": 262, "pharmacy_hour.id": 24, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "263": { "rite_aid_store_x_pharmacy_hour.id": 263, "pharmacy_hour.id": 25, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "264": { "rite_aid_store_x_pharmacy_hour.id": 264, "pharmacy_hour.id": 26, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "265": { "rite_aid_store_x_pharmacy_hour.id": 265, "pharmacy_hour.id": 265, "pharmacy_hour.ts": "2018-01-11 03:46:58", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 7:00 PM" }, "266": { "rite_aid_store_x_pharmacy_hour.id": 266, "pharmacy_hour.id": 266, "pharmacy_hour.ts": "2018-01-11 03:46:58", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" } } }, "50": { "rite_aid_store.id": 50, "rite_aid_store.ts": "2018-01-11 03:47:01", "rite_aid_store.title": "Rite Aid #07178 Spanish Fort", "rite_aid_store.address_street": "6530 Spanish Fort Blvd", "rite_aid_store.telephone": "(251) 626-0015", "rite_aid_store.latitude": 30.667400900000000518730303156189620494842529296875, "rite_aid_store.address_locality": "Spanish Fort", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36527, "rite_aid_store.longitude": -87.910482900000005201945896260440349578857421875, "rite_aid_store.city_x_rite_aid_store_id": { "50": { "city_x_rite_aid_store.id": 50, "city.id": 50, "city.ts": "2018-01-11 03:25:14", "city.title": "Spanish Fort", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "282": { "rite_aid_store_x_service_offered.id": 282, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "283": { "rite_aid_store_x_service_offered.id": 283, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "284": { "rite_aid_store_x_service_offered.id": 284, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "285": { "rite_aid_store_x_service_offered.id": 285, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "286": { "rite_aid_store_x_service_offered.id": 286, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "280": { "rite_aid_store_x_service_offered.id": 280, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "287": { "rite_aid_store_x_service_offered.id": 287, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "288": { "rite_aid_store_x_service_offered.id": 288, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "281": { "rite_aid_store_x_service_offered.id": 281, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "457": { "rite_aid_store_x_immunization.id": 457, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "458": { "rite_aid_store_x_immunization.id": 458, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "459": { "rite_aid_store_x_immunization.id": 459, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "460": { "rite_aid_store_x_immunization.id": 460, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "461": { "rite_aid_store_x_immunization.id": 461, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "462": { "rite_aid_store_x_immunization.id": 462, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "463": { "rite_aid_store_x_immunization.id": 463, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "464": { "rite_aid_store_x_immunization.id": 464, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "465": { "rite_aid_store_x_immunization.id": 465, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "466": { "rite_aid_store_x_immunization.id": 466, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "467": { "rite_aid_store_x_immunization.id": 467, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "468": { "rite_aid_store_x_immunization.id": 468, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "267": { "rite_aid_store_x_store_hour.id": 267, "store_hour.id": 22, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Monday", "store_hour.value": "7:00 AM - 10:00 PM" }, "268": { "rite_aid_store_x_store_hour.id": 268, "store_hour.id": 23, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Tuesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "269": { "rite_aid_store_x_store_hour.id": 269, "store_hour.id": 24, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Wednesday", "store_hour.value": "7:00 AM - 10:00 PM" }, "270": { "rite_aid_store_x_store_hour.id": 270, "store_hour.id": 25, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Thursday", "store_hour.value": "7:00 AM - 10:00 PM" }, "271": { "rite_aid_store_x_store_hour.id": 271, "store_hour.id": 26, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Friday", "store_hour.value": "7:00 AM - 10:00 PM" }, "272": { "rite_aid_store_x_store_hour.id": 272, "store_hour.id": 27, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Saturday", "store_hour.value": "7:00 AM - 10:00 PM" }, "273": { "rite_aid_store_x_store_hour.id": 273, "store_hour.id": 28, "store_hour.ts": "2018-01-11 03:41:29", "store_hour.key": "Sunday", "store_hour.value": "7:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "272": { "rite_aid_store_x_pharmacy_hour.id": 272, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "273": { "rite_aid_store_x_pharmacy_hour.id": 273, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "267": { "rite_aid_store_x_pharmacy_hour.id": 267, "pharmacy_hour.id": 22, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "268": { "rite_aid_store_x_pharmacy_hour.id": 268, "pharmacy_hour.id": 23, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "269": { "rite_aid_store_x_pharmacy_hour.id": 269, "pharmacy_hour.id": 24, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "270": { "rite_aid_store_x_pharmacy_hour.id": 270, "pharmacy_hour.id": 25, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "271": { "rite_aid_store_x_pharmacy_hour.id": 271, "pharmacy_hour.id": 26, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" } } }, "51": { "rite_aid_store.id": 51, "rite_aid_store.ts": "2018-01-11 03:47:07", "rite_aid_store.title": "Rite Aid #07011 Sylacauga", "rite_aid_store.address_street": "1 North Broadway Avenue", "rite_aid_store.telephone": "(256) 245-7474", "rite_aid_store.latitude": 33.167716149919414192481781356036663055419921875, "rite_aid_store.address_locality": "Sylacauga", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35150, "rite_aid_store.longitude": -86.251457254411434405483305454254150390625, "rite_aid_store.city_x_rite_aid_store_id": { "51": { "city_x_rite_aid_store.id": 51, "city.id": 51, "city.ts": "2018-01-11 03:25:14", "city.title": "Sylacauga", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" } }, "rite_aid_store.rite_aid_store_x_service_offered_id": { "291": { "rite_aid_store_x_service_offered.id": 291, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "292": { "rite_aid_store_x_service_offered.id": 292, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "293": { "rite_aid_store_x_service_offered.id": 293, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "294": { "rite_aid_store_x_service_offered.id": 294, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "295": { "rite_aid_store_x_service_offered.id": 295, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "289": { "rite_aid_store_x_service_offered.id": 289, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "297": { "rite_aid_store_x_service_offered.id": 297, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "298": { "rite_aid_store_x_service_offered.id": 298, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "290": { "rite_aid_store_x_service_offered.id": 290, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" }, "296": { "rite_aid_store_x_service_offered.id": 296, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "469": { "rite_aid_store_x_immunization.id": 469, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "470": { "rite_aid_store_x_immunization.id": 470, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "471": { "rite_aid_store_x_immunization.id": 471, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "472": { "rite_aid_store_x_immunization.id": 472, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "473": { "rite_aid_store_x_immunization.id": 473, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "474": { "rite_aid_store_x_immunization.id": 474, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "475": { "rite_aid_store_x_immunization.id": 475, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "476": { "rite_aid_store_x_immunization.id": 476, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "477": { "rite_aid_store_x_immunization.id": 477, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "478": { "rite_aid_store_x_immunization.id": 478, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "479": { "rite_aid_store_x_immunization.id": 479, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "480": { "rite_aid_store_x_immunization.id": 480, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" } }, "rite_aid_store.rite_aid_store_x_store_hour_id": { "274": { "rite_aid_store_x_store_hour.id": 274, "store_hour.id": 127, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Monday", "store_hour.value": "8:00 AM - 10:00 PM" }, "275": { "rite_aid_store_x_store_hour.id": 275, "store_hour.id": 128, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Tuesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "276": { "rite_aid_store_x_store_hour.id": 276, "store_hour.id": 129, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Wednesday", "store_hour.value": "8:00 AM - 10:00 PM" }, "277": { "rite_aid_store_x_store_hour.id": 277, "store_hour.id": 130, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Thursday", "store_hour.value": "8:00 AM - 10:00 PM" }, "278": { "rite_aid_store_x_store_hour.id": 278, "store_hour.id": 131, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Friday", "store_hour.value": "8:00 AM - 10:00 PM" }, "279": { "rite_aid_store_x_store_hour.id": 279, "store_hour.id": 132, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Saturday", "store_hour.value": "8:00 AM - 10:00 PM" }, "280": { "rite_aid_store_x_store_hour.id": 280, "store_hour.id": 133, "store_hour.ts": "2018-01-11 03:44:31", "store_hour.key": "Sunday", "store_hour.value": "8:00 AM - 10:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "279": { "rite_aid_store_x_pharmacy_hour.id": 279, "pharmacy_hour.id": 6, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "9:00 AM - 6:00 PM" }, "280": { "rite_aid_store_x_pharmacy_hour.id": 280, "pharmacy_hour.id": 7, "pharmacy_hour.ts": "2018-01-11 03:41:14", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "10:00 AM - 6:00 PM" }, "274": { "rite_aid_store_x_pharmacy_hour.id": 274, "pharmacy_hour.id": 22, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Monday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "275": { "rite_aid_store_x_pharmacy_hour.id": 275, "pharmacy_hour.id": 23, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Tuesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "276": { "rite_aid_store_x_pharmacy_hour.id": 276, "pharmacy_hour.id": 24, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Wednesday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "277": { "rite_aid_store_x_pharmacy_hour.id": 277, "pharmacy_hour.id": 25, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Thursday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" }, "278": { "rite_aid_store_x_pharmacy_hour.id": 278, "pharmacy_hour.id": 26, "pharmacy_hour.ts": "2018-01-11 03:41:29", "pharmacy_hour.key": "Friday", "pharmacy_hour.value": "8:00 AM - 9:00 PM" } } } } } }