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
You can access the reporting recipe relating to this investigation here
4
5
Data Tables
6
NationalThe percentage of EU nationals in the frontline staff of NHS Trusts in England
7
Outside LondonThe percentage of EU nationals in the frontline staff of NHS Trusts outside London
8
LondonThe percentage of EU nationals in the frontline staff of NHS Trusts in London
9
SpecialistThe percentage of EU nationals in the frontline staff of specialist NHS Trust hospitals
10
Change in nurses 2017-18Change in the numbers and percentage of EU nurses between 2017 and 2018
11
12
Data Fields
13
CodeUnique identifier assigned to the Trust by the NHS.
14
NameNHS Trust name.
15
AreaNHS area in which the Trust operates.
16
All staff_TotalHeadcount of all staff working for the Trust.
17
All staff_EUHeadcount of staff working for the Trust who are EU nationals.
18
All staff_%Percentage of staff working for the Trust who are EU nationals.
19
Frontline_Total
Headcount of frontline staff working for the Trust. We have defined 'frontline' as doctors, nurses and midwives.
20
Frontline_EU
Headcount of frontline staff working for the Trust who are EU nationals. We have defined 'frontline' as doctors, nurses and midwives.
21
Frontline_%
Percentage of frontline staff working for the Trust who are EU nationals. We have defined 'frontline' as doctors, nurses and midwives.
22
HCHS doctors_TotalHeadcount of doctors working for the Trust.
23
HCHS doctors_EUHeadcount of doctors working for the Trust who are EU nationals.
24
HCHS doctors_%Percentage of doctors working for the Trust who are EU nationals.
25
Nurses & health visitors_TotalHeadcount of nurses working for the Trust.
26
Nurses & health visitors_EUHeadcount of nurses working for the Trust who are EU nationals.
27
Nurses & health visitors_%Percentage of nurses working for the Trust who are EU nationals.
28
Midwives_TotalHeadcount of midwives working for the Trust.
29
Midwives_EUHeadcount of midwives working for the Trust who are EU nationals.
30
Midwives_%Percentage of midwives working for the Trust who are EU nationals.
31
Over 10
How many of the three frontline staff categories (doctors, nurses and midwives) exceed 10% of EU nationals
32
Frontline staff EU %, national rankRanking of Trust by percentage of EU frontline staff (1 = highest)
33
Doctors EU %, national rankRanking of Trust by percentage of doctors from EU (1 = highest)
34
Nurses EU %, national rankRanking of Trust by percentage of nurses from EU (1 = highest)
35
Midwives EU %, national rankRanking of Trust by percentage of midwives from EU (1 = highest)
36
Overall change in nurses, 2017-18Absolute change in number of nurses at Trust - net change
37
Change in EU nurses, 2017-18Absolute change in number of nurses from EU at Trust - net change
38
2017 total nursesHeadcount of nurses at the Trust, 2017
39
2017 EU nursesHeadcount of nurses from the EU at the Trust, 2017
40
2018 total nursesHeadcount of nurses at the Trust, 2018
41
2018 EU nursesHeadcount of nurses from the EU at the Trust, 2018
42
EU nurse change 17-18The change in EU nurses (net) from 2017 to 2018
43
Overall nurse change 17-18The change in all nurses (net) from 2017 to 2018
44
2017 % EU nursesThe percentage of nurses at the Trust from the EU in 2017
45
2018 % EU nursesThe percentage of nurses at the Trust from the EU in 2018
46
Total nursing staff change (%)The percentage change in total nurses at the Trust from 2017 to 2018
47
EU nursing staff change (%)The percentage change in nurses from the EU at the Trust from 2017 to 2018
48
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.
49
50
51
Notes
52
Cells are highlighted in green where EU nationals make up 10 or more percent of a given staff category
53
NHS areas are highlighted in yellow in the "Outside London" tab when the trust is located in the South of England
54
NHS areas are highlighted in red in the "Outside London" tab when the trust is located in the Midlands
55
NHS areas are highlighted in blue in the "Outside London" tab when the trust is located in the North of England
56
-
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
57
58
If you want to get in touch about this data email bureaulocal@gmail.com
59
This dataset was put together by The Bureau of Investigative Journalism. Please give credit when reporting on it.
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