ESIF 2014-2020 EU Payments (daily Update) Timeseries

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

@esifunds.gayr_92qh

Table List

1 table(100.1 KB)

Table 1

@esifunds.gayr_92qh.table_1

100.1 KB
1000 rows
22 columns

ms Ms	ms_name Ms Name	cci Cci	title Title	fund Fund	category_of_region Category Of Region	year Year	net_planned_eu_amount Net Planned Eu Amount	cumulative_initial_pre_financing Cumulative Initial Pre Financing	cumulative_annual_pre_financing Cumulative Annual Pre Financing	pre_financing_covered_by_expenditure Pre Financing Covered By Expenditure	recovery_of_annual_pre_financing Recovery Of Annual Pre Financing	net_pre_financing Net Pre Financing	cumulative_interim_payments Cumulative Interim Payments	recovery_of_expenses Recovery Of Expenses	net_interim_payments Net Interim Payments	total_net_payments Total Net Payments	eu_payment_rate Eu Payment Rate	eu_payment_rate_on_planned_eu_amount Eu Payment Rate On Planned Eu Amount	is_latest_period Is Latest Period
ES	Spain	2014ES05SFOP012	Social inclusion and social economy - ES - ESF	ESF	Transition	2016	484248090	15931762.18	9103864.1			25035626.28				25035626.28	5.17000000557565	5.17000000557565	N
SK	Slovakia	2014SK05M0OP001	Human Resources - SK - ESF/ERDF/YEI	YEI ESF Matching Component		2019	122175259	2165257.77	8093470.77	1240374.3	4353199.71	4665154.53	54513257.46	3624106.72	52129525.04	56794679.57	46.4862362763643	46.4862362763643	N
PL	Poland	2014PL16M2OP004	Lubuskie Voivodeship - ERDF/ESF	ESF	Less developed	2021	249466244	7194241.47	36763891.38	8734935.84	19201526.59	16021670.42	161264402.37	4000490.35	165998847.86	182020518.28	72.9639871757559	72.9639871757559	N
IT	Italy	2014IT06RDRP018	Calabria - Rural Development	EAFRD	EURI	2020													N
RO	Romania	2014RO16RFOP001	Competitiveness Programme - RO - ERDF	ERDF	More developed	2025	358523697	9359521.09	48098345.66	19660853.08	24422274.29	13374739.38	394890620.73	85772110.75	328779363.06	342154102.44	95.4341666403156	95.4341666403156	Y
AT	Austria	2014AT05SFOP001	Employment - AT - ESF	ESF	More developed	2022	416781119	11753227.56	68581333.15	20241358.25	36025906.44	24067296.02	347244951.52		367486309.77	391553605.79	93.9470594851971	93.9470594851971	N
PL	Poland	2014PL16M2OP007	Mazowieckie Voivodeship - ERDF/ESF	ESF	More developed	2021	545153821	15373337.7	78801984.6	16293139.17	42700875.41	35181307.72	314753211.62	695777.91	330350572.88	365531880.6	67.0511452950084	67.0511452950084	N
ES	Spain	2014ES06RDRP004	Baleares - Rural Development	EAFRD	EURI	2016													N
ES	Spain	2014ES16RFOP008	Cantabria - ERDF	ERDF	More developed	2020	60087073	1716257.31	6792539	2094932.71	2775092.12	3638771.48	35665493.84		37760426.55	41399198.03	68.8986764757205	68.8986764757205	N
CZ	Czechia	2014CZ16RFOP002	Integrated Regional Programme - CZ - ERDF	ERDF	Less developed	2022	4739080738	130186703.22	771321275.32	288747537.77	358621680.34	254138760.43	3697794326.12		3986541863.89	4240680624.32	89.4831900692552	89.4831900692552	N


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "cci" VARCHAR,
  "title" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "year" BIGINT,
  "net_planned_eu_amount" DOUBLE,
  "cumulative_initial_pre_financing" DOUBLE,
  "cumulative_additional_initial_pre_financing" DOUBLE,
  "recovery_of_initial_pre_financing" DOUBLE,
  "cumulative_annual_pre_financing" DOUBLE,
  "pre_financing_covered_by_expenditure" DOUBLE,
  "recovery_of_annual_pre_financing" DOUBLE,
  "net_pre_financing" DOUBLE,
  "cumulative_interim_payments" DOUBLE,
  "recovery_of_expenses" DOUBLE,
  "net_interim_payments" DOUBLE,
  "total_net_payments" DOUBLE,
  "eu_payment_rate" DOUBLE,
  "eu_payment_rate_on_planned_eu_amount" DOUBLE,
  "is_latest_period" VARCHAR
);