myeu.uk Stories with Westminster Parliamentary Constituency

	A	B	F	G	J	K
1	myeu.uk Stories with Westminster Parliamentary Constituency		Last Updated:	19 Apr 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	Columns				Counts
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	Columns					Counts
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	signs_with_constituency
55	User-uploaded pictures of signs with constituency and nearest postcode, where available.
56	Refreshes hourly.
57
58	Columns
59	id	Direct link to the sign on the map; the UUID4 after sign/ is the unique ID for the sign.
60	latitude	Latitude of the sign, either from the user's device, EXIF data, or manual search by moderators.
61	longitude	Longitude of the sign, either from the user's device, EXIF data, or manual search by moderators.
62	title	User-supplied title for the picture of the sign.
63	postcode	Nearest postcode, where known (from https://postcodes.io/).
64	parliamentaryConstituency	Westminster Parliamentary Constituency name, where known (from https://postcodes.io/).
65
66	License
67	The data used in this sheet are subject to various licenses. See https://www.myeu.uk/about/ for licensing information for each dataset.
68	Contains OS data © Crown copyright and database right 2019.
69	These notes are licenced CC-BY. Copyright © 2019 The myeu.uk team.
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