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" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 100, "time": 0.01489000000000000045741188614556449465453624725341796875 }, "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": { "1": { "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "rite_aid_store.city_x_rite_aid_store_id": { "1": { "city_x_rite_aid_store.id": 1, "city.id": 1, "city.ts": "2018-01-11 03:25:14", "city.title": "Abbeville", "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": { "1": { "rite_aid_store_x_service_offered.id": 1, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "2": { "rite_aid_store_x_service_offered.id": 2, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "3": { "rite_aid_store_x_service_offered.id": 3, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "4": { "rite_aid_store_x_service_offered.id": 4, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "5": { "rite_aid_store_x_service_offered.id": 5, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "1": { "rite_aid_store_x_immunization.id": 1, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "2": { "rite_aid_store_x_immunization.id": 2, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "3": { "rite_aid_store_x_immunization.id": 3, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "4": { "rite_aid_store_x_immunization.id": 4, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "5": { "rite_aid_store_x_immunization.id": 5, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "6": { "rite_aid_store_x_immunization.id": 6, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "7": { "rite_aid_store_x_immunization.id": 7, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "8": { "rite_aid_store_x_immunization.id": 8, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "9": { "rite_aid_store_x_immunization.id": 9, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "10": { "rite_aid_store_x_immunization.id": 10, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "11": { "rite_aid_store_x_immunization.id": 11, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "12": { "rite_aid_store_x_immunization.id": 12, "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": { "1": { "rite_aid_store_x_store_hour.id": 1, "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" }, "2": { "rite_aid_store_x_store_hour.id": 2, "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" }, "3": { "rite_aid_store_x_store_hour.id": 3, "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" }, "4": { "rite_aid_store_x_store_hour.id": 4, "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" }, "5": { "rite_aid_store_x_store_hour.id": 5, "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" }, "6": { "rite_aid_store_x_store_hour.id": 6, "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" }, "7": { "rite_aid_store_x_store_hour.id": 7, "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": { "1": { "rite_aid_store_x_pharmacy_hour.id": 1, "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" }, "2": { "rite_aid_store_x_pharmacy_hour.id": 2, "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" }, "3": { "rite_aid_store_x_pharmacy_hour.id": 3, "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" }, "4": { "rite_aid_store_x_pharmacy_hour.id": 4, "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" }, "5": { "rite_aid_store_x_pharmacy_hour.id": 5, "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" }, "6": { "rite_aid_store_x_pharmacy_hour.id": 6, "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" }, "7": { "rite_aid_store_x_pharmacy_hour.id": 7, "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" } } }, "2": { "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "rite_aid_store.city_x_rite_aid_store_id": { "2": { "city_x_rite_aid_store.id": 2, "city.id": 2, "city.ts": "2018-01-11 03:25:14", "city.title": "Alabaster", "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": { "7": { "rite_aid_store_x_service_offered.id": 7, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "8": { "rite_aid_store_x_service_offered.id": 8, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "9": { "rite_aid_store_x_service_offered.id": 9, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "10": { "rite_aid_store_x_service_offered.id": 10, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "11": { "rite_aid_store_x_service_offered.id": 11, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "6": { "rite_aid_store_x_service_offered.id": 6, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "12": { "rite_aid_store_x_service_offered.id": 12, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "13": { "rite_aid_store_x_service_offered.id": 13, "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": { "13": { "rite_aid_store_x_immunization.id": 13, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "14": { "rite_aid_store_x_immunization.id": 14, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "15": { "rite_aid_store_x_immunization.id": 15, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "16": { "rite_aid_store_x_immunization.id": 16, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "17": { "rite_aid_store_x_immunization.id": 17, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "18": { "rite_aid_store_x_immunization.id": 18, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "19": { "rite_aid_store_x_immunization.id": 19, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "20": { "rite_aid_store_x_immunization.id": 20, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "21": { "rite_aid_store_x_immunization.id": 21, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "22": { "rite_aid_store_x_immunization.id": 22, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "23": { "rite_aid_store_x_immunization.id": 23, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "24": { "rite_aid_store_x_immunization.id": 24, "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": { "8": { "rite_aid_store_x_store_hour.id": 8, "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" }, "9": { "rite_aid_store_x_store_hour.id": 9, "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" }, "10": { "rite_aid_store_x_store_hour.id": 10, "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" }, "11": { "rite_aid_store_x_store_hour.id": 11, "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" }, "12": { "rite_aid_store_x_store_hour.id": 12, "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" }, "13": { "rite_aid_store_x_store_hour.id": 13, "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" }, "14": { "rite_aid_store_x_store_hour.id": 14, "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": { "13": { "rite_aid_store_x_pharmacy_hour.id": 13, "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" }, "14": { "rite_aid_store_x_pharmacy_hour.id": 14, "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" }, "8": { "rite_aid_store_x_pharmacy_hour.id": 8, "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" }, "9": { "rite_aid_store_x_pharmacy_hour.id": 9, "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" }, "10": { "rite_aid_store_x_pharmacy_hour.id": 10, "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" }, "11": { "rite_aid_store_x_pharmacy_hour.id": 11, "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" }, "12": { "rite_aid_store_x_pharmacy_hour.id": 12, "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" } } }, "3": { "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "rite_aid_store.city_x_rite_aid_store_id": { "3": { "city_x_rite_aid_store.id": 3, "city.id": 3, "city.ts": "2018-01-11 03:25:14", "city.title": "Alexander City", "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": { "15": { "rite_aid_store_x_service_offered.id": 15, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "16": { "rite_aid_store_x_service_offered.id": 16, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "17": { "rite_aid_store_x_service_offered.id": 17, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "18": { "rite_aid_store_x_service_offered.id": 18, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "19": { "rite_aid_store_x_service_offered.id": 19, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "14": { "rite_aid_store_x_service_offered.id": 14, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "20": { "rite_aid_store_x_service_offered.id": 20, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "21": { "rite_aid_store_x_service_offered.id": 21, "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": { "25": { "rite_aid_store_x_immunization.id": 25, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "26": { "rite_aid_store_x_immunization.id": 26, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "27": { "rite_aid_store_x_immunization.id": 27, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "28": { "rite_aid_store_x_immunization.id": 28, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "29": { "rite_aid_store_x_immunization.id": 29, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "30": { "rite_aid_store_x_immunization.id": 30, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "31": { "rite_aid_store_x_immunization.id": 31, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "32": { "rite_aid_store_x_immunization.id": 32, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "33": { "rite_aid_store_x_immunization.id": 33, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "34": { "rite_aid_store_x_immunization.id": 34, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "35": { "rite_aid_store_x_immunization.id": 35, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "36": { "rite_aid_store_x_immunization.id": 36, "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": { "15": { "rite_aid_store_x_store_hour.id": 15, "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" }, "16": { "rite_aid_store_x_store_hour.id": 16, "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" }, "17": { "rite_aid_store_x_store_hour.id": 17, "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" }, "18": { "rite_aid_store_x_store_hour.id": 18, "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" }, "19": { "rite_aid_store_x_store_hour.id": 19, "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" }, "20": { "rite_aid_store_x_store_hour.id": 20, "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" }, "21": { "rite_aid_store_x_store_hour.id": 21, "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": { "15": { "rite_aid_store_x_pharmacy_hour.id": 15, "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" }, "16": { "rite_aid_store_x_pharmacy_hour.id": 16, "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" }, "17": { "rite_aid_store_x_pharmacy_hour.id": 17, "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" }, "18": { "rite_aid_store_x_pharmacy_hour.id": 18, "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" }, "19": { "rite_aid_store_x_pharmacy_hour.id": 19, "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" }, "21": { "rite_aid_store_x_pharmacy_hour.id": 21, "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" }, "20": { "rite_aid_store_x_pharmacy_hour.id": 20, "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" } } }, "4": { "rite_aid_store.id": 4, "rite_aid_store.ts": "2018-01-11 03:41:29", "rite_aid_store.title": "Rite Aid #07095 Andalusia", "rite_aid_store.address_street": "1017 River Falls Street", "rite_aid_store.telephone": "(334) 222-9414", "rite_aid_store.latitude": 31.317395999999998679186319350264966487884521484375, "rite_aid_store.address_locality": "Andalusia", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36420, "rite_aid_store.longitude": -86.4983529999999944948285701684653759002685546875, "rite_aid_store.city_x_rite_aid_store_id": { "4": { "city_x_rite_aid_store.id": 4, "city.id": 4, "city.ts": "2018-01-11 03:25:14", "city.title": "Andalusia", "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": { "24": { "rite_aid_store_x_service_offered.id": 24, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "25": { "rite_aid_store_x_service_offered.id": 25, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "26": { "rite_aid_store_x_service_offered.id": 26, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "27": { "rite_aid_store_x_service_offered.id": 27, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "28": { "rite_aid_store_x_service_offered.id": 28, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "22": { "rite_aid_store_x_service_offered.id": 22, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "30": { "rite_aid_store_x_service_offered.id": 30, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "31": { "rite_aid_store_x_service_offered.id": 31, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "23": { "rite_aid_store_x_service_offered.id": 23, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" }, "29": { "rite_aid_store_x_service_offered.id": 29, "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": { "37": { "rite_aid_store_x_immunization.id": 37, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "38": { "rite_aid_store_x_immunization.id": 38, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "39": { "rite_aid_store_x_immunization.id": 39, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "40": { "rite_aid_store_x_immunization.id": 40, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "41": { "rite_aid_store_x_immunization.id": 41, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "42": { "rite_aid_store_x_immunization.id": 42, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "43": { "rite_aid_store_x_immunization.id": 43, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "44": { "rite_aid_store_x_immunization.id": 44, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "45": { "rite_aid_store_x_immunization.id": 45, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "46": { "rite_aid_store_x_immunization.id": 46, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "47": { "rite_aid_store_x_immunization.id": 47, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "48": { "rite_aid_store_x_immunization.id": 48, "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": { "22": { "rite_aid_store_x_store_hour.id": 22, "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" }, "23": { "rite_aid_store_x_store_hour.id": 23, "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" }, "24": { "rite_aid_store_x_store_hour.id": 24, "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" }, "25": { "rite_aid_store_x_store_hour.id": 25, "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" }, "26": { "rite_aid_store_x_store_hour.id": 26, "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" }, "27": { "rite_aid_store_x_store_hour.id": 27, "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" }, "28": { "rite_aid_store_x_store_hour.id": 28, "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": { "28": { "rite_aid_store_x_pharmacy_hour.id": 28, "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" }, "27": { "rite_aid_store_x_pharmacy_hour.id": 27, "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" }, "22": { "rite_aid_store_x_pharmacy_hour.id": 22, "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" }, "23": { "rite_aid_store_x_pharmacy_hour.id": 23, "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" }, "24": { "rite_aid_store_x_pharmacy_hour.id": 24, "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" }, "25": { "rite_aid_store_x_pharmacy_hour.id": 25, "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" }, "26": { "rite_aid_store_x_pharmacy_hour.id": 26, "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" } } }, "6": { "rite_aid_store.id": 6, "rite_aid_store.ts": "2018-01-11 03:41:35", "rite_aid_store.title": "Rite Aid #07099 Atmore", "rite_aid_store.address_street": "506 East Church Street", "rite_aid_store.telephone": "(251) 368-8131", "rite_aid_store.latitude": 31.021491999999998512294041574932634830474853515625, "rite_aid_store.address_locality": "Atmore", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36502, "rite_aid_store.longitude": -87.487990999999993846358847804367542266845703125, "rite_aid_store.city_x_rite_aid_store_id": { "6": { "city_x_rite_aid_store.id": 6, "city.id": 6, "city.ts": "2018-01-11 03:25:14", "city.title": "Atmore", "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": { "32": { "rite_aid_store_x_service_offered.id": 32, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "33": { "rite_aid_store_x_service_offered.id": 33, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "34": { "rite_aid_store_x_service_offered.id": 34, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "35": { "rite_aid_store_x_service_offered.id": 35, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "36": { "rite_aid_store_x_service_offered.id": 36, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "38": { "rite_aid_store_x_service_offered.id": 38, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "39": { "rite_aid_store_x_service_offered.id": 39, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "37": { "rite_aid_store_x_service_offered.id": 37, "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": { "49": { "rite_aid_store_x_immunization.id": 49, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "50": { "rite_aid_store_x_immunization.id": 50, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "51": { "rite_aid_store_x_immunization.id": 51, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "52": { "rite_aid_store_x_immunization.id": 52, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "53": { "rite_aid_store_x_immunization.id": 53, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "54": { "rite_aid_store_x_immunization.id": 54, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "55": { "rite_aid_store_x_immunization.id": 55, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "56": { "rite_aid_store_x_immunization.id": 56, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "57": { "rite_aid_store_x_immunization.id": 57, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "58": { "rite_aid_store_x_immunization.id": 58, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "59": { "rite_aid_store_x_immunization.id": 59, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "60": { "rite_aid_store_x_immunization.id": 60, "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": { "29": { "rite_aid_store_x_store_hour.id": 29, "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" }, "30": { "rite_aid_store_x_store_hour.id": 30, "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" }, "31": { "rite_aid_store_x_store_hour.id": 31, "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" }, "32": { "rite_aid_store_x_store_hour.id": 32, "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" }, "33": { "rite_aid_store_x_store_hour.id": 33, "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" }, "34": { "rite_aid_store_x_store_hour.id": 34, "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" }, "35": { "rite_aid_store_x_store_hour.id": 35, "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": { "29": { "rite_aid_store_x_pharmacy_hour.id": 29, "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" }, "30": { "rite_aid_store_x_pharmacy_hour.id": 30, "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" }, "31": { "rite_aid_store_x_pharmacy_hour.id": 31, "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" }, "32": { "rite_aid_store_x_pharmacy_hour.id": 32, "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" }, "33": { "rite_aid_store_x_pharmacy_hour.id": 33, "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" }, "34": { "rite_aid_store_x_pharmacy_hour.id": 34, "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" }, "35": { "rite_aid_store_x_pharmacy_hour.id": 35, "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" } } }, "8": { "rite_aid_store.id": 8, "rite_aid_store.ts": "2018-01-11 03:41:46", "rite_aid_store.title": "Rite Aid #07125 Chickasaw", "rite_aid_store.address_street": "414 North Craft Highway", "rite_aid_store.telephone": "(251) 452-0531", "rite_aid_store.latitude": 30.770562999999999220790414256043732166290283203125, "rite_aid_store.address_locality": "Chickasaw", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36611, "rite_aid_store.longitude": -88.0741770000000059326339396648108959197998046875, "rite_aid_store.city_x_rite_aid_store_id": { "8": { "city_x_rite_aid_store.id": 8, "city.id": 8, "city.ts": "2018-01-11 03:25:14", "city.title": "Chickasaw", "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": { "41": { "rite_aid_store_x_service_offered.id": 41, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "42": { "rite_aid_store_x_service_offered.id": 42, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "43": { "rite_aid_store_x_service_offered.id": 43, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "44": { "rite_aid_store_x_service_offered.id": 44, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "45": { "rite_aid_store_x_service_offered.id": 45, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "40": { "rite_aid_store_x_service_offered.id": 40, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "46": { "rite_aid_store_x_service_offered.id": 46, "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": { "61": { "rite_aid_store_x_immunization.id": 61, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "62": { "rite_aid_store_x_immunization.id": 62, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "63": { "rite_aid_store_x_immunization.id": 63, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "64": { "rite_aid_store_x_immunization.id": 64, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "65": { "rite_aid_store_x_immunization.id": 65, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "66": { "rite_aid_store_x_immunization.id": 66, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "67": { "rite_aid_store_x_immunization.id": 67, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "68": { "rite_aid_store_x_immunization.id": 68, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "69": { "rite_aid_store_x_immunization.id": 69, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "70": { "rite_aid_store_x_immunization.id": 70, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "71": { "rite_aid_store_x_immunization.id": 71, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "72": { "rite_aid_store_x_immunization.id": 72, "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": { "36": { "rite_aid_store_x_store_hour.id": 36, "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" }, "37": { "rite_aid_store_x_store_hour.id": 37, "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" }, "38": { "rite_aid_store_x_store_hour.id": 38, "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" }, "39": { "rite_aid_store_x_store_hour.id": 39, "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" }, "40": { "rite_aid_store_x_store_hour.id": 40, "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" }, "41": { "rite_aid_store_x_store_hour.id": 41, "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" }, "42": { "rite_aid_store_x_store_hour.id": 42, "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": { "36": { "rite_aid_store_x_pharmacy_hour.id": 36, "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" }, "37": { "rite_aid_store_x_pharmacy_hour.id": 37, "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" }, "38": { "rite_aid_store_x_pharmacy_hour.id": 38, "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" }, "39": { "rite_aid_store_x_pharmacy_hour.id": 39, "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" }, "40": { "rite_aid_store_x_pharmacy_hour.id": 40, "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" }, "41": { "rite_aid_store_x_pharmacy_hour.id": 41, "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" }, "42": { "rite_aid_store_x_pharmacy_hour.id": 42, "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" } } }, "9": { "rite_aid_store.id": 9, "rite_aid_store.ts": "2018-01-11 03:41:53", "rite_aid_store.title": "Rite Aid #07004 Clanton", "rite_aid_store.address_street": "641 Ollie Avenue", "rite_aid_store.telephone": "(205) 755-5879", "rite_aid_store.latitude": 32.84920175971596023600795888341963291168212890625, "rite_aid_store.address_locality": "Clanton", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35045, "rite_aid_store.longitude": -86.632703840732574462890625, "rite_aid_store.city_x_rite_aid_store_id": { "9": { "city_x_rite_aid_store.id": 9, "city.id": 9, "city.ts": "2018-01-11 03:25:14", "city.title": "Clanton", "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": { "48": { "rite_aid_store_x_service_offered.id": 48, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "49": { "rite_aid_store_x_service_offered.id": 49, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "50": { "rite_aid_store_x_service_offered.id": 50, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "51": { "rite_aid_store_x_service_offered.id": 51, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "52": { "rite_aid_store_x_service_offered.id": 52, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "47": { "rite_aid_store_x_service_offered.id": 47, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "53": { "rite_aid_store_x_service_offered.id": 53, "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": { "73": { "rite_aid_store_x_immunization.id": 73, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "74": { "rite_aid_store_x_immunization.id": 74, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "75": { "rite_aid_store_x_immunization.id": 75, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "76": { "rite_aid_store_x_immunization.id": 76, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "77": { "rite_aid_store_x_immunization.id": 77, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "78": { "rite_aid_store_x_immunization.id": 78, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "79": { "rite_aid_store_x_immunization.id": 79, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "80": { "rite_aid_store_x_immunization.id": 80, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "81": { "rite_aid_store_x_immunization.id": 81, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "82": { "rite_aid_store_x_immunization.id": 82, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "83": { "rite_aid_store_x_immunization.id": 83, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "84": { "rite_aid_store_x_immunization.id": 84, "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": { "43": { "rite_aid_store_x_store_hour.id": 43, "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" }, "44": { "rite_aid_store_x_store_hour.id": 44, "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" }, "45": { "rite_aid_store_x_store_hour.id": 45, "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" }, "46": { "rite_aid_store_x_store_hour.id": 46, "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" }, "47": { "rite_aid_store_x_store_hour.id": 47, "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" }, "48": { "rite_aid_store_x_store_hour.id": 48, "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" }, "49": { "rite_aid_store_x_store_hour.id": 49, "store_hour.id": 49, "store_hour.ts": "2018-01-11 03:41:53", "store_hour.key": "Sunday", "store_hour.value": "7:00 AM - 9:00 PM" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "43": { "rite_aid_store_x_pharmacy_hour.id": 43, "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" }, "44": { "rite_aid_store_x_pharmacy_hour.id": 44, "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" }, "45": { "rite_aid_store_x_pharmacy_hour.id": 45, "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" }, "46": { "rite_aid_store_x_pharmacy_hour.id": 46, "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" }, "47": { "rite_aid_store_x_pharmacy_hour.id": 47, "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" }, "48": { "rite_aid_store_x_pharmacy_hour.id": 48, "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" }, "49": { "rite_aid_store_x_pharmacy_hour.id": 49, "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" } } }, "11": { "rite_aid_store.id": 11, "rite_aid_store.ts": "2018-01-11 03:42:05", "rite_aid_store.title": "Rite Aid #07136 Dadeville", "rite_aid_store.address_street": "459 North Broadnax Street", "rite_aid_store.telephone": "(256) 825-4242", "rite_aid_store.latitude": 32.83518099999999861893229535780847072601318359375, "rite_aid_store.address_locality": "Dadeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36853, "rite_aid_store.longitude": -85.7640779999999978144842316396534442901611328125, "rite_aid_store.city_x_rite_aid_store_id": { "11": { "city_x_rite_aid_store.id": 11, "city.id": 11, "city.ts": "2018-01-11 03:25:14", "city.title": "Dadeville", "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": { "54": { "rite_aid_store_x_service_offered.id": 54, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "55": { "rite_aid_store_x_service_offered.id": 55, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "56": { "rite_aid_store_x_service_offered.id": 56, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "57": { "rite_aid_store_x_service_offered.id": 57, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "58": { "rite_aid_store_x_service_offered.id": 58, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "59": { "rite_aid_store_x_service_offered.id": 59, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "60": { "rite_aid_store_x_service_offered.id": 60, "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": { "85": { "rite_aid_store_x_immunization.id": 85, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "86": { "rite_aid_store_x_immunization.id": 86, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "87": { "rite_aid_store_x_immunization.id": 87, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "88": { "rite_aid_store_x_immunization.id": 88, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "89": { "rite_aid_store_x_immunization.id": 89, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "90": { "rite_aid_store_x_immunization.id": 90, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "91": { "rite_aid_store_x_immunization.id": 91, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "92": { "rite_aid_store_x_immunization.id": 92, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "93": { "rite_aid_store_x_immunization.id": 93, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "94": { "rite_aid_store_x_immunization.id": 94, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "95": { "rite_aid_store_x_immunization.id": 95, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "96": { "rite_aid_store_x_immunization.id": 96, "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": { "50": { "rite_aid_store_x_store_hour.id": 50, "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" }, "51": { "rite_aid_store_x_store_hour.id": 51, "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" }, "52": { "rite_aid_store_x_store_hour.id": 52, "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" }, "53": { "rite_aid_store_x_store_hour.id": 53, "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" }, "54": { "rite_aid_store_x_store_hour.id": 54, "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" }, "55": { "rite_aid_store_x_store_hour.id": 55, "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" }, "56": { "rite_aid_store_x_store_hour.id": 56, "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": { "50": { "rite_aid_store_x_pharmacy_hour.id": 50, "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" }, "51": { "rite_aid_store_x_pharmacy_hour.id": 51, "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" }, "52": { "rite_aid_store_x_pharmacy_hour.id": 52, "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" }, "53": { "rite_aid_store_x_pharmacy_hour.id": 53, "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" }, "54": { "rite_aid_store_x_pharmacy_hour.id": 54, "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" }, "55": { "rite_aid_store_x_pharmacy_hour.id": 55, "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" }, "56": { "rite_aid_store_x_pharmacy_hour.id": 56, "pharmacy_hour.id": 56, "pharmacy_hour.ts": "2018-01-11 03:42:05", "pharmacy_hour.key": "Sunday", "pharmacy_hour.value": "12:30 PM - 6:00 PM" } } }, "14": { "rite_aid_store.id": 14, "rite_aid_store.ts": "2018-01-11 03:42:30", "rite_aid_store.title": "Rite Aid #07093 Enterprise", "rite_aid_store.address_street": "903 Rucker Boulevard", "rite_aid_store.telephone": "(334) 393-4440", "rite_aid_store.latitude": 31.32376824799622028194789891131222248077392578125, "rite_aid_store.address_locality": "Enterprise", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36330, "rite_aid_store.longitude": -85.8303987979888916015625, "rite_aid_store.city_x_rite_aid_store_id": { "14": { "city_x_rite_aid_store.id": 14, "city.id": 14, "city.ts": "2018-01-11 03:25:14", "city.title": "Enterprise", "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": { "62": { "rite_aid_store_x_service_offered.id": 62, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "63": { "rite_aid_store_x_service_offered.id": 63, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "65": { "rite_aid_store_x_service_offered.id": 65, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "66": { "rite_aid_store_x_service_offered.id": 66, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "67": { "rite_aid_store_x_service_offered.id": 67, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "61": { "rite_aid_store_x_service_offered.id": 61, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "69": { "rite_aid_store_x_service_offered.id": 69, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "70": { "rite_aid_store_x_service_offered.id": 70, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "68": { "rite_aid_store_x_service_offered.id": 68, "service_offered.id": 29, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "GNC" }, "64": { "rite_aid_store_x_service_offered.id": 64, "service_offered.id": 64, "service_offered.ts": "2018-01-11 03:42:30", "service_offered.value": "24Hr Store (Pharmacy Not 24Hr)" } }, "rite_aid_store.rite_aid_store_x_immunization_id": { "97": { "rite_aid_store_x_immunization.id": 97, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "98": { "rite_aid_store_x_immunization.id": 98, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "99": { "rite_aid_store_x_immunization.id": 99, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "100": { "rite_aid_store_x_immunization.id": 100, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "101": { "rite_aid_store_x_immunization.id": 101, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "102": { "rite_aid_store_x_immunization.id": 102, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "103": { "rite_aid_store_x_immunization.id": 103, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "104": { "rite_aid_store_x_immunization.id": 104, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "105": { "rite_aid_store_x_immunization.id": 105, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "106": { "rite_aid_store_x_immunization.id": 106, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "107": { "rite_aid_store_x_immunization.id": 107, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "108": { "rite_aid_store_x_immunization.id": 108, "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": { "57": { "rite_aid_store_x_store_hour.id": 57, "store_hour.id": 57, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Monday", "store_hour.value": "" }, "58": { "rite_aid_store_x_store_hour.id": 58, "store_hour.id": 58, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Tuesday", "store_hour.value": "" }, "59": { "rite_aid_store_x_store_hour.id": 59, "store_hour.id": 59, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Wednesday", "store_hour.value": "" }, "60": { "rite_aid_store_x_store_hour.id": 60, "store_hour.id": 60, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Thursday", "store_hour.value": "" }, "61": { "rite_aid_store_x_store_hour.id": 61, "store_hour.id": 61, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Friday", "store_hour.value": "" }, "62": { "rite_aid_store_x_store_hour.id": 62, "store_hour.id": 62, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Saturday", "store_hour.value": "" }, "63": { "rite_aid_store_x_store_hour.id": 63, "store_hour.id": 63, "store_hour.ts": "2018-01-11 03:42:30", "store_hour.key": "Sunday", "store_hour.value": "" } }, "rite_aid_store.rite_aid_store_x_pharmacy_hour_id": { "57": { "rite_aid_store_x_pharmacy_hour.id": 57, "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" }, "58": { "rite_aid_store_x_pharmacy_hour.id": 58, "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" }, "59": { "rite_aid_store_x_pharmacy_hour.id": 59, "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" }, "60": { "rite_aid_store_x_pharmacy_hour.id": 60, "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" }, "61": { "rite_aid_store_x_pharmacy_hour.id": 61, "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" }, "63": { "rite_aid_store_x_pharmacy_hour.id": 63, "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" }, "62": { "rite_aid_store_x_pharmacy_hour.id": 62, "pharmacy_hour.id": 62, "pharmacy_hour.ts": "2018-01-11 03:42:30", "pharmacy_hour.key": "Saturday", "pharmacy_hour.value": "8:00 AM - 8:00 PM" } } }, "15": { "rite_aid_store.id": 15, "rite_aid_store.ts": "2018-01-11 03:42:34", "rite_aid_store.title": "Rite Aid #04606 Eufaula", "rite_aid_store.address_street": "130 South Eufaula Avenue", "rite_aid_store.telephone": "(334) 687-7144", "rite_aid_store.latitude": 31.8918919999999985748218023218214511871337890625, "rite_aid_store.address_locality": "Eufaula", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36027, "rite_aid_store.longitude": -85.146375000000006139089236967265605926513671875, "rite_aid_store.city_x_rite_aid_store_id": { "15": { "city_x_rite_aid_store.id": 15, "city.id": 15, "city.ts": "2018-01-11 03:25:14", "city.title": "Eufaula", "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": { "72": { "rite_aid_store_x_service_offered.id": 72, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "73": { "rite_aid_store_x_service_offered.id": 73, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "74": { "rite_aid_store_x_service_offered.id": 74, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "75": { "rite_aid_store_x_service_offered.id": 75, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "76": { "rite_aid_store_x_service_offered.id": 76, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "71": { "rite_aid_store_x_service_offered.id": 71, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "78": { "rite_aid_store_x_service_offered.id": 78, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "79": { "rite_aid_store_x_service_offered.id": 79, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "77": { "rite_aid_store_x_service_offered.id": 77, "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": { "109": { "rite_aid_store_x_immunization.id": 109, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "110": { "rite_aid_store_x_immunization.id": 110, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "111": { "rite_aid_store_x_immunization.id": 111, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "112": { "rite_aid_store_x_immunization.id": 112, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "113": { "rite_aid_store_x_immunization.id": 113, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "114": { "rite_aid_store_x_immunization.id": 114, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "115": { "rite_aid_store_x_immunization.id": 115, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "116": { "rite_aid_store_x_immunization.id": 116, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "117": { "rite_aid_store_x_immunization.id": 117, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "118": { "rite_aid_store_x_immunization.id": 118, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "119": { "rite_aid_store_x_immunization.id": 119, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "120": { "rite_aid_store_x_immunization.id": 120, "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": { "64": { "rite_aid_store_x_store_hour.id": 64, "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" }, "65": { "rite_aid_store_x_store_hour.id": 65, "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" }, "66": { "rite_aid_store_x_store_hour.id": 66, "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" }, "67": { "rite_aid_store_x_store_hour.id": 67, "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" }, "68": { "rite_aid_store_x_store_hour.id": 68, "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" }, "69": { "rite_aid_store_x_store_hour.id": 69, "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" }, "70": { "rite_aid_store_x_store_hour.id": 70, "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": { "64": { "rite_aid_store_x_pharmacy_hour.id": 64, "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" }, "65": { "rite_aid_store_x_pharmacy_hour.id": 65, "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" }, "66": { "rite_aid_store_x_pharmacy_hour.id": 66, "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" }, "67": { "rite_aid_store_x_pharmacy_hour.id": 67, "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" }, "68": { "rite_aid_store_x_pharmacy_hour.id": 68, "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" }, "69": { "rite_aid_store_x_pharmacy_hour.id": 69, "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" }, "70": { "rite_aid_store_x_pharmacy_hour.id": 70, "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" } } }, "16": { "rite_aid_store.id": 16, "rite_aid_store.ts": "2018-01-11 03:42:38", "rite_aid_store.title": "Rite Aid #07104 Fairhope", "rite_aid_store.address_street": "101 South Greeno Road", "rite_aid_store.telephone": "(251) 990-7172", "rite_aid_store.latitude": 30.519501999999999242163539747707545757293701171875, "rite_aid_store.address_locality": "Fairhope", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36532, "rite_aid_store.longitude": -87.8855219999999945912350085563957691192626953125, "rite_aid_store.city_x_rite_aid_store_id": { "16": { "city_x_rite_aid_store.id": 16, "city.id": 16, "city.ts": "2018-01-11 03:25:14", "city.title": "Fairhope", "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": { "81": { "rite_aid_store_x_service_offered.id": 81, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "82": { "rite_aid_store_x_service_offered.id": 82, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "83": { "rite_aid_store_x_service_offered.id": 83, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "84": { "rite_aid_store_x_service_offered.id": 84, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "80": { "rite_aid_store_x_service_offered.id": 80, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "86": { "rite_aid_store_x_service_offered.id": 86, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "85": { "rite_aid_store_x_service_offered.id": 85, "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": { "121": { "rite_aid_store_x_immunization.id": 121, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "122": { "rite_aid_store_x_immunization.id": 122, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "123": { "rite_aid_store_x_immunization.id": 123, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "124": { "rite_aid_store_x_immunization.id": 124, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "125": { "rite_aid_store_x_immunization.id": 125, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "126": { "rite_aid_store_x_immunization.id": 126, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "127": { "rite_aid_store_x_immunization.id": 127, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "128": { "rite_aid_store_x_immunization.id": 128, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "129": { "rite_aid_store_x_immunization.id": 129, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "130": { "rite_aid_store_x_immunization.id": 130, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "131": { "rite_aid_store_x_immunization.id": 131, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "132": { "rite_aid_store_x_immunization.id": 132, "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": { "71": { "rite_aid_store_x_store_hour.id": 71, "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" }, "72": { "rite_aid_store_x_store_hour.id": 72, "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" }, "73": { "rite_aid_store_x_store_hour.id": 73, "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" }, "74": { "rite_aid_store_x_store_hour.id": 74, "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" }, "75": { "rite_aid_store_x_store_hour.id": 75, "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" }, "76": { "rite_aid_store_x_store_hour.id": 76, "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" }, "77": { "rite_aid_store_x_store_hour.id": 77, "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": { "71": { "rite_aid_store_x_pharmacy_hour.id": 71, "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" }, "72": { "rite_aid_store_x_pharmacy_hour.id": 72, "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" }, "73": { "rite_aid_store_x_pharmacy_hour.id": 73, "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" }, "74": { "rite_aid_store_x_pharmacy_hour.id": 74, "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" }, "75": { "rite_aid_store_x_pharmacy_hour.id": 75, "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" }, "76": { "rite_aid_store_x_pharmacy_hour.id": 76, "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" }, "77": { "rite_aid_store_x_pharmacy_hour.id": 77, "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" } } }, "18": { "rite_aid_store.id": 18, "rite_aid_store.ts": "2018-01-11 03:42:49", "rite_aid_store.title": "Rite Aid #07179 Foley", "rite_aid_store.address_street": "1255 South McKenzie Street", "rite_aid_store.telephone": "(251) 971-1017", "rite_aid_store.latitude": 30.392722500000001417674866388551890850067138671875, "rite_aid_store.address_locality": "Foley", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36535, "rite_aid_store.longitude": -87.6825304999999985966496751643717288970947265625, "rite_aid_store.city_x_rite_aid_store_id": { "18": { "city_x_rite_aid_store.id": 18, "city.id": 18, "city.ts": "2018-01-11 03:25:14", "city.title": "Foley", "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": { "88": { "rite_aid_store_x_service_offered.id": 88, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "89": { "rite_aid_store_x_service_offered.id": 89, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "90": { "rite_aid_store_x_service_offered.id": 90, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "91": { "rite_aid_store_x_service_offered.id": 91, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "92": { "rite_aid_store_x_service_offered.id": 92, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "87": { "rite_aid_store_x_service_offered.id": 87, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "94": { "rite_aid_store_x_service_offered.id": 94, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "93": { "rite_aid_store_x_service_offered.id": 93, "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": { "133": { "rite_aid_store_x_immunization.id": 133, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "134": { "rite_aid_store_x_immunization.id": 134, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "135": { "rite_aid_store_x_immunization.id": 135, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "136": { "rite_aid_store_x_immunization.id": 136, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "137": { "rite_aid_store_x_immunization.id": 137, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "138": { "rite_aid_store_x_immunization.id": 138, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "139": { "rite_aid_store_x_immunization.id": 139, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "140": { "rite_aid_store_x_immunization.id": 140, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "141": { "rite_aid_store_x_immunization.id": 141, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "142": { "rite_aid_store_x_immunization.id": 142, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "143": { "rite_aid_store_x_immunization.id": 143, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "144": { "rite_aid_store_x_immunization.id": 144, "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": { "78": { "rite_aid_store_x_store_hour.id": 78, "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" }, "79": { "rite_aid_store_x_store_hour.id": 79, "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" }, "80": { "rite_aid_store_x_store_hour.id": 80, "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" }, "81": { "rite_aid_store_x_store_hour.id": 81, "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" }, "82": { "rite_aid_store_x_store_hour.id": 82, "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" }, "83": { "rite_aid_store_x_store_hour.id": 83, "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" }, "84": { "rite_aid_store_x_store_hour.id": 84, "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": { "78": { "rite_aid_store_x_pharmacy_hour.id": 78, "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" }, "79": { "rite_aid_store_x_pharmacy_hour.id": 79, "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" }, "80": { "rite_aid_store_x_pharmacy_hour.id": 80, "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" }, "81": { "rite_aid_store_x_pharmacy_hour.id": 81, "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" }, "82": { "rite_aid_store_x_pharmacy_hour.id": 82, "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" }, "83": { "rite_aid_store_x_pharmacy_hour.id": 83, "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" }, "84": { "rite_aid_store_x_pharmacy_hour.id": 84, "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" } } }, "19": { "rite_aid_store.id": 19, "rite_aid_store.ts": "2018-01-11 03:42:53", "rite_aid_store.title": "Rite Aid #07060 Fort Payne", "rite_aid_store.address_street": "1303 Gault Avenue North", "rite_aid_store.telephone": "(256) 845-6338", "rite_aid_store.latitude": 34.45294392199293298517659422941505908966064453125, "rite_aid_store.address_locality": "Fort Payne", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35967, "rite_aid_store.longitude": -85.7114803791046142578125, "rite_aid_store.city_x_rite_aid_store_id": { "19": { "city_x_rite_aid_store.id": 19, "city.id": 19, "city.ts": "2018-01-11 03:25:14", "city.title": "Fort Payne", "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": { "96": { "rite_aid_store_x_service_offered.id": 96, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "97": { "rite_aid_store_x_service_offered.id": 97, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "98": { "rite_aid_store_x_service_offered.id": 98, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "99": { "rite_aid_store_x_service_offered.id": 99, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "100": { "rite_aid_store_x_service_offered.id": 100, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "95": { "rite_aid_store_x_service_offered.id": 95, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "101": { "rite_aid_store_x_service_offered.id": 101, "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": { "145": { "rite_aid_store_x_immunization.id": 145, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "146": { "rite_aid_store_x_immunization.id": 146, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "147": { "rite_aid_store_x_immunization.id": 147, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "148": { "rite_aid_store_x_immunization.id": 148, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "149": { "rite_aid_store_x_immunization.id": 149, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "150": { "rite_aid_store_x_immunization.id": 150, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "151": { "rite_aid_store_x_immunization.id": 151, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "152": { "rite_aid_store_x_immunization.id": 152, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "153": { "rite_aid_store_x_immunization.id": 153, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "154": { "rite_aid_store_x_immunization.id": 154, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "155": { "rite_aid_store_x_immunization.id": 155, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "156": { "rite_aid_store_x_immunization.id": 156, "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": { "85": { "rite_aid_store_x_store_hour.id": 85, "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" }, "86": { "rite_aid_store_x_store_hour.id": 86, "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" }, "87": { "rite_aid_store_x_store_hour.id": 87, "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" }, "88": { "rite_aid_store_x_store_hour.id": 88, "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" }, "89": { "rite_aid_store_x_store_hour.id": 89, "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" }, "90": { "rite_aid_store_x_store_hour.id": 90, "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" }, "91": { "rite_aid_store_x_store_hour.id": 91, "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": { "85": { "rite_aid_store_x_pharmacy_hour.id": 85, "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" }, "86": { "rite_aid_store_x_pharmacy_hour.id": 86, "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" }, "87": { "rite_aid_store_x_pharmacy_hour.id": 87, "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" }, "88": { "rite_aid_store_x_pharmacy_hour.id": 88, "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" }, "89": { "rite_aid_store_x_pharmacy_hour.id": 89, "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" }, "90": { "rite_aid_store_x_pharmacy_hour.id": 90, "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" }, "91": { "rite_aid_store_x_pharmacy_hour.id": 91, "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" } } }, "20": { "rite_aid_store.id": 20, "rite_aid_store.ts": "2018-01-11 03:43:01", "rite_aid_store.title": "Rite Aid #07014 Fultondale", "rite_aid_store.address_street": "1713 US Hwy 31 N", "rite_aid_store.telephone": "(205) 841-3815", "rite_aid_store.latitude": 33.6116260000000011132215149700641632080078125, "rite_aid_store.address_locality": "Fultondale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35068, "rite_aid_store.longitude": -86.7962409999999948695403872989118099212646484375, "rite_aid_store.city_x_rite_aid_store_id": { "20": { "city_x_rite_aid_store.id": 20, "city.id": 20, "city.ts": "2018-01-11 03:25:14", "city.title": "Fultondale", "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": { "103": { "rite_aid_store_x_service_offered.id": 103, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "104": { "rite_aid_store_x_service_offered.id": 104, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "105": { "rite_aid_store_x_service_offered.id": 105, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "106": { "rite_aid_store_x_service_offered.id": 106, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "107": { "rite_aid_store_x_service_offered.id": 107, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "102": { "rite_aid_store_x_service_offered.id": 102, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "108": { "rite_aid_store_x_service_offered.id": 108, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "109": { "rite_aid_store_x_service_offered.id": 109, "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": { "157": { "rite_aid_store_x_immunization.id": 157, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "158": { "rite_aid_store_x_immunization.id": 158, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "159": { "rite_aid_store_x_immunization.id": 159, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "160": { "rite_aid_store_x_immunization.id": 160, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "161": { "rite_aid_store_x_immunization.id": 161, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "162": { "rite_aid_store_x_immunization.id": 162, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "163": { "rite_aid_store_x_immunization.id": 163, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "164": { "rite_aid_store_x_immunization.id": 164, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "165": { "rite_aid_store_x_immunization.id": 165, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "166": { "rite_aid_store_x_immunization.id": 166, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "167": { "rite_aid_store_x_immunization.id": 167, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "168": { "rite_aid_store_x_immunization.id": 168, "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": { "92": { "rite_aid_store_x_store_hour.id": 92, "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" }, "93": { "rite_aid_store_x_store_hour.id": 93, "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" }, "94": { "rite_aid_store_x_store_hour.id": 94, "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" }, "95": { "rite_aid_store_x_store_hour.id": 95, "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" }, "96": { "rite_aid_store_x_store_hour.id": 96, "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" }, "97": { "rite_aid_store_x_store_hour.id": 97, "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" }, "98": { "rite_aid_store_x_store_hour.id": 98, "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": { "97": { "rite_aid_store_x_pharmacy_hour.id": 97, "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" }, "98": { "rite_aid_store_x_pharmacy_hour.id": 98, "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" }, "92": { "rite_aid_store_x_pharmacy_hour.id": 92, "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" }, "93": { "rite_aid_store_x_pharmacy_hour.id": 93, "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" }, "94": { "rite_aid_store_x_pharmacy_hour.id": 94, "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" }, "95": { "rite_aid_store_x_pharmacy_hour.id": 95, "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" }, "96": { "rite_aid_store_x_pharmacy_hour.id": 96, "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" } } }, "21": { "rite_aid_store.id": 21, "rite_aid_store.ts": "2018-01-11 03:43:06", "rite_aid_store.title": "Rite Aid #07367 Gardendale", "rite_aid_store.address_street": "1018 Main St", "rite_aid_store.telephone": "(205) 631-8707", "rite_aid_store.latitude": 33.65344499999999783312887302599847316741943359375, "rite_aid_store.address_locality": "Gardendale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35071, "rite_aid_store.longitude": -86.8126290000000011559677659533917903900146484375, "rite_aid_store.city_x_rite_aid_store_id": { "21": { "city_x_rite_aid_store.id": 21, "city.id": 21, "city.ts": "2018-01-11 03:25:14", "city.title": "Gardendale", "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": { "110": { "rite_aid_store_x_service_offered.id": 110, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "111": { "rite_aid_store_x_service_offered.id": 111, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "112": { "rite_aid_store_x_service_offered.id": 112, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "113": { "rite_aid_store_x_service_offered.id": 113, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "114": { "rite_aid_store_x_service_offered.id": 114, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "116": { "rite_aid_store_x_service_offered.id": 116, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "117": { "rite_aid_store_x_service_offered.id": 117, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "115": { "rite_aid_store_x_service_offered.id": 115, "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": { "169": { "rite_aid_store_x_immunization.id": 169, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "170": { "rite_aid_store_x_immunization.id": 170, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "171": { "rite_aid_store_x_immunization.id": 171, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "172": { "rite_aid_store_x_immunization.id": 172, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "173": { "rite_aid_store_x_immunization.id": 173, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "174": { "rite_aid_store_x_immunization.id": 174, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "175": { "rite_aid_store_x_immunization.id": 175, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "176": { "rite_aid_store_x_immunization.id": 176, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "177": { "rite_aid_store_x_immunization.id": 177, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "178": { "rite_aid_store_x_immunization.id": 178, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "179": { "rite_aid_store_x_immunization.id": 179, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "180": { "rite_aid_store_x_immunization.id": 180, "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": { "99": { "rite_aid_store_x_store_hour.id": 99, "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" }, "100": { "rite_aid_store_x_store_hour.id": 100, "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" }, "101": { "rite_aid_store_x_store_hour.id": 101, "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" }, "102": { "rite_aid_store_x_store_hour.id": 102, "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" }, "103": { "rite_aid_store_x_store_hour.id": 103, "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" }, "104": { "rite_aid_store_x_store_hour.id": 104, "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" }, "105": { "rite_aid_store_x_store_hour.id": 105, "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": { "104": { "rite_aid_store_x_pharmacy_hour.id": 104, "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" }, "105": { "rite_aid_store_x_pharmacy_hour.id": 105, "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" }, "99": { "rite_aid_store_x_pharmacy_hour.id": 99, "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" }, "100": { "rite_aid_store_x_pharmacy_hour.id": 100, "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" }, "101": { "rite_aid_store_x_pharmacy_hour.id": 101, "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" }, "102": { "rite_aid_store_x_pharmacy_hour.id": 102, "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" }, "103": { "rite_aid_store_x_pharmacy_hour.id": 103, "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" } } }, "22": { "rite_aid_store.id": 22, "rite_aid_store.ts": "2018-01-11 03:44:20", "rite_aid_store.title": "Rite Aid #07180 Gulf Shores", "rite_aid_store.address_street": "1527 Highway 59 South", "rite_aid_store.telephone": "(251) 968-6119", "rite_aid_store.latitude": 30.265539000000000413592715631239116191864013671875, "rite_aid_store.address_locality": "Gulf Shores", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36542, "rite_aid_store.longitude": -87.690236999999996214683051221072673797607421875, "rite_aid_store.city_x_rite_aid_store_id": { "22": { "city_x_rite_aid_store.id": 22, "city.id": 22, "city.ts": "2018-01-11 03:25:14", "city.title": "Gulf Shores", "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": { "118": { "rite_aid_store_x_service_offered.id": 118, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "119": { "rite_aid_store_x_service_offered.id": 119, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "120": { "rite_aid_store_x_service_offered.id": 120, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "121": { "rite_aid_store_x_service_offered.id": 121, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "122": { "rite_aid_store_x_service_offered.id": 122, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "124": { "rite_aid_store_x_service_offered.id": 124, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "125": { "rite_aid_store_x_service_offered.id": 125, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "123": { "rite_aid_store_x_service_offered.id": 123, "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": { "181": { "rite_aid_store_x_immunization.id": 181, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "182": { "rite_aid_store_x_immunization.id": 182, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "183": { "rite_aid_store_x_immunization.id": 183, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "184": { "rite_aid_store_x_immunization.id": 184, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "185": { "rite_aid_store_x_immunization.id": 185, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "186": { "rite_aid_store_x_immunization.id": 186, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "187": { "rite_aid_store_x_immunization.id": 187, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "188": { "rite_aid_store_x_immunization.id": 188, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "189": { "rite_aid_store_x_immunization.id": 189, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "190": { "rite_aid_store_x_immunization.id": 190, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "191": { "rite_aid_store_x_immunization.id": 191, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "192": { "rite_aid_store_x_immunization.id": 192, "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": { "106": { "rite_aid_store_x_store_hour.id": 106, "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" }, "107": { "rite_aid_store_x_store_hour.id": 107, "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" }, "108": { "rite_aid_store_x_store_hour.id": 108, "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" }, "109": { "rite_aid_store_x_store_hour.id": 109, "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" }, "110": { "rite_aid_store_x_store_hour.id": 110, "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" }, "111": { "rite_aid_store_x_store_hour.id": 111, "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" }, "112": { "rite_aid_store_x_store_hour.id": 112, "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": { "106": { "rite_aid_store_x_pharmacy_hour.id": 106, "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" }, "107": { "rite_aid_store_x_pharmacy_hour.id": 107, "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" }, "108": { "rite_aid_store_x_pharmacy_hour.id": 108, "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" }, "109": { "rite_aid_store_x_pharmacy_hour.id": 109, "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" }, "110": { "rite_aid_store_x_pharmacy_hour.id": 110, "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" }, "111": { "rite_aid_store_x_pharmacy_hour.id": 111, "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" }, "112": { "rite_aid_store_x_pharmacy_hour.id": 112, "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" } } }, "23": { "rite_aid_store.id": 23, "rite_aid_store.ts": "2018-01-11 03:44:26", "rite_aid_store.title": "Rite Aid #07049 Hartselle", "rite_aid_store.address_street": "241 Highway 31 SW", "rite_aid_store.telephone": "(256) 773-6561", "rite_aid_store.latitude": 34.44071900000000141517375595867633819580078125, "rite_aid_store.address_locality": "Hartselle", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35640, "rite_aid_store.longitude": -86.9433800000000047702997107990086078643798828125, "rite_aid_store.city_x_rite_aid_store_id": { "23": { "city_x_rite_aid_store.id": 23, "city.id": 23, "city.ts": "2018-01-11 03:25:14", "city.title": "Hartselle", "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": { "126": { "rite_aid_store_x_service_offered.id": 126, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "127": { "rite_aid_store_x_service_offered.id": 127, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "128": { "rite_aid_store_x_service_offered.id": 128, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "129": { "rite_aid_store_x_service_offered.id": 129, "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": { "193": { "rite_aid_store_x_immunization.id": 193, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "194": { "rite_aid_store_x_immunization.id": 194, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "195": { "rite_aid_store_x_immunization.id": 195, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "196": { "rite_aid_store_x_immunization.id": 196, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "197": { "rite_aid_store_x_immunization.id": 197, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "198": { "rite_aid_store_x_immunization.id": 198, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "199": { "rite_aid_store_x_immunization.id": 199, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "200": { "rite_aid_store_x_immunization.id": 200, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "201": { "rite_aid_store_x_immunization.id": 201, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "202": { "rite_aid_store_x_immunization.id": 202, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "203": { "rite_aid_store_x_immunization.id": 203, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "204": { "rite_aid_store_x_immunization.id": 204, "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": { "113": { "rite_aid_store_x_store_hour.id": 113, "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" }, "114": { "rite_aid_store_x_store_hour.id": 114, "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" }, "115": { "rite_aid_store_x_store_hour.id": 115, "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" }, "116": { "rite_aid_store_x_store_hour.id": 116, "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" }, "117": { "rite_aid_store_x_store_hour.id": 117, "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" }, "118": { "rite_aid_store_x_store_hour.id": 118, "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" }, "119": { "rite_aid_store_x_store_hour.id": 119, "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": { "113": { "rite_aid_store_x_pharmacy_hour.id": 113, "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" }, "114": { "rite_aid_store_x_pharmacy_hour.id": 114, "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" }, "115": { "rite_aid_store_x_pharmacy_hour.id": 115, "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" }, "116": { "rite_aid_store_x_pharmacy_hour.id": 116, "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" }, "117": { "rite_aid_store_x_pharmacy_hour.id": 117, "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" }, "118": { "rite_aid_store_x_pharmacy_hour.id": 118, "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" }, "119": { "rite_aid_store_x_pharmacy_hour.id": 119, "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" } } }, "24": { "rite_aid_store.id": 24, "rite_aid_store.ts": "2018-01-11 03:44:29", "rite_aid_store.title": "Rite Aid #01146 Hazel Green", "rite_aid_store.address_street": "14450 Highway 231/431 North", "rite_aid_store.telephone": "(256) 828-5133", "rite_aid_store.latitude": 34.9401950000000027785063139162957668304443359375, "rite_aid_store.address_locality": "Hazel Green", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35750, "rite_aid_store.longitude": -86.57071600000000444197212345898151397705078125, "rite_aid_store.city_x_rite_aid_store_id": { "24": { "city_x_rite_aid_store.id": 24, "city.id": 24, "city.ts": "2018-01-11 03:25:14", "city.title": "Hazel Green", "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": { "131": { "rite_aid_store_x_service_offered.id": 131, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "132": { "rite_aid_store_x_service_offered.id": 132, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "133": { "rite_aid_store_x_service_offered.id": 133, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "134": { "rite_aid_store_x_service_offered.id": 134, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "135": { "rite_aid_store_x_service_offered.id": 135, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "130": { "rite_aid_store_x_service_offered.id": 130, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "136": { "rite_aid_store_x_service_offered.id": 136, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "137": { "rite_aid_store_x_service_offered.id": 137, "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": { "205": { "rite_aid_store_x_immunization.id": 205, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "206": { "rite_aid_store_x_immunization.id": 206, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "207": { "rite_aid_store_x_immunization.id": 207, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "208": { "rite_aid_store_x_immunization.id": 208, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "209": { "rite_aid_store_x_immunization.id": 209, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "210": { "rite_aid_store_x_immunization.id": 210, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "211": { "rite_aid_store_x_immunization.id": 211, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "212": { "rite_aid_store_x_immunization.id": 212, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "213": { "rite_aid_store_x_immunization.id": 213, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "214": { "rite_aid_store_x_immunization.id": 214, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "215": { "rite_aid_store_x_immunization.id": 215, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "216": { "rite_aid_store_x_immunization.id": 216, "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": { "120": { "rite_aid_store_x_store_hour.id": 120, "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" }, "121": { "rite_aid_store_x_store_hour.id": 121, "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" }, "122": { "rite_aid_store_x_store_hour.id": 122, "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" }, "123": { "rite_aid_store_x_store_hour.id": 123, "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" }, "124": { "rite_aid_store_x_store_hour.id": 124, "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" }, "125": { "rite_aid_store_x_store_hour.id": 125, "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" }, "126": { "rite_aid_store_x_store_hour.id": 126, "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": { "120": { "rite_aid_store_x_pharmacy_hour.id": 120, "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" }, "121": { "rite_aid_store_x_pharmacy_hour.id": 121, "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" }, "122": { "rite_aid_store_x_pharmacy_hour.id": 122, "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" }, "123": { "rite_aid_store_x_pharmacy_hour.id": 123, "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" }, "124": { "rite_aid_store_x_pharmacy_hour.id": 124, "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" }, "125": { "rite_aid_store_x_pharmacy_hour.id": 125, "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" }, "126": { "rite_aid_store_x_pharmacy_hour.id": 126, "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" } } }, "25": { "rite_aid_store.id": 25, "rite_aid_store.ts": "2018-01-11 03:44:31", "rite_aid_store.title": "Rite Aid #07370 Hoover", "rite_aid_store.address_street": "1615 Montgomery Highway", "rite_aid_store.telephone": "(205) 823-6091", "rite_aid_store.latitude": 33.3977459999999979345375322736799716949462890625, "rite_aid_store.address_locality": "Hoover", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35216, "rite_aid_store.longitude": -86.804767999999995709003997035324573516845703125, "rite_aid_store.city_x_rite_aid_store_id": { "25": { "city_x_rite_aid_store.id": 25, "city.id": 25, "city.ts": "2018-01-11 03:25:14", "city.title": "Hoover", "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": { "139": { "rite_aid_store_x_service_offered.id": 139, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "140": { "rite_aid_store_x_service_offered.id": 140, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "141": { "rite_aid_store_x_service_offered.id": 141, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "142": { "rite_aid_store_x_service_offered.id": 142, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "143": { "rite_aid_store_x_service_offered.id": 143, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "145": { "rite_aid_store_x_service_offered.id": 145, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "146": { "rite_aid_store_x_service_offered.id": 146, "service_offered.id": 13, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Food Mart" }, "138": { "rite_aid_store_x_service_offered.id": 138, "service_offered.id": 23, "service_offered.ts": "2018-01-11 03:41:29", "service_offered.value": "Prescription Home Delivery" }, "144": { "rite_aid_store_x_service_offered.id": 144, "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": { "217": { "rite_aid_store_x_immunization.id": 217, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "218": { "rite_aid_store_x_immunization.id": 218, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "219": { "rite_aid_store_x_immunization.id": 219, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "220": { "rite_aid_store_x_immunization.id": 220, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "221": { "rite_aid_store_x_immunization.id": 221, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "222": { "rite_aid_store_x_immunization.id": 222, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "223": { "rite_aid_store_x_immunization.id": 223, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "224": { "rite_aid_store_x_immunization.id": 224, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "225": { "rite_aid_store_x_immunization.id": 225, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "226": { "rite_aid_store_x_immunization.id": 226, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "227": { "rite_aid_store_x_immunization.id": 227, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "228": { "rite_aid_store_x_immunization.id": 228, "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": { "127": { "rite_aid_store_x_store_hour.id": 127, "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" }, "128": { "rite_aid_store_x_store_hour.id": 128, "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" }, "129": { "rite_aid_store_x_store_hour.id": 129, "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" }, "130": { "rite_aid_store_x_store_hour.id": 130, "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" }, "131": { "rite_aid_store_x_store_hour.id": 131, "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" }, "132": { "rite_aid_store_x_store_hour.id": 132, "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" }, "133": { "rite_aid_store_x_store_hour.id": 133, "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": { "127": { "rite_aid_store_x_pharmacy_hour.id": 127, "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" }, "128": { "rite_aid_store_x_pharmacy_hour.id": 128, "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" }, "129": { "rite_aid_store_x_pharmacy_hour.id": 129, "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" }, "130": { "rite_aid_store_x_pharmacy_hour.id": 130, "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" }, "131": { "rite_aid_store_x_pharmacy_hour.id": 131, "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" }, "132": { "rite_aid_store_x_pharmacy_hour.id": 132, "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" }, "133": { "rite_aid_store_x_pharmacy_hour.id": 133, "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" } } }, "26": { "rite_aid_store.id": 26, "rite_aid_store.ts": "2018-01-11 03:44:35", "rite_aid_store.title": "Rite Aid #07003 Hueytown", "rite_aid_store.address_street": "220 Forest Road", "rite_aid_store.telephone": "(205) 491-1894", "rite_aid_store.latitude": 33.450029999999998153725755400955677032470703125, "rite_aid_store.address_locality": "Hueytown", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35023, "rite_aid_store.longitude": -86.9858540000000033387550502084195613861083984375, "rite_aid_store.city_x_rite_aid_store_id": { "26": { "city_x_rite_aid_store.id": 26, "city.id": 26, "city.ts": "2018-01-11 03:25:14", "city.title": "Hueytown", "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": { "148": { "rite_aid_store_x_service_offered.id": 148, "service_offered.id": 1, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Western Union" }, "149": { "rite_aid_store_x_service_offered.id": 149, "service_offered.id": 2, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "ATM" }, "150": { "rite_aid_store_x_service_offered.id": 150, "service_offered.id": 3, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Receutics Active Skin Repair" }, "151": { "rite_aid_store_x_service_offered.id": 151, "service_offered.id": 4, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "higi Blood Pressure Station" }, "152": { "rite_aid_store_x_service_offered.id": 152, "service_offered.id": 5, "service_offered.ts": "2018-01-11 03:41:14", "service_offered.value": "Blue Rhino Propane" }, "147": { "rite_aid_store_x_service_offered.id": 147, "service_offered.id": 6, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Drive-Thru Pharmacy" }, "153": { "rite_aid_store_x_service_offered.id": 153, "service_offered.id": 12, "service_offered.ts": "2018-01-11 03:41:17", "service_offered.value": "Beer" }, "154": { "rite_aid_store_x_service_offered.id": 154, "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": { "229": { "rite_aid_store_x_immunization.id": 229, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "230": { "rite_aid_store_x_immunization.id": 230, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "231": { "rite_aid_store_x_immunization.id": 231, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "232": { "rite_aid_store_x_immunization.id": 232, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "233": { "rite_aid_store_x_immunization.id": 233, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "234": { "rite_aid_store_x_immunization.id": 234, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "235": { "rite_aid_store_x_immunization.id": 235, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "236": { "rite_aid_store_x_immunization.id": 236, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "237": { "rite_aid_store_x_immunization.id": 237, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "238": { "rite_aid_store_x_immunization.id": 238, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "239": { "rite_aid_store_x_immunization.id": 239, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "240": { "rite_aid_store_x_immunization.id": 240, "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": { "134": { "rite_aid_store_x_store_hour.id": 134, "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" }, "135": { "rite_aid_store_x_store_hour.id": 135, "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" }, "136": { "rite_aid_store_x_store_hour.id": 136, "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" }, "137": { "rite_aid_store_x_store_hour.id": 137, "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" }, "138": { "rite_aid_store_x_store_hour.id": 138, "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" }, "139": { "rite_aid_store_x_store_hour.id": 139, "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" }, "140": { "rite_aid_store_x_store_hour.id": 140, "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": { "134": { "rite_aid_store_x_pharmacy_hour.id": 134, "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" }, "135": { "rite_aid_store_x_pharmacy_hour.id": 135, "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" }, "136": { "rite_aid_store_x_pharmacy_hour.id": 136, "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" }, "137": { "rite_aid_store_x_pharmacy_hour.id": 137, "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" }, "138": { "rite_aid_store_x_pharmacy_hour.id": 138, "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" }, "139": { "rite_aid_store_x_pharmacy_hour.id": 139, "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" }, "140": { "rite_aid_store_x_pharmacy_hour.id": 140, "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" } } } } } }