myeu.uk Stories with Westminster Parliamentary Constituency
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
myeu.uk Stories with Westminster Parliamentary Constituency
Last Updated:17 Feb 2019
2
https://www.myeu.uk
3
4
project_stories_with_constituency
5
All project funding stories [1] on the map with their postcode, amounts and Westminster Parliamentary Constituency.
6
7
ColumnsCounts
8
my_eu_id
Internal unique identifier for the story.
48004
9
postcode
The postcode for the beneficiary (outward code, one space, inward code). The data are sorted on this column.
48004
10
project_title
Title of the project that was funded.
48004
11
organisation_name
Name of the beneficiary of the funding.
48004
12
eu_contribution_gbp
EU funding in GBP given to the beneficiary for the project, where known. [2] [3]
27434
13
project_eu_contribution_gbp
EU funding in GBP given for the project as a whole (possibly to multiple beneficiaries). [2]
48004
14
project_total_cost_gbp
Total cost in GBP for the project as a whole (often larger where the EU provided cofinancing), where known. [2]
28780
15
start_date
Start date for the funding to the beneficiary for the project (or for the project as a whole [3]) (YYYY-MM-DD).
48004
16
end_date
End date for the funding to the beneficiary for the project (or for the project as a whole [3]), where known (YYYY-MM-DD). [4]
28905
17
project_url
Website for the project, where known.
6534
18
organisation_url
Website for the beneficiary, where known.
41173
19
my_eu_url
Direct link to the project's postcode on myeu.uk for more information.
48004
20
parliamentary_constituency_name
Westminster Parliamentary Constituency name.
48004
21
22
Notes
23
[1] Stories based on Financial Transparency System (FTS) data are not included, because they are on a different basis (annual budget allocation rather than project costs).
24
[2] Where amounts have been converted from EUR to GBP, the conversion uses the average exchange rates between the start and end dates. Where end dates are not known, we have used the average exchange rate for the year of grant.
25
[3] Some datasets, notably Creative Europe and Erasmus, include only total project funding, not the amount of funding given to each beneficiary.
26
[4] Some datasets, notably Erasmus and LIFE, do not include end dates.
27
28
nhs_stories_with_constituency
29
Counts of NHS Hospital Trust staff who identify as being from the EU (excluding the UK) with hospital postcode and Westminster Parliamentary Constituency.
30
The data are from June, 2018. Only Hospital Trusts are included, not Clinical Care Groups.
31
Staff counts are Full Time Equivalents (FTEs), rather than headcounts, and have been rounded.
32
Staff counts are per trust, not per hospital. The finest granularity available is trust.
33
Source data: https://digital.nhs.uk/data-and-information/find-data-and-publications/supplementary-information/2018-supplementary-information-files/staff-numbers/hchs-staff-by-staff-group-nationality-and-organisation-september-2017-and-june-2018
34
35
ColumnsCounts
36
my_eu_id
Internal unique identifier for the story.
872
37
postcode
The postcode of the hospital
38
organisation
Three-letter NHS identifier for the NHS Hospital Trust.
39
organisation_name
Name of the NHS Hospital Trust.
40
hospital_organisation
Five-letter NHS identifier for the hospital.
41
hospital_name
Name of the NHS hospital.
42
eu_doctors
Full Time Equivalent staff in the trust in NHS staff group "HCHS doctors" with a stated nationality in an EU country other than the UK.
43
eu_nurses
Full Time Equivalent staff in the trust in NHS staff group "Nurses & health visitors" with a stated nationality in an EU country other than the UK.
44
eu_other
Full Time Equivalent staff in the trust in other NHS staff groups with a stated nationality in an EU country other than the UK.
45
non_eu_doctors
Full Time Equivalent staff in the trust in NHS staff group "HCHS doctors" with a stated nationality in the UK or a non-EU (rest of world) country.
46
non_eu_nurses
Full Time Equivalent staff in the trust in NHS staff group "Nurses & health visitors" with a stated nationality in the UK or a non-EU (rest of world) country.
47
non_eu_other
Full Time Equivalent staff in the trust in other NHS staff groups with a stated nationality in the UK or a non-EU (rest of world) country.
48
unknown_doctors
Full Time Equivalent staff in the trust in NHS staff group "HCHS doctors" without a stated nationality.
49
unknown_nurses
Full Time Equivalent staff in the trust in NHS staff group "Nurses & health visitors" without a stated nationality.
50
unknown_other
Full Time Equivalent staff in the trust in other NHS staff groups without a stated nationality.
51
my_eu_url
Direct link to the project's postcode on myeu.uk for more information.
52
parliamentary_constituency_name
Westminster Parliamentary Constituency name.
53
54
License
55
The data used in this sheet are subject to various licenses. See https://www.myeu.uk/about/ for licensing information for each dataset.
56
Contains OS data © Crown copyright and database right 2019.
57
These notes are licenced CC-BY. Copyright © 2019 The myeu.uk team.
58
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