Spreadsheet: 599955d1543393670-transposing-data-foi-data-nhs-trusts-roles
Sheet: Look up info

 |  | Company | First 25 characters | Id
 |  | 2gether NHS Foundation Trust RTQ |  | 10625
 |  | 5 Boroughs Partnership NHS Foundation Trust RTV |  | 10627
 |  | Airedale NHS Foundation Trust RCF |  | 35977
 |  | Ashford and St. Peters Hospitals NHS Found |  | 186647
 |  | Barnet, Enfield and Haringey Mental Health NHS Tru |  | 38539
 |  | Barnsley Hospital NHS Foundation Trust RFF |  | 38501
 |  | Bedford Hospital NHS Trust RC1 |  | 38765
 |  | Berkshire Healthcare NHS Foundation Trust RWX |  | 39391
 |  | Birmingham and Solihull Mental Health NHS Foundati |  | 12041
 |  | [NAME] Hospital NHS Foundation Trus |  | 12069
 |  | Birmingham Community Healthcare NHS Trust RYW |  | 12083
 |  | [NAME] NHS Foundation Trust RLU |  | 12171
 |  | Black Country Partnership NHS Foundation Trust TAJ |  | 12125
 |  | Blackpool Teaching Hospitals NHS Foundation Trust |  | 186861
 |  | Bolton NHS Foundation Trust RMC |  | 12227
 |  | Bradford District Care Trust TAD |  | 40119
 |  | Bradford Teaching Hospitals NHS Foundation Trust R |  | 40171
 |  | Bridgewater Community Healthcare NHS Trust RY2 |  | 12405
 |  | [NAME] and Sussex University Hospitals NHS Trust |  | 40501
 |  | Calderdale and Huddersfield NHS Foundation Trust R |  | 41107
 |  | Calderstones Partnership NHS Foundation Trust RJX |  | 12751
 |  | Cambridgeshire and Peterborough NHS Foundation Tru |  | 41261
 |  | Cambridgeshire Community Services NHS Trust RYV |  | 41297
 |  | Camden and Islington NHS Foundation Trust TAF |  | 41377
 |  | Central and North West London NHS Foundation Trust |  | 42467
 |  | Central London Community Healthcare NHS Trust RYX |  | 42471
 |  | Central Manchester University Hospitals NHS Founda |  | 13071
 |  | Chelsea and Westminster Hospital NHS Foundation Tr |  | 42787
 |  | Cheshire and Wirral Partnership NHS Foundation Tru |  | 13315
 |  | Chesterfield Royal Hospital NHS Foundation Trust R |  | 42879
 |  | City Hospitals Sunderland NHS Foundation Trust RLN |  | 43345
 |  | Cornwall Partnership NHS Foundation Trust RJ8 |  | 13743
 |  | Countess of Chester Hospital NHS Foundation Trust |  | 187029
 |  | County Durham and Darlington NHS Foundation Trust |  | 187061
 |  | Coventry and Warwickshire Partnership NHS Trust RY |  | 13865
 |  | Croydon Health Services NHS Trust RJ6 |  | 44789
 |  | Cumbria Partnership NHS Foundation Trust RNN |  | 13941
 |  | [NAME] and Gravesham NHS Trust RN7 |  | 45347
 |  | Derby Hospitals NHS Foundation Trust RTG |  | 45679
 |  | Derbyshire Community Health Services NHS Trust RY8 |  | 45735
 |  | Derbyshire Healthcare NHS Foundation Trust RXM |  | 45787
 |  | Devon Partnership NHS Trust RWV |  | 14239
 |  | Doncaster and Bassetlaw Hospitals NHS Foundation T |  | 46147
 |  | Dorset County Hospital NHS Foundation Trust RBD |  | 14415
 |  | Dorset Healthcare University NHS Foundation Trust |  | 187201
 |  | [NAME] and Walsall Mental Health Partnership NHS T |  | 17361
 |  | Ealing Hospital NHS Trust RC3 |  | 53507
 |  | East and North Hertfordshire NHS Trust RWH |  | 53471
 |  | East Cheshire NHS Trust RJN |  | 17547
 |  | East London NHS Foundation Trust RWK |  | 53575
 |  | East Midlands Ambulance Service NHS Trust RX9 |  | 53595
 |  | East of England Ambulance Service NHS Trust RYC |  | 53691
 |  | [NAME] and St Helier University Hospitals NHS Trust |  | 54405
 |  | Essex Partnership University NHS Foundation Trust |  | 212351
 |  | Frimley Park Hospital NHS Foundation Trust RDU |  | 55801
 |  | Gateshead Health NHS Foundation Trust RR7 |  | 56087
 |  | Gloucestershire Care Services NHS Trust R1J |  | 18271
 |  | Gloucestershire Hospitals NHS Foundation Trust RTE |  | 18329
 |  | Great Ormond Street Hospital for Children NHS Foun |  | 56893
 |  | Great Western Hospitals NHS Foundation Trust RN3 |  | 18447
 |  | Greater Manchester West Mental Health NHS Foundati |  | 18479
 |  | Guy's and [NAME] NHS Foundation Trust RJ1 |  | 57095
 |  | Hampshire Hospitals NHS Foundation Trust RN5 |  | 57523
 |  | Harrogate and District NHS Foundation Trust RCD |  | 57647
 |  | Heart of England NHS Foundation Trust RR1 |  | 18825
 |  | Heatherwood and Wexham Park Hospitals NHS Foundati |  | 58305
 |  | Hertfordshire Community NHS Trust RY4 |  | 58433
 |  | Hertfordshire Partnership University NHS Foundatio |  | 58499
 |  | Homerton University Hospital NHS Foundation Trust |  | 187549
 |  | Hounslow and Richmond Community Healthcare NHS Tru |  | 59525
 |  | Hull and East Yorkshire Hospitals NHS Trust RWA |  | 59467
 |  | Humber NHS Foundation Trust RV9 |  | 59555
 |  | Imperial College Healthcare NHS Trust RYJ |  | 59739
 |  | Ipswich Hospital NHS Trust RGQ |  | 60185
 |  | Isle of Wight NHS Trust R1F |  | 60307
 |  | James Paget University Hospitals NHS Foundation Tr |  | 60371
 |  | Kent and Medway NHS and Social Care Partnership Tr |  | 61051
 |  | Kent Community Health NHS Trust RYY |  | 60965
 |  | Kettering General Hospital NHS Foundation Trust RN |  | 61065
 |  | King's College Hospital NHS Foundation Trust RJZ |  | 61331
 |  | Kingston Hospital NHS Foundation Trust RAX |  | 61297
 |  | Lancashire Care NHS Foundation Trust RW5 |  | 19959
 |  | Lancashire Teaching Hospitals NHS Foundation Trust |  | 19965
 |  | Leeds and York Partnership NHS Foundation Trust RG |  | 62189
 |  | Leeds Community Healthcare NHS Trust RY6 |  | 62093
 |  | Leeds Teaching Hospitals NHS Trust RR8 |  | 62205
 |  | Leicestershire Partnership NHS Trust RT5 |  | 62089
 |  | Lewisham and Greenwich NHS Trust RJ2 |  | 62307
 |  | Lincolnshire Community Health Services NHS Trust R |  | 34325
 |  | Lincolnshire Partnership NHS Foundation Trust RP7 |  | 62451
 |  | Liverpool Community Health NHS Trust RY1 |  | 20213
 |  | Liverpool Heart and Chest NHS Foundation Trust RBQ |  | 20223
 |  | Liverpool Women's NHS Foundation Trust REP |  | 20251
 |  | London North West Healthcare NHS Trust R1K |  | 62909
 |  | Luton and Dunstable University Hospital NHS Founda |  | 63121
 |  | Maidstone and Tunbridge Wells NHS Trust RWF |  | 63411
 |  | Mersey Care NHS Trust RW4 |  | 20853
 |  | Mid Cheshire Hospitals NHS Foundation Trust RBT |  | 32297
 |  | Mid Essex Hospital Services NHS Trust RQ8 |  | 64603
 |  | Mid Staffordshire NHS Foundation Trust RJD |  | 20811
 |  | Milton Keynes Hospital NHS Foundation Trust RD8 |  | 64801
 |  | Moorfields Eye Hospital NHS Foundation Trust RP6 |  | 65401
 |  | NHS Blood and Transplant T1460 |  | 71955
 |  | NHS Direct NHS Trust RYH |  | 71987
 |  | Norfolk and Norwich University Hospitals NHS Found |  | 72157
 |  | Norfolk Community Health and Care NHS Trust RY3 |  | 72091
 |  | North Bristol NHS Trust RVJ |  | 24859
 |  | North East Ambulance Service NHS Foundation Trust |  | 72319
 |  | North East London NHS Foundation Trust RAT |  | 72243
 |  | North Essex Partnership University NHS Foundation |  | 72279
 |  | North Middlesex University Hospital NHS Trust RAP |  | 72221
 |  | North Staffordshire Combined Healthcare NHS Trust |  | 24911
 |  | North Tees and Hartlepool NHS Foundation Trust RVW |  | 72223
 |  | North West Ambulance Service NHS Trust RX7 |  | 24827
 |  | North West London Hospitals NHS Trust RV8 |  | 32457
 |  | Northampton General Hospital NHS Trust RNS |  | 72263
 |  | Northamptonshire Healthcare NHS Foundation Trust R |  | 72329
 |  | Northern Devon Healthcare NHS Trust RBZ |  | 24889
 |  | Northumberland, [NAME] and Wear NHS Foundation Trust |  | 72511
 |  | Northumbria Healthcare NHS Foundation Trust RTF |  | 72397
 |  | Nottingham University Hospitals NHS Trust RX1 |  | 72513
 |  | Oxford Health NHS Foundation Trust RNU |  | 73531
 |  | Oxford University Hospitals NHS Trust RTH |  | 73527
 |  | Oxleas NHS Foundation Trust RPG |  | 73447
 |  | Papworth Hospital NHS Foundation Trust RGM |  | 73661
 |  | Pennine Care NHS Foundation Trust RT2 |  | 25519
 |  | Peterborough and Stamford Hospitals NHS Foundation |  | 74417
 |  | Plymouth Hospitals NHS Trust RK9 |  | 25675
 |  | Poole Hospital NHS Foundation Trust RD3 |  | 25697
 |  | Portsmouth Hospitals NHS Trust RHU |  | 74895
 |  | Queen Victoria Hospital NHS Foundation Trust RPC |  | 75601
 |  | [NAME] and South Humber NHS Foundatio |  | 76961
 |  | Royal Berkshire NHS Foundation Trust RHW |  | 77159
 |  | [NAME] and Harefield NHS Foundation Trust |  | 77225
 |  | Royal Cornwall Hospitals NHS Trust REF |  | 26557
 |  | [NAME] and Exeter NHS Foundation Trust RH8 |  | 26573
 |  | Royal Free London NHS Foundation Trust RAL |  | 77123
 |  | Royal National Hospital for Rheumatic Diseases NHS |  | 26585
 |  | Royal National Orthopaedic Hospital NHS Trust RAN |  | 77175
 |  | Royal Surrey County Hospital NHS Foundation Trust |  | 77183
 |  | Royal United Hospital Bath NHS Trust RD1 |  | 26537
 |  | Salford Royal NHS Foundation Trust RM3 |  | 26675
 |  | Salisbury NHS Foundation Trust RNZ |  | 26733
 |  | Sandwell and West Birmingham Hospitals NHS Trust R |  | 26741
 |  | Sheffield Children's NHS Foundation Trust RCU |  | 78221
 |  | Sheffield Health and Social Care NHS Foundation Tr |  | 78261
 |  | Sheffield Teaching Hospitals NHS Foundation Trust |  | 78351
 |  | Shrewsbury and Telford Hospital NHS Trust RXW |  | 27075
 |  | Shropshire Community Health NHS Trust R1D |  | 26971
 |  | Solent NHS Trust R1C |  | 78929
 |  | Somerset Partnership NHS Foundation Trust RH5 |  | 27189
 |  | South Central Ambulance Service NHS Foundation Tru |  | 79001
 |  | South East Coast Ambulance Service NHS Foundation |  | 79073
 |  | South Essex Partnership University NHS Foundation |  | 79177
 |  | South London and Maudsley NHS Foundation Trust RV5 |  | 79215
 |  | South Staffordshire and Shropshire Healthcare NHS |  | 188615
 |  | South Tees Hospitals NHS Foundation Trust RTR |  | 79143
 |  | South Tyneside NHS Foundation Trust RE9 |  | 79201
 |  | South Warwickshire NHS Foundation Trust RJC |  | 27165
 |  | South West London and [NAME] Mental Health NH |  | 79087
 |  | South West Yorkshire Partnership NHS Foundation Tr |  | 79119
 |  | South Western Ambulance Service NHS Foundation Tru |  | 27199
 |  | Southend University Hospital NHS Foundation Trust |  | 79217
 |  | Southend University Hospital NHS Foundation Trust |  | 188565
 |  | Southern Health NHS Foundation Trust RW1 |  | 79127
 |  | Southport and Ormskirk Hospital NHS Trust RVY |  | 27249
 |  | [NAME] Healthcare NHS Trust RJ7 |  | 79763
 |  | [NAME] and Knowsley Teaching Hospitals NHS Trus |  | 27451
 |  | Staffordshire & Stoke-on-Trent Partnership NHS Tr |  | 10297
 |  | Stockport NHS Foundation Trust RWJ |  | 27657
 |  | [NAME] and Borders Partnership NHS Foundation Trus |  | 80989
 |  | [NAME] and Sussex Healthcare NHS Trust RTP |  | 81001
 |  | Sussex Community NHS Trust RDR |  | 81091
 |  | Sussex Partnership NHS Foundation Trust |  | 10363
 |  | Taunton and Somerset NHS Foundation Trust RBA |  | 27897
 |  | Tavistock and Portman NHS Foundation Trust RNK |  | 81447
 |  | Tees, Esk and Wear Valleys NHS Foundation Trust RX |  | 81445
 |  | The Christie NHS Foundation Trust RBV |  | 28221
 |  | The Clatterbridge Cancer Centre NHS Foundation Tru |  | 28285
 |  | The Dudley Group NHS Foundation Trust RNA |  | 28233
 |  | The Hillingdon Hospitals NHS Foundation Trust RAS |  | 82781
 |  | The Mid Yorkshire Hospitals NHS Trust RXF |  | 83263
 |  | The Newcastle-upon-Tyne Hospitals NHS Foundation T |  | 83367
 |  | The Pennine Acute Hospitals NHS Trust RW6 |  | 28611
 |  | The Princess Alexandra Hospital NHS Trust RQW |  | 83585
 |  | The Rotherham NHS Foundation Trust RFR |  | 83737
 |  | The Royal Marsden NHS Foundation Trust RPY |  | 83775
 |  | The Royal Orthopaedic Hospital NHS Foundation Trus |  | 28745
 |  | The Royal Wolverhampton NHS Trust RL4 |  | 28627
 |  | The Walton Centre NHS Foundation Trust RET |  | 28787
 |  | The Whittington Hospital NHS Trust RKE |  | 84223
 |  | [NAME] and South Devon NHS Foundation Trust RA9 |  | 29019
 |  | [NAME] and Southern Devon Health and Care NHS Trus |  | 29023
 |  | University College London Hospitals NHS Foundation |  | 85239
 |  | University Hospital of North Staffordshire NHS Tru |  | 29255
 |  | University Hospital of South Manchester NHS Founda |  | 29267
 |  | University Hospital Southampton NHS Foundation Tru |  | 85311
 |  | University Hospitals Birmingham NHS Foundation Tru |  | 29275
 |  | University Hospitals Bristol NHS Foundation Trust |  | 29297
 |  | University Hospitals Coventry and Warwickshire NHS |  | 29313
 |  | University Hospitals of Leicester NHS Trust RWE |  | 85327
 |  | Walsall Healthcare NHS Trust RBK |  | 29507
 |  | Warrington and Halton Hospitals NHS Foundation Tru |  | 29553
 |  | West Hertfordshire Hospitals NHS Trust RWG |  | 86465
 |  | West London Mental Health NHS Trust RKL |  | 86485
 |  | West Middlesex University Hospital NHS Trust RFW |  | 86399
 |  | West Midlands Ambulance Service NHS Foundation Tru |  | 29815
 |  | West Suffolk NHS Foundation Trust RGR |  | 86413
 |  | Western Sussex Hospitals NHS Foundation Trust RYR |  | 86585
 |  | Weston Area Health NHS Trust RA3 |  | 29839
 |  | Wirral Community NHS Trust RY7 |  | 29991
 |  | Wirral University Teaching Hospital NHS Foundation |  | 30055
 |  | Worcestershire Acute Hospitals NHS Trust RWP |  | 30089
 |  | Wrightington, [NAME] and Leigh NHS Foundation Trust |  | 30207
 |  | Yeovil District Hospital NHS Foundation Trust RA4 |  | 30309
 |  | Yorkshire Ambulance Service NHS Trust RX8 |  | 87851