ESIF 2014 – 2020 ERDF-CF-ESF Raw Categorisation

Regio-Eval@ec.europa.eu

@esifunds.xe4p_7b9q

Table List

1 table(100.66 KB)

Table 1

@esifunds.xe4p_7b9q.table_1

100.66 KB
1000 rows
37 columns

country Country	programme_cci_code Programme Cci Code	programme_tle_shrt Programme Tle Shrt	year Year	fin_data_report_vers Fin Data Report Vers	status Status	priority_axis_code Priority Axis Code	to_by_priority_axis To By Priority Axis	to_short_name To Short Name	fund Fund	category_of_region Category Of Region	calculation_basis Calculation Basis	interv_field_code Interv Field Code	interv_field_tle_shrt Interv Field Tle Shrt	form_of_fin_code Form Of Fin Code	form_of_fin_tle_shrt Form Of Fin Tle Shrt	terr_dim_code Terr Dim Code	terr_dim_title_shrt Terr Dim Title Shrt	terr_dlry_mech_code Terr Dlry Mech Code	terr_dlry_mech_tle_shrt Terr Dlry Mech Tle Shrt	them_object_code Them Object Code	them_object_descrpt Them Object Descrpt	to_code_shrt_tle To Code Shrt Tle	esf_sec_them_code Esf Sec Them Code	esf_sec_them_tle_shrt Esf Sec Them Tle Shrt	eco_dim_code Eco Dim Code	eco_dim_tle_shrt Eco Dim Tle Shrt	loc_dim_code Loc Dim Code	loc_dim_tle_shrt Loc Dim Tle Shrt	elig_cost_calculation Elig Cost Calculation	tot_elig_cost Tot Elig Cost	public_elig_cost Public Elig Cost	tot_expend_declared Tot Expend Declared	number_of_operations Number Of Operations	cofin_rate Cofin Rate	tot_elig_eu_cost Tot Elig Eu Cost	tot_expend_eu_declared Tot Expend Eu Declared
FI	2014FI16M2OP001	Sustainable growth and jobs - FI - ERDF/ESF	2015	201601	Sent	4	10	Educational & Vocational Training	ESF	More developed	Public	117	117-Enhancing equal access to lifelong learning	1	01-Non-repayable grant	2	02-Small Urban areas (intermediate density >5 000 population)	7	07-Not applicable	VOID	VOID	VOID	01	01-Supporting the shift to a low-carbon, green economy	19	19-Education	FI1D6	FI1D6-Pohjois-Pohjanmaa	36795.38	40107.88	36795.38		1	50	20053.94
CZ	2014CZ05M9OP001	Employment, Human Capital and Social Cohesion - CZ - ESF/YEI	2016	201701	Sent	1	08	Sustainable & Quality Employment	ESF	Less developed	Total	106	106-Adapting of workers, enterprises & entrepreneurs to change	1	01-Non-repayable grant	1	01-Large Urban areas (densely populated >50 000 population)	7	07-Not applicable	VOID	VOID	VOID	08	08-Not applicable	18	18-Public administration	CZ071	CZ071-Olomoucký kraj	4982223.15	4982223.15	4982223.15	10409.3	2	84.999999955721	4234889.67529392	8847.90499539086
MT	2014MT16M1OP001	Fostering a competitive and sustainable economy - MT - ERDF/CF	2016	201701.1	Sent	PA 5	06	Environment Protection & Resource Efficiency	ERDF	Transition	Public	94	094-Protect, develop & promote public cultural assets	1	01-Non-repayable grant	2	02-Small Urban areas (intermediate density >5 000 population)	7	07-Not applicable				VOID	VOID	23	23-Arts, entertainment, creative industries and recreation	MT001	MT001-Malta	33507112.42	33507112.42	33507112.42		10	79.9999994449561	26805689.7500208
CZ	2014CZ05M9OP001	Employment, Human Capital and Social Cohesion - CZ - ESF/YEI	2016	201701	Sent	1	08	Sustainable & Quality Employment	ESF	Less developed	Total	105	105-Equality between men & women in all areas	1	01-Non-repayable grant	3	03-Rural areas (thinly populated)	7	07-Not applicable	VOID	VOID	VOID	07	07-Gender equality	20	20-Human health activities	CZ051	CZ051-Liberecký kraj						84.999999955721
CZ	2014CZ05M9OP001	Employment, Human Capital and Social Cohesion - CZ - ESF/YEI	2016	201701	Sent	1	08	Sustainable & Quality Employment	ESF	Less developed	Total	105	105-Equality between men & women in all areas	1	01-Non-repayable grant	1	01-Large Urban areas (densely populated >50 000 population)	7	07-Not applicable	VOID	VOID	VOID	07	07-Gender equality	24	24-Other unspecified services	CZ072	CZ072-Zlínský kraj	116672.22	116672.22	116672.22		8	84.999999955721	99171.3869483387
GR	2014GR16M3TA001	Technical assistance - GR - ERDF/ESF/CF	2016	201701	Sent	1	TA	Technical Assistance	ERDF	Less developed	Public	121	121-Preparation, implementation, monitoring and inspection	1	01-Non-repayable grant	7	07-Not applicable	7	07-Not applicable				VOID	VOID	18	18-Public administration	EL21	EL21-Ήπειρος (Ipeiros)	14162751.79	14162751.79	14162751.79	2749254.39	22	79.9999996806824	11330201.3867758	2199403.50322115
DE	2014DE16RFOP009	Nordrhein-Westfalen - ERDF	2016	201701	Sent	3	04	Low-Carbon Economy	ERDF	More developed	Total	16	016-High efficiency co-generation and district heating	1	01-Non-repayable grant	1	01-Large Urban areas (densely populated >50 000 population)	7	07-Not applicable	04	Supporting the shift towards a low-carbon economy in all ...	TO 4 Low Carbon	VOID	VOID	7	07-Other unspecified manufacturing industries	DEA58	DEA58-Märkischer Kreis	18900	18900	9450	18900	1	50	9450	9450
DE	2014DE05SFOP010	Nordrhein-Westfalen - ESF	2016	201701	Sent	1	08	Sustainable & Quality Employment	ESF	More developed	Total	106	106-Adapting of workers, enterprises & entrepreneurs to change	1	01-Non-repayable grant	1	01-Large Urban areas (densely populated >50 000 population)	7	07-Not applicable	VOID	VOID	VOID	08	08-Not applicable	19	19-Education	DE6	DE6-HAMBURG	694815.36	694815.36	292674.33	694815.36	146	50	347407.68	347407.68
ES	2014ES16RFOP005	Asturias - ERDF	2015	201601.1	Sent	01	01	Research & Innovation	ERDF	More developed	Public												VOID	VOID										79.9999995003376
SE	2014SE16RFOP003	West Sweden - ERDF	2016	201701	Sent	2	03	Competitiveness of SMEs	ERDF	More developed	Total	67	067-SME business development, entrepreneurship & incubation	1	01-Non-repayable grant	1	01-Large Urban areas (densely populated >50 000 population)	7	07-Not applicable	03	Enhancing the competitiveness of small and mediumsized ...	TO 3 SMEs	VOID	VOID	23	23-Arts, entertainment, creative industries and recreation	SE23	SE23-Västsverige	715137	715137	429082	37552	1	39.9999996280913	286054.797340343	15020.7998603408


CREATE TABLE table_1 (
  "country" VARCHAR,
  "programme_cci_code" VARCHAR,
  "programme_tle_shrt" VARCHAR,
  "year" BIGINT,
  "fin_data_report_vers" DOUBLE,
  "status" VARCHAR,
  "priority_axis_code" VARCHAR,
  "to_by_priority_axis" VARCHAR,
  "to_short_name" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "calculation_basis" VARCHAR,
  "interv_field_code" DOUBLE,
  "interv_field_tle_shrt" VARCHAR,
  "form_of_fin_code" DOUBLE,
  "form_of_fin_tle_shrt" VARCHAR,
  "terr_dim_code" DOUBLE,
  "terr_dim_title_shrt" VARCHAR,
  "terr_dlry_mech_code" DOUBLE,
  "terr_dlry_mech_tle_shrt" VARCHAR,
  "them_object_code" VARCHAR,
  "them_object_descrpt" VARCHAR,
  "to_code_shrt_tle" VARCHAR,
  "esf_sec_them_code" VARCHAR,
  "esf_sec_them_tle_shrt" VARCHAR,
  "eco_dim_code" DOUBLE,
  "eco_dim_tle_shrt" VARCHAR,
  "loc_dim_code" VARCHAR,
  "loc_dim_tle_shrt" VARCHAR,
  "elig_cost_calculation" DOUBLE,
  "tot_elig_cost" DOUBLE,
  "public_elig_cost" DOUBLE,
  "tot_expend_declared" DOUBLE,
  "number_of_operations" BIGINT,
  "cofin_rate" DOUBLE,
  "tot_elig_eu_cost" DOUBLE,
  "tot_expend_eu_declared" DOUBLE
);