home / nhsadmin

Pharmacy Headquarters

Data source: OUseful Databeat

5,954 rows

View and edit SQL

This data as .json

Suggested facets: 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 Contact Telephone Number Amended Record Indicator
1 P001 KAYS CHEMIST     24 ROSS ROAD     MAIDENHEAD BERKSHIRE SL6 2SZ 2004-04-01 00:00:00 2007-04-06 00:00:00   0
2 P002 VE LETTSOM CHEMIST     84 VESTRY ROAD CAMBERWELL   LONDON GREATER LONDON SE5 8PQ 2004-04-01 00:00:00     0
3 P003 PEPYS PHARMACY     2 GOLDEN HIND PLACE GROVE STREET   LONDON GREATER LONDON SE8 3QG 2004-04-01 00:00:00     0
4 P004 ALLIED (MIDDLETON) PHARMACY     25 RING ROAD LINGWELL CROFT SURGERY MIDDLETON LEEDS WEST YORKSHIRE LS10 3LT 2004-04-01 00:00:00     0
5 P005 ELM PARK PHARMACY     208 - 212 ELM PARK AVENUE     HORNCHURCH ESSEX RM12 4SD 2004-04-01 00:00:00     0
6 P006 R L ALLISON     56 KINGSLEY PARK TERRACE KINGSLEY   NORTHAMPTON NORTHAMPTONSHIRE NN2 7HH 2004-04-01 00:00:00 2011-06-30 00:00:00   0
7 P007 BAS PHARMACY     24 UPPER TACHBROOK STREET     LONDON GREATER LONDON SW1V 1SW 2004-04-01 00:00:00     0
8 P008 GIBBS & GURNELL     34 UNION STREET     RYDE ISLE OF WIGHT PO33 2LE 2004-04-01 00:00:00 2007-10-31 00:00:00   0
9 P009 AMBA LTD     285 - 287 BROCKLEY ROAD     LONDON GREATER LONDON SE4 2SA 2004-04-01 00:00:00 2004-12-08 00:00:00   0
10 P00A VITALTONE LTD     VITALTONE PHARMACY 14 THE SQUARE   CATERHAM SURREY CR3 6QA 2004-04-01 00:00:00     0
11 P00C J. STEPHEN HAWKINS LTD     149 BURNGREAVE ROAD     SHEFFIELD SOUTH YORKSHIRE S3 9DL 2004-04-01 00:00:00 2007-08-31 00:00:00   0
12 P00D MINSTER PHARMACY     15 SILVER STREET     ILMINSTER SOMERSET TA19 0DH 2004-04-01 00:00:00 2007-03-31 00:00:00   0
13 P00E NETTESWELL PHARMACY     1 PYPERS HATCH     HARLOW ESSEX CM20 3NG 2004-04-01 00:00:00     0
14 P00F JARDINES (UK) LTD     LAKESIDE 2 SHIRWELL CRESCENT FURZTON MILTON KEYNES BUCKINGHAMSHIRE MK4 1GA 2004-04-01 00:00:00     0
15 P00G DUDLEY TAYLOR PHARMACIES LTD     TAYLOR GROUP HOUSE WEDGNOCK INDUSTRIAL ESTATE   WARWICK WARWICKSHIRE CV34 5YA 2004-04-01 00:00:00     0
16 P00H RATEBROOK LTD     221 STOCKPORT ROAD     STOCKPORT CHESHIRE SK3 0RH 2004-04-01 00:00:00 2005-06-01 00:00:00   0
17 P00J R. K. SIRPAL     SIRPAL CHEMIST 274-276 LADYPOOL ROAD   BIRMINGHAM WEST MIDLANDS B12 8JU 2004-04-01 00:00:00     0
18 P00K STAVELEY PHARMACY     6 MARKET PLACE STAVELEY   CHESTERFIELD DERBYSHIRE S43 3UR 2004-04-01 00:00:00     0
19 P00L CHEMYS DISPENSING CHEMISTS     SOVEREIGN HOUSE MILES GRAY ROAD   BASILDON ESSEX SS14 3FR 2004-04-01 00:00:00 2016-06-30 00:00:00   0
20 P00M COLLINS PHARMACY     544 RADFORD ROAD     NOTTINGHAM NOTTINGHAMSHIRE NG7 7EA 2004-04-01 00:00:00 2006-04-28 00:00:00   0
21 P00N MOLEND LTD     64 STATION ROAD     UPMINSTER ESSEX RM14 2TD 2004-04-01 00:00:00     0
22 P00P GOLDSTRANDS PHARMACY     780 FULHAM ROAD     LONDON GREATER LONDON SW6 5SL 2004-04-01 00:00:00     0
23 P00Q TRENT HEALTH PHARMACY LTD     339 ASH BANK ROAD WERRINGTON   STOKE-ON-TRENT STAFFORDSHIRE ST9 0JS 2004-04-01 00:00:00     0
24 P00R RISHI PHARMACY     84 HART RD     BENFLEET ESSEX SS7 3PF 2004-04-01 00:00:00     0
25 P00T NR PATEL CHEMISTS     153 BOWES ROAD     LONDON GREATER LONDON N13 4SE 2004-04-01 00:00:00     0
26 P00V WISE (CHEMIST) LTD     372-374 DICKENSON ROAD     MANCHESTER GREATER MANCHESTER M13 0WQ 2004-04-01 00:00:00     0
27 P00W BEACHTECH LTD     H S CHEMISTS 16 CARLISLE ROAD   BRADFORD WEST YORKSHIRE BD8 8AD 2004-04-01 00:00:00     0
28 P00X ASHFORD LODGE PHARMACY     122 FELTHAM HILL ROAD     ASHFORD MIDDLESEX TW15 2BX 2004-04-01 00:00:00     0
29 P00Y CRAWLEY CHEMISTS LTD     18 HASLETT AVENUE WEST     CRAWLEY WEST SUSSEX RH10 1HS 2004-04-01 00:00:00     0
30 P010 DENTON PHARMACIES     293 DENTON ROAD     NEWCASTLE UPON TYNE TYNE AND WEAR NE15 7HJ 2004-04-01 00:00:00 2006-09-30 00:00:00   0
31 P011 CARE PHARMACEUTICAL LTD     742 - 744 ALUM ROCK ROAD WARD END   BIRMINGHAM WEST MIDLANDS B8 3PP 2004-04-01 00:00:00     0
32 P012 CHARLES FOX LTD     190 HIGH STREET BOSTON SPA   WETHERBY WEST YORKSHIRE LS23 6BT 2004-04-01 00:00:00 2006-06-01 00:00:00   0
33 P013 C & A BRACK LTD     2E THE SQUARE STAMFORD BRIDGE   YORK NORTH YORKSHIRE YO41 1AF 2004-04-01 00:00:00 2010-11-30 00:00:00   0
34 P014 BOURNE PHARMACY LTD     24O UTTOXETER ROAD BLYTHE BRIDGE   STOKE-ON-TRENT STAFFORDSHIRE ST11 9LY 2004-04-01 00:00:00     0
35 P015 ALNEBURGH PHARMACY LTD     ALNEBURGH HOUSE EWANRIGG ROAD   MARYPORT CUMBRIA CA15 8EL 2004-04-01 00:00:00     0
36 P016 BROOK RETAIL LTD     8 WESTBROOK CENTRE GRASSMERE WAY   WATERLOOVILLE HAMPSHIRE PO7 8SE 2004-04-01 00:00:00     0
37 P017 CHEL PHARMACY LTD     173 GREAT PORTLAND STREET     LONDON GREATER LONDON W1W 5PH 2004-04-01 00:00:00     0
38 P018 ACHEASON CHEMIST     273 HIGH ROAD LEYTONSTONE   LONDON GREATER LONDON E11 4HH 2004-04-01 00:00:00     0
39 P019 VILLAGE STREET PHARMACY LTD     217 VILLAGE STREET NORMANTON   DERBY DERBYSHIRE DE23 8DD 2004-04-01 00:00:00     0
40 P01A LAMBERT CHEMIST LTD     LAMBERT CHEMIST 40 HIGH STREET MARKYATE ST. ALBANS HERTFORDSHIRE AL3 8PB 2004-04-01 00:00:00 2008-05-09 00:00:00   0
41 P01C H.V. BRIGGS LTD     1A CROMPTON HOUSE WRITTLE ROAD   CHELMSFORD ESSEX CM1 3RW 2004-04-01 00:00:00 2008-04-30 00:00:00   0
42 P01D S & S PHARMACY     S & S CHEMIST 226 DEANE ROAD   BOLTON LANCASHIRE BL3 5DP 2004-04-01 00:00:00 2011-11-30 00:00:00   0
43 P01E WEST ST.LEONARDS PHARMACY     7 BEXHILL ROAD     ST. LEONARDS-ON-SEA EAST SUSSEX TN38 0AH 2004-04-01 00:00:00 2008-02-29 00:00:00   0
44 P01F RM DRUMMOND (DISPENSING CHEMIST)     71 HALIFAX ROAD     DEWSBURY WEST YORKSHIRE WF13 4HD 2004-04-01 00:00:00 2006-09-10 00:00:00   0
45 P01G DEDHAM PHARMACY LTD     HIGH STREET DEDHAM   COLCHESTER ESSEX CO7 6DE 2004-04-01 00:00:00 2017-02-28 00:00:00   1
46 P01H R.F. GOULD LTD     STONECROFT CHERITON FITZPAINE   CREDITON DEVON EX17 4JA 2004-04-01 00:00:00 2007-02-27 00:00:00   0
47 P01J G. P. ROBERTS LTD     12 ALBERT ROAD     MANCHESTER GREATER MANCHESTER M19 3PJ 2004-04-01 00:00:00     0
48 P01K J WHITMORE LIMITED     8 SHOWELL CIRCUS     WOLVERHAMPTON WEST MIDLANDS WV10 9BA 2004-04-01 00:00:00 2006-02-01 00:00:00   0
49 P01L SHADFORTH PHARMACEUTICALS COMPANY LTD     UNIT 11 ROBJOHNS ROAD   CHELMSFORD ESSEX CM1 3AG 2004-04-01 00:00:00     0
50 P01M HALE VILLAGE PHARMACY     3 IVY FARM COURT TOWN LANE HALE VILLAGE LIVERPOOL MERSEYSIDE L24 4AG 2004-04-01 00:00:00     0
51 P01N BOREHAMWOOD SUPPLIES LTD     7 HOWARD DRIVE     BOREHAMWOOD HERTFORDSHIRE WD6 2NY 2004-04-01 00:00:00     0
52 P01P ARROWBLUE LTD     70-72 WALM LANE     LONDON GREATER LONDON NW2 4RA 2004-04-01 00:00:00 2008-08-31 00:00:00   0
53 P01Q C.J. PARKER- VANTAGE     8 COPMANTHORPE SHOPPING CENTRE COPMANTHORPE   YORK NORTH YORKSHIRE YO23 3UB 2004-04-01 00:00:00 2006-07-01 00:00:00   0
54 P01R KUMRAI VK     E HORNE CHEMIST 235 EDGWARE ROAD   LONDON GREATER LONDON NW9 6LU 2004-04-01 00:00:00 2013-09-01 00:00:00   0
55 P01T J WILLIAMSON CHEMIST     1 MANSTON DRIVE     BISHOP'S STORTFORD HERTFORDSHIRE CM23 5EJ 2004-04-01 00:00:00     0
56 P01V WOLSTENHOLME & MCDIARMID LTD     67 MARKET STREET SHAW   OLDHAM LANCASHIRE OL2 8NP 2004-04-01 00:00:00     0
57 P01W BEN WILSON LTD     GALLAGHERS CHEMISTS 7 AUSTHORPE VIEW   LEEDS WEST YORKSHIRE LS15 8NN 2004-04-01 00:00:00     0
58 P01X RISE PARK PHARMACY     173 RISE PARK PARADE EASTERN AVENUE EAST   ROMFORD ESSEX RM1 4NT 2004-04-01 00:00:00     0
59 P01Y CRISTALS CHEMIST     4 LYNTON PARADE TURNERS HILL CHESHUNT WALTHAM CROSS HERTFORDSHIRE EN8 8LF 2004-04-01 00:00:00     0
60 P020 AMK LOCUMS LTD     3 DELANUNAYS ROAD CRUMPSALL   MANCHESTER GREATER MANCHESTER M8 4QS 2004-04-01 00:00:00 2007-05-31 00:00:00   0
61 P021 CRAY VALLEY PHARMACY LTD     55 HIGH STREET ST MARY CRAY   ORPINGTON KENT BR5 3NJ 2004-04-01 00:00:00 2005-07-25 00:00:00   0
62 P022 RODING PHARMACY     214 REDBRIDGE LANE EAST REDBRIDGE   ILFORD ESSEX IG4 5BQ 2004-04-01 00:00:00     0
63 P023 BOOKACHEMIST RECRUITMENT LTD     4 ROTHERHAM ROAD GREAT HOUGHTON   BARNSLEY SOUTH YORKSHIRE S72 0DB 2004-04-01 00:00:00     0
64 P024 MG PHARMACY WIDCOMBE     4A WIDCOMBE PARADE WIDCOMBE   BATH AVON BA2 4JT 2004-04-01 00:00:00 2011-06-30 00:00:00   0
65 P025 AIDWELL LTD     6 ELYSTAN STREET     LONDON GREATER LONDON SW3 3NS 2004-04-01 00:00:00     0
66 P026 THE COTSWOLD PHARMACY     MARKET PLACE NORTHLEACH   CHELTENHAM GLOUCESTERSHIRE GL54 3EG 2004-04-01 00:00:00     0
67 P027 BROCKLEHURST CHEMIST LTD     214 WILLERBY ROAD     HULL NORTH HUMBERSIDE HU5 5JW 2004-04-01 00:00:00     0
68 P028 STATION PHARMACY     102 PARK ROAD TIMPERLEY   ALTRINCHAM CHESHIRE WA15 6TE 2004-04-01 00:00:00 2006-09-30 00:00:00   0
69 P029 LEYTON GREEN PHARMACY     768 LEABRIDGE ROAD WALTHAMSTOW   LONDON GREATER LONDON E17 9DN 2004-04-01 00:00:00 2004-12-08 00:00:00   0
70 P02A MIDDLE CHARE PHARMACY LTD     14 THE GREEN SOUTHWICK   BRIGHTON EAST SUSSEX BN42 4GF 2004-04-01 00:00:00 2016-01-31 00:00:00   0
71 P02C KELTONE LTD     ROCHMILLS CHEMIST HIGH STREET MOULTON NORTHAMPTON NORTHAMPTONSHIRE NN3 7SR 2004-04-01 00:00:00     0
72 P02D OZA PHARMACY     50 LOWMOOR ROAD KIRKBY-IN-ASHFIELD   NOTTINGHAM NOTTINGHAMSHIRE NG17 7BG 2004-04-01 00:00:00     0
73 P02E ANDREW BASS LTD     1148 GREEN LANE     DAGENHAM ESSEX RM8 1BP 2004-04-01 00:00:00 2008-10-31 00:00:00   0
74 P02F GOODCARE DUSKS LTD     WALLER PHARMACY 279 HEATHWAY   DAGENHAM ESSEX RM9 5AQ 2004-04-01 00:00:00     0
75 P02G ANANT S. PATEL     384 HOLLINWOOD NEW MOSTON   MANCHESTER GREATER MANCHESTER M40 0JD 2004-04-01 00:00:00     0
76 P02H B.J. WILSON LTD     13 STADIUM BUSINESS COURT MILLENNIUM WAY PRIDE PARK DERBY DERBYSHIRE DE24 8HP 2004-04-01 00:00:00     0
77 P02J APPLIED DISPENSARY SERVICES     UNIT 4 PIONEER WAY   CASTLEFORD WEST YORKSHIRE WF10 5QU 2004-04-01 00:00:00 2006-04-20 00:00:00   0
78 P02K PATEL CHEMISTS     53 GREEN LANE     ILFORD ESSEX IG1 1XG 2004-04-01 00:00:00 2007-12-31 00:00:00   0
79 P02L CROSBY CHEMISTS LTD     THE CRESCENT PHARMACY 3 THE CRESCENT THORNTON LIVERPOOL MERSEYSIDE L23 4TA 2004-04-01 00:00:00     0
80 P02M T. HALL PHARMACY     CHAPELFORD MEDICAL CENTRE BURTONWOOD ROAD GREAT SANKEY WARRINGTON CHESHIRE WA5 3AN 2004-04-01 00:00:00 2013-03-31 00:00:00   0
81 P02N ROYAL PHARMACY     57 HIGH TOWN ROAD     LUTON BEDFORDSHIRE LU2 0BW 2004-04-01 00:00:00     0
82 P02P DUBISON LTD     168 CHURCH ROAD     LONDON GREATER LONDON NW10 9NH 2004-04-01 00:00:00     0
83 P02Q LANCEWISE PHARMACY     6 QUEENSWAY     MANCHESTER GREATER MANCHESTER M19 1QP 2004-04-01 00:00:00 2008-10-13 00:00:00   0
84 P02R CASTLE PHARMACY     364 CRICKLEWOOD LANE     LONDON GREATER LONDON NW2 2QJ 2004-04-01 00:00:00 2012-05-21 00:00:00   0
85 P02T THE VILLAGE PHARMACY     218-220 HIGH STREET     HAYES MIDDLESEX UB3 5DS 2004-04-01 00:00:00     0
86 P02V WOODHALL PHARMACY     UNIT 4 SHENLEY ROAD   HEMEL HEMPSTEAD HERTFORDSHIRE HP2 7QH 2004-04-01 00:00:00 2009-11-01 00:00:00   0
87 P02W BERE PENINSULA PHARMACY LTD     3 FORE STREET BERE ALSTON   YELVERTON DEVON PL20 7AA 2004-04-01 00:00:00     0
88 P02X ALAN CHALMERS (CHEMISTS) LTD     THE MARTIN PHARMACY 6 BAYLIS PARADE OATLANDS DRIVE SLOUGH BERKSHIRE SL1 3LF 2004-04-01 00:00:00     0
89 P02Y CROFT MEDICAL CENTRE LTD     40 GOMER STREET     WILLENHALL WEST MIDLANDS WV13 2DR 2004-04-01 00:00:00     0
90 P030 BRISCO'S CHEMIST     1 - 3 KINGSWAY KIRBY-IN-ASHFIELD   NOTTINGHAM NOTTINGHAMSHIRE NG17 7BB 2004-04-01 00:00:00     0
91 P031 AMG HEALTHCARE LTD     SELSDON HOUSE 212-220 ADDINGTON ROAD   SOUTH CROYDON SURREY CR2 8LD 2004-04-01 00:00:00     0
92 P032 ANCHOR HEALTH LTD     UNIT 2 45 - 47 ELGIN AVENUE MAIDA VALE LONDON GREATER LONDON W9 3PP 2004-04-01 00:00:00     0
93 P033 BAILEY & GARRET (CHEMIST) LTD     KIDDROW LANE HEALTH CENTRE KIDDROW LANE   BURNLEY LANCASHIRE BB12 6LH 2004-04-01 00:00:00     0
94 P034 CENTRECHEM LTD     11 FRONT STREET SEDGEFIELD   STOCKTON-ON-TEES CLEVELAND TS21 3AT 2004-04-01 00:00:00     0
95 P035 ALLISONS     43 MOSS WAY CROXTETH   LIVERPOOL MERSEYSIDE L11 0BL 2004-04-01 00:00:00 2005-10-01 00:00:00   0
96 P036 ALLENS PHARMACY     19 CASTALIA SQUARE ISLE OF DOGS   LONDON GREATER LONDON E14 3PQ 2004-04-01 00:00:00     0
97 P037 NEWLAND COMMUNITY PHARMACY LTD     59 - 61 NEWLAND AVENUE     HULL NORTH HUMBERSIDE HU5 3BG 2004-04-01 00:00:00     0
98 P038 BANKS PHARMACY     13 PRINCES ROAD BRUNTON PARK GOSFORTH NEWCASTLE UPON TYNE TYNE AND WEAR NE3 5TT 2004-04-01 00:00:00 2010-07-31 00:00:00   0
99 P039 BIRK AND NAGRA     THE PHARMACY COURT STREET   LEAMINGTON SPA WARWICKSHIRE CV31 2BB 2004-04-01 00:00:00     0
100 P03A BLACKS PHARMACY     99-101 WAVERTREE ROAD     LIVERPOOL MERSEYSIDE L7 1PG 2004-04-01 00:00:00 2006-11-03 00:00:00   0

Next page

CREATE TABLE "epharmacyhq" (
"Organisation Code" TEXT,
  "Name" TEXT,
  "National Grouping" REAL,
  "High Level Health Geography" REAL,
  "Address Line 1" TEXT,
  "Address Line 2" TEXT,
  "Address Line 3" TEXT,
  "Address Line 4" TEXT,
  "Address Line 5" TEXT,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Contact Telephone Number" REAL,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 26.854ms · Data source: OUseful Databeat