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

European Commission - Directorate-General for Regional and Urban Policy

@esifunds.n_9fpg_67a4

Table List

1 table(97.88 KB)

Table 1

@esifunds.n_9fpg_67a4.table_1

97.88 KB
1000 rows
29 columns

ctry_code Ctry Code	cci Cci	cci_title Cci Title	ver Ver	status Status	pax_cd Pax Cd	pax_name Pax Name	dim_type Dim Type	dim_cd Dim Cd	dim_description Dim Description	fund Fund	category_of_region Category Of Region	is_multi_to Is Multi To	to_cd To Cd	to_short_name To Short Name	eu_amount Eu Amount	dimension_title_short Dimension Title Short	last_modification_date Last Modification Date	eu_co_financing Eu Co Financing	total_planned Total Planned
SE	2014SE16RFOP006	North-Central Sweden - ERDF	9	Adopted by MS	5	Tekniskt stöd(TA)	FinanceForm	1	Non-repayable grant	ERDF	More developed	N	TA	Technical Assistance	5881820	01 - Non-repayable grant	Tue Jul 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5	11763640
FR	2014FR16M2OP009	Poitou-Charentes - ERDF/ESF	11	Adopted by MS	Axe11	Accompagner la relance du territoire néo-aquitain verte, résiliente et numérique	InterventionField	78	e-Government services and applications (including e-Procurement, ICT measures supporting the reform of public administration, cyber-security, trust and privacy measures, e-Justice and e-Democracy)	ERDF	REACT-EU	N	13	Fostering crisis repair and resilience	1089606	078 - e-Government services & applications	Thu May 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8	1362007.5
GR	2014GR16M2OP005	Western Greece - ERDF/ESF	8	Adopted by MS	3	Ανάπτυξη - Εκσυγχρονισμός – Συμπλήρωση μεταφορικών υποδομών	Territorial Delivery Mechanism	1	Integrated Territorial Investment – Urban	ERDF	Less developed	N	07	Network Infrastructures in Transport and Energy	4640000	01 - Integrated territorial investment (SUD)	Fri Oct 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.7999999	5800000.72500009
PL	2014PL16M2OP002	Kujawsko-Pomorskie Voivodeship - ERDF/ESF	14	Adopted by MS	01	WZMOCNIENIE INNOWACYJNOŚCI I KONKURENCYJNOŚCI GOSPODARKI REGIONU	InterventionField	62	Technology transfer and university-enterprise cooperation primarily benefiting SMEs	ERDF	Less developed	Y	Multi	Multi	23623711	062 - Tech-transfer & university-SME cooperation	Thu Jul 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.85	27792601.1764706
CY	2014CY16M1OP001	Competitiveness and sustainable development - CY - ERDF/CF	12	Adopted by MS	2	Προώθηση της Χρήσης των ΤΠΕ	FinanceForm	1	Non-repayable grant	ERDF	More developed	N	02	Information & Communication Technologies	33500000	01 - Non-repayable grant	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.85	39411764.7058824
PL	2014PL16M2OP008	Opolskie Voivodeship - ERDF/ESF	9.1	Adopted by MS	XII	WSPARCIE W RAMACH REACT - EU W WOJEWÓDZTWIE OPOLSKIM	Territorial Delivery Mechanism	7	Not applicable	ERDF	REACT-EU	N	13	Fostering crisis repair and resilience	11526461	07 - Not applicable	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.9	12807178.8888889
SE	2014SE16RFOP008	Upper Norrland - ERDF	9	Adopted by MS	6	Tekniskt stöd	InterventionField	122	Evaluation and studies	ERDF	More developed	N	TA	Technical Assistance	424131	122 - Evaluation and studies	Tue Jul 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5	848262
TC	2014TC16RFCB037	Interreg V-A - Italy-Malta	4	Adopted by MS	4	Assistenza Tecnica	FinanceForm	1	Non-repayable grant	ERDF		N	TA	Technical Assistance	3000000	01 - Non-repayable grant	Fri Jul 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8499999	3529412.17993084
ES	2014ES16RFOP009	Castilla y León - ERDF	12	Adopted by MS	20	EP20 REACT EU	InterventionField	50	Education infrastructure for vocational education and training and adult learning	ERDF	REACT-EU	N	13	Fostering crisis repair and resilience	1880147	050 - Education infrastructure for VET & adult learning	Fri Sep 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1880147
PL	2014PL16M2OP006	Małopolskie Voivodeship - ERDF/ESF	12	Adopted by MS	10	Wiedza i kompetencje	EsfSecondaryTheme	6	Non-discrimination	ESF	Less developed	N	10	Educational & Vocational Training	201536502	06 - Non-discrimination	Tue Oct 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.85	237101767.058824


CREATE TABLE table_1 (
  "ctry_code" VARCHAR,
  "cci" VARCHAR,
  "cci_title" VARCHAR,
  "ver" DOUBLE,
  "status" VARCHAR,
  "pax_cd" VARCHAR,
  "pax_name" VARCHAR,
  "dim_type" VARCHAR,
  "dim_cd" BIGINT,
  "dim_description" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "is_multi_to" VARCHAR,
  "to_cd" VARCHAR,
  "to_short_name" VARCHAR,
  "eu_amount" DOUBLE,
  "dimension_title_short" VARCHAR,
  "last_modification_date" TIMESTAMP,
  "eu_co_financing" DOUBLE,
  "total_planned" DOUBLE,
  "climate_weighting" DOUBLE,
  "planned_eu_amount_climate_action" DOUBLE,
  "planned_total_amount_climate_action" DOUBLE,
  "biodiversity_weighting" DOUBLE,
  "planned_eu_amount_biodiversity" DOUBLE,
  "planned_total_amount_biodiversity" DOUBLE,
  "clean_air_weighting" DOUBLE,
  "planned_eu_amount_clean_air" DOUBLE,
  "planned_total_amount_clean_air" DOUBLE
);