1. HILIS4.git
  2. setup
  3. schema
  4. hospitals.sql
 RSS Git Download  Clone
Raw Blame History 
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Staffs Hospital Laboratory','69390');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Mid Yorks Nuffield','8AV07');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('The Doctors Laboratory','8EQ15');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Aarhus University Hospital','AAUH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Adelaide Hospital','ARAH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Prince Alfred Hospital','ARPAH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Curie Memorial Cancer Centre, Warsaw','CMCC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hopitaux Universitaires De Geneve','GENUH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Ghana (Kumasi)','GHANA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Herlev Hospital, Copenhagen','HERLEV');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Portugal Institute Of Oncology','IPOLS');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wishaw General','L308H');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Aberdeen Childrens','N121H');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Harrogate - Nuffield','NT217');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Huddersfield - Nuffield','NT220');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hull - Nuffield','NT221');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leeds - Nuffield','NT225');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Tunbridge Wells - Nuffield','NT239');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wolverhampton - Nuffield','NT242');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('York - Nuffield','NT243');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BUPA - Gatwick Park','NT308');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BUPA - Park Way','NT320');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BUPA - Leicester','NT322');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BUPA - Elland','NT328');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Methley Park','NT330');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BUPA - Hull','NT331');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Spire/BUPA - Roundhay','NT332');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('BMI - Alexandra Hospital, Cheadle','NT401');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Chelsfield Park Hospital','NT409');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Somerfield Hospital, Maidstone','NT438');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Yorkshire Clinic','NT818');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('New Victoria Hospital','NTY65');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Blackheath Hospital, London','NV106');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Peter MacCallum Cancer Ctr, Australia','PEMAC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Pivotal Laboratories','PIVLAB');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Surrey County Hospital','RA201');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Bristol Haematology & Oncology Ctr','RA710');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Torbay District General','RA901');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Bradford Royal','RAE01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Luke\'s, Bradford','RAE05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Southend','RAJ01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Free Hospital','RAL01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Barnet General','RAL26');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hillingdon Hospital','RAS01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kingston','RAX01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Taunton, Musgrove Park','RBA11');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Dorset County','RBD01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Arrowe Park, Wirral','RBL14');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Whiston Hospital, Prescott','RBN01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Alderhey Childrens Hospital','RBS25');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leighton Hospital','RBT20');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Christie Hospital','RBV01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Devon District','RBZ12');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('York District','RCB55');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Scarborough','RCC25');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Harrogate & District','RCD35');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Airedale','RCF22');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Nottingham City Hospital','RCSLB');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Sheffield Children\'s Hospital','RCUEF');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Elizabeth, Kings Lynn','RCX70');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal United Hospital, Bath','RD130');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Poole General','RD300');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wexham Park Hospital','RD750');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Milton Keynes General','RD816');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Basildon & Thurrock University Hospital','RDDH0');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Colchester General','RDEE4');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Bournemouth General','RDZ20');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('South Tyneside District General','RE9GA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Cornwall','REF12');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Walton Hospital, Liverpool','REM20');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Liverpool University Hospital','REP17');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Walton Neurology Centre, Liverpool','RET20');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('King George Hospital, Ilford','RF4DG');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Oldchurch Hospital','RF4OC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen\'s Hospital, Romford','RF4QH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Barnsley District General','RFFAA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Rotherham District General','RFRPA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Chesterfield & North Derbyshire','RFSDA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('West Middlesex University Hospital','RFW01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Princess Royal University Hospital','RG303');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Mary\'s, Leeds','RGDAV');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('James Paget Hospital','RGP75');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Ipswich','RGQ02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('West Suffolk Hospital','RGR50');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Addenbrookes Hospital','RGT01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Canterbury Health Laboratories','RGWKC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Mary\'s Hospital, Sidcup','RGZ01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Devon & Exeter','RH801');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Southampton University Hospital','RHM01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Hallamshire','RHQHH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Northern General, Sheffield','RHQNG');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Bassetlaw NHS Trust','RHQNN');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Weston Park, Sheffield','RHQWP');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Alexandra, Portsmouth','RHU03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Berkshire & Battle','RHW01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Guy\'s Hospital','RJ121');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Mary\'s, London','RJ501');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Mayday University Hospital','RJ611');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('South Warwickshire General','RJC02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Staffordshire General','RJD01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Staffordshire Royal Infirmary','RJE01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queens Hospital, Burton-on-Trent','RJF02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Good Hope Hospital','RJH01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Diana Princess of Wales','RJL30');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Scunthorpe','RJL32');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Macclesfield','RJN71');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Countess of Chester','RJR05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kings College Hospital','RJZ01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kings Mill','RK5BC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Derriford Hospital, Plymouth','RK950');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Walsgrave/Coventry University Hospital','RKB01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Ysbyty Bronglais','RKUAJ');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('New Cross Hospital, Wolverhampton','RL403');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hereford County Hospital','RLQ01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('George Eliot, Nuneaton','RLT01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Norfolk & Norwich University Hospital','RM102');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wythenshaw','RM202');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hope Hospital, Salford','RM301');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Trafford General Hospital','RM401');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Bolton Hospital','RMC00');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Tameside General','RMP01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Great Western Hospital, Swindon','RN325');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Hampshire Hospital','RN506');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Darent Valley','RN707');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Russells Hall Hospital','RNA01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Bartholomews','RNJM0');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Cumberland Infirmary','RNLAY');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kettering General Hospital','RNQ51');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Northampton General','RNS01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Salisbury District','RNZ02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Melbourne Hospital','ROMBH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Doncaster Royal Infirmary','RP5DR');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Medway Maritime Hospital','RPA02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Worthing','RPL04');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Richard\'s Hospital','RPR01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Marsden','RPY01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St John\'s Hospital','RQ8LH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Welsh Bone Marrow Donor Registry','RQF5B');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hammersmith','RQN02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Princess Alexandra','RQWG0');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Homerton University Hospital','RQXM1');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St. George\'s, London','RQY45');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Birmingham Heartlands','RR101');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Elizabeth, Gateshead','RR7EN');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leeds General Infirmary','RR801');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leeds Dental Hospital','RR802');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Cookridge','RR803');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wharfedale General','RR807');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St. James\'s, Leeds','RR813');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Seacroft','RR814');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Chapel Allerton','RR819');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leigh Infirmary','RRF01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Albert Edward, Wigan','RRF02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Orthopaedic Hospital, Birmingham','RRJ05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Elizabeth, Birmingham','RRK02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Prince Charles Hospital','RRSB3');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('University College Hospital','RRV10');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Fairfield General','RT201');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Oldham','RT203');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Ysbyty Gwynedd','RT7AU');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Glan Clwyd Hospital','RT8A1');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Alexandra','RT8A5');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wrexham Maelor','RT9A4');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Freeman Hospital, Newcastle','RTD01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Victoria Infirmary, Newcastle','RTD02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Cheltenham General','RTE01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Gloucestershire Royal','RTE03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wansbeck General','RTFED');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Tyneside General','RTFFS');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Derby Royal Infirmary','RTGFA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Derby City General','RTGFG');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('John Radcliffe Hospital','RTH08');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Peter\'s, Chertsey','RTK01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Friarage, Northallerton','RTR45');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('James Cook Hospital, Middlesbrough','RTRAT');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('University Hospital, North Tees','RTRNT');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Lancaster','RTX02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Furness General, Cumbria','RTXBU');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Westmorland General','RTXBW');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Northwick Park','RV820');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Central Middlesex','RV831');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('West Wales General, Carmarthen','RVAAG');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Prince Philip, Llanelli','RVAAL');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Singleton Hospital','RVCC4');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Morriston Hospital','RVCC7');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Nevill Hall, Abergavenny','RVFAM');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Gwent','RVFAR');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Southmead, Bristol','RVJ01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Chase Farm Hospital','RVLC7');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('St Helier','RVR05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Epsom General','RVR50');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Queen Elizabeth, Margate','RVV09');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kent & Canterbury Hospital','RVVKC');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Southport','RVY03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Manchester Royal Infirmary','RW3MR');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Manchester Childrens Hospital','RW3RM');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Aintree Hospital','RW402');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('North Manchester General','RW602');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Rochdale Infirmary','RW604');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Birch Hill, Rochdale','RW605');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Bury General','RW606');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hull Royal Infirmary','RWA01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Castle Hill, Humberside','RWA16');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Louth County','RWDAA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Lincoln County','RWDDA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Boston Pilgrim','RWDLA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Grantham & District','RWDLP');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Leicester Royal Infirmary','RWEAA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Pembury Hospital, Kent','RWF01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kent & Sussex Hospital','RWF02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Maidstone General Hospital','RWF03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('William Harvey Hospital','RWF37');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Mount Vernon Hospital','RWG01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Watford General','RWG02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Stepping Hill Hospital','RWJ09');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('University Hospital of Wales','RWMBV');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Alexandra Hospital, Redditch','RWP01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Kidderminster','RWP31');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Worcestershire Royal','RWP50');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Halton Hospital','RWWHG');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Warrington General','RWWWH');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Huddersfield Royal Infirmary','RWY01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Calderdale','RWY02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Newark Hospital','RX1HP');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Conquest Hospital, E. Sussex','RXC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Eastbourne District General','RXC02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Pontefract General','RXF03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Clayton, Wakefield','RXF04');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Pinderfields General','RXF05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Castleford, Normanton & District','RXF07');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Dewsbury & District','RXF10');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Sussex County Hospital','RXH01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Sandwell General Hospital','RXK01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Birmingham City Hospital','RXK02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Blackpool Victoria','RXL01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Preston Hospital','RXN02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Bishop Auckland General','RXPBA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Darlington Memorial','RXPDA');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Stoke Mandeville','RXQ02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Wycombe Hospital','RXQ50');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Burnley General','RXR10');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Blackburn Royal Infirmary','RXR30');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Shrewsbury','RXWAS');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Edinburgh Royal Infirmary','S314H');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Borders General Hospital','SBC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Karolinska Institutet, Stockholm','SEKIS');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Western Infirmary, Glasgow','SGA07');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Southern General, Glasgow','SGC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Yorkhill (RHSC), Glasgow','SGC02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Victoria Infirmary, Glasgow','SGC03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Glasgow Royal','SGC05');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Stobhill, Glasgow','SGC06');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Inverness Raigmore','SHC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Hairmyres, East Kilbride','SLA03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Monklands District Hospital','SLC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Aberdeen Royal Infirmary','SNC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Royal Hospital For Sick Children, Edinburgh','SSC03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Western General, Edinburgh','SSC04');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Tayside Hospitals','STC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Perth Royal','STC02');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Falkirk Royal Infirmary','SVC03');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Dumfries Royal Infirmary','SYC01');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Surgery/Medical Centre','V81999');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('National Blood Service, Seacroft','X6002');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Noble\'s Hospital, Isle Of Man','X9001');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Unknown/other','X99999');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('HMP Newhall, Wakefield','YDE1T');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('HMP, Armley, Leeds','YDE47');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Belfast City','Z1020');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Ulster Hospital','Z1110');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Beaumont Hospital, Dublin','Z9901');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Connolly Hospital, Dublin','Z9929');
INSERT INTO `referral_sources` (`display_name`,`organisation_code`) VALUES ('Mater Misericordiae, Dublin','Z9930');