Lookup Comparison Of 2017-13 V 2014-2020 Thematic Categorisation Codes

@esifunds.widm_y9e8

Table List

1 table(27.39 KB)

Table 1

@esifunds.widm_y9e8.table_1

27.39 KB
130 rows
9 columns

n__2014_2020_section_title 2014–2020 Section Title	n__2014_2020_intervention_field 2014–2020 Intervention Field	n__2014_2020_intervention_field_1 2014–2020 Intervention Field 1	n__2014_2020_intervention_field_2 2014–2020 Intervention Field 2	n__2014v2007 2014v2007	n__2007_2013_section_title 2007–2013 Section Title	n__2007_2014_priority_theme 2007–2014 Priority Theme	n__2007_2013_priority_theme 2007–2013 Priority Theme	n__2007_2013_priority_theme_1 2007–2013 Priority Theme 1
I. Productive investment:	001 - Generic productive investment in small and medium –sized e	1	Generic productive investment in small and medium –sized enterprises (‘SMEs’)	Expanded	SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship	08 - Other investment in firms	08	Other investment in firms
I. Productive investment:	002 - Research and innovation processes in large enterprises	2	Research and innovation processes in large enterprises	Expanded	SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship	07 - Investment in firms directly linked to research and innovat	07	Investment in firms directly linked to research and innovation (...)
I. Productive investment:	003 - Productive investment in large enterprises linked to the l	3	Productive investment in large enterprises linked to the low-carbon economy	Expanded	SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship	07 - Investment in firms directly linked to research and innovat	07	Investment in firms directly linked to research and innovation (...)
I. Productive investment:	004 - Productive investment linked to the cooperation between la	4	Productive investment linked to the cooperation between large enterprises and SMEs for developing information and communication technology(‘ICT’) products and services, e-commerce and enhancing demand for ICT	New		NEW - No approximation	NEW	No approximation
II.1 Energy infrastructure	005 - Electricity (storage and transmission)	5	Electricity (storage and transmission)	Unchanged	SECTION 4: Energy	33 - Electricity	33	Electricity
II.1 Energy infrastructure	006 - Electricity (TEN-E storage and transmission)	6	Electricity (TEN-E storage and transmission)	Unchanged	SECTION 4: Energy	34 - Electricity (TEN-E)	34	Electricity (TEN-E)
II.1 Energy infrastructure	007 - Natural gas	7	Natural gas	Unchanged	SECTION 4: Energy	35 - Natural gas	35	Natural gas
II.1 Energy infrastructure	008 - Natural gas (TEN-E)	8	Natural gas (TEN-E)	Unchanged	SECTION 4: Energy	36 - Natural gas (TEN-E)	36	Natural gas (TEN-E)
II.1 Energy infrastructure	009 - Renewable energy: wind	9	Renewable energy: wind	Unchanged	SECTION 4: Energy	39 - Renewable energy: wind	39	Renewable energy: wind
II.1 Energy infrastructure	010 - Renewable energy: solar	10	Renewable energy: solar	Unchanged	SECTION 4: Energy	40 - Renewable energy: solar	40	Renewable energy: solar


CREATE TABLE table_1 (
  "n__2014_2020_section_title" VARCHAR,
  "n__2014_2020_intervention_field" VARCHAR,
  "n__2014_2020_intervention_field_1" BIGINT,
  "n__2014_2020_intervention_field_2" VARCHAR,
  "n__2014v2007" VARCHAR,
  "n__2007_2013_section_title" VARCHAR,
  "n__2007_2014_priority_theme" VARCHAR,
  "n__2007_2013_priority_theme" VARCHAR,
  "n__2007_2013_priority_theme_1" VARCHAR
);