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": "Pharmacies in UK", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/pharmacies_in_uk/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/pharmacies_in_uk/main/list/?app=html-json" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/pharmacies_in_uk/main/list/4/?app=html-json" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/pharmacies_in_uk/main/list/6/?app=html-json" } }, "meta": { "query": { "page": 5, "limit": 20, "limit_total": 100, "time": 0.10420000000000000095479180117763462476432323455810546875 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 11299, "pages_total": 565 }, "struct": { "stem": { "0": "pharmacy" }, "leaf": "pharmacy.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "89": { "pharmacy.id": 89, "pharmacy.ts": "2018-01-11 22:24:05", "pharmacy.title": "Alneburgh Pharmacy Ltd", "pharmacy.phone": "01900 819111", "pharmacy.street_address": "Alneburgh House, Ewanrigg Road, Maryport", "pharmacy.address_locality": "Cumbria", "pharmacy.address_region": "Cumbria", "pharmacy.postal_code": "CA15 8EL", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "89": { "category_2_x_pharmacy.id": 89, "category_2.id": 11, "category_2.ts": "2018-01-14 21:33:05", "category_2.title": "Abbey Town", "category_2.latitude": 54.84400000000000119371179607696831226348876953125, "category_2.longitude": -3.286000000000000031974423109204508364200592041015625, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "2724": { "category_2_x_pharmacy.id": 2724, "category_2.id": 275, "category_2.ts": "2018-01-16 13:39:20", "category_2.title": "Allerby", "category_2.latitude": 54.74499999999999744204615126363933086395263671875, "category_2.longitude": -3.420999999999999818811602381174452602863311767578125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "2974": { "category_2_x_pharmacy.id": 2974, "category_2.id": 300, "category_2.ts": "2018-01-16 16:22:42", "category_2.title": "Allonby", "category_2.latitude": 54.7770000000000010231815394945442676544189453125, "category_2.longitude": -3.430000000000000159872115546022541821002960205078125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "4520": { "category_2_x_pharmacy.id": 4520, "category_2.id": 454, "category_2.ts": "2018-01-17 09:56:40", "category_2.title": "Baggrow", "category_2.latitude": 54.768000000000000682121026329696178436279296875, "category_2.longitude": -3.279999999999999804600747665972448885440826416015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "7679": { "category_2_x_pharmacy.id": 7679, "category_2.id": 770, "category_2.ts": "2018-01-19 02:18:08", "category_2.title": "Bassenthwaite", "category_2.latitude": 54.67999999999999971578290569595992565155029296875, "category_2.longitude": -3.19099999999999983657517077517695724964141845703125, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "8967": { "category_2_x_pharmacy.id": 8967, "category_2.id": 899, "category_2.ts": "2018-01-19 16:46:55", "category_2.title": "Calvo", "category_2.latitude": 54.8719999999999998863131622783839702606201171875, "category_2.longitude": -3.3330000000000001847411112976260483264923095703125, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "9184": { "category_2_x_pharmacy.id": 9184, "category_2.id": 921, "category_2.ts": "2018-01-19 20:00:50", "category_2.title": "Camerton, Cumbria", "category_2.latitude": 54.667000000000001591615728102624416351318359375, "category_2.longitude": -3.492999999999999882760448599583469331264495849609375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "13661": { "category_2_x_pharmacy.id": 13661, "category_2.id": 1369, "category_2.ts": "2018-01-22 04:49:32", "category_2.title": "Dearham", "category_2.latitude": 54.7109999999999985220711096189916133880615234375, "category_2.longitude": -3.444999999999999840127884453977458178997039794921875, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "16038": { "category_2_x_pharmacy.id": 16038, "category_2.id": 1607, "category_2.ts": "2018-01-23 11:57:09", "category_2.title": "Eaglesfield", "category_2.latitude": 54.63900000000000289901436190120875835418701171875, "category_2.longitude": -3.40200000000000013500311979441903531551361083984375, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "23831": { "category_2_x_pharmacy.id": 23831, "category_2.id": 2388, "category_2.ts": "2018-01-27 19:00:57", "category_2.title": "Flimby", "category_2.latitude": 54.68599999999999994315658113919198513031005859375, "category_2.longitude": -3.512000000000000010658141036401502788066864013671875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "25636": { "category_2_x_pharmacy.id": 25636, "category_2.id": 2568, "category_2.ts": "2018-01-28 19:24:24", "category_2.title": "Gilcrux", "category_2.latitude": 54.72999999999999687361196265555918216705322265625, "category_2.longitude": -3.374000000000000110134124042815528810024261474609375, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "27245": { "category_2_x_pharmacy.id": 27245, "category_2.id": 2729, "category_2.ts": "2018-01-29 18:05:15", "category_2.title": "Goodyhills", "category_2.latitude": 54.808999999999997498889570124447345733642578125, "category_2.longitude": -3.388999999999999790389892950770445168018341064453125, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "39921": { "category_2_x_pharmacy.id": 39921, "category_2.id": 3999, "category_2.ts": "2018-02-05 12:54:24", "category_2.title": "Langrigg, Cumbria", "category_2.latitude": 54.79899999999999948840923025272786617279052734375, "category_2.longitude": -3.302000000000000046185277824406512081623077392578125, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "45282": { "category_2_x_pharmacy.id": 45282, "category_2.id": 4536, "category_2.ts": "2018-01-11 11:19:55", "category_2.title": "Maryport", "category_2.latitude": 54.715000000000003410605131648480892181396484375, "category_2.longitude": -3.49500000000000010658141036401502788066864013671875, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "45644": { "category_2_x_pharmacy.id": 45644, "category_2.id": 4572, "category_2.ts": "2018-01-11 11:27:02", "category_2.title": "Mawbray", "category_2.latitude": 54.80799999999999982946974341757595539093017578125, "category_2.longitude": -3.422000000000000152766688188421539962291717529296875, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "47549": { "category_2_x_pharmacy.id": 47549, "category_2.id": 4763, "category_2.ts": "2018-01-11 11:58:14", "category_2.title": "Netherton, Cumbria", "category_2.latitude": 54.70700000000000073896444519050419330596923828125, "category_2.longitude": -3.492999999999999882760448599583469331264495849609375, "category_1.id": 14, "category_1.ts": "2018-01-10 22:21:23", "category_1.title": "N" }, "53402": { "category_2_x_pharmacy.id": 53402, "category_2.id": 5348, "category_2.ts": "2018-01-11 13:28:05", "category_2.title": "Oughterside", "category_2.latitude": 54.75200000000000244426701101474463939666748046875, "category_2.longitude": -3.37000000000000010658141036401502788066864013671875, "category_1.id": 15, "category_1.ts": "2018-01-10 22:21:28", "category_1.title": "O" }, "54782": { "category_2_x_pharmacy.id": 54782, "category_2.id": 5486, "category_2.ts": "2018-01-11 13:47:25", "category_2.title": "Papcastle", "category_2.latitude": 54.6689999999999969304553815163671970367431640625, "category_2.longitude": -3.382000000000000117239551400416530668735504150390625, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "55374": { "category_2_x_pharmacy.id": 55374, "category_2.id": 5545, "category_2.ts": "2018-01-11 13:56:01", "category_2.title": "Parsonby", "category_2.latitude": 54.73700000000000187583282240666449069976806640625, "category_2.longitude": -3.3330000000000001847411112976260483264923095703125, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "56425": { "category_2_x_pharmacy.id": 56425, "category_2.id": 5650, "category_2.ts": "2018-01-11 14:08:58", "category_2.title": "Pelutho", "category_2.latitude": 54.8299999999999982946974341757595539093017578125, "category_2.longitude": -3.3719999999999998863131622783839702606201171875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "65218": { "category_2_x_pharmacy.id": 65218, "category_2.id": 6529, "category_2.ts": "2018-01-11 16:11:17", "category_2.title": "Schoose", "category_2.latitude": 54.63700000000000045474735088646411895751953125, "category_2.longitude": -3.528999999999999914734871708787977695465087890625, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "66027": { "category_2_x_pharmacy.id": 66027, "category_2.id": 6610, "category_2.ts": "2018-01-11 16:21:46", "category_2.title": "Seaton, Cumbria", "category_2.latitude": 54.66499999999999914734871708787977695465087890625, "category_2.longitude": -3.523000000000000131450406115618534386157989501953125, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "66186": { "category_2_x_pharmacy.id": 66186, "category_2.id": 6626, "category_2.ts": "2018-01-11 16:23:26", "category_2.title": "Seaville", "category_2.latitude": 54.868999999999999772626324556767940521240234375, "category_2.longitude": -3.310000000000000053290705182007513940334320068359375, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "66902": { "category_2_x_pharmacy.id": 66902, "category_2.id": 6698, "category_2.ts": "2018-01-11 16:32:18", "category_2.title": "Tallentire", "category_2.latitude": 54.70400000000000062527760746888816356658935546875, "category_2.longitude": -3.38600000000000012079226507921703159809112548828125, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "70437": { "category_2_x_pharmacy.id": 70437, "category_2.id": 7051, "category_2.ts": "2018-01-11 17:17:15", "category_2.title": "Thornthwaite, Cumbria", "category_2.latitude": 54.6159999999999996589394868351519107818603515625, "category_2.longitude": -3.197999999999999953814722175593487918376922607421875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "71008": { "category_2_x_pharmacy.id": 71008, "category_2.id": 7108, "category_2.ts": "2018-01-11 17:24:29", "category_2.title": "Uldale", "category_2.latitude": 54.72200000000000130739863379858434200286865234375, "category_2.longitude": -3.162999999999999811706175023573450744152069091796875, "category_1.id": 21, "category_1.ts": "2018-01-10 22:11:25", "category_1.title": "U" }, "80845": { "category_2_x_pharmacy.id": 80845, "category_2.id": 8494, "category_2.ts": "2018-01-11 19:47:08", "category_2.title": "Arkleby", "category_2.latitude": 54.74499999999999744204615126363933086395263671875, "category_2.longitude": -3.337000000000000188293824976426549255847930908203125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "82805": { "category_2_x_pharmacy.id": 82805, "category_2.id": 8691, "category_2.ts": "2018-01-11 20:14:18", "category_2.title": "Aspatria", "category_2.latitude": 54.76299999999999812416717759333550930023193359375, "category_2.longitude": -3.33499999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "85903": { "category_2_x_pharmacy.id": 85903, "category_2.id": 9801, "category_2.ts": "2018-01-11 20:57:54", "category_2.title": "Beckfoot, Cumbria", "category_2.latitude": 54.832999999999998408384271897375583648681640625, "category_2.longitude": -3.414000000000000145661260830820538103580474853515625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "88707": { "category_2_x_pharmacy.id": 88707, "category_2.id": 10082, "category_2.ts": "2018-01-11 21:35:46", "category_2.title": "Bewaldeth", "category_2.latitude": 54.70100000000000051159076974727213382720947265625, "category_2.longitude": -3.22299999999999986499688020558096468448638916015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "90541": { "category_2_x_pharmacy.id": 90541, "category_2.id": 10267, "category_2.ts": "2018-01-11 22:04:49", "category_2.title": "Birkby, Cumbria", "category_2.latitude": 54.7229999999999989768184605054557323455810546875, "category_2.longitude": -3.467000000000000081712414612411521375179290771484375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "92938": { "category_2_x_pharmacy.id": 92938, "category_2.id": 10506, "category_2.ts": "2018-01-11 22:41:29", "category_2.title": "Blennerhasset", "category_2.latitude": 54.76200000000000045474735088646411895751953125, "category_2.longitude": -3.279999999999999804600747665972448885440826416015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "93043": { "category_2_x_pharmacy.id": 93043, "category_2.id": 10517, "category_2.ts": "2018-01-11 22:42:33", "category_2.title": "Blindcrake", "category_2.latitude": 54.7000000000000028421709430404007434844970703125, "category_2.longitude": -3.3269999999999999573674358543939888477325439453125, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "93115": { "category_2_x_pharmacy.id": 93115, "category_2.id": 10524, "category_2.ts": "2018-01-11 22:43:18", "category_2.title": "Blitterlees", "category_2.latitude": 54.856999999999999317878973670303821563720703125, "category_2.longitude": -3.390000000000000124344978758017532527446746826171875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "95216": { "category_2_x_pharmacy.id": 95216, "category_2.id": 10735, "category_2.ts": "2018-01-11 23:10:06", "category_2.title": "Bothel", "category_2.latitude": 54.73899999999999721467247582040727138519287109375, "category_2.longitude": -3.27400000000000002131628207280300557613372802734375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "99552": { "category_2_x_pharmacy.id": 99552, "category_2.id": 11169, "category_2.ts": "2018-01-12 00:07:39", "category_2.title": "Bridekirk", "category_2.latitude": 54.68900000000000005684341886080801486968994140625, "category_2.longitude": -3.37000000000000010658141036401502788066864013671875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "99748": { "category_2_x_pharmacy.id": 99748, "category_2.id": 11188, "category_2.ts": "2018-01-12 00:10:41", "category_2.title": "Bridgefoot, Cumbria", "category_2.latitude": 54.64800000000000324007487506605684757232666015625, "category_2.longitude": -3.46600000000000019184653865522705018520355224609375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "100043": { "category_2_x_pharmacy.id": 100043, "category_2.id": 11218, "category_2.ts": "2018-01-12 00:17:08", "category_2.title": "Brigham, Cumbria", "category_2.latitude": 54.65899999999999891997504164464771747589111328125, "category_2.longitude": -3.4169999999999998152588887023739516735076904296875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "100645": { "category_2_x_pharmacy.id": 100645, "category_2.id": 12078, "category_2.ts": "2018-01-12 00:27:53", "category_2.title": "Causewayhead", "category_2.latitude": 54.86500000000000198951966012828052043914794921875, "category_2.longitude": -3.359999999999999875655021241982467472553253173828125, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "109430": { "category_2_x_pharmacy.id": 109430, "category_2.id": 12958, "category_2.ts": "2018-01-12 02:43:12", "category_2.title": "Cockermouth", "category_2.latitude": 54.65899999999999891997504164464771747589111328125, "category_2.longitude": -3.36699999999999999289457264239899814128875732421875, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "117000": { "category_2_x_pharmacy.id": 117000, "category_2.id": 14515, "category_2.ts": "2018-01-12 04:34:40", "category_2.title": "Dovenby", "category_2.latitude": 54.68500000000000227373675443232059478759765625, "category_2.longitude": -3.407999999999999918287585387588478624820709228515625, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "120241": { "category_2_x_pharmacy.id": 120241, "category_2.id": 15640, "category_2.ts": "2018-01-12 05:23:41", "category_2.title": "Edderside", "category_2.latitude": 54.79899999999999948840923025272786617279052734375, "category_2.longitude": -3.395000000000000017763568394002504646778106689453125, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "121537": { "category_2_x_pharmacy.id": 121537, "category_2.id": 15770, "category_2.ts": "2018-01-12 05:48:40", "category_2.title": "Ellenborough", "category_2.latitude": 54.71000000000000085265128291212022304534912109375, "category_2.longitude": -3.4839999999999999857891452847979962825775146484375, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "122603": { "category_2_x_pharmacy.id": 122603, "category_2.id": 15876, "category_2.ts": "2018-01-12 06:04:28", "category_2.title": "Embleton, Cumbria", "category_2.latitude": 54.6640000000000014779288903810083866119384765625, "category_2.longitude": -3.29300000000000014921397450962103903293609619140625, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "129390": { "category_2_x_pharmacy.id": 129390, "category_2.id": 18156, "category_2.ts": "2018-01-12 07:54:52", "category_2.title": "Great Broughton, Cumbria", "category_2.latitude": 54.66799999999999926103555480949580669403076171875, "category_2.longitude": -3.44200000000000017053025658242404460906982421875, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "129604": { "category_2_x_pharmacy.id": 129604, "category_2.id": 18177, "category_2.ts": "2018-01-12 08:00:29", "category_2.title": "Great Clifton", "category_2.latitude": 54.65100000000000335376171278767287731170654296875, "category_2.longitude": -3.491000000000000103028696685214526951313018798828125, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "131830": { "category_2_x_pharmacy.id": 131830, "category_2.id": 18401, "category_2.ts": "2018-01-12 08:46:02", "category_2.title": "Greengill", "category_2.latitude": 54.72200000000000130739863379858434200286865234375, "category_2.longitude": -3.39299999999999979394260662957094609737396240234375, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "134185": { "category_2_x_pharmacy.id": 134185, "category_2.id": 19036, "category_2.ts": "2018-01-12 09:40:38", "category_2.title": "Harriston", "category_2.latitude": 54.76100000000000278532752417959272861480712890625, "category_2.longitude": -3.310000000000000053290705182007513940334320068359375, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "136769": { "category_2_x_pharmacy.id": 136769, "category_2.id": 19296, "category_2.ts": "2018-01-12 10:40:35", "category_2.title": "Hayton, Cumbria", "category_2.latitude": 54.76100000000000278532752417959272861480712890625, "category_2.longitude": -3.391999999999999904076730672386474907398223876953125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "141115": { "category_2_x_pharmacy.id": 141115, "category_2.id": 19730, "category_2.ts": "2018-01-12 12:33:31", "category_2.title": "High Ireby", "category_2.latitude": 54.72399999999999664623828721232712268829345703125, "category_2.longitude": -3.194999999999999840127884453977458178997039794921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "141253": { "category_2_x_pharmacy.id": 141253, "category_2.id": 19744, "category_2.ts": "2018-01-12 12:38:16", "category_2.title": "High Lorton", "category_2.latitude": 54.61800000000000210320649784989655017852783203125, "category_2.longitude": -3.3010000000000001563194018672220408916473388671875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "142431": { "category_2_x_pharmacy.id": 142431, "category_2.id": 19864, "category_2.ts": "2018-01-12 13:05:27", "category_2.title": "Highlaws", "category_2.latitude": 54.83400000000000318323145620524883270263671875, "category_2.longitude": -3.338999999999999968025576890795491635799407958984375, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "145619": { "category_2_x_pharmacy.id": 145619, "category_2.id": 20184, "category_2.ts": "2018-01-12 13:56:29", "category_2.title": "Holme St. Cuthbert", "category_2.latitude": 54.8130000000000023874235921539366245269775390625, "category_2.longitude": -3.395000000000000017763568394002504646778106689453125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "154359": { "category_2_x_pharmacy.id": 154359, "category_2.id": 22659, "category_2.ts": "2018-01-12 16:31:03", "category_2.title": "Little Broughton", "category_2.latitude": 54.67399999999999948840923025272786617279052734375, "category_2.longitude": -3.43299999999999982946974341757595539093017578125, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "154754": { "category_2_x_pharmacy.id": 154754, "category_2.id": 22698, "category_2.ts": "2018-01-12 16:35:53", "category_2.title": "Little Crosthwaite", "category_2.latitude": 54.63900000000000289901436190120875835418701171875, "category_2.longitude": -3.186999999999999833022457096376456320285797119140625, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "160055": { "category_2_x_pharmacy.id": 160055, "category_2.id": 23228, "category_2.ts": "2018-01-12 17:53:34", "category_2.title": "Low Lorton", "category_2.latitude": 54.618999999999999772626324556767940521240234375, "category_2.longitude": -3.319999999999999840127884453977458178997039794921875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "167315": { "category_2_x_pharmacy.id": 167315, "category_2.id": 24754, "category_2.ts": "2018-01-12 20:19:59", "category_2.title": "Millbeck", "category_2.latitude": 54.625, "category_2.longitude": -3.153000000000000024868995751603506505489349365234375, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180651": { "category_2_x_pharmacy.id": 180651, "category_2.id": 28491, "category_2.ts": "2018-01-13 00:22:23", "category_2.title": "Plumbland", "category_2.latitude": 54.74000000000000198951966012828052043914794921875, "category_2.longitude": -3.322999999999999953814722175593487918376922607421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "192922": { "category_2_x_pharmacy.id": 192922, "category_2.id": 31319, "category_2.ts": "2018-01-13 03:45:39", "category_2.title": "Silloth", "category_2.latitude": 54.868999999999999772626324556767940521240234375, "category_2.longitude": -3.387000000000000010658141036401502788066864013671875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "193782": { "category_2_x_pharmacy.id": 193782, "category_2.id": 31405, "category_2.ts": "2018-01-13 04:02:20", "category_2.title": "Skinburness", "category_2.latitude": 54.89099999999999823785401531495153903961181640625, "category_2.longitude": -3.3620000000000000994759830064140260219573974609375, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "195265": { "category_2_x_pharmacy.id": 195265, "category_2.id": 31553, "category_2.ts": "2018-01-13 04:29:20", "category_2.title": "Snittlegarth", "category_2.latitude": 54.72800000000000153477230924181640148162841796875, "category_2.longitude": -3.217999999999999971578290569595992565155029296875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "197923": { "category_2_x_pharmacy.id": 197923, "category_2.id": 31819, "category_2.ts": "2018-01-13 05:04:24", "category_2.title": "Southerfield", "category_2.latitude": 54.8250000000000028421709430404007434844970703125, "category_2.longitude": -3.2980000000000000426325641456060111522674560546875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "201005": { "category_2_x_pharmacy.id": 201005, "category_2.id": 32128, "category_2.ts": "2018-01-13 05:44:33", "category_2.title": "Stainburn, Cumbria", "category_2.latitude": 54.64699999999999846522769075818359851837158203125, "category_2.longitude": -3.523000000000000131450406115618534386157989501953125, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "205031": { "category_2_x_pharmacy.id": 205031, "category_2.id": 33332, "category_2.ts": "2018-01-13 06:56:49", "category_2.title": "Threapland, Cumbria", "category_2.latitude": 54.74199999999999732835931354202330112457275390625, "category_2.longitude": -3.314999999999999946709294817992486059665679931640625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "208104": { "category_2_x_pharmacy.id": 208104, "category_2.id": 33640, "category_2.ts": "2018-01-13 08:06:12", "category_2.title": "Torpenhow", "category_2.latitude": 54.7469999999999998863131622783839702606201171875, "category_2.longitude": -3.2400000000000002131628207280300557613372802734375, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "208726": { "category_2_x_pharmacy.id": 208726, "category_2.id": 33703, "category_2.ts": "2018-01-13 08:21:01", "category_2.title": "Townhead, Cumbria", "category_2.latitude": 54.7109999999999985220711096189916133880615234375, "category_2.longitude": -3.44099999999999983657517077517695724964141845703125, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "217890": { "category_2_x_pharmacy.id": 217890, "category_2.id": 35422, "category_2.ts": "2018-01-13 12:14:22", "category_2.title": "Westnewton, Cumbria", "category_2.latitude": 54.78399999999999891997504164464771747589111328125, "category_2.longitude": -3.349000000000000198951966012828052043914794921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "221075": { "category_2_x_pharmacy.id": 221075, "category_2.id": 35741, "category_2.ts": "2018-01-13 13:09:59", "category_2.title": "Whitrigg, Cumbria", "category_2.latitude": 54.73899999999999721467247582040727138519287109375, "category_2.longitude": -3.234999999999999875655021241982467472553253173828125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225972": { "category_2_x_pharmacy.id": 225972, "category_2.id": 36231, "category_2.ts": "2018-01-13 14:18:38", "category_2.title": "Wolsty", "category_2.latitude": 54.844999999999998863131622783839702606201171875, "category_2.longitude": -3.398000000000000131450406115618534386157989501953125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "227796": { "category_2_x_pharmacy.id": 227796, "category_2.id": 36414, "category_2.ts": "2018-01-13 14:46:12", "category_2.title": "Woodside, Cumbria", "category_2.latitude": 54.691000000000002501110429875552654266357421875, "category_2.longitude": -3.484999999999999875655021241982467472553253173828125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "567": { "pharmacy_x_hour.id": 567, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "561": { "pharmacy_x_hour.id": 561, "hour.id": 43, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Monday", "hour.value": "09:00 - 18:00" }, "562": { "pharmacy_x_hour.id": 562, "hour.id": 44, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Tuesday", "hour.value": "09:00 - 18:00" }, "563": { "pharmacy_x_hour.id": 563, "hour.id": 45, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Wednesday", "hour.value": "09:00 - 18:00" }, "564": { "pharmacy_x_hour.id": 564, "hour.id": 46, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Thursday", "hour.value": "09:00 - 18:00" }, "565": { "pharmacy_x_hour.id": 565, "hour.id": 47, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Friday", "hour.value": "09:00 - 18:00" }, "566": { "pharmacy_x_hour.id": 566, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" } }, "pharmacy.pharmacy_x_review_id": {} }, "90": { "pharmacy.id": 90, "pharmacy.ts": "2018-01-11 22:24:17", "pharmacy.title": "J W W Allison and Sons Ltd", "pharmacy.phone": "01900 822292", "pharmacy.street_address": "31 Main Street", "pharmacy.address_locality": "Cockermouth", "pharmacy.address_region": "Cumbria", "pharmacy.postal_code": "CA13 9LE", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "90": { "category_2_x_pharmacy.id": 90, "category_2.id": 11, "category_2.ts": "2018-01-14 21:33:05", "category_2.title": "Abbey Town", "category_2.latitude": 54.84400000000000119371179607696831226348876953125, "category_2.longitude": -3.286000000000000031974423109204508364200592041015625, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "2727": { "category_2_x_pharmacy.id": 2727, "category_2.id": 275, "category_2.ts": "2018-01-16 13:39:20", "category_2.title": "Allerby", "category_2.latitude": 54.74499999999999744204615126363933086395263671875, "category_2.longitude": -3.420999999999999818811602381174452602863311767578125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "2978": { "category_2_x_pharmacy.id": 2978, "category_2.id": 300, "category_2.ts": "2018-01-16 16:22:42", "category_2.title": "Allonby", "category_2.latitude": 54.7770000000000010231815394945442676544189453125, "category_2.longitude": -3.430000000000000159872115546022541821002960205078125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "4515": { "category_2_x_pharmacy.id": 4515, "category_2.id": 454, "category_2.ts": "2018-01-17 09:56:40", "category_2.title": "Baggrow", "category_2.latitude": 54.768000000000000682121026329696178436279296875, "category_2.longitude": -3.279999999999999804600747665972448885440826416015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "7674": { "category_2_x_pharmacy.id": 7674, "category_2.id": 770, "category_2.ts": "2018-01-19 02:18:08", "category_2.title": "Bassenthwaite", "category_2.latitude": 54.67999999999999971578290569595992565155029296875, "category_2.longitude": -3.19099999999999983657517077517695724964141845703125, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "11175": { "category_2_x_pharmacy.id": 11175, "category_2.id": 1120, "category_2.ts": "2018-01-20 17:28:32", "category_2.title": "Castlerigg", "category_2.latitude": 54.58899999999999863575794734060764312744140625, "category_2.longitude": -3.1089999999999999857891452847979962825775146484375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "13442": { "category_2_x_pharmacy.id": 13442, "category_2.id": 1347, "category_2.ts": "2018-01-22 02:14:07", "category_2.title": "Dean, Cumbria", "category_2.latitude": 54.61399999999999721467247582040727138519287109375, "category_2.longitude": -3.43299999999999982946974341757595539093017578125, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "13632": { "category_2_x_pharmacy.id": 13632, "category_2.id": 1366, "category_2.ts": "2018-01-22 04:25:14", "category_2.title": "Deanscales", "category_2.latitude": 54.62400000000000233058017329312860965728759765625, "category_2.longitude": -3.407000000000000028421709430404007434844970703125, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "13666": { "category_2_x_pharmacy.id": 13666, "category_2.id": 1369, "category_2.ts": "2018-01-22 04:49:32", "category_2.title": "Dearham", "category_2.latitude": 54.7109999999999985220711096189916133880615234375, "category_2.longitude": -3.444999999999999840127884453977458178997039794921875, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "16032": { "category_2_x_pharmacy.id": 16032, "category_2.id": 1607, "category_2.ts": "2018-01-23 11:57:09", "category_2.title": "Eaglesfield", "category_2.latitude": 54.63900000000000289901436190120875835418701171875, "category_2.longitude": -3.40200000000000013500311979441903531551361083984375, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "23796": { "category_2_x_pharmacy.id": 23796, "category_2.id": 2384, "category_2.ts": "2018-01-27 18:34:06", "category_2.title": "Fletchertown", "category_2.latitude": 54.77499999999999857891452847979962825775146484375, "category_2.longitude": -3.2339999999999999857891452847979962825775146484375, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "24925": { "category_2_x_pharmacy.id": 24925, "category_2.id": 2497, "category_2.ts": "2018-01-28 09:48:29", "category_2.title": "Gatesgarth", "category_2.latitude": 54.5240000000000009094947017729282379150390625, "category_2.longitude": -3.245999999999999996447286321199499070644378662109375, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "25634": { "category_2_x_pharmacy.id": 25634, "category_2.id": 2568, "category_2.ts": "2018-01-28 19:24:24", "category_2.title": "Gilcrux", "category_2.latitude": 54.72999999999999687361196265555918216705322265625, "category_2.longitude": -3.374000000000000110134124042815528810024261474609375, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "27250": { "category_2_x_pharmacy.id": 27250, "category_2.id": 2729, "category_2.ts": "2018-01-29 18:05:15", "category_2.title": "Goodyhills", "category_2.latitude": 54.808999999999997498889570124447345733642578125, "category_2.longitude": -3.388999999999999790389892950770445168018341064453125, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "33305": { "category_2_x_pharmacy.id": 33305, "category_2.id": 3337, "category_2.ts": "2018-02-02 00:28:27", "category_2.title": "Ireby, Cumbria", "category_2.latitude": 54.74199999999999732835931354202330112457275390625, "category_2.longitude": -3.185000000000000053290705182007513940334320068359375, "category_1.id": 9, "category_1.ts": "2018-01-10 22:11:25", "category_1.title": "I" }, "35706": { "category_2_x_pharmacy.id": 35706, "category_2.id": 3578, "category_2.ts": "2018-02-03 05:43:04", "category_2.title": "Keswick, Cumbria", "category_2.latitude": 54.59899999999999664623828721232712268829345703125, "category_2.longitude": -3.125999999999999889865875957184471189975738525390625, "category_1.id": 11, "category_1.ts": "2018-01-10 22:16:38", "category_1.title": "K" }, "38705": { "category_2_x_pharmacy.id": 38705, "category_2.id": 3878, "category_2.ts": "2018-02-04 20:33:18", "category_2.title": "Lamplugh", "category_2.latitude": 54.5739999999999980673237587325274944305419921875, "category_2.longitude": -3.411000000000000031974423109204508364200592041015625, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "39917": { "category_2_x_pharmacy.id": 39917, "category_2.id": 3999, "category_2.ts": "2018-02-05 12:54:24", "category_2.title": "Langrigg, Cumbria", "category_2.latitude": 54.79899999999999948840923025272786617279052734375, "category_2.longitude": -3.302000000000000046185277824406512081623077392578125, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "45647": { "category_2_x_pharmacy.id": 45647, "category_2.id": 4572, "category_2.ts": "2018-01-11 11:27:02", "category_2.title": "Mawbray", "category_2.latitude": 54.80799999999999982946974341757595539093017578125, "category_2.longitude": -3.422000000000000152766688188421539962291717529296875, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "46074": { "category_2_x_pharmacy.id": 46074, "category_2.id": 4615, "category_2.ts": "2018-01-11 11:34:02", "category_2.title": "Mealsgate", "category_2.latitude": 54.76599999999999823785401531495153903961181640625, "category_2.longitude": -3.2309999999999998721023075631819665431976318359375, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "53405": { "category_2_x_pharmacy.id": 53405, "category_2.id": 5348, "category_2.ts": "2018-01-11 13:28:05", "category_2.title": "Oughterside", "category_2.latitude": 54.75200000000000244426701101474463939666748046875, "category_2.longitude": -3.37000000000000010658141036401502788066864013671875, "category_1.id": 15, "category_1.ts": "2018-01-10 22:21:28", "category_1.title": "O" }, "54780": { "category_2_x_pharmacy.id": 54780, "category_2.id": 5486, "category_2.ts": "2018-01-11 13:47:25", "category_2.title": "Papcastle", "category_2.latitude": 54.6689999999999969304553815163671970367431640625, "category_2.longitude": -3.382000000000000117239551400416530668735504150390625, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "54860": { "category_2_x_pharmacy.id": 54860, "category_2.id": 5494, "category_2.ts": "2018-01-11 13:48:29", "category_2.title": "Pardshaw", "category_2.latitude": 54.61299999999999954525264911353588104248046875, "category_2.longitude": -3.39599999999999990762944435118697583675384521484375, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "55371": { "category_2_x_pharmacy.id": 55371, "category_2.id": 5545, "category_2.ts": "2018-01-11 13:56:01", "category_2.title": "Parsonby", "category_2.latitude": 54.73700000000000187583282240666449069976806640625, "category_2.longitude": -3.3330000000000001847411112976260483264923095703125, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "56428": { "category_2_x_pharmacy.id": 56428, "category_2.id": 5650, "category_2.ts": "2018-01-11 14:08:58", "category_2.title": "Pelutho", "category_2.latitude": 54.8299999999999982946974341757595539093017578125, "category_2.longitude": -3.3719999999999998863131622783839702606201171875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "65986": { "category_2_x_pharmacy.id": 65986, "category_2.id": 6606, "category_2.ts": "2018-01-11 16:21:14", "category_2.title": "Seathwaite, Cumbria", "category_2.latitude": 54.49900000000000233058017329312860965728759765625, "category_2.longitude": -3.18100000000000004973799150320701301097869873046875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "66015": { "category_2_x_pharmacy.id": 66015, "category_2.id": 6609, "category_2.ts": "2018-01-11 16:21:38", "category_2.title": "Seatoller", "category_2.latitude": 54.5150000000000005684341886080801486968994140625, "category_2.longitude": -3.16500000000000003552713678800500929355621337890625, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "66901": { "category_2_x_pharmacy.id": 66901, "category_2.id": 6698, "category_2.ts": "2018-01-11 16:32:18", "category_2.title": "Tallentire", "category_2.latitude": 54.70400000000000062527760746888816356658935546875, "category_2.longitude": -3.38600000000000012079226507921703159809112548828125, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "70432": { "category_2_x_pharmacy.id": 70432, "category_2.id": 7051, "category_2.ts": "2018-01-11 17:17:15", "category_2.title": "Thornthwaite, Cumbria", "category_2.latitude": 54.6159999999999996589394868351519107818603515625, "category_2.longitude": -3.197999999999999953814722175593487918376922607421875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "71005": { "category_2_x_pharmacy.id": 71005, "category_2.id": 7108, "category_2.ts": "2018-01-11 17:24:29", "category_2.title": "Uldale", "category_2.latitude": 54.72200000000000130739863379858434200286865234375, "category_2.longitude": -3.162999999999999811706175023573450744152069091796875, "category_1.id": 21, "category_1.ts": "2018-01-10 22:11:25", "category_1.title": "U" }, "71090": { "category_2_x_pharmacy.id": 71090, "category_2.id": 7117, "category_2.ts": "2018-01-11 17:26:01", "category_2.title": "Ullock", "category_2.latitude": 54.60300000000000153477230924181640148162841796875, "category_2.longitude": -3.4260000000000001563194018672220408916473388671875, "category_1.id": 21, "category_1.ts": "2018-01-10 22:11:25", "category_1.title": "U" }, "77855": { "category_2_x_pharmacy.id": 77855, "category_2.id": 7795, "category_2.ts": "2018-01-11 19:02:45", "category_2.title": "Watendlath", "category_2.latitude": 54.53600000000000136424205265939235687255859375, "category_2.longitude": -3.12300000000000022026824808563105762004852294921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "80422": { "category_2_x_pharmacy.id": 80422, "category_2.id": 8452, "category_2.ts": "2018-01-11 19:38:40", "category_2.title": "Applethwaite", "category_2.latitude": 54.618999999999999772626324556767940521240234375, "category_2.longitude": -3.140000000000000124344978758017532527446746826171875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "80842": { "category_2_x_pharmacy.id": 80842, "category_2.id": 8494, "category_2.ts": "2018-01-11 19:47:08", "category_2.title": "Arkleby", "category_2.latitude": 54.74499999999999744204615126363933086395263671875, "category_2.longitude": -3.337000000000000188293824976426549255847930908203125, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "82802": { "category_2_x_pharmacy.id": 82802, "category_2.id": 8691, "category_2.ts": "2018-01-11 20:14:18", "category_2.title": "Aspatria", "category_2.latitude": 54.76299999999999812416717759333550930023193359375, "category_2.longitude": -3.33499999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "85908": { "category_2_x_pharmacy.id": 85908, "category_2.id": 9801, "category_2.ts": "2018-01-11 20:57:54", "category_2.title": "Beckfoot, Cumbria", "category_2.latitude": 54.832999999999998408384271897375583648681640625, "category_2.longitude": -3.414000000000000145661260830820538103580474853515625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "88700": { "category_2_x_pharmacy.id": 88700, "category_2.id": 10082, "category_2.ts": "2018-01-11 21:35:46", "category_2.title": "Bewaldeth", "category_2.latitude": 54.70100000000000051159076974727213382720947265625, "category_2.longitude": -3.22299999999999986499688020558096468448638916015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "90547": { "category_2_x_pharmacy.id": 90547, "category_2.id": 10267, "category_2.ts": "2018-01-11 22:04:49", "category_2.title": "Birkby, Cumbria", "category_2.latitude": 54.7229999999999989768184605054557323455810546875, "category_2.longitude": -3.467000000000000081712414612411521375179290771484375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "92905": { "category_2_x_pharmacy.id": 92905, "category_2.id": 10503, "category_2.ts": "2018-01-11 22:41:08", "category_2.title": "Blencogo", "category_2.latitude": 54.8190000000000026147972675971686840057373046875, "category_2.longitude": -3.254000000000000003552713678800500929355621337890625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "92933": { "category_2_x_pharmacy.id": 92933, "category_2.id": 10506, "category_2.ts": "2018-01-11 22:41:29", "category_2.title": "Blennerhasset", "category_2.latitude": 54.76200000000000045474735088646411895751953125, "category_2.longitude": -3.279999999999999804600747665972448885440826416015625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "93040": { "category_2_x_pharmacy.id": 93040, "category_2.id": 10517, "category_2.ts": "2018-01-11 22:42:33", "category_2.title": "Blindcrake", "category_2.latitude": 54.7000000000000028421709430404007434844970703125, "category_2.longitude": -3.3269999999999999573674358543939888477325439453125, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "93118": { "category_2_x_pharmacy.id": 93118, "category_2.id": 10524, "category_2.ts": "2018-01-11 22:43:18", "category_2.title": "Blitterlees", "category_2.latitude": 54.856999999999999317878973670303821563720703125, "category_2.longitude": -3.390000000000000124344978758017532527446746826171875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "94236": { "category_2_x_pharmacy.id": 94236, "category_2.id": 10637, "category_2.ts": "2018-01-11 22:58:02", "category_2.title": "Bolton Low Houses", "category_2.latitude": 54.7879999999999967030817060731351375579833984375, "category_2.longitude": -3.18599999999999994315658113919198513031005859375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "94283": { "category_2_x_pharmacy.id": 94283, "category_2.id": 10642, "category_2.ts": "2018-01-11 22:58:33", "category_2.title": "Boltongate", "category_2.latitude": 54.756000000000000227373675443232059478759765625, "category_2.longitude": -3.1989999999999998436805981327779591083526611328125, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "94915": { "category_2_x_pharmacy.id": 94915, "category_2.id": 10705, "category_2.ts": "2018-01-11 23:06:07", "category_2.title": "Borrowdale", "category_2.latitude": 54.51599999999999823785401531495153903961181640625, "category_2.longitude": -3.153000000000000024868995751603506505489349365234375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "95211": { "category_2_x_pharmacy.id": 95211, "category_2.id": 10735, "category_2.ts": "2018-01-11 23:10:06", "category_2.title": "Bothel", "category_2.latitude": 54.73899999999999721467247582040727138519287109375, "category_2.longitude": -3.27400000000000002131628207280300557613372802734375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "97612": { "category_2_x_pharmacy.id": 97612, "category_2.id": 10975, "category_2.ts": "2018-01-11 23:43:40", "category_2.title": "Braithwaite, Cumbria", "category_2.latitude": 54.59899999999999664623828721232712268829345703125, "category_2.longitude": -3.18599999999999994315658113919198513031005859375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "98113": { "category_2_x_pharmacy.id": 98113, "category_2.id": 11025, "category_2.ts": "2018-01-11 23:49:57", "category_2.title": "Brandelhow", "category_2.latitude": 54.5750000000000028421709430404007434844970703125, "category_2.longitude": -3.16199999999999992184029906638897955417633056640625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "98486": { "category_2_x_pharmacy.id": 98486, "category_2.id": 11062, "category_2.ts": "2018-01-11 23:54:15", "category_2.title": "Branthwaite, Cumbria", "category_2.latitude": 54.72699999999999675992512493394315242767333984375, "category_2.longitude": -3.093999999999999861444166526780463755130767822265625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "99551": { "category_2_x_pharmacy.id": 99551, "category_2.id": 11169, "category_2.ts": "2018-01-12 00:07:39", "category_2.title": "Bridekirk", "category_2.latitude": 54.68900000000000005684341886080801486968994140625, "category_2.longitude": -3.37000000000000010658141036401502788066864013671875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "100040": { "category_2_x_pharmacy.id": 100040, "category_2.id": 11218, "category_2.ts": "2018-01-12 00:17:08", "category_2.title": "Brigham, Cumbria", "category_2.latitude": 54.65899999999999891997504164464771747589111328125, "category_2.longitude": -3.4169999999999998152588887023739516735076904296875, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "100648": { "category_2_x_pharmacy.id": 100648, "category_2.id": 12078, "category_2.ts": "2018-01-12 00:27:53", "category_2.title": "Causewayhead", "category_2.latitude": 54.86500000000000198951966012828052043914794921875, "category_2.longitude": -3.359999999999999875655021241982467472553253173828125, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "109428": { "category_2_x_pharmacy.id": 109428, "category_2.id": 12958, "category_2.ts": "2018-01-12 02:43:12", "category_2.title": "Cockermouth", "category_2.latitude": 54.65899999999999891997504164464771747589111328125, "category_2.longitude": -3.36699999999999999289457264239899814128875732421875, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "116998": { "category_2_x_pharmacy.id": 116998, "category_2.id": 14515, "category_2.ts": "2018-01-12 04:34:40", "category_2.title": "Dovenby", "category_2.latitude": 54.68500000000000227373675443232059478759765625, "category_2.longitude": -3.407999999999999918287585387588478624820709228515625, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "120244": { "category_2_x_pharmacy.id": 120244, "category_2.id": 15640, "category_2.ts": "2018-01-12 05:23:41", "category_2.title": "Edderside", "category_2.latitude": 54.79899999999999948840923025272786617279052734375, "category_2.longitude": -3.395000000000000017763568394002504646778106689453125, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "122598": { "category_2_x_pharmacy.id": 122598, "category_2.id": 15876, "category_2.ts": "2018-01-12 06:04:28", "category_2.title": "Embleton, Cumbria", "category_2.latitude": 54.6640000000000014779288903810083866119384765625, "category_2.longitude": -3.29300000000000014921397450962103903293609619140625, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "128562": { "category_2_x_pharmacy.id": 128562, "category_2.id": 18073, "category_2.ts": "2018-01-12 07:42:29", "category_2.title": "Grange, Cumbria", "category_2.latitude": 54.5450000000000017053025658242404460906982421875, "category_2.longitude": -3.157000000000000028421709430404007434844970703125, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "129387": { "category_2_x_pharmacy.id": 129387, "category_2.id": 18156, "category_2.ts": "2018-01-12 07:54:52", "category_2.title": "Great Broughton, Cumbria", "category_2.latitude": 54.66799999999999926103555480949580669403076171875, "category_2.longitude": -3.44200000000000017053025658242404460906982421875, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "129699": { "category_2_x_pharmacy.id": 129699, "category_2.id": 18188, "category_2.ts": "2018-01-12 08:03:58", "category_2.title": "Great Crosthwaite", "category_2.latitude": 54.6099999999999994315658113919198513031005859375, "category_2.longitude": -3.141999999999999904076730672386474907398223876953125, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "131831": { "category_2_x_pharmacy.id": 131831, "category_2.id": 18401, "category_2.ts": "2018-01-12 08:46:02", "category_2.title": "Greengill", "category_2.latitude": 54.72200000000000130739863379858434200286865234375, "category_2.longitude": -3.39299999999999979394260662957094609737396240234375, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "132397": { "category_2_x_pharmacy.id": 132397, "category_2.id": 18458, "category_2.ts": "2018-01-12 09:00:58", "category_2.title": "Greysouthen", "category_2.latitude": 54.64800000000000324007487506605684757232666015625, "category_2.longitude": -3.439999999999999946709294817992486059665679931640625, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "134178": { "category_2_x_pharmacy.id": 134178, "category_2.id": 19036, "category_2.ts": "2018-01-12 09:40:38", "category_2.title": "Harriston", "category_2.latitude": 54.76100000000000278532752417959272861480712890625, "category_2.longitude": -3.310000000000000053290705182007513940334320068359375, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "136772": { "category_2_x_pharmacy.id": 136772, "category_2.id": 19296, "category_2.ts": "2018-01-12 10:40:35", "category_2.title": "Hayton, Cumbria", "category_2.latitude": 54.76100000000000278532752417959272861480712890625, "category_2.longitude": -3.391999999999999904076730672386474907398223876953125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "141110": { "category_2_x_pharmacy.id": 141110, "category_2.id": 19730, "category_2.ts": "2018-01-12 12:33:31", "category_2.title": "High Ireby", "category_2.latitude": 54.72399999999999664623828721232712268829345703125, "category_2.longitude": -3.194999999999999840127884453977458178997039794921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "141246": { "category_2_x_pharmacy.id": 141246, "category_2.id": 19744, "category_2.ts": "2018-01-12 12:38:16", "category_2.title": "High Lorton", "category_2.latitude": 54.61800000000000210320649784989655017852783203125, "category_2.longitude": -3.3010000000000001563194018672220408916473388671875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "142434": { "category_2_x_pharmacy.id": 142434, "category_2.id": 19864, "category_2.ts": "2018-01-12 13:05:27", "category_2.title": "Highlaws", "category_2.latitude": 54.83400000000000318323145620524883270263671875, "category_2.longitude": -3.338999999999999968025576890795491635799407958984375, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "145624": { "category_2_x_pharmacy.id": 145624, "category_2.id": 20184, "category_2.ts": "2018-01-12 13:56:29", "category_2.title": "Holme St. Cuthbert", "category_2.latitude": 54.8130000000000023874235921539366245269775390625, "category_2.longitude": -3.395000000000000017763568394002504646778106689453125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "154357": { "category_2_x_pharmacy.id": 154357, "category_2.id": 22659, "category_2.ts": "2018-01-12 16:31:03", "category_2.title": "Little Broughton", "category_2.latitude": 54.67399999999999948840923025272786617279052734375, "category_2.longitude": -3.43299999999999982946974341757595539093017578125, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "154605": { "category_2_x_pharmacy.id": 154605, "category_2.id": 22683, "category_2.ts": "2018-01-12 16:34:19", "category_2.title": "Little Clifton", "category_2.latitude": 54.643000000000000682121026329696178436279296875, "category_2.longitude": -3.460999999999999854338739169179461896419525146484375, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "154749": { "category_2_x_pharmacy.id": 154749, "category_2.id": 22698, "category_2.ts": "2018-01-12 16:35:53", "category_2.title": "Little Crosthwaite", "category_2.latitude": 54.63900000000000289901436190120875835418701171875, "category_2.longitude": -3.186999999999999833022457096376456320285797119140625, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "156718": { "category_2_x_pharmacy.id": 156718, "category_2.id": 22895, "category_2.ts": "2018-01-12 17:03:15", "category_2.title": "Little Town, Cumbria", "category_2.latitude": 54.56400000000000005684341886080801486968994140625, "category_2.longitude": -3.189999999999999946709294817992486059665679931640625, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "160046": { "category_2_x_pharmacy.id": 160046, "category_2.id": 23228, "category_2.ts": "2018-01-12 17:53:34", "category_2.title": "Low Lorton", "category_2.latitude": 54.618999999999999772626324556767940521240234375, "category_2.longitude": -3.319999999999999840127884453977458178997039794921875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "162306": { "category_2_x_pharmacy.id": 162306, "category_2.id": 23454, "category_2.ts": "2018-01-12 18:33:12", "category_2.title": "Loweswater", "category_2.latitude": 54.57900000000000062527760746888816356658935546875, "category_2.longitude": -3.3300000000000000710542735760100185871124267578125, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "167309": { "category_2_x_pharmacy.id": 167309, "category_2.id": 24754, "category_2.ts": "2018-01-12 20:19:59", "category_2.title": "Millbeck", "category_2.latitude": 54.625, "category_2.longitude": -3.153000000000000024868995751603506505489349365234375, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "168587": { "category_2_x_pharmacy.id": 168587, "category_2.id": 24883, "category_2.ts": "2018-01-12 20:51:21", "category_2.title": "Mockerkin", "category_2.latitude": 54.5979999999999989768184605054557323455810546875, "category_2.longitude": -3.404999999999999804600747665972448885440826416015625, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180648": { "category_2_x_pharmacy.id": 180648, "category_2.id": 28491, "category_2.ts": "2018-01-13 00:22:23", "category_2.title": "Plumbland", "category_2.latitude": 54.74000000000000198951966012828052043914794921875, "category_2.longitude": -3.322999999999999953814722175593487918376922607421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "181939": { "category_2_x_pharmacy.id": 181939, "category_2.id": 28621, "category_2.ts": "2018-01-13 00:47:20", "category_2.title": "Portinscale", "category_2.latitude": 54.60000000000000142108547152020037174224853515625, "category_2.longitude": -3.15899999999999980815346134477294981479644775390625, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "185952": { "category_2_x_pharmacy.id": 185952, "category_2.id": 29822, "category_2.ts": "2018-01-13 01:53:35", "category_2.title": "Rosthwaite, Cumbria", "category_2.latitude": 54.5210000000000007958078640513122081756591796875, "category_2.longitude": -3.149999999999999911182158029987476766109466552734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "192925": { "category_2_x_pharmacy.id": 192925, "category_2.id": 31319, "category_2.ts": "2018-01-13 03:45:39", "category_2.title": "Silloth", "category_2.latitude": 54.868999999999999772626324556767940521240234375, "category_2.longitude": -3.387000000000000010658141036401502788066864013671875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "195260": { "category_2_x_pharmacy.id": 195260, "category_2.id": 31553, "category_2.ts": "2018-01-13 04:29:20", "category_2.title": "Snittlegarth", "category_2.latitude": 54.72800000000000153477230924181640148162841796875, "category_2.longitude": -3.217999999999999971578290569595992565155029296875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "197924": { "category_2_x_pharmacy.id": 197924, "category_2.id": 31819, "category_2.ts": "2018-01-13 05:04:24", "category_2.title": "Southerfield", "category_2.latitude": 54.8250000000000028421709430404007434844970703125, "category_2.longitude": -3.2980000000000000426325641456060111522674560546875, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "201249": { "category_2_x_pharmacy.id": 201249, "category_2.id": 32153, "category_2.ts": "2018-01-13 05:48:19", "category_2.title": "Stair", "category_2.latitude": 54.578000000000002955857780762016773223876953125, "category_2.longitude": -3.18599999999999994315658113919198513031005859375, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "205028": { "category_2_x_pharmacy.id": 205028, "category_2.id": 33332, "category_2.ts": "2018-01-13 06:56:49", "category_2.title": "Threapland, Cumbria", "category_2.latitude": 54.74199999999999732835931354202330112457275390625, "category_2.longitude": -3.314999999999999946709294817992486059665679931640625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "205205": { "category_2_x_pharmacy.id": 205205, "category_2.id": 33349, "category_2.ts": "2018-01-13 06:59:03", "category_2.title": "Threlkeld", "category_2.latitude": 54.618999999999999772626324556767940521240234375, "category_2.longitude": -3.05600000000000004973799150320701301097869873046875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "208100": { "category_2_x_pharmacy.id": 208100, "category_2.id": 33640, "category_2.ts": "2018-01-13 08:06:12", "category_2.title": "Torpenhow", "category_2.latitude": 54.7469999999999998863131622783839702606201171875, "category_2.longitude": -3.2400000000000002131628207280300557613372802734375, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "208731": { "category_2_x_pharmacy.id": 208731, "category_2.id": 33703, "category_2.ts": "2018-01-13 08:21:01", "category_2.title": "Townhead, Cumbria", "category_2.latitude": 54.7109999999999985220711096189916133880615234375, "category_2.longitude": -3.44099999999999983657517077517695724964141845703125, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "217895": { "category_2_x_pharmacy.id": 217895, "category_2.id": 35422, "category_2.ts": "2018-01-13 12:14:22", "category_2.title": "Westnewton, Cumbria", "category_2.latitude": 54.78399999999999891997504164464771747589111328125, "category_2.longitude": -3.349000000000000198951966012828052043914794921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "221070": { "category_2_x_pharmacy.id": 221070, "category_2.id": 35741, "category_2.ts": "2018-01-13 13:09:59", "category_2.title": "Whitrigg, Cumbria", "category_2.latitude": 54.73899999999999721467247582040727138519287109375, "category_2.longitude": -3.234999999999999875655021241982467472553253173828125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225975": { "category_2_x_pharmacy.id": 225975, "category_2.id": 36231, "category_2.ts": "2018-01-13 14:18:38", "category_2.title": "Wolsty", "category_2.latitude": 54.844999999999998863131622783839702606201171875, "category_2.longitude": -3.398000000000000131450406115618534386157989501953125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "574": { "pharmacy_x_hour.id": 574, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "568": { "pharmacy_x_hour.id": 568, "hour.id": 92, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Monday", "hour.value": "08:30 - 18:00" }, "569": { "pharmacy_x_hour.id": 569, "hour.id": 93, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Tuesday", "hour.value": "08:30 - 18:00" }, "570": { "pharmacy_x_hour.id": 570, "hour.id": 94, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Wednesday", "hour.value": "08:30 - 18:00" }, "571": { "pharmacy_x_hour.id": 571, "hour.id": 95, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Thursday", "hour.value": "08:30 - 18:00" }, "572": { "pharmacy_x_hour.id": 572, "hour.id": 96, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Friday", "hour.value": "08:30 - 18:00" }, "573": { "pharmacy_x_hour.id": 573, "hour.id": 573, "hour.ts": "2018-01-11 22:24:17", "hour.key": "Saturday", "hour.value": "08:30 - 16:00" } }, "pharmacy.pharmacy_x_review_id": { "47": { "pharmacy_x_review.id": 47, "review.id": 47, "review.ts": "2018-01-11 22:24:17", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "Whenever I visit, which I do regularly as I take medications following open-heart surgery 16 years ago, I am greeted with a smile and by ...", "review.date": "15 November 2016" } } }, "91": { "pharmacy.id": 91, "pharmacy.ts": "2018-01-11 22:24:25", "pharmacy.title": "Withnell Pharmacy", "pharmacy.phone": "01254 830180", "pharmacy.street_address": "17 Bury Lane, Withnell, Chorley", "pharmacy.address_locality": "Lancashire", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "PR6 8RX", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "91": { "category_2_x_pharmacy.id": 91, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "61821": { "category_2_x_pharmacy.id": 61821, "category_2.id": 6190, "category_2.ts": "2018-01-11 15:20:26", "category_2.title": "Riley Green", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "100549": { "category_2_x_pharmacy.id": 100549, "category_2.id": 11269, "category_2.ts": "2018-01-12 00:26:29", "category_2.title": "Brinscall", "category_2.latitude": 53.6869999999999976125764078460633754730224609375, "category_2.longitude": -2.564999999999999946709294817992486059665679931640625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "142227": { "category_2_x_pharmacy.id": 142227, "category_2.id": 19844, "category_2.ts": "2018-01-12 12:59:49", "category_2.title": "Higher Wheelton", "category_2.latitude": 53.695999999999997953636921010911464691162109375, "category_2.longitude": -2.595000000000000195399252334027551114559173583984375, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144538": { "category_2_x_pharmacy.id": 144538, "category_2.id": 20076, "category_2.ts": "2018-01-12 13:38:33", "category_2.title": "Hoghton", "category_2.latitude": 53.72500000000000142108547152020037174224853515625, "category_2.longitude": -2.5830000000000001847411112976260483264923095703125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144547": { "category_2_x_pharmacy.id": 144547, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "184906": { "category_2_x_pharmacy.id": 184906, "category_2.id": 29718, "category_2.ts": "2018-01-13 01:36:53", "category_2.title": "Roddlesworth", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.52400000000000002131628207280300557613372802734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "188091": { "category_2_x_pharmacy.id": 188091, "category_2.id": 30036, "category_2.ts": "2018-01-13 02:31:47", "category_2.title": "Ryal Fold", "category_2.latitude": 53.68999999999999772626324556767940521240234375, "category_2.longitude": -2.51100000000000012079226507921703159809112548828125, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "219528": { "category_2_x_pharmacy.id": 219528, "category_2.id": 35586, "category_2.ts": "2018-01-13 12:47:37", "category_2.title": "Wheelton", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.604999999999999982236431605997495353221893310546875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "220215": { "category_2_x_pharmacy.id": 220215, "category_2.id": 35655, "category_2.ts": "2018-01-13 12:57:36", "category_2.title": "White Coppice", "category_2.latitude": 53.66499999999999914734871708787977695465087890625, "category_2.longitude": -2.593999999999999861444166526780463755130767822265625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "223890": { "category_2_x_pharmacy.id": 223890, "category_2.id": 36023, "category_2.ts": "2018-01-13 13:49:51", "category_2.title": "Windmill Hill, Lancashire", "category_2.latitude": 53.71900000000000119371179607696831226348876953125, "category_2.longitude": -2.593999999999999861444166526780463755130767822265625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225446": { "category_2_x_pharmacy.id": 225446, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225456": { "category_2_x_pharmacy.id": 225456, "category_2.id": 36180, "category_2.ts": "2018-01-13 14:11:19", "category_2.title": "Withnell Fold", "category_2.latitude": 53.7060000000000030695446184836328029632568359375, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "581": { "pharmacy_x_hour.id": 581, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "575": { "pharmacy_x_hour.id": 575, "hour.id": 106, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Monday", "hour.value": "08:30 - 13:00" }, "576": { "pharmacy_x_hour.id": 576, "hour.id": 107, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Tuesday", "hour.value": "08:30 - 13:00" }, "577": { "pharmacy_x_hour.id": 577, "hour.id": 108, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Wednesday", "hour.value": "08:30 - 13:00" }, "578": { "pharmacy_x_hour.id": 578, "hour.id": 109, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Thursday", "hour.value": "08:30 - 13:00" }, "579": { "pharmacy_x_hour.id": 579, "hour.id": 110, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Friday", "hour.value": "08:30 - 13:00" }, "580": { "pharmacy_x_hour.id": 580, "hour.id": 580, "hour.ts": "2018-01-11 22:24:25", "hour.key": "Saturday", "hour.value": "08:30 - 12:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "92": { "pharmacy.id": 92, "pharmacy.ts": "2018-01-11 22:24:30", "pharmacy.title": "Manor Pharmacy", "pharmacy.phone": "01254 200 094", "pharmacy.street_address": "Unit 2, Livesey Branch Road, Feniscowles", "pharmacy.address_locality": "Blackburn", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB2 5DX", "pharmacy.rating": "3.5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "92": { "category_2_x_pharmacy.id": 92, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "21961": { "category_2_x_pharmacy.id": 21961, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "46194": { "category_2_x_pharmacy.id": 46194, "category_2.id": 4627, "category_2.ts": "2018-01-11 11:36:06", "category_2.title": "Nab's Head", "category_2.latitude": 53.75999999999999801048033987171947956085205078125, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 14, "category_1.ts": "2018-01-10 22:21:23", "category_1.title": "N" }, "61820": { "category_2_x_pharmacy.id": 61820, "category_2.id": 6190, "category_2.ts": "2018-01-11 15:20:26", "category_2.title": "Riley Green", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "63393": { "category_2_x_pharmacy.id": 63393, "category_2.id": 6347, "category_2.ts": "2018-01-11 15:46:40", "category_2.title": "Samlesbury Bottoms", "category_2.latitude": 53.75500000000000255795384873636066913604736328125, "category_2.longitude": -2.58499999999999996447286321199499070644378662109375, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "100552": { "category_2_x_pharmacy.id": 100552, "category_2.id": 11269, "category_2.ts": "2018-01-12 00:26:29", "category_2.title": "Brinscall", "category_2.latitude": 53.6869999999999976125764078460633754730224609375, "category_2.longitude": -2.564999999999999946709294817992486059665679931640625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "103539": { "category_2_x_pharmacy.id": 103539, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "144536": { "category_2_x_pharmacy.id": 144536, "category_2.id": 20076, "category_2.ts": "2018-01-12 13:38:33", "category_2.title": "Hoghton", "category_2.latitude": 53.72500000000000142108547152020037174224853515625, "category_2.longitude": -2.5830000000000001847411112976260483264923095703125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144546": { "category_2_x_pharmacy.id": 144546, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "180436": { "category_2_x_pharmacy.id": 180436, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "184913": { "category_2_x_pharmacy.id": 184913, "category_2.id": 29718, "category_2.ts": "2018-01-13 01:36:53", "category_2.title": "Roddlesworth", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.52400000000000002131628207280300557613372802734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "188094": { "category_2_x_pharmacy.id": 188094, "category_2.id": 30036, "category_2.ts": "2018-01-13 02:31:47", "category_2.title": "Ryal Fold", "category_2.latitude": 53.68999999999999772626324556767940521240234375, "category_2.longitude": -2.51100000000000012079226507921703159809112548828125, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "207316": { "category_2_x_pharmacy.id": 207316, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "223893": { "category_2_x_pharmacy.id": 223893, "category_2.id": 36023, "category_2.ts": "2018-01-13 13:49:51", "category_2.title": "Windmill Hill, Lancashire", "category_2.latitude": 53.71900000000000119371179607696831226348876953125, "category_2.longitude": -2.593999999999999861444166526780463755130767822265625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225447": { "category_2_x_pharmacy.id": 225447, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225462": { "category_2_x_pharmacy.id": 225462, "category_2.id": 36180, "category_2.ts": "2018-01-13 14:11:19", "category_2.title": "Withnell Fold", "category_2.latitude": 53.7060000000000030695446184836328029632568359375, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "587": { "pharmacy_x_hour.id": 587, "hour.id": 6, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Saturday", "hour.value": "09:00 - 13:00" }, "588": { "pharmacy_x_hour.id": 588, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "582": { "pharmacy_x_hour.id": 582, "hour.id": 43, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Monday", "hour.value": "09:00 - 18:00" }, "583": { "pharmacy_x_hour.id": 583, "hour.id": 44, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Tuesday", "hour.value": "09:00 - 18:00" }, "584": { "pharmacy_x_hour.id": 584, "hour.id": 45, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Wednesday", "hour.value": "09:00 - 18:00" }, "585": { "pharmacy_x_hour.id": 585, "hour.id": 46, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Thursday", "hour.value": "09:00 - 18:00" }, "586": { "pharmacy_x_hour.id": 586, "hour.id": 68, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Friday", "hour.value": "09:00 - 13:00" } }, "pharmacy.pharmacy_x_review_id": { "48": { "pharmacy_x_review.id": 48, "review.id": 48, "review.ts": "2018-01-11 22:24:30", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "I have used this pharmacy since 2015 and I have to say this is my favourite pharmacy by far! In the past I always had problems with my re...", "review.date": "1 January 2017" }, "49": { "pharmacy_x_review.id": 49, "review.id": 49, "review.ts": "2018-01-11 22:24:30", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "I've used this chemist since day 1, they collect and deliver my prescription monthly and when needed to and I have never had any proble...", "review.date": "9 December 2016" } } }, "93": { "pharmacy.id": 93, "pharmacy.ts": "2018-01-11 22:24:33", "pharmacy.title": "Livesey Pharmacy", "pharmacy.phone": "01254 582872", "pharmacy.street_address": "238, Livesey Branch Road", "pharmacy.address_locality": "Blackburn", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB2 4QL", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "93": { "category_2_x_pharmacy.id": 93, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "16124": { "category_2_x_pharmacy.id": 16124, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "21963": { "category_2_x_pharmacy.id": 21963, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "61825": { "category_2_x_pharmacy.id": 61825, "category_2.id": 6190, "category_2.ts": "2018-01-11 15:20:26", "category_2.title": "Riley Green", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "103541": { "category_2_x_pharmacy.id": 103541, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124039": { "category_2_x_pharmacy.id": 124039, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "144544": { "category_2_x_pharmacy.id": 144544, "category_2.id": 20076, "category_2.ts": "2018-01-12 13:38:33", "category_2.title": "Hoghton", "category_2.latitude": 53.72500000000000142108547152020037174224853515625, "category_2.longitude": -2.5830000000000001847411112976260483264923095703125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144552": { "category_2_x_pharmacy.id": 144552, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "160752": { "category_2_x_pharmacy.id": 160752, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "180440": { "category_2_x_pharmacy.id": 180440, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "184915": { "category_2_x_pharmacy.id": 184915, "category_2.id": 29718, "category_2.ts": "2018-01-13 01:36:53", "category_2.title": "Roddlesworth", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.52400000000000002131628207280300557613372802734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "188095": { "category_2_x_pharmacy.id": 188095, "category_2.id": 30036, "category_2.ts": "2018-01-13 02:31:47", "category_2.title": "Ryal Fold", "category_2.latitude": 53.68999999999999772626324556767940521240234375, "category_2.longitude": -2.51100000000000012079226507921703159809112548828125, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "207317": { "category_2_x_pharmacy.id": 207317, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "225448": { "category_2_x_pharmacy.id": 225448, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225463": { "category_2_x_pharmacy.id": 225463, "category_2.id": 36180, "category_2.ts": "2018-01-13 14:11:19", "category_2.title": "Withnell Fold", "category_2.latitude": 53.7060000000000030695446184836328029632568359375, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "595": { "pharmacy_x_hour.id": 595, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "594": { "pharmacy_x_hour.id": 594, "hour.id": 174, "hour.ts": "2018-01-11 22:14:02", "hour.key": "Saturday", "hour.value": "09:00 - 12:30" }, "589": { "pharmacy_x_hour.id": 589, "hour.id": 204, "hour.ts": "2018-01-11 22:14:42", "hour.key": "Monday", "hour.value": "09:00 - 12:30" }, "590": { "pharmacy_x_hour.id": 590, "hour.id": 205, "hour.ts": "2018-01-11 22:14:42", "hour.key": "Tuesday", "hour.value": "09:00 - 12:30" }, "591": { "pharmacy_x_hour.id": 591, "hour.id": 206, "hour.ts": "2018-01-11 22:14:42", "hour.key": "Wednesday", "hour.value": "09:00 - 12:30" }, "592": { "pharmacy_x_hour.id": 592, "hour.id": 207, "hour.ts": "2018-01-11 22:14:42", "hour.key": "Thursday", "hour.value": "09:00 - 12:30" }, "593": { "pharmacy_x_hour.id": 593, "hour.id": 208, "hour.ts": "2018-01-11 22:14:42", "hour.key": "Friday", "hour.value": "09:00 - 12:30" } }, "pharmacy.pharmacy_x_review_id": {} }, "94": { "pharmacy.id": 94, "pharmacy.ts": "2018-01-11 22:24:57", "pharmacy.title": "LloydsPharmacy", "pharmacy.phone": "01254 202870", "pharmacy.street_address": "8 Bentham Road, Mill Hill, Blackburn", "pharmacy.address_locality": ", BB2 4PN", "pharmacy.address_region": "", "pharmacy.postal_code": "BB2 4PN", "pharmacy.rating": "3.5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "94": { "category_2_x_pharmacy.id": 94, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "16126": { "category_2_x_pharmacy.id": 16126, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "21962": { "category_2_x_pharmacy.id": 21962, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "61824": { "category_2_x_pharmacy.id": 61824, "category_2.id": 6190, "category_2.ts": "2018-01-11 15:20:26", "category_2.title": "Riley Green", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "103540": { "category_2_x_pharmacy.id": 103540, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124041": { "category_2_x_pharmacy.id": 124041, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "144542": { "category_2_x_pharmacy.id": 144542, "category_2.id": 20076, "category_2.ts": "2018-01-12 13:38:33", "category_2.title": "Hoghton", "category_2.latitude": 53.72500000000000142108547152020037174224853515625, "category_2.longitude": -2.5830000000000001847411112976260483264923095703125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144551": { "category_2_x_pharmacy.id": 144551, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "160754": { "category_2_x_pharmacy.id": 160754, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "167212": { "category_2_x_pharmacy.id": 167212, "category_2.id": 24744, "category_2.ts": "2018-01-12 20:17:46", "category_2.title": "Mill Hill, Blackburn with Darwen", "category_2.latitude": 53.73899999999999721467247582040727138519287109375, "category_2.longitude": -2.5, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180439": { "category_2_x_pharmacy.id": 180439, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "207319": { "category_2_x_pharmacy.id": 207319, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "225450": { "category_2_x_pharmacy.id": 225450, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225465": { "category_2_x_pharmacy.id": 225465, "category_2.id": 36180, "category_2.ts": "2018-01-13 14:11:19", "category_2.title": "Withnell Fold", "category_2.latitude": 53.7060000000000030695446184836328029632568359375, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "602": { "pharmacy_x_hour.id": 602, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "599": { "pharmacy_x_hour.id": 599, "hour.id": 60, "hour.ts": "2018-01-11 22:10:42", "hour.key": "Thursday", "hour.value": "09:00 - 18:30" }, "601": { "pharmacy_x_hour.id": 601, "hour.id": 174, "hour.ts": "2018-01-11 22:14:02", "hour.key": "Saturday", "hour.value": "09:00 - 12:30" }, "596": { "pharmacy_x_hour.id": 596, "hour.id": 211, "hour.ts": "2018-01-11 22:14:47", "hour.key": "Monday", "hour.value": "09:00 - 18:30" }, "597": { "pharmacy_x_hour.id": 597, "hour.id": 212, "hour.ts": "2018-01-11 22:14:47", "hour.key": "Tuesday", "hour.value": "09:00 - 18:30" }, "598": { "pharmacy_x_hour.id": 598, "hour.id": 213, "hour.ts": "2018-01-11 22:14:47", "hour.key": "Wednesday", "hour.value": "09:00 - 18:30" }, "600": { "pharmacy_x_hour.id": 600, "hour.id": 215, "hour.ts": "2018-01-11 22:14:47", "hour.key": "Friday", "hour.value": "09:00 - 18:30" } }, "pharmacy.pharmacy_x_review_id": { "50": { "pharmacy_x_review.id": 50, "review.id": 50, "review.ts": "2018-01-11 22:24:57", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "This has to be one of the best pharmacies in the area they always go the extra mile for me and my family I know I can always count on the...", "review.date": "17 May 2017" }, "51": { "pharmacy_x_review.id": 51, "review.id": 51, "review.ts": "2018-01-11 22:24:57", "review.rating": "Rating 1 out of 5 stars -", "review.reviewtext": "The staff try and force their own products when I have asked for specific products which work well for me. This has wasted my money when...", "review.date": "12 April 2017" } } }, "95": { "pharmacy.id": 95, "pharmacy.ts": "2018-01-11 22:25:04", "pharmacy.title": "LloydsPharmacy", "pharmacy.phone": "01254 702602", "pharmacy.street_address": "103 Blackburn Road, Darwen, Darwen", "pharmacy.address_locality": ", BB3 1ET", "pharmacy.address_region": "", "pharmacy.postal_code": "BB3 1ET", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "95": { "category_2_x_pharmacy.id": 95, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "13116": { "category_2_x_pharmacy.id": 13116, "category_2.id": 1314, "category_2.ts": "2018-01-21 20:47:52", "category_2.title": "Darwen", "category_2.latitude": 53.69500000000000028421709430404007434844970703125, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "16122": { "category_2_x_pharmacy.id": 16122, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "58095": { "category_2_x_pharmacy.id": 58095, "category_2.id": 5817, "category_2.ts": "2018-01-11 14:30:06", "category_2.title": "Pickup Bank", "category_2.latitude": 53.6989999999999980673237587325274944305419921875, "category_2.longitude": -2.415999999999999925393012745189480483531951904296875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "59553": { "category_2_x_pharmacy.id": 59553, "category_2.id": 5963, "category_2.ts": "2018-01-11 14:50:36", "category_2.title": "Rann", "category_2.latitude": 53.71600000000000108002495835535228252410888671875, "category_2.longitude": -2.431999999999999939603867460391484200954437255859375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "78284": { "category_2_x_pharmacy.id": 78284, "category_2.id": 7838, "category_2.ts": "2018-01-11 19:07:43", "category_2.title": "Waterside, Blackburn with Darwen", "category_2.latitude": 53.70700000000000073896444519050419330596923828125, "category_2.longitude": -2.444999999999999840127884453977458178997039794921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "87321": { "category_2_x_pharmacy.id": 87321, "category_2.id": 9944, "category_2.ts": "2018-01-11 21:15:52", "category_2.title": "Belthorn", "category_2.latitude": 53.7180000000000035242919693700969219207763671875, "category_2.longitude": -2.435000000000000053290705182007513940334320068359375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "91744": { "category_2_x_pharmacy.id": 91744, "category_2.id": 10387, "category_2.ts": "2018-01-11 22:25:43", "category_2.title": "Blackburn with Darwen", "category_2.latitude": 53.69200000000000017053025658242404460906982421875, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "92215": { "category_2_x_pharmacy.id": 92215, "category_2.id": 10434, "category_2.ts": "2018-01-11 22:31:39", "category_2.title": "Blacksnape", "category_2.latitude": 53.6869999999999976125764078460633754730224609375, "category_2.longitude": -2.436999999999999833022457096376456320285797119140625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "132616": { "category_2_x_pharmacy.id": 132616, "category_2.id": 18480, "category_2.ts": "2018-01-12 09:08:39", "category_2.title": "Grimshaw", "category_2.latitude": 53.7109999999999985220711096189916133880615234375, "category_2.longitude": -2.451000000000000067501559897209517657756805419921875, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "144391": { "category_2_x_pharmacy.id": 144391, "category_2.id": 20061, "category_2.ts": "2018-01-12 13:36:02", "category_2.title": "Hoddlesden", "category_2.latitude": 53.6989999999999980673237587325274944305419921875, "category_2.longitude": -2.439999999999999946709294817992486059665679931640625, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "160750": { "category_2_x_pharmacy.id": 160750, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "184908": { "category_2_x_pharmacy.id": 184908, "category_2.id": 29718, "category_2.ts": "2018-01-13 01:36:53", "category_2.title": "Roddlesworth", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.52400000000000002131628207280300557613372802734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "188087": { "category_2_x_pharmacy.id": 188087, "category_2.id": 30036, "category_2.ts": "2018-01-13 02:31:47", "category_2.title": "Ryal Fold", "category_2.latitude": 53.68999999999999772626324556767940521240234375, "category_2.longitude": -2.51100000000000012079226507921703159809112548828125, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "207318": { "category_2_x_pharmacy.id": 207318, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "221273": { "category_2_x_pharmacy.id": 221273, "category_2.id": 35761, "category_2.ts": "2018-01-13 13:12:29", "category_2.title": "Whittlestone Head", "category_2.latitude": 53.6689999999999969304553815163671970367431640625, "category_2.longitude": -2.41800000000000014921397450962103903293609619140625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225449": { "category_2_x_pharmacy.id": 225449, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "603": { "pharmacy_x_hour.id": 603, "hour.id": 1, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Monday", "hour.value": "09:00 - 17:30" }, "604": { "pharmacy_x_hour.id": 604, "hour.id": 2, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Tuesday", "hour.value": "09:00 - 17:30" }, "605": { "pharmacy_x_hour.id": 605, "hour.id": 3, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Wednesday", "hour.value": "09:00 - 17:30" }, "606": { "pharmacy_x_hour.id": 606, "hour.id": 4, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Thursday", "hour.value": "09:00 - 17:30" }, "607": { "pharmacy_x_hour.id": 607, "hour.id": 5, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Friday", "hour.value": "09:00 - 17:30" }, "609": { "pharmacy_x_hour.id": 609, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "608": { "pharmacy_x_hour.id": 608, "hour.id": 174, "hour.ts": "2018-01-11 22:14:02", "hour.key": "Saturday", "hour.value": "09:00 - 12:30" } }, "pharmacy.pharmacy_x_review_id": {} }, "96": { "pharmacy.id": 96, "pharmacy.ts": "2018-01-11 22:25:08", "pharmacy.title": "Geloo Brothers Ltd", "pharmacy.phone": "01254 57278", "pharmacy.street_address": "1 New Wellington Street, Mill Hill, Blackburn", "pharmacy.address_locality": "blackburn", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB2 4DY", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "96": { "category_2_x_pharmacy.id": 96, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "16125": { "category_2_x_pharmacy.id": 16125, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "21967": { "category_2_x_pharmacy.id": 21967, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "103545": { "category_2_x_pharmacy.id": 103545, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124038": { "category_2_x_pharmacy.id": 124038, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "160753": { "category_2_x_pharmacy.id": 160753, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "167210": { "category_2_x_pharmacy.id": 167210, "category_2.id": 24744, "category_2.ts": "2018-01-12 20:17:46", "category_2.title": "Mill Hill, Blackburn with Darwen", "category_2.latitude": 53.73899999999999721467247582040727138519287109375, "category_2.longitude": -2.5, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180443": { "category_2_x_pharmacy.id": 180443, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "207321": { "category_2_x_pharmacy.id": 207321, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" } }, "pharmacy.pharmacy_x_hour_id": { "615": { "pharmacy_x_hour.id": 615, "hour.id": 6, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Saturday", "hour.value": "09:00 - 13:00" }, "616": { "pharmacy_x_hour.id": 616, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "610": { "pharmacy_x_hour.id": 610, "hour.id": 64, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Monday", "hour.value": "09:00 - 13:00" }, "611": { "pharmacy_x_hour.id": 611, "hour.id": 65, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Tuesday", "hour.value": "09:00 - 13:00" }, "612": { "pharmacy_x_hour.id": 612, "hour.id": 66, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Wednesday", "hour.value": "09:00 - 13:00" }, "613": { "pharmacy_x_hour.id": 613, "hour.id": 67, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Thursday", "hour.value": "09:00 - 13:00" }, "614": { "pharmacy_x_hour.id": 614, "hour.id": 68, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Friday", "hour.value": "09:00 - 13:00" } }, "pharmacy.pharmacy_x_review_id": { "52": { "pharmacy_x_review.id": 52, "review.id": 52, "review.ts": "2018-01-11 22:25:08", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "Found the staff to be very welcoming, and professional in the service they provided to me regarding my sick elderly relative. Especial...", "review.date": "26 July 2017" } } }, "97": { "pharmacy.id": 97, "pharmacy.ts": "2018-01-11 22:25:15", "pharmacy.title": "Pharmakeion Ltd", "pharmacy.phone": "01254 55366", "pharmacy.street_address": "62 New Chapel Street, Mill Hill", "pharmacy.address_locality": "Blackburn", "pharmacy.address_region": "", "pharmacy.postal_code": "BB2 4DT", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "97": { "category_2_x_pharmacy.id": 97, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "16128": { "category_2_x_pharmacy.id": 16128, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "21965": { "category_2_x_pharmacy.id": 21965, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "103543": { "category_2_x_pharmacy.id": 103543, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124042": { "category_2_x_pharmacy.id": 124042, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "144553": { "category_2_x_pharmacy.id": 144553, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "160755": { "category_2_x_pharmacy.id": 160755, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "167209": { "category_2_x_pharmacy.id": 167209, "category_2.id": 24744, "category_2.ts": "2018-01-12 20:17:46", "category_2.title": "Mill Hill, Blackburn with Darwen", "category_2.latitude": 53.73899999999999721467247582040727138519287109375, "category_2.longitude": -2.5, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180441": { "category_2_x_pharmacy.id": 180441, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "207322": { "category_2_x_pharmacy.id": 207322, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" } }, "pharmacy.pharmacy_x_hour_id": { "623": { "pharmacy_x_hour.id": 623, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "617": { "pharmacy_x_hour.id": 617, "hour.id": 64, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Monday", "hour.value": "09:00 - 13:00" }, "618": { "pharmacy_x_hour.id": 618, "hour.id": 65, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Tuesday", "hour.value": "09:00 - 13:00" }, "619": { "pharmacy_x_hour.id": 619, "hour.id": 66, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Wednesday", "hour.value": "09:00 - 13:00" }, "620": { "pharmacy_x_hour.id": 620, "hour.id": 67, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Thursday", "hour.value": "09:00 - 13:00" }, "621": { "pharmacy_x_hour.id": 621, "hour.id": 68, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Friday", "hour.value": "09:00 - 13:00" }, "622": { "pharmacy_x_hour.id": 622, "hour.id": 174, "hour.ts": "2018-01-11 22:14:02", "hour.key": "Saturday", "hour.value": "09:00 - 12:30" } }, "pharmacy.pharmacy_x_review_id": {} }, "98": { "pharmacy.id": 98, "pharmacy.ts": "2018-01-11 22:25:18", "pharmacy.title": "Boots", "pharmacy.phone": "0125455074", "pharmacy.street_address": "435 Bolton Rd", "pharmacy.address_locality": "Blackburn", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB2 4HY", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "98": { "category_2_x_pharmacy.id": 98, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "13119": { "category_2_x_pharmacy.id": 13119, "category_2.id": 1314, "category_2.ts": "2018-01-21 20:47:52", "category_2.title": "Darwen", "category_2.latitude": 53.69500000000000028421709430404007434844970703125, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "16121": { "category_2_x_pharmacy.id": 16121, "category_2.id": 1616, "category_2.ts": "2018-01-23 14:12:16", "category_2.title": "Earcroft", "category_2.latitude": 53.7169999999999987494447850622236728668212890625, "category_2.longitude": -2.486000000000000209610107049229554831981658935546875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "21969": { "category_2_x_pharmacy.id": 21969, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "78288": { "category_2_x_pharmacy.id": 78288, "category_2.id": 7838, "category_2.ts": "2018-01-11 19:07:43", "category_2.title": "Waterside, Blackburn with Darwen", "category_2.latitude": 53.70700000000000073896444519050419330596923828125, "category_2.longitude": -2.444999999999999840127884453977458178997039794921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "91747": { "category_2_x_pharmacy.id": 91747, "category_2.id": 10387, "category_2.ts": "2018-01-11 22:25:43", "category_2.title": "Blackburn with Darwen", "category_2.latitude": 53.69200000000000017053025658242404460906982421875, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "103547": { "category_2_x_pharmacy.id": 103547, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124037": { "category_2_x_pharmacy.id": 124037, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "132624": { "category_2_x_pharmacy.id": 132624, "category_2.id": 18480, "category_2.ts": "2018-01-12 09:08:39", "category_2.title": "Grimshaw", "category_2.latitude": 53.7109999999999985220711096189916133880615234375, "category_2.longitude": -2.451000000000000067501559897209517657756805419921875, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "144394": { "category_2_x_pharmacy.id": 144394, "category_2.id": 20061, "category_2.ts": "2018-01-12 13:36:02", "category_2.title": "Hoddlesden", "category_2.latitude": 53.6989999999999980673237587325274944305419921875, "category_2.longitude": -2.439999999999999946709294817992486059665679931640625, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "160747": { "category_2_x_pharmacy.id": 160747, "category_2.id": 23298, "category_2.ts": "2018-01-12 18:05:54", "category_2.title": "Lower Darwen", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.476999999999999868549593884381465613842010498046875, "category_1.id": 12, "category_1.ts": "2018-01-10 22:16:42", "category_1.title": "L" }, "207320": { "category_2_x_pharmacy.id": 207320, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "219814": { "category_2_x_pharmacy.id": 219814, "category_2.id": 35614, "category_2.ts": "2018-01-13 12:51:39", "category_2.title": "Whinny Heights", "category_2.latitude": 53.73700000000000187583282240666449069976806640625, "category_2.longitude": -2.47900000000000009237055564881302416324615478515625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "629": { "pharmacy_x_hour.id": 629, "hour.id": 6, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Saturday", "hour.value": "09:00 - 13:00" }, "630": { "pharmacy_x_hour.id": 630, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "624": { "pharmacy_x_hour.id": 624, "hour.id": 92, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Monday", "hour.value": "08:30 - 18:00" }, "625": { "pharmacy_x_hour.id": 625, "hour.id": 93, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Tuesday", "hour.value": "08:30 - 18:00" }, "626": { "pharmacy_x_hour.id": 626, "hour.id": 94, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Wednesday", "hour.value": "08:30 - 18:00" }, "627": { "pharmacy_x_hour.id": 627, "hour.id": 95, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Thursday", "hour.value": "08:30 - 18:00" }, "628": { "pharmacy_x_hour.id": 628, "hour.id": 96, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Friday", "hour.value": "08:30 - 18:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "99": { "pharmacy.id": 99, "pharmacy.ts": "2018-01-11 22:25:38", "pharmacy.title": "Cohens Chemist", "pharmacy.phone": "01254772106", "pharmacy.street_address": "Darwen Health Centre, James Street West", "pharmacy.address_locality": "Darwen", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB3 1PY", "pharmacy.rating": "2.5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "99": { "category_2_x_pharmacy.id": 99, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "13113": { "category_2_x_pharmacy.id": 13113, "category_2.id": 1314, "category_2.ts": "2018-01-21 20:47:52", "category_2.title": "Darwen", "category_2.latitude": 53.69500000000000028421709430404007434844970703125, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 4, "category_1.ts": "2018-01-10 22:15:28", "category_1.title": "D" }, "58094": { "category_2_x_pharmacy.id": 58094, "category_2.id": 5817, "category_2.ts": "2018-01-11 14:30:06", "category_2.title": "Pickup Bank", "category_2.latitude": 53.6989999999999980673237587325274944305419921875, "category_2.longitude": -2.415999999999999925393012745189480483531951904296875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "59556": { "category_2_x_pharmacy.id": 59556, "category_2.id": 5963, "category_2.ts": "2018-01-11 14:50:36", "category_2.title": "Rann", "category_2.latitude": 53.71600000000000108002495835535228252410888671875, "category_2.longitude": -2.431999999999999939603867460391484200954437255859375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "78283": { "category_2_x_pharmacy.id": 78283, "category_2.id": 7838, "category_2.ts": "2018-01-11 19:07:43", "category_2.title": "Waterside, Blackburn with Darwen", "category_2.latitude": 53.70700000000000073896444519050419330596923828125, "category_2.longitude": -2.444999999999999840127884453977458178997039794921875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "87328": { "category_2_x_pharmacy.id": 87328, "category_2.id": 9944, "category_2.ts": "2018-01-11 21:15:52", "category_2.title": "Belthorn", "category_2.latitude": 53.7180000000000035242919693700969219207763671875, "category_2.longitude": -2.435000000000000053290705182007513940334320068359375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "91741": { "category_2_x_pharmacy.id": 91741, "category_2.id": 10387, "category_2.ts": "2018-01-11 22:25:43", "category_2.title": "Blackburn with Darwen", "category_2.latitude": 53.69200000000000017053025658242404460906982421875, "category_2.longitude": -2.468999999999999861444166526780463755130767822265625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "92214": { "category_2_x_pharmacy.id": 92214, "category_2.id": 10434, "category_2.ts": "2018-01-11 22:31:39", "category_2.title": "Blacksnape", "category_2.latitude": 53.6869999999999976125764078460633754730224609375, "category_2.longitude": -2.436999999999999833022457096376456320285797119140625, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "132621": { "category_2_x_pharmacy.id": 132621, "category_2.id": 18480, "category_2.ts": "2018-01-12 09:08:39", "category_2.title": "Grimshaw", "category_2.latitude": 53.7109999999999985220711096189916133880615234375, "category_2.longitude": -2.451000000000000067501559897209517657756805419921875, "category_1.id": 7, "category_1.ts": "2018-01-10 22:15:53", "category_1.title": "G" }, "144389": { "category_2_x_pharmacy.id": 144389, "category_2.id": 20061, "category_2.ts": "2018-01-12 13:36:02", "category_2.title": "Hoddlesden", "category_2.latitude": 53.6989999999999980673237587325274944305419921875, "category_2.longitude": -2.439999999999999946709294817992486059665679931640625, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "184907": { "category_2_x_pharmacy.id": 184907, "category_2.id": 29718, "category_2.ts": "2018-01-13 01:36:53", "category_2.title": "Roddlesworth", "category_2.latitude": 53.6880000000000023874235921539366245269775390625, "category_2.longitude": -2.52400000000000002131628207280300557613372802734375, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "188086": { "category_2_x_pharmacy.id": 188086, "category_2.id": 30036, "category_2.ts": "2018-01-13 02:31:47", "category_2.title": "Ryal Fold", "category_2.latitude": 53.68999999999999772626324556767940521240234375, "category_2.longitude": -2.51100000000000012079226507921703159809112548828125, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "207323": { "category_2_x_pharmacy.id": 207323, "category_2.id": 33561, "category_2.ts": "2018-01-13 07:44:23", "category_2.title": "Tockholes", "category_2.latitude": 53.70900000000000318323145620524883270263671875, "category_2.longitude": -2.5099999999999997868371792719699442386627197265625, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "221272": { "category_2_x_pharmacy.id": 221272, "category_2.id": 35761, "category_2.ts": "2018-01-13 13:12:29", "category_2.title": "Whittlestone Head", "category_2.latitude": 53.6689999999999969304553815163671970367431640625, "category_2.longitude": -2.41800000000000014921397450962103903293609619140625, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" }, "225452": { "category_2_x_pharmacy.id": 225452, "category_2.id": 36179, "category_2.ts": "2018-01-13 14:11:10", "category_2.title": "Withnell", "category_2.latitude": 53.691000000000002501110429875552654266357421875, "category_2.longitude": -2.555000000000000159872115546022541821002960205078125, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "637": { "pharmacy_x_hour.id": 637, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "636": { "pharmacy_x_hour.id": 636, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "631": { "pharmacy_x_hour.id": 631, "hour.id": 631, "hour.ts": "2018-01-11 22:25:38", "hour.key": "Monday", "hour.value": "08:00 - 13:00" }, "632": { "pharmacy_x_hour.id": 632, "hour.id": 632, "hour.ts": "2018-01-11 22:25:38", "hour.key": "Tuesday", "hour.value": "08:00 - 13:00" }, "633": { "pharmacy_x_hour.id": 633, "hour.id": 633, "hour.ts": "2018-01-11 22:25:38", "hour.key": "Wednesday", "hour.value": "08:00 - 13:00" }, "634": { "pharmacy_x_hour.id": 634, "hour.id": 634, "hour.ts": "2018-01-11 22:25:38", "hour.key": "Thursday", "hour.value": "08:00 - 13:00" }, "635": { "pharmacy_x_hour.id": 635, "hour.id": 635, "hour.ts": "2018-01-11 22:25:38", "hour.key": "Friday", "hour.value": "08:00 - 13:00" } }, "pharmacy.pharmacy_x_review_id": { "53": { "pharmacy_x_review.id": 53, "review.id": 53, "review.ts": "2018-01-11 22:25:38", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "I would just like to say that I have really noticed a big improvement in the service provided at Darwen health care cohens pharmacy. I ...", "review.date": "25 October 2017" }, "54": { "pharmacy_x_review.id": 54, "review.id": 54, "review.ts": "2018-01-11 22:25:38", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "A few months ago I was suffering really badly with pnic attacks, I came into the pharmacy and the pharmacist sat me down, re-assured me t...", "review.date": "8 July 2017" }, "55": { "pharmacy_x_review.id": 55, "review.id": 55, "review.ts": "2018-01-11 22:25:38", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "I have used this chemist for a while, very helpful advice from the manager on the last visit, great staff, they helped me get my prescrip...", "review.date": "26 March 2017" }, "56": { "pharmacy_x_review.id": 56, "review.id": 56, "review.ts": "2018-01-11 22:25:38", "review.rating": "Rating 1 out of 5 stars -", "review.reviewtext": "Went into the chemist last week, totally disorganised.waited an hour for my prescription, 20 mins waiting to be served, 40 mins for my pr...", "review.date": "16 March 2017" }, "57": { "pharmacy_x_review.id": 57, "review.id": 57, "review.ts": "2018-01-11 22:25:38", "review.rating": "Rating 1 out of 5 stars -", "review.reviewtext": "Went in to this chemist which I instantly thought was under staffed with one assistant and 2 dispensers and one pharmacist for a Friday a...", "review.date": "28 October 2016" } } }, "100": { "pharmacy.id": 100, "pharmacy.ts": "2018-01-11 22:25:45", "pharmacy.title": "Cohens Chemist", "pharmacy.phone": "0125453780", "pharmacy.street_address": "33 Preston Old Road, Witton", "pharmacy.address_locality": "Blackburn", "pharmacy.address_region": "Lancashire", "pharmacy.postal_code": "BB2 2ST", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "100": { "category_2_x_pharmacy.id": 100, "category_2.id": 12, "category_2.ts": "2018-01-14 21:55:32", "category_2.title": "Abbey Village", "category_2.latitude": 53.7000000000000028421709430404007434844970703125, "category_2.longitude": -2.547000000000000152766688188421539962291717529296875, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "21964": { "category_2_x_pharmacy.id": 21964, "category_2.id": 2200, "category_2.ts": "2018-01-26 18:10:25", "category_2.title": "Feniscowles", "category_2.latitude": 53.72699999999999675992512493394315242767333984375, "category_2.longitude": -2.537999999999999811706175023573450744152069091796875, "category_1.id": 6, "category_1.ts": "2018-01-10 22:15:43", "category_1.title": "F" }, "46195": { "category_2_x_pharmacy.id": 46195, "category_2.id": 4627, "category_2.ts": "2018-01-11 11:36:06", "category_2.title": "Nab's Head", "category_2.latitude": 53.75999999999999801048033987171947956085205078125, "category_2.longitude": -2.58199999999999985078602549037896096706390380859375, "category_1.id": 14, "category_1.ts": "2018-01-10 22:21:23", "category_1.title": "N" }, "61827": { "category_2_x_pharmacy.id": 61827, "category_2.id": 6190, "category_2.ts": "2018-01-11 15:20:26", "category_2.title": "Riley Green", "category_2.latitude": 53.72200000000000130739863379858434200286865234375, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 18, "category_1.ts": "2018-01-10 22:23:01", "category_1.title": "R" }, "63394": { "category_2_x_pharmacy.id": 63394, "category_2.id": 6347, "category_2.ts": "2018-01-11 15:46:40", "category_2.title": "Samlesbury Bottoms", "category_2.latitude": 53.75500000000000255795384873636066913604736328125, "category_2.longitude": -2.58499999999999996447286321199499070644378662109375, "category_1.id": 19, "category_1.ts": "2018-01-10 22:23:08", "category_1.title": "S" }, "85497": { "category_2_x_pharmacy.id": 85497, "category_2.id": 9760, "category_2.ts": "2018-01-11 20:50:48", "category_2.title": "Beardwood", "category_2.latitude": 53.76100000000000278532752417959272861480712890625, "category_2.longitude": -2.52099999999999990762944435118697583675384521484375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "103542": { "category_2_x_pharmacy.id": 103542, "category_2.id": 12369, "category_2.ts": "2018-01-12 01:13:40", "category_2.title": "Cherry Tree, Blackburn with Darwen", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.52700000000000013500311979441903531551361083984375, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" }, "124046": { "category_2_x_pharmacy.id": 124046, "category_2.id": 16020, "category_2.ts": "2018-01-12 06:22:43", "category_2.title": "Ewood", "category_2.latitude": 53.72800000000000153477230924181640148162841796875, "category_2.longitude": -2.49199999999999999289457264239899814128875732421875, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "144543": { "category_2_x_pharmacy.id": 144543, "category_2.id": 20076, "category_2.ts": "2018-01-12 13:38:33", "category_2.title": "Hoghton", "category_2.latitude": 53.72500000000000142108547152020037174224853515625, "category_2.longitude": -2.5830000000000001847411112976260483264923095703125, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "144548": { "category_2_x_pharmacy.id": 144548, "category_2.id": 20077, "category_2.ts": "2018-01-12 13:38:39", "category_2.title": "Hoghton Bottoms", "category_2.latitude": 53.73100000000000164845914696343243122100830078125, "category_2.longitude": -2.576000000000000067501559897209517657756805419921875, "category_1.id": 8, "category_1.ts": "2018-01-10 22:16:03", "category_1.title": "H" }, "164474": { "category_2_x_pharmacy.id": 164474, "category_2.id": 24470, "category_2.ts": "2018-01-12 19:14:58", "category_2.title": "Mellor Brook", "category_2.latitude": 53.7770000000000010231815394945442676544189453125, "category_2.longitude": -2.5510000000000001563194018672220408916473388671875, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "167208": { "category_2_x_pharmacy.id": 167208, "category_2.id": 24744, "category_2.ts": "2018-01-12 20:17:46", "category_2.title": "Mill Hill, Blackburn with Darwen", "category_2.latitude": 53.73899999999999721467247582040727138519287109375, "category_2.longitude": -2.5, "category_1.id": 13, "category_1.ts": "2018-01-10 22:16:50", "category_1.title": "M" }, "180437": { "category_2_x_pharmacy.id": 180437, "category_2.id": 28470, "category_2.ts": "2018-01-13 00:20:00", "category_2.title": "Pleasington", "category_2.latitude": 53.7349999999999994315658113919198513031005859375, "category_2.longitude": -2.5449999999999999289457264239899814128875732421875, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" } }, "pharmacy.pharmacy_x_hour_id": { "644": { "pharmacy_x_hour.id": 644, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "643": { "pharmacy_x_hour.id": 643, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "638": { "pharmacy_x_hour.id": 638, "hour.id": 106, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Monday", "hour.value": "08:30 - 13:00" }, "639": { "pharmacy_x_hour.id": 639, "hour.id": 107, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Tuesday", "hour.value": "08:30 - 13:00" }, "640": { "pharmacy_x_hour.id": 640, "hour.id": 108, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Wednesday", "hour.value": "08:30 - 13:00" }, "641": { "pharmacy_x_hour.id": 641, "hour.id": 109, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Thursday", "hour.value": "08:30 - 13:00" }, "642": { "pharmacy_x_hour.id": 642, "hour.id": 110, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Friday", "hour.value": "08:30 - 13:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "101": { "pharmacy.id": 101, "pharmacy.ts": "2018-01-11 22:25:50", "pharmacy.title": "Browne Af Ltd", "pharmacy.phone": "020 8311 0898", "pharmacy.street_address": "14-16 Wilton Road, Abbey Wood", "pharmacy.address_locality": "London", "pharmacy.address_region": "", "pharmacy.postal_code": "SE2 9RH", "pharmacy.rating": "1 out of 5", "pharmacy.category_2_x_pharmacy_id": { "101": { "category_2_x_pharmacy.id": 101, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68524": { "category_2_x_pharmacy.id": 68524, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "87428": { "category_2_x_pharmacy.id": 87428, "category_2.id": 9954, "category_2.ts": "2018-01-11 21:17:09", "category_2.title": "Belvedere", "category_2.latitude": 51.4849999999999994315658113919198513031005859375, "category_2.longitude": 0.1479999999999999926725280374739668332040309906005859375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "215227": { "category_2_x_pharmacy.id": 215227, "category_2.id": 35155, "category_2.ts": "2018-01-13 11:05:30", "category_2.title": "West Heath, Greater London", "category_2.latitude": 51.48100000000000164845914696343243122100830078125, "category_2.longitude": 0.12800000000000000266453525910037569701671600341796875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "651": { "pharmacy_x_hour.id": 651, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "650": { "pharmacy_x_hour.id": 650, "hour.id": 27, "hour.ts": "2018-01-11 22:10:13", "hour.key": "Saturday", "hour.value": "09:00 - 17:30" }, "645": { "pharmacy_x_hour.id": 645, "hour.id": 64, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Monday", "hour.value": "09:00 - 13:00" }, "646": { "pharmacy_x_hour.id": 646, "hour.id": 65, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Tuesday", "hour.value": "09:00 - 13:00" }, "647": { "pharmacy_x_hour.id": 647, "hour.id": 66, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Wednesday", "hour.value": "09:00 - 13:00" }, "648": { "pharmacy_x_hour.id": 648, "hour.id": 67, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Thursday", "hour.value": "09:00 - 13:00" }, "649": { "pharmacy_x_hour.id": 649, "hour.id": 68, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Friday", "hour.value": "09:00 - 13:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "102": { "pharmacy.id": 102, "pharmacy.ts": "2018-01-11 22:25:56", "pharmacy.title": "Access Pharmacy", "pharmacy.phone": "020 83106482", "pharmacy.street_address": "38 Grovebury Road, Abbey Wood", "pharmacy.address_locality": "London", "pharmacy.address_region": "", "pharmacy.postal_code": "SE2 9BB", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "102": { "category_2_x_pharmacy.id": 102, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68520": { "category_2_x_pharmacy.id": 68520, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" } }, "pharmacy.pharmacy_x_hour_id": { "658": { "pharmacy_x_hour.id": 658, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "657": { "pharmacy_x_hour.id": 657, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "652": { "pharmacy_x_hour.id": 652, "hour.id": 652, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Monday", "hour.value": "09:00 - 19:00" }, "653": { "pharmacy_x_hour.id": 653, "hour.id": 653, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Tuesday", "hour.value": "09:00 - 19:00" }, "654": { "pharmacy_x_hour.id": 654, "hour.id": 654, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Wednesday", "hour.value": "09:00 - 19:00" }, "655": { "pharmacy_x_hour.id": 655, "hour.id": 655, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Thursday", "hour.value": "09:00 - 19:00" }, "656": { "pharmacy_x_hour.id": 656, "hour.id": 656, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Friday", "hour.value": "09:00 - 19:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "103": { "pharmacy.id": 103, "pharmacy.ts": "2018-01-11 22:26:02", "pharmacy.title": "Brownes Chemist", "pharmacy.phone": "020 83108238", "pharmacy.street_address": "208 Yarnton Way, Erith", "pharmacy.address_locality": ", DA18 4DR", "pharmacy.address_region": "", "pharmacy.postal_code": "DA18 4DR", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "103": { "category_2_x_pharmacy.id": 103, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68521": { "category_2_x_pharmacy.id": 68521, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "87426": { "category_2_x_pharmacy.id": 87426, "category_2.id": 9954, "category_2.ts": "2018-01-11 21:17:09", "category_2.title": "Belvedere", "category_2.latitude": 51.4849999999999994315658113919198513031005859375, "category_2.longitude": 0.1479999999999999926725280374739668332040309906005859375, "category_1.id": 2, "category_1.ts": "2018-01-10 22:15:13", "category_1.title": "B" }, "215233": { "category_2_x_pharmacy.id": 215233, "category_2.id": 35155, "category_2.ts": "2018-01-13 11:05:30", "category_2.title": "West Heath, Greater London", "category_2.latitude": 51.48100000000000164845914696343243122100830078125, "category_2.longitude": 0.12800000000000000266453525910037569701671600341796875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "665": { "pharmacy_x_hour.id": 665, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "664": { "pharmacy_x_hour.id": 664, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "659": { "pharmacy_x_hour.id": 659, "hour.id": 232, "hour.ts": "2018-01-11 22:15:07", "hour.key": "Monday", "hour.value": "" }, "660": { "pharmacy_x_hour.id": 660, "hour.id": 233, "hour.ts": "2018-01-11 22:15:07", "hour.key": "Tuesday", "hour.value": "" }, "661": { "pharmacy_x_hour.id": 661, "hour.id": 234, "hour.ts": "2018-01-11 22:15:07", "hour.key": "Wednesday", "hour.value": "" }, "662": { "pharmacy_x_hour.id": 662, "hour.id": 235, "hour.ts": "2018-01-11 22:15:07", "hour.key": "Thursday", "hour.value": "" }, "663": { "pharmacy_x_hour.id": 663, "hour.id": 236, "hour.ts": "2018-01-11 22:15:07", "hour.key": "Friday", "hour.value": "" } }, "pharmacy.pharmacy_x_review_id": {} }, "104": { "pharmacy.id": 104, "pharmacy.ts": "2018-01-11 22:26:07", "pharmacy.title": "Browne Af Ltd", "pharmacy.phone": "020 8310 4149", "pharmacy.street_address": "174 Eynsham Drive, Abbey Wood", "pharmacy.address_locality": "London", "pharmacy.address_region": "", "pharmacy.postal_code": "SE2 9PT", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "104": { "category_2_x_pharmacy.id": 104, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68523": { "category_2_x_pharmacy.id": 68523, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "215235": { "category_2_x_pharmacy.id": 215235, "category_2.id": 35155, "category_2.ts": "2018-01-13 11:05:30", "category_2.title": "West Heath, Greater London", "category_2.latitude": 51.48100000000000164845914696343243122100830078125, "category_2.longitude": 0.12800000000000000266453525910037569701671600341796875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "672": { "pharmacy_x_hour.id": 672, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "666": { "pharmacy_x_hour.id": 666, "hour.id": 64, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Monday", "hour.value": "09:00 - 13:00" }, "667": { "pharmacy_x_hour.id": 667, "hour.id": 65, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Tuesday", "hour.value": "09:00 - 13:00" }, "668": { "pharmacy_x_hour.id": 668, "hour.id": 66, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Wednesday", "hour.value": "09:00 - 13:00" }, "669": { "pharmacy_x_hour.id": 669, "hour.id": 67, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Thursday", "hour.value": "09:00 - 13:00" }, "670": { "pharmacy_x_hour.id": 670, "hour.id": 68, "hour.ts": "2018-01-11 22:10:46", "hour.key": "Friday", "hour.value": "09:00 - 13:00" }, "671": { "pharmacy_x_hour.id": 671, "hour.id": 167, "hour.ts": "2018-01-11 22:13:57", "hour.key": "Saturday", "hour.value": "09:00 - 17:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "105": { "pharmacy.id": 105, "pharmacy.ts": "2018-01-11 22:26:11", "pharmacy.title": "The Neem Tree Pharmacy", "pharmacy.phone": "020 83119003", "pharmacy.street_address": "110 Mcleod Road, Abbey Wood", "pharmacy.address_locality": "London", "pharmacy.address_region": "", "pharmacy.postal_code": "SE2 0BS", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "105": { "category_2_x_pharmacy.id": 105, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "19079": { "category_2_x_pharmacy.id": 19079, "category_2.id": 1911, "category_2.ts": "2018-01-25 01:02:47", "category_2.title": "East Wickham", "category_2.latitude": 51.47399999999999664623828721232712268829345703125, "category_2.longitude": 0.11200000000000000233146835171282873488962650299072265625, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "68525": { "category_2_x_pharmacy.id": 68525, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "215229": { "category_2_x_pharmacy.id": 215229, "category_2.id": 35155, "category_2.ts": "2018-01-13 11:05:30", "category_2.title": "West Heath, Greater London", "category_2.latitude": 51.48100000000000164845914696343243122100830078125, "category_2.longitude": 0.12800000000000000266453525910037569701671600341796875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "679": { "pharmacy_x_hour.id": 679, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "676": { "pharmacy_x_hour.id": 676, "hour.id": 46, "hour.ts": "2018-01-11 22:10:30", "hour.key": "Thursday", "hour.value": "09:00 - 18:00" }, "673": { "pharmacy_x_hour.id": 673, "hour.id": 652, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Monday", "hour.value": "09:00 - 19:00" }, "674": { "pharmacy_x_hour.id": 674, "hour.id": 653, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Tuesday", "hour.value": "09:00 - 19:00" }, "675": { "pharmacy_x_hour.id": 675, "hour.id": 654, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Wednesday", "hour.value": "09:00 - 19:00" }, "677": { "pharmacy_x_hour.id": 677, "hour.id": 656, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Friday", "hour.value": "09:00 - 19:00" }, "678": { "pharmacy_x_hour.id": 678, "hour.id": 678, "hour.ts": "2018-01-11 22:26:11", "hour.key": "Saturday", "hour.value": "09:00 - 18:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "106": { "pharmacy.id": 106, "pharmacy.ts": "2018-01-11 22:26:15", "pharmacy.title": "Worthcare Ltd", "pharmacy.phone": "020 8333 5007", "pharmacy.street_address": "Gallions Reach Health Ctr, Bentham Road, Thamesmead", "pharmacy.address_locality": "London", "pharmacy.address_region": "", "pharmacy.postal_code": "SE28 8BE", "pharmacy.rating": "5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "106": { "category_2_x_pharmacy.id": 106, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68519": { "category_2_x_pharmacy.id": 68519, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "115900": { "category_2_x_pharmacy.id": 115900, "category_2.id": 13605, "category_2.ts": "2018-01-12 04:19:08", "category_2.title": "Creekmouth", "category_2.latitude": 51.51700000000000301270119962282478809356689453125, "category_2.longitude": 0.10199999999999999344968415471157641150057315826416015625, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" } }, "pharmacy.pharmacy_x_hour_id": { "686": { "pharmacy_x_hour.id": 686, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "685": { "pharmacy_x_hour.id": 685, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "680": { "pharmacy_x_hour.id": 680, "hour.id": 106, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Monday", "hour.value": "08:30 - 13:00" }, "681": { "pharmacy_x_hour.id": 681, "hour.id": 107, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Tuesday", "hour.value": "08:30 - 13:00" }, "682": { "pharmacy_x_hour.id": 682, "hour.id": 108, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Wednesday", "hour.value": "08:30 - 13:00" }, "683": { "pharmacy_x_hour.id": 683, "hour.id": 109, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Thursday", "hour.value": "08:30 - 13:00" }, "684": { "pharmacy_x_hour.id": 684, "hour.id": 110, "hour.ts": "2018-01-11 22:11:49", "hour.key": "Friday", "hour.value": "08:30 - 13:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "107": { "pharmacy.id": 107, "pharmacy.ts": "2018-01-11 22:26:22", "pharmacy.title": "Sogim Pharmacy", "pharmacy.phone": "020 83110636", "pharmacy.street_address": "9 Wickham Lane, Abbey Wood, London", "pharmacy.address_locality": "LONDON", "pharmacy.address_region": "", "pharmacy.postal_code": "SE2 0XJ", "pharmacy.rating": "", "pharmacy.category_2_x_pharmacy_id": { "107": { "category_2_x_pharmacy.id": 107, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "19077": { "category_2_x_pharmacy.id": 19077, "category_2.id": 1911, "category_2.ts": "2018-01-25 01:02:47", "category_2.title": "East Wickham", "category_2.latitude": 51.47399999999999664623828721232712268829345703125, "category_2.longitude": 0.11200000000000000233146835171282873488962650299072265625, "category_1.id": 5, "category_1.ts": "2018-01-10 22:15:35", "category_1.title": "E" }, "68528": { "category_2_x_pharmacy.id": 68528, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "180752": { "category_2_x_pharmacy.id": 180752, "category_2.id": 28501, "category_2.ts": "2018-01-13 00:23:30", "category_2.title": "Plumstead, Greater London", "category_2.latitude": 51.4849999999999994315658113919198513031005859375, "category_2.longitude": 0.0869999999999999940047956670241546817123889923095703125, "category_1.id": 16, "category_1.ts": "2018-01-10 22:22:40", "category_1.title": "P" }, "215234": { "category_2_x_pharmacy.id": 215234, "category_2.id": 35155, "category_2.ts": "2018-01-13 11:05:30", "category_2.title": "West Heath, Greater London", "category_2.latitude": 51.48100000000000164845914696343243122100830078125, "category_2.longitude": 0.12800000000000000266453525910037569701671600341796875, "category_1.id": 23, "category_1.ts": "2018-01-10 22:23:36", "category_1.title": "W" } }, "pharmacy.pharmacy_x_hour_id": { "693": { "pharmacy_x_hour.id": 693, "hour.id": 7, "hour.ts": "2018-01-11 22:09:53", "hour.key": "Sunday", "hour.value": "" }, "692": { "pharmacy_x_hour.id": 692, "hour.id": 97, "hour.ts": "2018-01-11 22:11:26", "hour.key": "Saturday", "hour.value": "" }, "687": { "pharmacy_x_hour.id": 687, "hour.id": 652, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Monday", "hour.value": "09:00 - 19:00" }, "688": { "pharmacy_x_hour.id": 688, "hour.id": 653, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Tuesday", "hour.value": "09:00 - 19:00" }, "689": { "pharmacy_x_hour.id": 689, "hour.id": 654, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Wednesday", "hour.value": "09:00 - 19:00" }, "690": { "pharmacy_x_hour.id": 690, "hour.id": 655, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Thursday", "hour.value": "09:00 - 19:00" }, "691": { "pharmacy_x_hour.id": 691, "hour.id": 656, "hour.ts": "2018-01-11 22:25:56", "hour.key": "Friday", "hour.value": "09:00 - 19:00" } }, "pharmacy.pharmacy_x_review_id": {} }, "108": { "pharmacy.id": 108, "pharmacy.ts": "2018-01-11 22:26:31", "pharmacy.title": "Morrison Pharmacy", "pharmacy.phone": "020 83106585", "pharmacy.street_address": "2 Twin Tumps Way, Thamesmead, London", "pharmacy.address_locality": ", SE28 8RD", "pharmacy.address_region": "", "pharmacy.postal_code": "SE28 8RD", "pharmacy.rating": "3.5 out of 5", "pharmacy.category_2_x_pharmacy_id": { "108": { "category_2_x_pharmacy.id": 108, "category_2.id": 13, "category_2.ts": "2018-01-14 22:29:02", "category_2.title": "Abbey Wood", "category_2.latitude": 51.493999999999999772626324556767940521240234375, "category_2.longitude": 0.120999999999999996447286321199499070644378662109375, "category_1.id": 1, "category_1.ts": "2018-01-10 22:15:08", "category_1.title": "A" }, "68522": { "category_2_x_pharmacy.id": 68522, "category_2.id": 6860, "category_2.ts": "2018-01-11 16:53:01", "category_2.title": "Thamesmead", "category_2.latitude": 51.50399999999999778310666442848742008209228515625, "category_2.longitude": 0.11999999999999999555910790149937383830547332763671875, "category_1.id": 20, "category_1.ts": "2018-01-10 22:23:14", "category_1.title": "T" }, "115899": { "category_2_x_pharmacy.id": 115899, "category_2.id": 13605, "category_2.ts": "2018-01-12 04:19:08", "category_2.title": "Creekmouth", "category_2.latitude": 51.51700000000000301270119962282478809356689453125, "category_2.longitude": 0.10199999999999999344968415471157641150057315826416015625, "category_1.id": 3, "category_1.ts": "2018-01-10 22:15:23", "category_1.title": "C" } }, "pharmacy.pharmacy_x_hour_id": { "700": { "pharmacy_x_hour.id": 700, "hour.id": 21, "hour.ts": "2018-01-11 22:10:09", "hour.key": "Sunday", "hour.value": "10:00 - 16:00" }, "694": { "pharmacy_x_hour.id": 694, "hour.id": 694, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Monday", "hour.value": "08:30 - 14:00" }, "695": { "pharmacy_x_hour.id": 695, "hour.id": 695, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Tuesday", "hour.value": "08:30 - 14:00" }, "696": { "pharmacy_x_hour.id": 696, "hour.id": 696, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Wednesday", "hour.value": "08:30 - 14:00" }, "697": { "pharmacy_x_hour.id": 697, "hour.id": 697, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Thursday", "hour.value": "08:30 - 14:00" }, "698": { "pharmacy_x_hour.id": 698, "hour.id": 698, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Friday", "hour.value": "08:30 - 14:00" }, "699": { "pharmacy_x_hour.id": 699, "hour.id": 699, "hour.ts": "2018-01-11 22:26:31", "hour.key": "Saturday", "hour.value": "08:00 - 14:00" } }, "pharmacy.pharmacy_x_review_id": { "58": { "pharmacy_x_review.id": 58, "review.id": 58, "review.ts": "2018-01-11 22:26:31", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "The staff at this Chemst are helpful and have time for giving advice if needed so as not to waste a valuable GP appointment for trivial m...", "review.date": "21 December 2017" }, "59": { "pharmacy_x_review.id": 59, "review.id": 59, "review.ts": "2018-01-11 22:26:31", "review.rating": "Rating 5 out of 5 stars -", "review.reviewtext": "I have lived in Thamesmead area for the past 8 yrs and on many occasions i have been attended to by a particular member of staff at Mor...", "review.date": "15 December 2017" }, "60": { "pharmacy_x_review.id": 60, "review.id": 60, "review.ts": "2018-01-11 22:26:31", "review.rating": "I reviewed it -", "review.reviewtext": "I was told by a staff member to call on the telephone one week before me medication expires to arrange for a repeat prescription. Have no...", "review.date": "3 November 2017" }, "61": { "pharmacy_x_review.id": 61, "review.id": 61, "review.ts": "2018-01-11 22:26:31", "review.rating": "Rating 2 out of 5 stars -", "review.reviewtext": "I called the pharmacy at 13.55 to check if my prescription was ready for collection, a very rude person answered the phone to say they co...", "review.date": "15 August 2017" }, "62": { "pharmacy_x_review.id": 62, "review.id": 62, "review.ts": "2018-01-11 22:26:31", "review.rating": "Rating 1 out of 5 stars -", "review.reviewtext": "Do make sure you get a receipt when leaving a repeat prescription to be collected because I was told today (27.11.16) that the prescript...", "review.date": "27 November 2016" } } } } } }