text: insert into pharmacy
  values
    ('FA512','Lords Pharmacy','','Unit 61 The Guineas Shopping Centre','','Newmarket','CB8 8EQ','01638 428022',52.244796752929688,0.4055977463722229),
    ('FAP38','LloydsPharmacy Inside Sainsbury''s','Church Street','Carlisle','','','CA2 5TF','01228533915',54.894672393798828,-2.9472866058349609),
    ('FC826','Rutland Late Night Pharmacy','','45c High Street','','Oakham','LE15 6AJ','01572 723368',52.670024871826172,-0.7302858829498291),
    ('FD294','Cohens Chemist','33 Hill Street','','','Hinckley','LE10 1DS','01455613100',52.541034698486328,-1.36773824691772460),
    ('FJF07','East Street Pharmacy','East Street Pharmacy','47 East Street','','Tonbridge','TN9 1LA','01732 770055',51.197410583496094,0.27922672033309937),
    ('FJH46','Asda Pharmacy','','Woodchurch Road','','Upton Wirral','CH49 5PD','01515227710',53.370174407958984,-3.0762836933135986),
    ('FMR49','Sutton & Merton  Out of Hours','','28 The Market Wrythe Lane','','Carshalton','SM5 1AG','',51.383049011230469,-0.18840518593788147),
    ('FPM84','Tesco Instore Pharmacy','','District Shopping Centre','Chineham','Basingstoke','RG24 8BE','01256 824104',51.283706665039063,-1.0588270425796509),
    ('FWQ12','Cheadle Heath Pharmacy','Cheadle Heath Pharmacy','258 Stockport Road','Cheadle Heath','Stockport','SK3 0RG','0161 491 3704',53.400806427001953,-2.1940469741821289),
    ('FA002','Rowlands Pharmacy','','61 Arundel Avenue','Hazel Grove','Stockport','SK7 5LD','0161 4838729',53.372379302978516,-2.12734055519104),
    ('FA007','Rowlands Pharmacy','10a/b Bentalls Shopping Centre','Colchester Road','Heybridge','Maldon','CM9 4GD','01621 850559',51.740554809570312,0.68920385837554932),
    ('FA008','Boots','49-51 Merrion Ctr','','','Leeds','LS2 8PJ','01132428194',53.802139282226563,-1.5442358255386353),
    ('FA012','Medichem','100 Whitehorse Lane','Stepney','Tower Hamlets','London','E1 4LR','020 7790 3310',51.520950317382813,-4.4557001441717148E-2),
    ('FA015','Headcorn Pharmacy','Headcorn Surgery','Grigg Lane','Headcorn','Kent','TN27 9AA','01622 890758',51.170200347900391,0.63311606645584106),
    ('FA026','Grendon Pharmacy','','150 Boot Hill','','Baddesley Ensor','CV9 2EW','01827 715350',52.5859375,-1.5996764898300171),
    ('FA029','Rowlands Pharmacy','294 London Road','North End','Portsmouth','Hampshire','PO2 9JN','02392 660534',50.821914672851563,-1.0751380920410156),
    ('FA031','Bridgegate Chemist','54 Bridgegate','Retford','Nottinghamshire','','DN22 7UZ','01777 703299',53.324623107910156,-0.94645005464553833),
    ('FA037','New Line Pharmacy','Dereham Terrace','Stakeford','','Northumberland','NE62 5UR','01670 520 222',55.163604736328125,-1.5752315521240234),
    ('FA042','LloydsPharmacy','20 Great Whyte','Ramsey','','','PE26 1HA','01487814886',52.449043273925781,-0.10722045600414276),
    ('FA044','Coastal Pharmacy','1 Heysham Road','Heysham','','Morecambe','LA3 1DA','01524412275',54.063899993896484,-2.886195182800293),
    ('FA049','Fa Strange Chemist','185 Lower Clapton Road','Upper Clapton','City and Hackney','London','E5 8EQ','020 8510 0829',51.555107116699219,-5.5052760988473892E-2),
    ('FA052','Instore Pharmacy','Tesco Pharmacy','Bridge Road','','Rainham','RM13 9YZ','0345 677 9570',51.520534515380859,0.18956242501735687),
    ('FA053','Boots','73 PICCADILLY','','','London','W1J 8HS','02074092982',51.507442474365234,-0.14188778400421143),
    ('FA056','LloydsPharmacy Inside Sainsbury''s','William Frost Way','New Costessey','Norwich','','NR5 0JS','01603746759',52.652908325195313, 1.1871600151062012),
    ('FA057','Heswall Hills Pharmacy','119 Brimstage Road','Heswall','','Wirral','CH60 1XF','0151 342 4385',53.329746246337891,-3.074650049209594);
  