home / nhsadmin

Dispensaries

Data source: OUseful Databeat

16,865 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, Status Code, Organisation Sub-Type Code, Amended Record Indicator

Link rowid Organisation Code Name National Grouping High Level Health Geography Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Postcode Open Date Close Date Status Code Organisation Sub-Type Code Parent Organisation Code Join Parent Date Left Parent Date Contact Telephone Number Amended Record Indicator Current Care Organisation
1 FA002 ROWLANDS PHARMACY Y54 Q83 61 ARUNDEL AVENUE HAZEL GROVE STOCKPORT     SK7 5LD 2006-06-01 00:00:00   A 1 P79D 2006-06-01 00:00:00   0161 4838729 0 Q83
2 FA007 ROWLANDS PHARMACY Y55 Q79 10,10A & 10B BENTALLS CTR COLCHESTER ROAD HEYBRIDGE, MALDON     CM9 4GD 2008-03-01 00:00:00   A 1 P79D 2008-03-01 00:00:00   01621 850559 0 Q79
3 FA008 BOOTS UK LIMITED Y54 Q72 49-51 THE MERRION CENTRE LEEDS       LS2 8DB 1996-01-15 00:00:00   A 1 P08F 2004-04-01 00:00:00   0113 2428194 0 Q72
4 FA012 MEDICHEM Y56 Q71 100 WHITEHORSE LANE STEPNEY LONDON     E1 4LR 2003-07-01 00:00:00   A 1 P203 2004-04-01 00:00:00   020 77903310 0 Q71
5 FA015 HEADCORN PHARMACY Y57 Q81 HEADCORN SURGERY GRIGG LANE, HEADCORN ASHFORD KENT   TN27 9AA 2007-11-01 00:00:00   A 1 P1EK 2007-11-01 00:00:00   01622 890758 0 Q81
6 FA020 LLOYDSPHARMACY Y54 Q72 55A NEWBEGIN HORNSEA EAST RIDING OF YORKSHIRE     HU18 1AB 2008-07-01 00:00:00   A 1 P07F 2008-07-01 00:00:00   024 76432113 1 Q72
7 FA026 GRENDON PHARMACY Y55 Q77 150 BOOT HILL   BADDESLEY ENSOR WARWICKSHIRE   CV9 2EW 2011-05-25 00:00:00   A 1 P3JW 2011-05-25 00:00:00     0 Q77
8 FA027 BENSON PHARMACY Y52 Q38 23 HIGH STREET BENSON OXFORDSHIRE     OX10 6RP 2002-11-19 00:00:00 2007-06-30 00:00:00 C 1 P28H 2004-04-01 00:00:00 2007-06-30 00:00:00 01491 838686 0 5QE
9 FA029 ROWLANDS PHARMACY Y57 Q70 294 LONDON ROAD NORTH END PORTSMOUTH HAMPSHIRE   PO2 9JN 2006-06-01 00:00:00   A 1 P79D 2006-06-01 00:00:00   02392 660534 0 Q70
10 FA031 BRIDGEGATE CHEMIST Y54 Q72 54 BRIDGEGATE RETFORD NOTTINGHAMSHIRE     DN22 7UZ 1991-08-19 00:00:00   A 1 P0A7 2004-04-01 00:00:00   01777 703299 0 Q72
11 FA035 CELTIC POINT PHARMACY Y54 Q51 6 CELTIC POINT RAYMOTH LANE WORKSOP NOTTINGHAMSHIRE   S81 7AZ 2013-09-09 00:00:00 2013-11-30 00:00:00 C 1 P3E6 2013-09-09 00:00:00 2013-11-30 00:00:00 01909 482566 0 Q51
12 FA037 NEWLINE PHARMACY Y54 Q74 DEREHAM TERRACE DUNROAMIN HOUSE STAKEFORD NORTHUMBERLAND   NE62 5UR 2010-01-04 00:00:00   A 1 P3L1 2016-04-27 00:00:00   01670 520222 0 Q74
13 FA040 NITON PHARMACY Y57 Q70 HIGH STREET NITON VENTNOR ISLE OF WIGHT   PO38 2AZ 2013-04-02 00:00:00   A 1 P05F 2013-04-02 00:00:00   01983 730240 0 Q70
14 FA041 WELL Y57 Q80 1-5 PALACE AVENUE PAIGNTON DEVON     TQ3 3EF 2007-04-02 00:00:00   A 1 P25P 2007-04-02 00:00:00   01803 559015 0 Q80
15 FA042 LLOYDSPHARMACY Y55 Q79 20 GREAT WHYTE RAMSEY HUNTINGDON CAMBRIDGESHIRE   PE26 1HA 1989-02-01 00:00:00   A 1 P07F 2004-04-01 00:00:00     0 Q79
16 FA044 COASTAL PHARMACY Y54 Q84 1 HEYSHAM ROAD HEYSHAM MORECAMBE     LA3 1DA 2004-04-01 00:00:00   A 1 P36E 2004-04-01 00:00:00   01524 412275 0 Q84
17 FA049 FA STRANGE CHEMIST Y56 Q71 185 LOWER CLAPTON ROAD LONDON       E5 8EQ 2004-04-23 00:00:00   A 1 P33C 2004-04-23 00:00:00   020 89852795 0 Q71
18 FA050 LLOYDSPHARMACY Y53 Q36 GREEN LANES SURGERY 808 GREEN LANES WINCHMORE HILL LONDON   N21 2SA 2007-06-01 00:00:00 2012-10-31 00:00:00 C 1 P07F 2007-06-01 00:00:00 2012-10-31 00:00:00 020 83508350 0 5C1
19 FA052 INSTORE PHARMACY Y56 Q71 TESCO SUPERSTORE BRIDGE ROAD RAINHAM ESSEX   RM13 9YZ 1995-05-01 00:00:00   A 1 P29F 2004-04-01 00:00:00   01708 797649 0 Q71
20 FA053 BOOTS UK LIMITED Y56 Q71 73 PICCADILLY LONDON       W1J 8HS 1989-05-01 00:00:00   A 1 P08F 2004-04-01 00:00:00   020 74092982 0 Q71
21 FA056 LLOYDS PHARMACY LTD Y55 Q79 WILLIAM FROST WAY COSTESSEY NORWICH NORFOLK   NR5 0JS 2006-10-12 00:00:00   A 1 P07F 2016-09-09 00:00:00     0 Q79
22 FA057 HESWALL HILLS PHARMACY Y54 Q75 119 BRIMSTAGE ROAD HESWALL WIRRAL MERSEYSIDE   CH60 1XF 2006-08-01 00:00:00   A 1 P0R5 2006-08-01 00:00:00   0151 3424385 0 Q75
23 FA058 WM MORRISON SUPERMARKETS PLC Y55 Q76 FESTIVAL WAY FESTIVAL PARK HANLEY STOKE-ON-TRENT   ST1 5NY 2010-05-17 00:00:00   A 1 P0L6 2010-05-17 00:00:00   01782 262201 0 Q76
24 FA061 ADEL PHARMACY Y51 Q32 141 LONG CAUSEWAY ADEL LEEDS     LS16 8EX 2006-09-01 00:00:00 2007-05-31 00:00:00 C 1 P0RL 2006-09-01 00:00:00 2007-05-31 00:00:00 0113 2300351 0 5N1
25 FA065 WELL WOODFORD - JUBILEE PARADE Y56 Q71 2 JUBILEE PARADE SNAKES LANE WOODFORD GREEN ESSEX   IG8 7QF 1948-01-01 00:00:00   A 1 P30F 2004-04-01 00:00:00   020 85040121 0 Q71
26 FA066 SINGLEWELL PHARMACY Y57 Q81 133 SINGLEWELL ROAD GRAVESEND KENT     DA11 7QA 1987-03-01 00:00:00   A 1 P0CL 2004-04-01 00:00:00   01474 533674 0 Q81
27 FA071 O'NEILL WP Y43 Q02 89-91 SOUTH STREET BISHOPS STORTFORD HERTFORDSHIRE     CM23 3BG 1948-01-01 00:00:00 2005-01-15 00:00:00 C 2       01279 654172 0 5GK
28 FA076 BOOTS UK LIMITED Y55 Q76 1 COOPERS SQUARE BURTON-ON-TRENT STAFFORDSHIRE     DE14 1DG 1974-01-01 00:00:00   A 1 P08F 2004-04-01 00:00:00     0 Q76
29 FA078 FAIRVIEW PHARMACY Y56 Q71 293-5 BURNT OAK BROADWAY   EDGWARE MIDDLESEX   HA8 5ED 2012-07-01 00:00:00   A 1 P1R7 2012-07-01 00:00:00   020 89510542 0 Q71
30 FA079 KING STREET PHARMACY Y57 Q80 140 KING STREET STONEHOUSE PLYMOUTH DEVON   PL1 5JE 2004-12-01 00:00:00   A 1 P057 2004-12-08 00:00:00   01752 662712 0 Q80
31 FA083 BOUNCE CHEMIST Y54 Q75 18 PRESCOT ROAD FAIRFIELD LIVERPOOL     L7 0LQ 2015-04-01 00:00:00   A 1 P1YV 2015-04-01 00:00:00   0151 5463057 0 Q75
32 FA084 BOOTS UK LIMITED Y56 Q71 UNIT 8 TOWER RETAIL PARK CRAYFORD KENT   DA1 4LD 2005-06-01 00:00:00   A 1 P08F 2005-06-01 00:00:00   01322 315864 0 Q71
33 FA086 LLOYDSPHARMACY Y55 Q77 396 LONG LANE ROWLEY REGIS WARLEY WEST MIDLANDS   B65 0JE 1989-12-01 00:00:00 2016-09-30 00:00:00 C 1 P07F 2004-04-01 00:00:00 2016-09-30 00:00:00 0121 5592579 0 Q77
34 FA088 ASDA PHARMACY Y57 Q81 CROWHURST ROAD OFF CARDEN AVENUE HOLLINGBURY,BRIGHTON EAST SUSSEX   BN1 8AS 2001-04-21 00:00:00   A 1 P10F 2004-04-01 00:00:00   01273 542314 0 Q81
35 FA089 SAI CHEMISTS Y56 Q71 56 HESSEL STREET     LONDON   E1 2LP 2006-06-05 00:00:00   A 1 P591 2006-06-05 00:00:00   020 74884970 0 Q71
36 FA090 HEATHBROOK PHARMACY Y55 Q78 10 ARNOLDS CRESCENT NEWBOLD VERDON LEICESTER     LE9 9LD 2000-11-01 00:00:00   A 1 P368 2004-04-01 00:00:00   01455 822779 0 Q78
37 FA094 KAMSONS PHARMACY Y57 Q81 14 BRIGHTON ROAD CRAWLEY WEST SUSSEX     RH10 6AA 2011-08-30 00:00:00   A 1 P11F 2011-08-30 00:00:00   01293 527206 0 Q81
38 FA099 PHARMA KARMA Y51 Q31 123 DEANSGATE MANCHESTER       M3 2BY 2003-09-01 00:00:00 2010-01-31 00:00:00 C 1 P65R 2004-04-01 00:00:00 2010-01-31 00:00:00 0161 8349567 0 5NT
39 FA104 MORRILL PHARMACY Y54 Q72 312 HOLDERNESS ROAD HULL       HU9 3DA 2009-03-28 00:00:00   A 1 P2NF 2009-03-28 00:00:00   01482 320362 0 Q72
40 FA111 LLOYDSPHARMACY Y56 Q71 1-15 THE BREWERY WATERLOO ROAD ROMFORD     RM1 1AU 2007-09-07 00:00:00   A 1 P07F 2016-09-09 00:00:00   01708 767953 0 Q71
41 FA112 ALLIANCE PHARMACY Y51 Q34 1B LOWESMOOR TERRACE WORCESTER       WR1 2RX 1998-12-21 00:00:00 2008-03-31 00:00:00 C 1 P26F 2004-04-01 00:00:00 2008-03-31 00:00:00 01905 20727 0 5PL
42 FA114 ROWLANDS PHARMACY Y54 Q74 LAWSON STREET HEALTH CENT LAWSON STREET STOCKTON     TS18 1HU 2003-10-06 00:00:00   A 1 P79D 2004-04-01 00:00:00   01642 613533 0 Q74
43 FA116 DAY LEWIS PHARMACY Y57 Q70 22 CARISBROOKE HIGH ST CARISBROOKE NEWPORT ISLE OF WIGHT   PO30 1NR 2012-08-01 00:00:00   A 1 P45V 2012-08-01 00:00:00   01983 525216 0 Q70
44 FA119 LINTHORNS LTD Y51 Q34 104 WEOLEY CASTLE SQUARE SELLY OAK BIRMINGHAM     B29 5PT 1948-01-01 00:00:00 2007-04-17 00:00:00 C 1 P41Q 2004-04-01 00:00:00 2007-04-17 00:00:00 0121 4751822 0 5M1
45 FA121 TESCO INSTORE PHARMACY Y54 Q74 ST HELEN AUCKLAND IND EST BISHOP AUCKLAND COUNTY DURHAM     DL14 9AB 2011-01-17 00:00:00   A 1 P29F 2011-01-17 00:00:00   01388 448847 0 Q74
46 FA127 MEDICAL SPECIALISTS PHARMACY Y54 Q83 WESTMINSTER HOUSE 49 KNOWSLEY STREET BURY LANCASHSHIRE   BL9 0ST 2012-04-02 00:00:00   A 1 P1M0 2012-04-02 00:00:00   0161 7629108 0 Q83
47 FA129 YOUR LOCAL BOOTS PHARMACY Y57 Q80 55 VICARAGE ROAD ST AGNES CORNWALL     TR5 0TH 2007-06-01 00:00:00   A 1 P08F 2007-06-01 00:00:00   01872 552340 0 Q80
48 FA130 BROADHEATH PHARMACY Y51 Q31 70 MANCHESTER ROAD BROADHEATH ALTRINCHAM CHESHIRE   WA14 4PJ 2010-06-14 00:00:00 2013-01-06 00:00:00 C 1 P2MX 2010-06-14 00:00:00 2013-01-06 00:00:00 0161 9297144 0 5NR
49 FA131 ASDA STORES LTD Y54 Q72 HOLT ROAD HOLT PARK LEEDS WEST YORKSHIRE   LS16 7RY 2011-06-06 00:00:00   A 1 P10F 2011-06-06 00:00:00   0113 2699719 0 Q72
50 FA133 WARD MOBILITY LIMITED Y55 Q79 353 LONG ROAD CANVEY ISLAND ESSEX     SS8 0JQ 2012-04-01 00:00:00   A 2       01268 511111 0 Q79
51 FA137 WYKEN PHARMACY Y55 Q77 13-17 BRIXHAM DRIVE COVENTRY   WEST MIDLANDS   CV2 3LA 2010-02-01 00:00:00   A 1 P2WE 2010-02-01 00:00:00     0 Q77
52 FA141 SAVILE TOWN PHARMACY Y54 Q72 THE SIDINGS DEWSBURY WEST YORKSHIRE     WF12 9QU 2012-09-03 00:00:00   A 1 P0YJ 2012-09-03 00:00:00   01924 454729 0 Q72
53 FA150 MEDWAY PHARMACY Y56 Q71 18 MEDWAY PARADE MEDWAY VILLAGE, PERIVALE GREENFORD MIDDLESEX   UB6 8HR 2007-10-01 00:00:00   A 1 P1EF 2007-10-01 00:00:00   020 89975257 0 Q71
54 FA151 GREENFIELDS PHARMACY Y56 Q71 126 KENTISH TOWN ROAD LONDON       NW1 9QB 1999-05-01 00:00:00   A 1 P05F 2004-04-01 00:00:00   020 74853851 0 Q71
55 FA152 CHALLIS PHARMACY Y55 Q57 35 MASEFIELD ROAD BRAINTREE ESSEX     CM7 1AA 2012-12-01 00:00:00 2013-09-30 00:00:00 C 1 P2TM 2012-12-01 00:00:00 2013-09-30 00:00:00 01376 330500 0 Q57
56 FA163 ECCLESHALL PHARMACY Y55 Q76 8 HIGH STREET ECCLESHALL STAFFORD     ST21 6BZ 1993-08-09 00:00:00   A 1 P366 2004-04-01 00:00:00   01785 850057 0 Q76
57 FA164 J G DAWSON Y41 Q09 TRINITY MEDICAL CENTRE NEW GEORGE STREET SOUTH SHIELDS     NE33 5DU 1989-01-01 00:00:00 2004-11-01 00:00:00 C 1 P95H 2004-04-01 00:00:00 2004-11-01 00:00:00 0191 4271850 0 5KG
58 FA166 LLOYDSPHARMACY Y54 Q72 74 BUCHANAN ROAD PARSON CROSS SHEFFIELD     S5 8AL 1998-01-01 00:00:00   A 1 P07F 2004-04-01 00:00:00   0114 2400390 0 Q72
59 FA167 LLOYDSPHARMACY Y57 Q80 71 MAGDALEN ROAD EXETER       EX2 4TA 1948-01-01 00:00:00   A 1 P07F 2004-04-01 00:00:00   01392 273157 0 Q80
60 FA176 WELL CARLISLE - BLACKWELL ROAD Y54 Q74 28 BLACKWELL ROAD CARLISLE CUMBRIA     CA2 4EQ 1948-01-01 00:00:00   A 1 P0MG 2017-04-01 00:00:00   01228 522015 1 Q74
61 FA177 LLOYDSPHARMACY Y51 Q34 317 FOX HOLLIES ROAD ACOCKS GREEN BIRMINGHAM     B27 7PS 1948-01-01 00:00:00 2010-02-07 00:00:00 C 1 P07F 2004-04-01 00:00:00 2010-02-07 00:00:00 0121 7071844 0 5PG
62 FA179 HALSALL PHARMACY Y51 Q31 VILLAGE HALL HALSALL ROAD HALSALL WEST LANCASHIRE   L39 8RW 2008-06-02 00:00:00 2010-07-06 00:00:00 C 1 P09H 2008-06-02 00:00:00 2010-07-06 00:00:00 01704 840608 0 5NG
63 FA180 SILVER STREET PHARMACY Y57 Q64 6 SILVER STREET BRADFORD-ON-AVON WILTSHIRE     BA15 1JX 2012-07-06 00:00:00 2015-03-31 00:00:00 C 1 P1QM 2012-07-06 00:00:00 2015-03-31 00:00:00 01225 862212 0 Q64
64 FA182 CHANAS Y44 Q19 125 WORPLESDON ROAD GUILDFORD SURREY     GU2 9XA 2001-02-05 00:00:00 2004-11-01 00:00:00 C 1 P05F 2004-04-01 00:00:00 2004-11-01 00:00:00 01483 561805 0 5L5
65 FA188 WELDRICKS PHARMACY Y54 Q72 28/29 HALLGATE DONCASTER       DN1 3NL 1948-01-01 00:00:00   A 1 P06J 2004-04-01 00:00:00   01302 342338 0 Q72
66 FA190 MOINS CHEMIST Y55 Q78 11-15 COVENTRY ROAD MARKET HARBOROUGH LEICESTERSHIRE     LE16 9BX 2012-11-09 00:00:00   A 1 P1VR 2012-11-09 00:00:00   01858 468545 0 Q78
67 FA193 RAVENOR CHEMIST Y56 Q71 70 THE BROADWAY GREENFORD MIDDLESEX     UB6 9QA 1991-02-01 00:00:00   A 1 P43M 2004-04-01 00:00:00     0 Q71
68 FA194 ROWLANDS PHARMACY Y54 Q75 58 COPPLEHOUSE LANE FAZAKERLEY LIVERPOOL     L10 0AF 1999-03-01 00:00:00   A 1 P79D 2004-04-01 00:00:00   0151 5251160 0 Q75
69 FA196 HARFLEUR CHEMIST Y56 Q71 219 CLAPHAM ROAD LONDON       SW9 9BE 1988-09-01 00:00:00   A 1 P37H 2004-04-01 00:00:00   020 77333331 0 Q71
70 FA200 HOLLOWOOD CHEMIST Y54 Q83 7 INCE GREEN LANE INCE WIGAN LANCASHIRE   WN2 2AR 1948-01-01 00:00:00   A 1 P98P 2004-04-01 00:00:00   01942 245652 0 Q83
71 FA201 STUART MOUL DISPENSING CHEMIST Y52 Q39 14 LOWER STONE CLOSE FRAMPTON COTTERELL BRISTOL     BS36 2LE 1990-08-01 00:00:00 2007-11-30 00:00:00 C 1 P32Q 2004-04-01 00:00:00 2007-11-30 00:00:00 01454 774347 0 5A3
72 FA202 LORDS PHARMACY Y56 Q71 279 KINGSTON ROAD LONDON       SW20 8LB 2010-07-28 00:00:00   A 1 P3D0 2010-07-28 00:00:00   020 85424794 0 Q71
73 FA207 TESCO PHARMACY Y56 Q71 HIGHBRIDGE ROAD BARKING ESSEX     IG11 7BS 2012-08-28 00:00:00   A 1 P29F 2012-08-28 00:00:00   020 38011448 0 Q71
74 FA214 PHARMACY CARE 4 U Y54 Q45 UNIT 1D AVENUE ONE CHILTON IND EST,CHILTON FERRYHILL     DL17 0SF 2013-07-10 00:00:00 2014-03-14 00:00:00 C 1 P2FE 2013-07-10 00:00:00 2014-03-14 00:00:00 01388 722950 0 Q45
75 FA217 CHESTNUT PHARMACY Y54 Q72 THE PHARMACY UNIT CHESTNUT AVENUE,CARCROFT DONCASTER SOUTH YORKSHIRE   DN6 8AG 2012-03-12 00:00:00   A 1 P1J3 2012-03-12 00:00:00   01302 723723 0 Q72
76 FA227 BOOTS UK LIMITED Y55 Q77 EVESHAM RETAIL PARK WORCESTER ROAD EVESHAM WORCESTERSHIRE   WR11 4QR 2010-06-16 00:00:00   A 1 P08F 2010-06-16 00:00:00   0138 648665 0 Q77
77 FA231 WELL ARMLEY - ARMLEY MOOR HC Y54 Q72 STATION ROAD ARMLEY LEEDS     LS12 3EY 1999-12-01 00:00:00   A 1 P30F 2004-04-01 00:00:00   0113 2639606 0 Q72
78 FA242 LLOYDSPHARMACY Y54 Q72 3 INTAKE AVENUE YORK NORTH YORKSHIRE     YO30 6HB 2006-11-01 00:00:00   A 1 P07F 2006-11-01 00:00:00   01904 623472 0 Q72
79 FA244 WALKER CHEMISTS Y56 Q71 6 THE BROADWAY GUNNESBURY LANE ACTON LONDON   W3 8HR 1996-04-22 00:00:00   A 1 P580 2004-04-01 00:00:00   020 89924522 0 Q71
80 FA249 MOSS PHARMACY Y44 Q39 18 VICTORIA STREET BURNHAM-ON-SEA SOMERSET     TA8 1AN 1999-04-01 00:00:00 2007-03-25 00:00:00 C 1 P26F 2004-04-01 00:00:00 2007-03-25 00:00:00 01278 782017 0 5QL
81 FA250 EVERGREEN PHARMACY Y55 Q76 232 HIGHBURY ROAD BULWELL NOTTINGHAM     NG6 9FE 2013-06-03 00:00:00   A 1 P2F6 2013-06-03 00:00:00   0115 9278336 0 Q76
82 FA251 HORIZON PHARMACY Y57 Q80 THE CHAPEL THE COMMON PATCHWAY SOUTH GLOUCESTERSHIRE   BS34 6AS 2015-05-28 00:00:00   A 1 P9VN 2015-05-28 00:00:00   01454 613214 0 Q80
83 FA252 CROSSBELLS PHARMACY Y56 Q71 131 THE VALE ACTON LONDON     W3 7RQ 2003-03-28 00:00:00   A 1 P626 2004-04-01 00:00:00   020 87437354 0 Q71
84 FA253 GORE DENNIS (CHEMISTS) LTD Y42 Q14 26 WHITTAKER LANE PRESTWICH MANCHESTER     M25 1FX 1985-10-01 00:00:00 2005-12-14 00:00:00 C 1 P136 2004-04-01 00:00:00 2005-12-15 00:00:00 0161 7734212 0 5JX
85 FA256 TESCO PHARMACY Y57 Q81 FISHBOURNE ROAD EAST CHICHESTER WEST SUSSEX     PO19 3JT 1995-10-16 00:00:00   A 1 P29F 2004-04-01 00:00:00   01243 227400 0 Q81
86 FA258 ROWLANDS PHARMACY Y54 Q75 2-2A ELEPHANT LANE THATTO HEATH ST.HELENS MERSEYSIDE   WA9 5QG 2002-06-01 00:00:00   A 1 P79D 2004-04-01 00:00:00   01744 818088 0 Q75
87 FA268 BOWBURN PHARMACY LTD Y54 Q74 2 ASH TERRACE   BOWBURN CO DURHAM   DH6 5AS 1994-07-04 00:00:00   A 1 P659 2004-04-01 00:00:00   0191 3773413 0 Q74
88 FA271 BOOTS UK LIMITED Y56 Q71 55 SYDENHAM ROAD LONDON       SE26 5EX 1949-01-01 00:00:00   A 1 P08F 2004-04-01 00:00:00   020 87787651 0 Q71
89 FA272 LLOYDSPHARMACY Y55 Q79 46-47 ARBURY COURT ALEXWOOD ROAD CAMBRIDGE     CB4 2JQ 1992-05-01 00:00:00   A 1 P07F 2004-04-01 00:00:00     0 Q79
90 FA274 CORNWELLS CHEMISTS Y55 Q76 HOLMCROFT PHARMACY HOLMCROFT ROAD STAFFORD     ST16 1JG 1994-12-12 00:00:00   A 1 P72F 2004-04-01 00:00:00     0 Q76
91 FA276 JF EILBECK (CHEMIST) LIMITED Y54 Q74 THE HEALTH CENTRE PRINCE CONSORT ROAD GATESHEAD TYNE & WEAR   NE8 1NB 1985-04-01 00:00:00 2015-08-16 00:00:00 C 1 P064 2004-04-01 00:00:00 2015-08-16 00:00:00 0191 4772280 0 Q74
92 FA286 CLARKE & COLEMAN Y57 Q81 140 HIGH STREET TONBRIDGE KENT     TN9 1BB 1981-09-01 00:00:00   A 1 P74H 2004-04-01 00:00:00     0 Q81
93 FA287 PULSE PHARMACY Y56 Q71 310 CLAPHAM ROAD LONDON       SW9 9AE 1980-01-01 00:00:00   A 1 P69D 2004-04-01 00:00:00   020 76222544 0 Q71
94 FA288 ERLEIGH ROAD PHARMACY Y57 Q82 85-87 ERLEIGH ROAD READING BERKSHIRE     RG1 5NN 2007-07-01 00:00:00   A 1 P0X5 2007-07-01 00:00:00   0118 9663718 0 Q82
95 FA290 BOOTS UK LIMITED Y57 Q82 THE HEALTH CENTRE EAST STREET THAME OXFORDSHIRE   OX9 3JZ 1948-01-01 00:00:00   A 1 P08F 2004-04-01 00:00:00   01844 218248 0 Q82
96 FA295 ROWLANDS PHARMACY Y54 Q83 44 MARKET STREET WESTHOUGHTON BOLTON     BL5 3AN 2001-05-01 00:00:00   A 1 P79D 2004-04-01 00:00:00   01942 812182 0 Q83
97 FA296 BOOTS UK LIMITED Y57 Q80 6 EAST STREET ILMINSTER SOMERSET     TA19 0AJ 1948-01-01 00:00:00   A 1 P08F 2004-04-01 00:00:00   01460 52648 0 Q80
98 FA297 HURCOMB MI Y55 Q77 11 WHEELER STREET LOZELLS BIRMINGHAM     B19 2ER 1986-02-01 00:00:00   A 1 P5AD 2004-04-01 00:00:00   0121 5236803 0 Q77
99 FA306 ROWLANDS PHARMACY Y55 Q78 HAWTHORN ROAD SKEGNESS LINCS     PE25 3TD 2004-08-06 00:00:00   A 1 P9CV 2004-08-06 00:00:00   01754 767312 0 Q78
100 FA307 COHENS CHEMIST Y54 Q84 97 MARKET STREET   CHORLEY LANCASHIRE   PR7 2SQ 2004-12-01 00:00:00   A 1 P438 2004-12-08 00:00:00   01257 262613 0 Q84

Next page

CREATE TABLE "edispensary" (
"Organisation Code" TEXT,
  "Name" TEXT,
  "National Grouping" TEXT,
  "High Level Health Geography" TEXT,
  "Address Line 1" TEXT,
  "Address Line 2" TEXT,
  "Address Line 3" TEXT,
  "Address Line 4" TEXT,
  "Address Line 5" REAL,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Status Code" TEXT,
  "Organisation Sub-Type Code" INTEGER,
  "Parent Organisation Code" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Contact Telephone Number" TEXT,
  "Amended Record Indicator" INTEGER,
  "Current Care Organisation" TEXT
)
Powered by Datasette · Query took 50.276ms · Data source: OUseful Databeat