ESIF 2014-2020 Financial Plans (daily Update)

European Commission - Regional Policy

@esifunds.rmer_4wcy

Table List

1 table(128.61 KB)

Table 1

@esifunds.rmer_4wcy.table_1

128.61 KB
1000 rows
27 columns

ms Ms	ms_name Ms Name	cci Cci	version Version	title Title	fund Fund	category_of_region Category Of Region	ec_decision_date Ec Decision Date	ec_decision_number Ec Decision Number	y2014_main_allocation Y2014 Main Allocation	y2014_performance_reserve Y2014 Performance Reserve	y2015_main_allocation Y2015 Main Allocation	y2015_performance_reserve Y2015 Performance Reserve	y2016_main_allocation Y2016 Main Allocation	y2016_performance_reserve Y2016 Performance Reserve	y2017_main_allocation Y2017 Main Allocation	y2017_performance_reserve Y2017 Performance Reserve	y2018_main_allocation Y2018 Main Allocation	y2018_performance_reserve Y2018 Performance Reserve	y2019_main_allocation Y2019 Main Allocation	y2019_performance_reserve Y2019 Performance Reserve	y2020_main_allocation Y2020 Main Allocation	y2020_performance_reserve Y2020 Performance Reserve	y2021_main_allocation Y2021 Main Allocation	y2022_main_allocation Y2022 Main Allocation	total_main_allocation Total Main Allocation	total_performance_reserve Total Performance Reserve
IT	Italy	2014IT05SFOP002	10	Systems for Active Employment Policies - IT - ESF	ESF	Less Developed	Thu Nov 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)7963	113375140	7236711	120460880	7688992	138835861	8861864	141614455	9039221	144448572	9220122	147339312	9404637	150287637	59405308			956361857	110856855
UK	United Kingdom	2014UK16RFOP005	5	West Wales and The Valleys - ERDF	ERDF	Less Developed	Thu Mar 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)1858	152166088	9712729	155212479	9907180	158319429	10105495	162080798	10345583	165324454	10552625	168632919	10763803	172007294	10979189			1133743461	72366604
IT	Italy	2014IT05SFOP002	10	Systems for Active Employment Policies - IT - ESF	ESF	REACT_EU	Thu Nov 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)7963															4547670000	1500279540	6047949540
FR	France	2014FR05M2OP001	10.1	Guadeloupe et St Martin - ESF/ERDF	ESF	REACT_EU	Wed Nov 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)7879															23338315	8231733	31570048
FR	France	2014FR05M2OP001	10.1	Guadeloupe et St Martin - ESF/ERDF	ERDF	REACT_EU	Wed Nov 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)7879															27000000	7231733	34231733
FR	France	2014FR05M2OP001	10.1	Guadeloupe et St Martin - ESF/ERDF	ERDF	Less Developed	Wed Nov 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)7879	3966616	253188	4046031	258257	4127024	263427	4209621	268699	4293867	274077	4379797	279562	5167440	285156			30190396	1882366
DE	Germany	2014DE05SFOP011	4	Saarland - ESF	ESF	REACT_EU	Mon Dec 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2022)9932															12081255	3783786	15865041
DK	Denmark	2014DK05SFOP001	10	Educational and Entrepreneurial Growth - DK - ESF	ESF	REACT_EU	Mon Mar 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2022)1421															54676326		54676326
FR	France	2014FR06RDRP093	12.1	Provence-Alpes-Côte d'Azur - Rural Development	EAFRD	EURI	Wed May 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2024)3272															9935640	9935640	33582440
FR	France	2014FR16M0OP009	13.1	Guadeloupe - ERDF/ESF/YEI	ESF	Less Developed	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	C(2023)6500	11030484	624903	11232992	655745	11399122	727604	11664617	704809	11877390	739586	12114737	754735	7356810	770187			76676152	4977569


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "cci" VARCHAR,
  "version" DOUBLE,
  "title" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "ec_decision_date" TIMESTAMP,
  "ec_decision_number" VARCHAR,
  "y2014_main_allocation" DOUBLE,
  "y2014_performance_reserve" DOUBLE,
  "y2015_main_allocation" DOUBLE,
  "y2015_performance_reserve" DOUBLE,
  "y2016_main_allocation" DOUBLE,
  "y2016_performance_reserve" DOUBLE,
  "y2017_main_allocation" DOUBLE,
  "y2017_performance_reserve" DOUBLE,
  "y2018_main_allocation" DOUBLE,
  "y2018_performance_reserve" DOUBLE,
  "y2019_main_allocation" DOUBLE,
  "y2019_performance_reserve" DOUBLE,
  "y2020_main_allocation" DOUBLE,
  "y2020_performance_reserve" DOUBLE,
  "y2021_main_allocation" DOUBLE,
  "y2022_main_allocation" DOUBLE,
  "total_main_allocation" DOUBLE,
  "total_performance_reserve" DOUBLE
);