ESIF 2014-2020 Achievement Details Timeseries

European Commission

@esifunds.aesb_873i

Table List

1 table(47.77 KB)

Table 1

Table 1

@esifunds.aesb_873i.table_1

47.77 KB
1000 rows
39 columns

ms Ms	ms_name Ms Name	cci Cci	ver Ver	title Title	fund Fund	indicator_type_code Indicator Type Code	ind_code Ind Code	ind_group_code Ind Group Code	indicator_short_name Indicator Short Name	indicator_long_name Indicator Long Name	to To	to_short To Short	priority_code Priority Code	pax_react_eu Pax React Eu	pax_care Pax Care	pax_react_eu_care Pax React Eu Care	investment_priority Investment Priority	measure_code Measure Code	focus_area_code Focus Area Code	target_value Target Value	measurement_unit Measurement Unit	nominator Nominator	is_division Is Division	year Year	ir_ver Ir Ver	forecast_value Forecast Value	forecast_nominator Forecast Nominator	visualise_by_to Visualise By To	visualise_by_ms Visualise By Ms
RO	Romania	2015RO16RFSM001	1	SME Initiative (merged 2018 with Regional OP) - RO - ERDF	ERDF	OERDF	CO01	CO01	FIRMS: All firms	All firms receiving support	03	Competitiveness of SMEs	AP 1	N	N	N	3d	VOID	VOID	2500	Enterprises	2500	N	2015	2017			Y	Y
TC	Interreg	2014TC16RFCB004	1.1	Interreg V-A - Austria–Germany/Bayern	ERDF	OERDF	CO01	CO01	FIRMS: All firms	All firms receiving support	01	Research & Innovation	1	N	N	N	1b	VOID	VOID	50	Enterprises	50	N	2015	2021	100	100	Y	Y
TC	Interreg	2014TC16RFCB051	1.3	Interreg V-A - Mayotte-Comores-Madagascar	ERDF	OERDF	CO01	CO01	FIRMS: All firms	All firms receiving support	03	Competitiveness of SMEs	1	N	N	N	3d	VOID	VOID	50	Enterprises	50	N	2015	2021			Y	Y
DE	Germany	2014DE16RFOP012	1.2	Sachsen - ERDF	ERDF	OERDF	CO02	CO02	FIRMS: grant aided	Firms receiving grants	03	Competitiveness of SMEs	B	N	N	N	3d	VOID	VOID	95	Enterprises	95	N	2015				Y	Y
GR	Greece	2014GR16M2OP009	1.4	Ionian Islands - ERDF/ESF	ERDF	OERDF	CO02	CO02	FIRMS: grant aided	Firms receiving grants	03	Competitiveness of SMEs	1	N	N	N	3a	VOID	VOID	75	Enterprises	75	N	2015				Y	Y
TC	Interreg	2014TC16RFCB013	1.3	Interreg V-A - Poland-Denmark-Germany-Lithuania-Sweden (South Baltic)	ERDF	OERDF	CO02	CO02	FIRMS: grant aided	Firms receiving grants	03	Competitiveness of SMEs	I	N	N	N	3b	VOID	VOID	70	Enterprises	70	N	2015				Y	Y
DE	Germany	2014DE16RFOP003	1.2	Berlin - ERDF	ERDF	OERDF	CO03	CO03	FIRMS: non-grant aided	Firms receiving financial instrument support (non-grants)	04	Low-Carbon Economy	3	N	N	N	4b	VOID	VOID	200	Enterprises	200	N	2015				Y	Y
RO	Romania	2015RO16RFSM001	1	SME Initiative (merged 2018 with Regional OP) - RO - ERDF	ERDF	OERDF	CO03	CO03	FIRMS: non-grant aided	Firms receiving financial instrument support (non-grants)	03	Competitiveness of SMEs	AP 1	N	N	N	3d	VOID	VOID	2500	Enterprises	2500	N	2015	2017			Y	Y
FR	France	2014FR16M0OP013	1.2	Provence-Alpes-Côte d'Azur - ERDF/ESF/YEI	ERDF	OERDF	CO04	CO04	FIRMS: advised	Firms receiving non-financial support (advice)	03	Competitiveness of SMEs	1	N	N	N	3d	VOID	VOID	300	Enterprises	300	N	2015				Y	Y
TC	Interreg	2014TC16RFCB013	1.3	Interreg V-A - Poland-Denmark-Germany-Lithuania-Sweden (South Baltic)	ERDF	OERDF	CO04	CO04	FIRMS: advised	Firms receiving non-financial support (advice)	03	Competitiveness of SMEs	I	N	N	N	3b	VOID	VOID	280	Enterprises	280	N	2015				Y	Y


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "cci" VARCHAR,
  "ver" DOUBLE,
  "title" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "indicator_type_code" VARCHAR,
  "ind_code" VARCHAR,
  "ind_group_code" VARCHAR,
  "indicator_short_name" VARCHAR,
  "indicator_long_name" VARCHAR,
  "to" VARCHAR,
  "to_short" VARCHAR,
  "priority_code" VARCHAR,
  "pax_react_eu" VARCHAR,
  "pax_care" VARCHAR,
  "pax_react_eu_care" VARCHAR,
  "investment_priority" VARCHAR,
  "measure_code" VARCHAR,
  "focus_area_code" VARCHAR,
  "target_value" DOUBLE,
  "measurement_unit" VARCHAR,
  "nominator" DOUBLE,
  "denominator" VARCHAR,
  "is_division" VARCHAR,
  "year" BIGINT,
  "ir_ver" DOUBLE,
  "forecast_value" DOUBLE,
  "forecast_nominator" DOUBLE,
  "forecast_denominator" VARCHAR,
  "implemented_value" DOUBLE,
  "implemented_nominator" DOUBLE,
  "implemented_denominator" VARCHAR,
  "visualise_by_to" VARCHAR,
  "visualise_by_ms" VARCHAR,
  "ms_op_coverage" VARCHAR,
  "finance_coverage" VARCHAR,
  "ind_group_name" VARCHAR
);