2021-2027 EU Payment Details (timeseries)

REGIO-A3-BUDGET-TEAM@ec.europa.eu

@esifunds.pbbz_hmfu_1

Table List

1 table(79.52 KB)

Table 1

@esifunds.pbbz_hmfu_1.table_1

79.52 KB
1000 rows
20 columns

ms Ms	ms_name Ms Name	cci Cci	title Title	fund Fund	category_of_region Category Of Region	year Year	init_plan_eu_amt_1_adoption Init Plan Eu Amt 1 Adoption	actual_plan_eu_amt_latest_adop Actual Plan Eu Amt Latest Adop	pre_fin Pre Fin	recovery_of_pre_financing Recovery Of Pre Financing	net_pre_financing Net Pre Financing	interim_payments Interim Payments	net_interim_payments Net Interim Payments	total_net_payments Total Net Payments	eu_payment_rate_init_plan_eu_amt Eu Payment Rate Init Plan Eu Amt	eu_payment_rate_actual_plan_eu_amt Eu Payment Rate Actual Plan Eu Amt	is_latest_period Is Latest Period
SI	Slovenia	2021SI16FFPR001	EU Cohesion Policy - SI - ERDF/CF/ESF+/JTF	JTF	VOID	2025	258724543	258724543	82791853.78	2587245.44	80204608.34	967204.19	967204.19	81171812.53	0.313738355042722	0.313738355042722	Y
TC	Interreg	2021TC16FFOR005	Interreg VI-D - Amazonie	ERDF	VOID	2023	18899049	18899049	944952.45		944952.45			944952.45	0.05	0.05	N
BG	Bulgaria	2021BG05SFPR001	Education - BG - ESF+	ESF+	Less developed	2025	630989855	630989855	18929695.68	6309898.56	12619797.12	13525357.25	13525357.25	26145154.37	0.0414351422020882	0.0414351422020882	Y
BG	Bulgaria	2021BG05SFPR001	Education - BG - ESF+	ESF+	Transition	2025	155805145	155805145	4674154.32	1558051.44	3116102.88	3168865.57	3168865.57	6284968.45	0.0403386451070021	0.0403386451070021	Y
RO	Romania	2021RO05SFPR001	Education and Employment – RO – ESF+	ESF+	More developed	2023	144000300	144000300	3600007.5		3600007.5			3600007.5	0.025	0.025	N
SE	Sweden	2021SE16RFPR004	East-Central Sweden – ERDF ERDF	ERDF	More developed	2025	64282080	64282080	1928462.4	642820.8	1285641.6	7801724.15	7801724.15	9087365.75	0.141367014726344	0.141367014726344	Y
PL	Poland	2021PL16FFPR001	Dolny Śląsk - PL - ERDF/ESF+/JTF	JTF	VOID	2023	581587571	581587571	8723813.58		8723813.58			8723813.58	0.0150000000257915	0.0150000000257915	N
SE	Sweden	2021SE16RFPR009	Investments in growth and jobs - SE – ERDF	ERDF	More developed	2025	122315677	122315677	3669470.34	1223156.78	2446313.56	8939968.93	8939968.93	11386282.49	0.0930893142176697	0.0930893142176697	Y
SE	Sweden	2021SE16RFPR007	Central Norrland – ERDF	ERDF	More developed	2025	83221351	83221351	2496640.56	832213.52	1664427.04	2847879.8	2847879.8	4512306.84	0.0542205429950302	0.0542205429950302	Y
SE	Sweden	2021SE16RFPR006	North-Central Sweden – ERDF	ERDF	Transition	2025	134980262	134980262	4049407.86	1349802.62	2699605.24	10158430.8	10158430.8	12858036.04	0.095258638926038	0.095258638926038	Y


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "cci" VARCHAR,
  "title" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "year" BIGINT,
  "init_plan_eu_amt_1_adoption" DOUBLE,
  "transfers" DOUBLE,
  "actual_plan_eu_amt_latest_adop" DOUBLE,
  "pre_fin" DOUBLE,
  "recovery_of_pre_financing" DOUBLE,
  "net_pre_financing" DOUBLE,
  "interim_payments" DOUBLE,
  "recovery_of_expenses" DOUBLE,
  "net_interim_payments" DOUBLE,
  "total_net_payments" DOUBLE,
  "eu_payment_rate_init_plan_eu_amt" DOUBLE,
  "eu_payment_rate_actual_plan_eu_amt" DOUBLE,
  "is_latest_period" VARCHAR
);