ESIF 2014-2020 Categorisation ERDF-ESF-CF Planned Vs Implemented

DG REGIO

@esifunds.n_3kkx_ekfq

Table List

1 table(120.5 KB)

Table 1

@esifunds.n_3kkx_ekfq.table_1

120.5 KB
1000 rows
39 columns

ms Ms	cci Cci	title Title	programme_version Programme Version	status Status	priority Priority	pax_react_eu Pax React Eu	pax_care Pax Care	pax_react_eu_care Pax React Eu Care	fund Fund	category_of_region Category Of Region	year Year	dimension_type Dimension Type	dimension_title_short Dimension Title Short	dimension_code Dimension Code	dimension_title Dimension Title	financial_data_version Financial Data Version	eu_cofinancing_rate Eu Cofinancing Rate	planned_total_amount_notional Planned Total Amount Notional	planned_eu_amount Planned Eu Amount	total_eligible_costs_selected_fin_data Total Eligible Costs Selected Fin Data	eu_eligible_costs_selected_fin_data_notional Eu Eligible Costs Selected Fin Data Notional	public_eligible_costs_fin_data Public Eligible Costs Fin Data	total_elig_expenditure_declared_fin_data Total Elig Expenditure Declared Fin Data	eu_elig_expenditure_declared_fin_data_notional Eu Elig Expenditure Declared Fin Data Notional	reference_date Reference Date	number_of_operations Number Of Operations	to To	to_short To Short	sdg_mapping_description Sdg Mapping Description
SK	2014SK16M1OP001	Integrated Infrastructure - SK - ERDF/CF	6	Adopted by EC	9	N	N	N	ERDF	Less developed	2019	Location	Žilinský kraj	SK031	Žilinský kraj	202001.0	60.64760795			195828046.88	119455108.6	144609525.12	97028217.78	59187212.85	Tue Dec 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	360	01	Research & Innovation
CZ	2014CZ05M2OP001	Research Development and Education - CZ - ESF/ERDF	3	Adopted by EC	2	N	N	N	ESF	More developed	2019	EsfSecondaryTheme	04 - Strengthening research, technological development and innova	04	Strengthening research, technological development and innova	202001.0	50	22523190	11261595	9838172.19	4919086.1	9213960.64	4771016.32	2385508.16	Tue Dec 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	224	10	Educational & Vocational Training
GR	2014GR16M1OP001	Transport Infrastructure Environment and Sustainable Development - GR - ERDF/CF	3	Adopted by EC	15	N	N	N	ERDF	Less developed	2016	InterventionField	121 - Preparation, implementation, monitoring and inspection	121	Preparation, implementation, monitoring and inspection	201701.0	80	9572713.75	7658171	1117546.88	894037.5	1117546.88	46049.52	36839.62	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	17	TA	Technical Assistance	SDG not assigned
BG	2014BG05M9OP001	Human Resources Development - BG - ESF/YEI	2	Adopted by EC	ПО4	N	N	N	ESF	Less developed	2017	Territory	07 - Not applicable	07	Not applicable	201801.0	94.99999873			15338991.72	14572042.13	15338991.72			Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	87	MULTI	Multiple Thematic Objectives (ERDF/CF/ESF)
ES	2014ES16RFOP019	Murcia - ERDF	7	Adopted by EC	01	N	N	N	ERDF	Transition	2020	Territorial Delivery Mechanism	03 - Integrated territorial investment (other)	03	Integrated territorial investment (other)	202101.0	79.99999976	11603200	9282560						Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		01	Research & Innovation
IT	2014IT16RFOP013	Marche - ERDF	2.2	Adopted by EC	4	N	N	N	ERDF	More developed	2018	EsfSecondaryTheme	VOID - VOID	VOID	VOID	201901.0	50			31086007.19	15543003.6	31086007.19	17848349	8924174.5	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	61	04	Low-Carbon Economy	VOID
SE	2014SE16RFOP004	East-Central Sweden - ERDF	6	Adopted by EC	2	N	N	N	ERDF	More developed	2020	Economic Activity	03 - Manufacture of food products and beverages	03	Manufacture of food products and beverages	202101.0	50			39119	19559.5	39119	24474	12237	Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	03	Competitiveness of SMEs
ES	2014ES16RFOP011	Cataluña - ERDF	4	Adopted by EC	01	N	N	N	ERDF	More developed	2019	InterventionField	064 - R+I processes in SMEs (vouchers, process, design .)	064	Research and innovation processes in SMEs (including voucher schemes, process, design, service and social innovation)	202001.0	50	65589526	32794763	26568071.11	13284035.56	13404710.37	6748415.07	3374207.54	Tue Dec 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	104	01	Research & Innovation	SDG 9 Industry, innovation, infrastructure
TC	2014TC16RFCB023	Interreg V-A - Germany-The Netherlands	2.1	Adopted by EC	2	N	N	N	ERDF	VOID	2022	Economic Activity	24 - Other unspecified services	24	Other unspecified services	202301.0	50			33967873.39	16983936.7	28054066.41	31715249.2	15857624.6	Sat Dec 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16	11	Efficient Public Administration
TC	2014TC16RFCB035	Interreg V-A - Italy-Switzerland	4	Adopted by MS	1	N	N	N	ERDF	VOID	2021	Economic Activity	13 - ICT activities, incl. Telecoms	13	Information and communication activities, including telecomm	202201.0	84.64280643			1566151.92	1331229.13	1276505.39	802164.89	681840.16	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2	03	Competitiveness of SMEs


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "cci" VARCHAR,
  "title" VARCHAR,
  "programme_version" DOUBLE,
  "status" VARCHAR,
  "priority" VARCHAR,
  "pax_react_eu" VARCHAR,
  "pax_care" VARCHAR,
  "pax_react_eu_care" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "year" BIGINT,
  "dimension_type" VARCHAR,
  "dimension_title_short" VARCHAR,
  "dimension_code" VARCHAR,
  "dimension_title" VARCHAR,
  "financial_data_version" VARCHAR,
  "eu_cofinancing_rate" DOUBLE,
  "planned_total_amount_notional" DOUBLE,
  "planned_eu_amount" DOUBLE,
  "total_eligible_costs_selected_fin_data" DOUBLE,
  "eu_eligible_costs_selected_fin_data_notional" DOUBLE,
  "public_eligible_costs_fin_data" DOUBLE,
  "total_elig_expenditure_declared_fin_data" DOUBLE,
  "eu_elig_expenditure_declared_fin_data_notional" DOUBLE,
  "reference_date" TIMESTAMP,
  "planned_eu_amount_climate_change" DOUBLE,
  "eu_eligible_costs_notional_climate_change" DOUBLE,
  "eu_eligible_expenditure_notional_climate_change" DOUBLE,
  "planned_eu_amount_biodiversity" DOUBLE,
  "eu_eligible_costs_notional_biodiversity" DOUBLE,
  "eu_eligible_expenditure_notional_biodiversity" DOUBLE,
  "planned_eu_amount_clean_air" DOUBLE,
  "eu_eligible_costs_notional_clean_air" DOUBLE,
  "eu_eligible_expenditure_notional_clean_air" DOUBLE,
  "number_of_operations" DOUBLE,
  "to" VARCHAR,
  "to_short" VARCHAR,
  "sdg_mapping_description" VARCHAR
);