COVID19 / CRII - ESIF - 2014-2020 ERDF-ESF Enterprise Reprogramming

Regio-Eval@ec.europa.eu

@esifunds.n_9kj3_3bij_1

Table List

1 table(59.2 KB)

Table 1

@esifunds.n_9kj3_3bij_1.table_1

59.2 KB
1000 rows
20 columns

country_code Country Code	cci Cci	cci_title Cci Title	ver Ver	status Status	pax_cd Pax Cd	pax_name Pax Name	dim_type Dim Type	dim_cd Dim Cd	dim_description Dim Description	fund Fund	category_of_region Category Of Region	is_multi_to Is Multi To	to_cd To Cd	to_short_name To Short Name	dimension_title_short Dimension Title Short	from_date_eu_amount From Date Eu Amount	to_date_eu_amount To Date Eu Amount	eu_allocation_positive_change Eu Allocation Positive Change	eu_allocation_negative_change Eu Allocation Negative Change
SK	2014SK16RFOP001	Research and Innovation (Merged in 2019 with "Integrated Infrastructure") - SK - ERDF	7	Adopted by EC	2	Podpora výskumu, vývoja a inovácií v Bratislavskom kraji	InterventionField	64	Research and innovation processes in SMEs (including voucher schemes, process, design, service and social innovation)	ERDF	More developed	false	01	Research & Innovation	064 - R+I processes in SMEs (vouchers, process, design .)
IT	2014IT16RFOP005	Bolzano - ERDF	3	Adopted by EC	1	Ricerca e Innovazione	InterventionField	64	Research and innovation processes in SMEs (including voucher schemes, process, design, service and social innovation)	ERDF	More developed	false	01	Research & Innovation	064 - R+I processes in SMEs (vouchers, process, design .)	2623128	2623128
IT	2014IT16RFOP022	Basilicata - ERDF	8.1	Adopted by EC	3	Competitività	InterventionField	73	Support to social enterprises (SMEs)	ERDF	Less developed	false	03	Competitiveness of SMEs	073 - Support to social enterprises (SMEs)	975000	4930483	3955483
GR	2014GR16M2OP010	North Aegean - ERDF/ESF	6	Adopted by EC	2β	Υποδομές υποστήριξης ανθρώπινου δυναμικού	InterventionField	73	Support to social enterprises (SMEs)	ERDF	Transition	true	Multi	Multi	073 - Support to social enterprises (SMEs)
PT	2014PT16M2OP006	Madeira - ERDF/ESF	12	Adopted by EC	1	REFORÇAR A INVESTIGAÇÃO, O DESENVOLVIMENTO TECNOLÓGICO E A INOVAÇÃO	InterventionField	2	Research and innovation processes in large enterprises	ERDF	More developed	false	01	Research & Innovation	002 - Research and innovation processes in large enterprises	2700000	2483243		-216757
PT	2014PT16M2OP006	Madeira - ERDF/ESF	12	Adopted by EC	4	APOIAR A TRANSIÇÃO PARA UMA ECONOMIA DE BAIXO TEOR DE CARBONO EM TODOS OS SETORES	InterventionField	70	Promotion of energy efficiency in large enterprises	ERDF	More developed	false	04	Low-Carbon Economy	070 - Promotion of energy efficiency in large enterprises	1482000	276005		-1205995
FR	2014FR16M0OP003	Centre - ERDF/ESF/YEI	9.1	Adopted by EC	AXE 2	UNE SOCIÉTÉ PORTEUSE D'EMPLOIS	InterventionField	1	Generic productive investment in small and medium-sized enterprises (SMEs)	ERDF	More developed	false	03	Competitiveness of SMEs	001 - Generic productive investment in SMEs	7705361	12822485	5117124
PT	2014PT16M2OP006	Madeira - ERDF/ESF	12	Adopted by EC	1	REFORÇAR A INVESTIGAÇÃO, O DESENVOLVIMENTO TECNOLÓGICO E A INOVAÇÃO	InterventionField	62	Technology transfer and university-enterprise cooperation primarily benefiting SMEs	ERDF	More developed	false	01	Research & Innovation	062 - Tech-transfer & university-SME cooperation	5300000	5626000	326000
TC	2014TC16RFCB008	Interreg V-A - Hungary-Croatia	2	Adopted by EC	1	Enhancing the Competitiveness of SMEs	InterventionField	1	Generic productive investment in small and medium-sized enterprises (SMEs)	ERDF		false	03	Competitiveness of SMEs	001 - Generic productive investment in SMEs	6502500	6502500
PT	2014PT16M2OP006	Madeira - ERDF/ESF	12	Adopted by EC	7	PROMOVER O EMPREGO E APOIAR A MOBILIDADE LABORAL	InterventionField	106	Adaptation of workers, enterprises and entrepreneurs to change	ESF	More developed	false	08	Sustainable & Quality Employment	106 - Adapting of workers, enterprises & entrepreneurs to change	6940000	12335000	5395000


CREATE TABLE table_1 (
  "country_code" VARCHAR,
  "cci" VARCHAR,
  "cci_title" VARCHAR,
  "ver" DOUBLE,
  "status" VARCHAR,
  "pax_cd" VARCHAR,
  "pax_name" VARCHAR,
  "dim_type" VARCHAR,
  "dim_cd" BIGINT,
  "dim_description" VARCHAR,
  "fund" VARCHAR,
  "category_of_region" VARCHAR,
  "is_multi_to" VARCHAR,
  "to_cd" VARCHAR,
  "to_short_name" VARCHAR,
  "dimension_title_short" VARCHAR,
  "from_date_eu_amount" DOUBLE,
  "to_date_eu_amount" DOUBLE,
  "eu_allocation_positive_change" DOUBLE,
  "eu_allocation_negative_change" DOUBLE
);