ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
LeaversJoiners
2
Org
code
EU 2014-15All nationalities 2014-15% of EU leavers 2014-15EU 2015-16All nationalities 2015-16% of EU leavers 2015-16EU 2016-17All nationalities 2016-17% of EU leavers 2016-17Is proportion of EU staff leaving getting bigger year on year?Is proportion of EU staff leaving in the first six months of 2017 larger than 2014/15?EU joiners 2014-15All joiners 2014-15% of joiners from the EU 2014-15EU joiners 2015-16 All joiners 2015-16% of joiners from the EU 2015-16EU joiners 2016-17All joiners 2016-17% of joiners from the EU 2016-17Is % of EU joiners getting smaller year on year?Is proportion of EU joiners smaller in the first six months of 2017 than in 2014-15?Both EU leavers growing and EU joiners dwindling year on year?
3
RTQ2Gether NHS Foundation Trust32351.3%92274.0%21191.7%FALSEYes102304.3%102474.0%51453.4%TRUEYesFALSE
4
RTV5 Boroughs Partnership NHS Foundation Trust53131.6%83662.2%32121.4%FALSENo73352.1%113503.1%72602.7%FALSENoFALSE
5
REMAintree University Hospital NHS Foundation Trust243746.4%223895.7%132375.5%FALSENo314357.1%234804.8%162855.6%FALSEYesFALSE
6
RCFAiredale NHS Foundation Trust42631.5%72782.5%151619.3%TRUEYes3830512.5%3831612.0%112344.7%TRUEYesTRUE
7
RBSAlder Hey Children's NHS Foundation Trust132545.1%112993.7%81445.6%FALSEYes263517.4%183475.2%72083.4%TRUEYesFALSE
8
RTK
Ashford and St. Peter's Hospitals NHS Foundation Trust
404588.7%4543210.4%3622815.8%TRUEYes8151815.6%10852120.7%7035319.8%FALSENoFALSE
9
RVN
Avon and Wiltshire Mental Health Partnership NHS Trust
204954.0%174413.9%72722.6%FALSENo405018.0%335775.7%192687.1%FALSEYesFALSE
10
RF4
Barking, Havering and Redbridge University Hospitals NHS Trust
7065810.6%8069111.6%6034717.3%TRUEYes9989311.1%18585721.6%4441410.6%FALSEYesFALSE
11
RRPBarnet, Enfield and Haringey Mental Health NHS Trust323668.7%222977.4%2216313.5%FALSEYes3632411.1%4537312.1%3124612.6%FALSENoFALSE
12
RFFBarnsley Hospital NHS Foundation Trust43001.3%22700.7%31412.1%FALSEYes43301.2%133463.8%41592.5%FALSENoFALSE
13
R1HBarts Health NHS Trust202182711.1%275183615.0%174111615.6%TRUEYes437224819.4%333237614.0%169111215.2%FALSEYesFALSE
14
RDD
Basildon and Thurrock University Hospitals NHS Foundation Trust
364917.3%304496.7%3930712.7%FALSEYes465258.8%14189215.8%303648.2%FALSEYesFALSE
15
RC1Bedford Hospital NHS Trust232927.9%5333515.8%151529.9%FALSEYes10946323.5%3732311.5%3625214.3%FALSEYesFALSE
16
RWXBerkshire Healthcare NHS Foundation Trust315425.7%306674.5%142805.0%FALSENo466037.6%566239.0%293767.7%FALSENoFALSE
17
RXT
Birmingham and Solihull Mental Health NHS Foundation Trust
135182.5%84721.7%42441.6%FALSENo44480.9%113982.8%42181.8%FALSENoFALSE
18
RYW
Birmingham Community Healthcare NHS Foundation Trust
95161.7%175153.3%92553.5%TRUEYes123873.1%144743.0%82243.6%FALSENoFALSE
19
RQ3
Birmingham Women's and Children's NHS Foundation Trust
204015.0%144183.3%112254.9%FALSENo174893.5%335126.4%153504.3%FALSENoFALSE
20
RLUBirmingham Women's NHS Foundation Trust61523.9%111995.5%111169.5%TRUEYes101835.5%131677.8%#N/A#N/A#N/A#N/A#N/A#N/A
21
TAJBlack Country Partnership NHS Foundation Trust42022.0%51972.5%31112.7%TRUEYes32061.5%72392.9%21002.0%FALSENoFALSE
22
RXLBlackpool Teaching Hospitals NHS Foundation Trust286114.6%396236.3%293727.8%TRUEYes10089611.2%778169.4%153833.9%TRUEYesTRUE
23
RMCBolton NHS Foundation Trust194784.0%94851.9%72712.6%FALSENo145152.7%276304.3%65141.2%FALSEYesFALSE
24
TADBradford District Care NHS Foundation Trust92733.3%42841.4%41692.4%FALSENo93302.7%42261.8%41492.7%FALSEYesFALSE
25
RAEBradford Teaching Hospitals NHS Foundation Trust266074.3%265814.5%102983.4%FALSENo376335.8%397185.4%93502.6%TRUEYesFALSE
26
RY2
Bridgewater Community Healthcare NHS Foundation Trust
43941.0%93102.9%41752.3%FALSEYes32481.2%62982.0%71275.5%FALSENoFALSE
27
RXHBrighton and Sussex University Hospitals NHS Trust8880610.9%132102712.9%9549419.2%TRUEYes395174022.7%180103717.4%8954316.4%TRUEYesTRUE
28
RXQBuckinghamshire Healthcare NHS Trust637029.0%617048.7%4743810.7%FALSEYes11684513.7%14584317.2%8944620.0%FALSENoFALSE
29
RJFBurton Hospitals NHS Foundation Trust173255.2%273587.5%161838.7%TRUEYes4838312.5%213995.3%61783.4%TRUEYesTRUE
30
RWYCalderdale and Huddersfield NHS Foundation Trust108581.2%245674.2%153054.9%TRUEYes526398.1%548276.5%113952.8%TRUEYesTRUE
31
RJXCalderstones Partnership NHS Foundation Trust125792.1%21311.5%#N/A#N/A#N/A#N/A#N/A41762.3%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
32
RGTCambridge University Hospitals NHS Foundation Trust133113911.7%165121413.6%10364615.9%TRUEYes267160216.7%245170314.4%13576017.8%FALSENoFALSE
33
RT1
Cambridgeshire and Peterborough NHS Foundation Trust
182926.2%154673.2%182596.9%FALSEYes334577.2%475029.4%272749.9%FALSENoFALSE
34
RYVCambridgeshire Community Services NHS Trust227922.8%32811.1%72023.5%FALSEYes82732.9%112584.3%71405.0%FALSENoFALSE
35
TAFCamden and Islington NHS Foundation Trust232479.3%242549.4%1511812.7%TRUEYes4228314.8%4731814.8%2013115.3%FALSENoFALSE
36
RV3Central and North West London NHS Foundation Trust648727.3%628457.3%364278.4%FALSEYes7066110.6%9587710.8%546188.7%FALSEYesFALSE
37
RYXCentral London Community Healthcare NHS Trust555769.5%404279.4%162307.0%FALSENo4833014.5%314666.7%2623311.2%FALSEYesFALSE
38
RW3
Central Manchester University Hospitals NHS Foundation Trust
7012735.5%8712886.8%548116.7%FALSEYes8515865.4%11516157.1%688138.4%FALSENoFALSE
39
RQM
Chelsea and Westminster Hospital NHS Foundation Trust
7447315.6%14577418.7%7940419.6%TRUEYes22693924.1%13778517.5%8356914.6%TRUEYesTRUE
40
RXACheshire and Wirral Partnership NHS Foundation Trust114372.5%43821.0%52142.3%FALSENo43481.1%53171.6%11800.6%FALSEYesFALSE
41
RBVChristie NHS Foundation Trust192856.7%272849.5%91844.9%FALSENo303299.1%3833511.3%121806.7%FALSEYesFALSE
42
RLNCity Hospitals Sunderland NHS Foundation Trust124592.6%114122.7%82563.1%TRUEYes164054.0%114452.5%72482.8%FALSEYesFALSE
43
RENClatterbridge Cancer Centre NHS Foundation Trust3943.2%7987.1%1741.4%FALSENo81008.0%51104.5%3754.0%TRUEYesFALSE
44
RDEColchester Hospital University NHS Foundation Trust394967.9%6454711.7%2725210.7%FALSEYes14864423.0%525269.9%314117.5%TRUEYesFALSE
45
RJ8Cornwall Partnership NHS Foundation Trust51832.7%41982.0%73032.3%FALSENo32041.5%3721511.7%42131.9%FALSENoFALSE
46
RJRCountess of Chester Hospital NHS Foundation Trust234305.3%214554.6%242569.4%FALSEYes324726.8%335206.3%82922.7%TRUEYesFALSE
47
RXPCounty Durham and Darlington NHS Foundation Trust138411.5%249122.6%93952.3%FALSEYes247643.1%717469.5%4942011.7%FALSENoFALSE
48
RYGCoventry and Warwickshire Partnership NHS Trust165063.2%205233.8%62432.5%FALSENo84531.8%195193.7%62852.1%FALSENoFALSE
49
RJ6Croydon Health Services NHS Trust424619.1%5842413.7%2725510.6%FALSEYes11155819.9%8649617.3%3025411.8%TRUEYesFALSE
50
RNNCumbria Partnership NHS Foundation Trust33590.8%73961.8%42311.7%FALSEYes74451.6%103882.6%41912.1%FALSENoFALSE
51
RN7Dartford and Gravesham NHS Trust162626.1%193215.9%121597.5%FALSEYes384019.5%383919.7%202159.3%FALSEYesFALSE
52
RTGDerby Teaching Hospitals NHS Foundation Trust247473.2%287553.7%244545.3%TRUEYes469784.7%6611295.8%225274.2%FALSEYesFALSE
53
RY8
Derbyshire Community Health Services NHS Foundation Trust
13840.3%34590.7%12340.4%FALSEYes24660.4%13890.3%22260.9%FALSENoFALSE
54
RXMDerbyshire Healthcare NHS Foundation Trust32371.3%62502.4%11130.9%FALSENo21751.1%32111.4%31262.4%FALSENoFALSE
55
RWVDevon Partnership NHS Trust132605.0%132605.0%81535.2%FALSEYes162995.4%173175.4%81525.3%FALSEYesFALSE
56
RP5
Doncaster and Bassetlaw Teaching Hospitals NHS Foundation Trust
95861.5%106681.5%73671.9%FALSEYes167182.2%186073.0%53721.3%FALSEYesFALSE
57
RBDDorset County Hospital NHS Foundation Trust102663.8%183135.8%81505.3%FALSEYes4034211.7%133373.9%81734.6%FALSEYesFALSE
58
RDYDorset Healthcare University NHS Foundation Trust215693.7%245804.1%205113.9%FALSEYes427056.0%516757.6%263637.2%FALSENoFALSE
59
RYK
Dudley and Walsall Mental Health Partnership NHS Trust
41193.4%2952.1%2623.2%FALSENo21111.8%21151.7%3614.9%FALSENoFALSE
60
RNADudley Group NHS Foundation Trust195753.3%154573.3%82623.1%FALSENo214574.6%265874.4%23540.6%TRUEYesFALSE
61
RWHEast and North Hertfordshire NHS Trust355876.0%6159210.3%3331810.4%TRUEYes14583617.3%8783710.4%394359.0%TRUEYesTRUE
62
RJNEast Cheshire NHS Trust123413.5%214175.0%81634.9%FALSEYes5146511.0%143094.5%61973.0%TRUEYesFALSE
63
RVVEast Kent Hospitals University NHS Foundation Trust227962.8%479584.9%364837.5%TRUEYes137118411.6%889479.3%314227.3%TRUEYesTRUE
64
RXREast Lancashire Hospitals NHS Trust227123.1%227133.1%124192.9%FALSENo287683.6%299283.1%74801.5%TRUEYesFALSE
65
RWKEast London NHS Foundation Trust5145811.1%576369.0%303648.2%FALSENo7771710.7%7170110.1%363779.5%TRUEYesFALSE
66
RX9East Midlands Ambulance Service NHS Trust32231.3%33280.9%41742.3%FALSEYes33600.8%65151.2%4122018.6%FALSENoFALSE
67
RYCEast of England Ambulance Service NHS Trust34250.7%63251.8%51792.8%TRUEYes195163.7%44860.8%103233.1%FALSEYesFALSE
68
RXCEast Sussex Healthcare NHS Trust426706.3%396016.5%393989.8%TRUEYes7469910.6%136101213.4%7151113.9%FALSENoFALSE
69
RVREpsom and St Helier University Hospitals NHS Trust364847.4%7753814.3%3628312.7%FALSEYes19371327.1%8164312.6%4330414.1%FALSEYesFALSE
70
RDUFrimley Health NHS Foundation Trust113101011.2%10210709.5%6659311.1%FALSENo137114512.0%231131017.6%13280416.4%FALSENoFALSE
71
RR7Gateshead Health NHS Foundation Trust83442.3%113013.7%52222.3%FALSENo144163.4%204944.0%72133.3%FALSEYesFALSE
72
RLTGeorge Eliot Hospital NHS Trust72902.4%82263.5%31312.3%FALSENo72542.8%203086.5%61234.9%FALSENoFALSE
73
R1JGloucestershire Care Services NHS Trust83542.3%53171.6%42111.9%FALSENo62922.1%103303.0%81605.0%FALSENoFALSE
74
RTEGloucestershire Hospitals NHS Foundation Trust357764.5%358414.2%204594.4%FALSENo569705.8%4910574.6%204384.6%TRUEYesFALSE
75
RP4
Great Ormond Street Hospital For Children NHS Foundation Trust
10252719.4%10760317.7%5831418.5%FALSENo14764822.7%16782920.1%8239920.6%FALSEYesFALSE
76
RN3Great Western Hospitals NHS Foundation Trust346505.2%599396.3%243137.7%TRUEYes546897.8%757589.9%637788.1%FALSENoFALSE
77
RXV
Greater Manchester Mental Health NHS Foundation Trust
113433.2%153314.5%111975.6%TRUEYes164073.9%164233.8%142974.7%FALSENoFALSE
78
RJ1Guy's and St Thomas' NHS Foundation Trust222192511.5%232179013.0%14892716.0%TRUEYes330212215.6%313203515.4%215130816.4%FALSENoFALSE
79
RN5Hampshire Hospitals NHS Foundation Trust526917.5%516977.3%263906.7%FALSENo698028.6%738808.3%464959.3%FALSENoFALSE
80
RCDHarrogate and District NHS Foundation Trust284656.0%174683.6%122275.3%FALSENo313917.9%394868.0%252749.1%FALSENoFALSE
81
T1510Health Education England43551.1%43031.3%32071.4%TRUEYes23250.6%02800.0%42631.5%FALSENoFALSE
82
T1480Health Research Authority0120.0%1244.2%1147.1%TRUEYes0280.0%0320.0%-14#VALUE!#VALUE!#VALUE!#VALUE!
83
RR1Heart of England NHS Foundation Trust4310384.1%4111053.7%266144.2%FALSEYes9912907.7%9912587.9%466756.8%FALSEYesFALSE
84
RY4Hertfordshire Community NHS Trust253826.5%213675.7%102813.6%FALSENo243886.2%183365.4%121597.5%FALSENoFALSE
85
RWR
Hertfordshire Partnership University NHS Foundation Trust
192936.5%203036.6%121547.8%TRUEYes263637.2%364138.7%183465.2%FALSEYesFALSE
86
RASHillingdon Hospitals NHS Foundation Trust213176.6%5137013.8%2118111.6%FALSEYes9855017.8%7148614.6%2717815.2%FALSEYesFALSE
87
RQQHinchingbrooke Health Care NHS Trust172167.9%3022813.2%1410713.1%FALSEYes4727217.3%3325013.2%#N/A#N/A#N/A#N/A#N/A#N/A
88
RQXHomerton University Hospital NHS Foundation Trust5449211.0%7351614.1%3024212.4%FALSEYes10655919.0%7756713.6%5226819.4%FALSENoFALSE
89
RY9
Hounslow and Richmond Community Healthcare NHS Trust
141569.0%121468.2%4636.3%FALSENo121488.1%2521511.6%7878.0%FALSEYesFALSE
90
RWAHull and East Yorkshire Hospitals NHS Trust246363.8%598067.3%244085.9%FALSEYes10391011.3%488805.5%264006.5%FALSEYesFALSE
91
RV9Humber NHS Foundation Trust32361.3%33480.9%16110.2%FALSENo63251.8%22900.7%42171.8%FALSEYesFALSE
92
RYJImperial College Healthcare NHS Trust161126912.7%158134911.7%11260618.5%FALSEYes278155217.9%314145721.6%17084720.1%FALSENoFALSE
93
RGQIpswich Hospital NHS Trust173684.6%214035.2%102074.8%FALSEYes427285.8%445248.4%83092.6%FALSEYesFALSE
94
R1FIsle of Wight NHS Trust192916.5%152985.0%61993.0%FALSENo113153.5%183515.1%51832.7%FALSEYesFALSE
95
RGP
James Paget University Hospitals NHS Foundation Trust
213206.6%192677.1%91486.1%FALSENo3631411.5%183505.1%101985.1%TRUEYesFALSE
96
RXY
Kent and Medway NHS and Social Care Partnership Trust
133973.3%184114.4%92513.6%FALSEYes244355.5%264236.1%102623.8%FALSEYesFALSE
97
RYYKent Community Health NHS Foundation Trust238192.8%249912.4%144523.1%FALSEYes206233.2%236083.8%123014.0%FALSENoFALSE
98
RNQKettering General Hospital NHS Foundation Trust193645.2%273946.9%112254.9%FALSENo6954412.7%6756711.8%192956.4%TRUEYesFALSE
99
RJZKing's College Hospital NHS Foundation Trust175166810.5%232161814.3%8884410.4%FALSENo332170219.5%210176811.9%11290012.4%FALSEYesFALSE
100
RAXKingston Hospital NHS Foundation Trust394169.4%5437614.4%3920319.2%TRUEYes9055716.2%8559914.2%4327215.8%FALSEYesFALSE