2021-2027 Achievement Details (multi-funds) Timeseries

REGIO-EVAL@ec.europa.eu

@esifunds.xi3a_zddk

Table List

1 table(122.27 KB)

Table 1

@esifunds.xi3a_zddk.table_1

122.27 KB
1000 rows
49 columns

ms Ms	ms_name Ms Name	cci Cci	programme_version Programme Version	programme_status Programme Status	programme_adoption_date Programme Adoption Date	programme_short_title Programme Short Title	programme_full_title_en Programme Full Title En	programme_full_title Programme Full Title	fund Fund	fund_family Fund Family	tod_cycle Tod Cycle	priority_code Priority Code	priority_name Priority Name	policy_objective_short_name Policy Objective Short Name	policy_objective_code Policy Objective Code	policy_objective_name Policy Objective Name	specific_objective_short Specific Objective Short	specific_objective_code Specific Objective Code	specific_objective_name Specific Objective Name	category_of_region Category Of Region	indicator_type Indicator Type	indicator_type_output_result Indicator Type Output Result	common_indicators_y_n Common Indicators Y N	indicator_short_name Indicator Short Name	ind_code Ind Code	indicator_long_name Indicator Long Name	measurement_unit Measurement Unit	term_indicator_measurement_unit Term Indicator Measurement Unit	term_target_measurement_unit Term Target Measurement Unit	common_indicator_code_output Common Indicator Code Output	programme_specific_indicator_code_output Programme Specific Indicator Code Output	rsv_indicator_code_output Rsv Indicator Code Output	ind_group_code Ind Group Code	milestone_value_2024 Milestone Value 2024	target_value_2029 Target Value 2029	add_to_open_data_y_n Add To Open Data Y N	visualise_by_fund_ms Visualise By Fund Ms	visualise_by_po_so Visualise By Po So	ind_group_name Ind Group Name	odp_order Odp Order	odp_indicator_code Odp Indicator Code	is_latest_tod_cycle Is Latest Tod Cycle
TC	Interreg	2021TC16RFTN004	3	Adopted by MS	Fri Feb 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Interreg VI-B - North Sea	(Interreg VI-B) North Sea	(Interreg VI-B) North Sea	Interreg Funds	Cohesion	202406	1	Priority 1: Robust and smart economies in the North Sea region	PO1 Smarter Europe	1	Smarter Europe	RSO1.1 Enhancing research and innovation	RSO1.1	Enhancing research and innovation	VOID	RESULT	COMMON	true	RCR79 Interreg: Joint strategies and action plans taken up	RCR79	Joint strategies and action plans taken up by organisations	joint strategy/action plan	VOID	VOID	VOID	VOID	VOID	RCR79		40	Y	N	N	ETC	1	RCR79	true
TC	Interreg	2021TC16RFCB039	2	Adopted by EC	Thu Nov 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Interreg VI-A - Belgium-France (Wallonie-Vlaanderen-France)	(Interreg VI-A) Belgium-France (Wallonie-Vlaanderen-France)	(Interreg VI-A) Belgium-France (Wallonie-Vlaanderen-France)	Interreg Funds	Cohesion	202406	4	Priorité 4 : Soutenir la cohésion sanitaire, sociale, culturelle et touristique du territoire	PO4 Social Europe	4	Social Europe	RSO4.6 Culture and sustainable tourism	RSO4.6	Culture and sustainable tourism	VOID	OUTPUT	COMMON	true	RCO116 Interreg: Jointly developed solutions	RCO116	Jointly developed solutions	solutions	VOID	VOID	RCO116	VOID	VOID	RCO116		10	Y	Y	Y	ETC	7	RCO116	true
NL	Netherlands	2021NL05SFPR001	1.2	Adopted by EC	Tue Aug 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	National Programme - NL - ESF+	ESF+ the Netherlands	ESF+ Nederland	ESF+	Cohesion	202406	3	Prioriteit Ondersteuning Meest Behoeftigen	PO4 Social Europe	4	Social Europe	ESO4.13 Addressing material deprivation	ESO4.13	Addressing material deprivation	Transition	RESULT	RESF	true	EMCR14: 65 years of age and above (non-food)	EMCR14	Number of end recipients 65 years of age and above	number of persons	VOID	VOID	VOID	VOID	VOID	EMCR14			Y	N	N	VOID	58	EMCR14	true
TC	Interreg	2021TC16RFCB041	1.3	Adopted by EC	Tue Sep 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Interreg VI-A - Belgium-The Netherlands (Vlaanderen-Nederland)	(Interreg VI-A) Belgium-The Netherlands (Vlaanderen-Nederland)	(Interreg VI-A) Belgium-The Netherlands (Vlaanderen-Nederland)	Interreg Funds	Cohesion	202406	B	Een groener Europa. Klimaat, milieu en natuur. (BD2)	PO2 Greener Europe	2	Greener Europe	RSO2.4 Climate change adaptation	RSO2.4	Climate change adaptation	VOID	OUTPUT	COMMON	true	RCO01 Firms: All firms	RCO01	Enterprises supported (of which: micro, small, medium, large)	enterprises	VOID	VOID	RCO01	VOID	VOID	RCO01	4	11	Y	Y	Y	ETC	14	RCO01	true
DE	Germany	2021DE05SFPR013	1.1	Adopted by EC	Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sachsen-Anhalt - ESF+	Programme ESF Plus 2021 - 2027 Saxony-Anhalt	ESF Plus Programm 2021 - 2027 Sachsen-Anhalt	ESF+	Cohesion	202406	A	Beitrag zu den Politikbereichen: Beschäftigung, Bildung, Soziale Inklusion und Gesundheit	PO4 Social Europe	4	Social Europe	ESO4.7 Lifelong learning and career transitions	ESO4.7	Lifelong learning and career transitions	Transition	OUTPUT	OESF	true	EECO13: Third country nationals	EECO13	Third country nationals	number of persons	VOID	VOID	VOID	VOID	VOID	EECO13			Y	Y	Y	VOID	13	EECO13	true
ES	Spain	2021ES05SFPR007	1	Adopted by EC	Tue Dec 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Asturias - ESF+	ESF+ Asturias	FSE+ Principado de Asturias	ESF+	Cohesion	202406	5	Empleo Juvenil	PO4 Social Europe	4	Social Europe	ESO4.12 Social integration of people at risk	ESO4.12	Social integration of people at risk	Transition	OUTPUT	COMMON	true	EECO07: Young people (18-29)	EECO07	Young people between 18 and 29 years of age	number of persons	VOID	VOID	EECO07	VOID	VOID	EECO06-07-08	78	234	Y	Y	Y	IJG	7	EECO07	true
PT	Portugal	2021PT16FFPR002	2.2	Adopted by EC	Fri Dec 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Azores Regional Programme 2021-2027	Azores Regional Programme 2021-2027	Programa Regional dos Açores 2021-2027	ESF+	Cohesion	202406	4D	Apoio aos Jovens	PO4 Social Europe	4	Social Europe	ESO4.1 Access to employment and activation measures for all	ESO4.1	Access to employment and activation measures for all	Less developed	OUTPUT	OESF	true	EECO09: ISCED 0-2	EECO09	Participants with lower secondary education or less	number of persons	VOID	VOID	VOID	VOID	VOID	EECO09-10-11			Y	Y	Y	VOID	9	EECO09	true
RO	Romania	2021RO16RFPR002	1.2	Adopted by EC	Mon Oct 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	North East – RO – ERDF	North East	Nord Est	ERDF	Cohesion	202406	P1	Nord-Est – O regiune mai competitiva, mai inovativa	PO1 Smarter Europe	1	Smarter Europe	RSO1.1 Enhancing research and innovation	RSO1.1	Enhancing research and innovation	Less developed	RESULT	COMMON	true	RCR02 Firms: Private investments	RCR02	Private investments matching public support (of which: grants, financial instruments)	euro	VOID	VOID	VOID	VOID	VOID	RCR02		17706000	Y	N	N	IJG	10	RCR02	true
DE	Germany	2021DE05SFPR003	1.2	Adopted by EC	Mon May 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Bayern - ESF+	Programme ESF Plus 2021 - 2027 Bavaria	ESF Plus Programm 2021 - 2027 Bayern	ESF+	Cohesion	202406	2	Innovative Maßnahmen	PO4 Social Europe	4	Social Europe	ESO4.8 Active inclusion and employability	ESO4.8	Active inclusion and employability	More developed	OUTPUT	OESF	true	EECO04: Inactive supported	EECO04	Inactive	number of persons	VOID	VOID	VOID	VOID	VOID	EECO02-04-05			Y	Y	Y	VOID	4	EECO04	true
IT	Italy	2021IT05SFPR017	1.2	Adopted by EC	Mon Oct 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Valle d'Aosta - ESF+	RP Valle d'Aosta ESF+ 2021-2027	PR Valle d'Aosta FSE+ 2021-2027	ESF+	Cohesion	202406	2	ISTRUZIONE E FORMAZIONE	PO4 Social Europe	4	Social Europe	ESO4.5 Improving education and training systems	ESO4.5	Improving education and training systems	More developed	OUTPUT	COMMON	true	EECO18: Supported public administrations or services	EECO18	Number of supported public administrations or public services	number of entities	VOID	VOID	EECO18	VOID	VOID	EECO18	25	100	Y	Y	Y	IJG	18	EECO18	true


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "cci" VARCHAR,
  "programme_version" DOUBLE,
  "programme_status" VARCHAR,
  "programme_adoption_date" TIMESTAMP,
  "programme_short_title" VARCHAR,
  "programme_full_title_en" VARCHAR,
  "programme_full_title" VARCHAR,
  "fund" VARCHAR,
  "fund_family" VARCHAR,
  "tod_cycle" BIGINT,
  "tod_reference_version" VARCHAR,
  "tod_status_short_name" VARCHAR,
  "priority_code" VARCHAR,
  "priority_name" VARCHAR,
  "step_priority" BOOLEAN,
  "policy_objective_short_name" VARCHAR,
  "policy_objective_code" BIGINT,
  "policy_objective_name" VARCHAR,
  "specific_objective_short" VARCHAR,
  "specific_objective_code" VARCHAR,
  "specific_objective_name" VARCHAR,
  "category_of_region" VARCHAR,
  "indicator_type" VARCHAR,
  "indicator_type_output_result" VARCHAR,
  "common_indicators_y_n" BOOLEAN,
  "indicator_short_name" VARCHAR,
  "ind_code" VARCHAR,
  "indicator_long_name" VARCHAR,
  "measurement_unit" VARCHAR,
  "term_indicator_measurement_unit" VARCHAR,
  "term_target_measurement_unit" VARCHAR,
  "common_indicator_code_output" VARCHAR,
  "programme_specific_indicator_code_output" VARCHAR,
  "rsv_indicator_code_output" VARCHAR,
  "ind_group_code" VARCHAR,
  "baseline_value" DOUBLE,
  "milestone_value_2024" DOUBLE,
  "target_value_2029" DOUBLE,
  "decided_value" VARCHAR,
  "implemented_value" VARCHAR,
  "add_to_open_data_y_n" VARCHAR,
  "visualise_by_fund_ms" VARCHAR,
  "visualise_by_po_so" VARCHAR,
  "ind_group_name" VARCHAR,
  "odp_order" BIGINT,
  "odp_indicator_code" VARCHAR,
  "is_latest_tod_cycle" BOOLEAN
);