Data: EU staff in NHS trusts
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
EU Staff in NHS trusts Investigation
2
A database of the percentage of EU nationals in frontline staff of NHS trusts, January 2018.
3
4
Data Tables
5
NationalThe percentage of EU nationals in the frontline staff of NHS Trusts in England
6
Outside LondonThe percentage of EU nationals in the frontline staff of NHS Trusts outside London
7
LondonThe percentage of EU nationals in the frontline staff of NHS Trusts in London
8
SpecialistThe percentage of EU nationals in the frontline staff of specialist NHS Trust hospitals
9
Change in nurses 2017-18Change in the numbers and percentage of EU nurses between 2017 and 2018
10
11
Data Fields
12
CodeUnique identifier assigned to the Trust by the NHS.
13
NameNHS Trust name.
14
AreaNHS area in which the Trust operates.
15
All staff_TotalHeadcount of all staff working for the Trust.
16
All staff_EUHeadcount of staff working for the Trust who are EU nationals.
17
All staff_%Percentage of staff working for the Trust who are EU nationals.
18
Frontline_Total
Headcount of frontline staff working for the Trust. We have defined 'frontline' as doctors, nurses and midwives.
19
Frontline_EU
Headcount of frontline staff working for the Trust who are EU nationals. We have defined 'frontline' as doctors, nurses and midwives.
20
Frontline_%
Percentage of frontline staff working for the Trust who are EU nationals. We have defined 'frontline' as doctors, nurses and midwives.
21
HCHS doctors_TotalHeadcount of doctors working for the Trust.
22
HCHS doctors_EUHeadcount of doctors working for the Trust who are EU nationals.
23
HCHS doctors_%Percentage of doctors working for the Trust who are EU nationals.
24
Nurses & health visitors_TotalHeadcount of nurses working for the Trust.
25
Nurses & health visitors_EUHeadcount of nurses working for the Trust who are EU nationals.
26
Nurses & health visitors_%Percentage of nurses working for the Trust who are EU nationals.
27
Midwives_TotalHeadcount of midwives working for the Trust.
28
Midwives_EUHeadcount of midwives working for the Trust who are EU nationals.
29
Midwives_%Percentage of midwives working for the Trust who are EU nationals.
30
Over 10
How many of the three frontline staff categories (doctors, nurses and midwives) exceed 10% of EU nationals
31
Frontline staff EU %, national rankRanking of Trust by percentage of EU frontline staff (1 = highest)
32
Doctors EU %, national rankRanking of Trust by percentage of doctors from EU (1 = highest)
33
Nurses EU %, national rankRanking of Trust by percentage of nurses from EU (1 = highest)
34
Midwives EU %, national rankRanking of Trust by percentage of midwives from EU (1 = highest)
35
Overall change in nurses, 2017-18Absolute change in number of nurses at Trust - net change
36
Change in EU nurses, 2017-18Absolute change in number of nurses from EU at Trust - net change
37
2017 total nursesHeadcount of nurses at the Trust, 2017
38
2017 EU nursesHeadcount of nurses from the EU at the Trust, 2017
39
2018 total nursesHeadcount of nurses at the Trust, 2018
40
2018 EU nursesHeadcount of nurses from the EU at the Trust, 2018
41
EU nurse change 17-18The change in EU nurses (net) from 2017 to 2018
42
Overall nurse change 17-18The change in all nurses (net) from 2017 to 2018
43
2017 % EU nursesThe percentage of nurses at the Trust from the EU in 2017
44
2018 % EU nursesThe percentage of nurses at the Trust from the EU in 2018
45
Total nursing staff change (%)The percentage change in total nurses at the Trust from 2017 to 2018
46
EU nursing staff change (%)The percentage change in nurses from the EU at the Trust from 2017 to 2018
47
Is the % loss of EU nurses higher than the Trust's overall loss of nurses?
The Bureau has used a formula to mark 'yes' if the total nursing staff has fallen and the fall in EU nurses is greater than the fall in nurses overall. i.e. EU nurses are leaving at higher rate than non-EU nurses.
48
49
50
Notes
51
Cells are highlighted in green where EU nationals make up 10 or more percent of a given staff category
52
NHS areas are highlighted in yellow in the "Outside London" tab when the trust is located in the South of England
53
NHS areas are highlighted in red in the "Outside London" tab when the trust is located in the Midlands
54
NHS areas are highlighted in blue in the "Outside London" tab when the trust is located in the North of England
55
-
Cells that are greyed out and marked with a "-" or #n/a, indicate that the percentage could not be calculated due to a division by zero, or data didn't exist
56
57
If you want to get in touch about this data email bureaulocal@gmail.com
58
This dataset was put together by The Bureau of Investigative Journalism. Please give credit when reporting on it.
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu