Lookup Comparison Of 2017-13 V 2014-2020 Thematic Categorisation Codes
@esifunds.n_6upq_vvwi
Table 1
@esifunds.n_6upq_vvwi.table_1
- 30.8 KB
- 138 rows
- 11 columns
n__2014_2020_section_title2014–2020 Section Title | n__2014_2020_intervention_field2014–2020 Intervention Field | n__2014_2020_intervention_field_12014–2020 Intervention Field 1 | n__2014_2020_intervention_field_22014–2020 Intervention Field 2 | n__2014v2007_comment2014v2007 Comment | n__2014_20_thematic_objective2014–20 Thematic Objective | n__2014_20_thematic_objective_12014–20 Thematic Objective 1 | n__2007_2013_section_title2007–2013 Section Title | n__2007_2014_priority_theme2007–2014 Priority Theme | n__2007_2013_priority_theme2007–2013 Priority Theme | n__2007_2013_priority_theme_12007–2013 Priority Theme 1 |
|---|---|---|---|---|---|---|---|---|---|---|
| IV.1 Research and development and innovation | 060 - Research and innovation activities in public research cent | 60 | Research and innovation activities in public research centres and centres of competence including networking | Expanded | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 01 - R&TD activities in research centres | 1 | R&TD activities in research centres |
| IV.1 Research and development and innovation | 061 - Research and innovation activities in private research cen | 61 | Research and innovation activities in private research centres including networking | Expanded | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 01 - R&TD activities in research centres | 1 | R&TD activities in research centres |
| IV.1 Research and development and innovation | 058 - Research and innovation infrastructure (public) | 58 | Research and innovation infrastructure (public) | Expanded | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 02 - R&TD infrastructure and centres of competence in a specific | 2 | R&TD infrastructure and centres of competence in a specific technology |
| IV.1 Research and development and innovation | 059 - Research and innovation infrastructure (private, including | 59 | Research and innovation infrastructure (private, including science parks) | Expanded | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 02 - R&TD infrastructure and centres of competence in a specific | 2 | R&TD infrastructure and centres of competence in a specific technology |
| IV.1 Research and development and innovation | 062 - Technology transfer and university-enterprise cooperation | 62 | Technology transfer and university-enterprise cooperation primarily benefiting SMEs | Unchanged | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 03 - Technology transfer and improvement of cooperation networks | 3 | Technology transfer and improvement of cooperation networks ... |
| IV.1 Research and development and innovation | 063 - Cluster support and business networks primarily benefiting | 63 | Cluster support and business networks primarily benefiting SMEs | Expanded | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 03 - Technology transfer and improvement of cooperation networks | 3 | Technology transfer and improvement of cooperation networks ... |
| IV.1 Research and development and innovation | 064 - Research and innovation processes in SMEs (including vouch | 64 | Research and innovation processes in SMEs (including voucher schemes, process, design, service and social innovation) | Unchanged | 1 | Strengthening research, technological development and innovation | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 04 - Assistance to R&TD, particularly in SMEs (including access | 4 | Assistance to R&TD, particularly in SMEs (including access to R&TD services in research centres) |
| IV.2 Business Development | 066 - Advanced support services for SMEs and groups of SMEs (inc | 66 | Advanced support services for SMEs and groups of SMEs (including management, marketing and design services) | Expanded | 3 | Enhancing competitiveness of small and medium sized enterprises | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 05 - Advanced support services for firms and groups of firms | 5 | Advanced support services for firms and groups of firms |
| IV.2 Business Development | 067 - SME business development, support to entrepreneurship and | 67 | SME business development, support to entrepreneurship and incubation (including support to spin offs and spin outs) | Unchanged | 3 | Enhancing competitiveness of small and medium sized enterprises | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 05 - Advanced support services for firms and groups of firms | 5 | Advanced support services for firms and groups of firms |
| IV.2 Business Development | 069 - Support to environmentally-friendly production processes a | 69 | Support to environmentally-friendly production processes and resource efficiency in SMEs | Expanded | 3 | Enhancing competitiveness of small and medium sized enterprises | SECTION 1: Research and technological development (R&TD), innovation and entrepreneurship | 06 - Assistance to SMEs for the promotion of environmentally-fri | 6 | Assistance to SMEs for the promotion of environmentally-friendly products and production processes (...) |
CREATE TABLE table_1 (
"n__2014_2020_section_title" VARCHAR,
"n__2014_2020_intervention_field" VARCHAR,
"n__2014_2020_intervention_field_1" VARCHAR,
"n__2014_2020_intervention_field_2" VARCHAR,
"n__2014v2007_comment" VARCHAR,
"n__2014_20_thematic_objective" BIGINT,
"n__2014_20_thematic_objective_1" 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
);