Programme Lookup Table 14-20 + 21-27

@esifunds.f5vn_zy5i

Table List

1 table(52.73 KB)

Table 1

@esifunds.f5vn_zy5i.table_1

52.73 KB
1000 rows
14 columns

natord Natord	ms Ms	country Country	cci Cci	official_titles Official Titles	op_short_title Op Short Title	weblink Weblink	fundcombo Fundcombo	scope Scope	mono_multi Mono Multi	dg Dg	type Type	nature Nature	period Period
1	AT	Austria	2014AT05SFOP001	Operational Programme Employment Austria 2014-2020	Employment Austria - ESF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/at/2014at16rfop001_en	ESF	National	Mono-fund	5	SF	OP	14-20
5	BE	Belgium	2014BE05M9OP001	ESF Operationnal Programme Wallonie-Bruxelles 2020.eu	Wallonie-Bruxelles 2020.eu - ESF/YEI	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/AT/2014AT05SFOP001_en	ESF/YEI	Regional	Mono-fund	5	M9	OP	14-20
6	BE	Belgium	2014BE05M9OP002	Operational programme ESF 2014-2020 of the Brussels-Capital Region : Investment for growth and jobs	Brussels-Capital Region : Investment for growth and jobs - ESF/YEI	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BE/2014BE05M9OP001_en	ESF/YEI	Regional	Mono-fund	5	M9	OP	14-20
7	BE	Belgium	2014BE05SFOP001	European Social Fund 2014-2020 _ German Speaking Community of Belgium	German Speaking Community of Belgium - ESF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BE/2014BE05M9OP002_en	ESF	Regional	Mono-fund	5	SF	OP	14-20
8	BE	Belgium	2014BE05SFOP002	Operational Programme ESF Flanders 2014-2020	Flanders - ESF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BE/2014BE05SFOP001_en	ESF	Regional	Mono-fund	5	SF	OP	14-20
15	BG	Bulgaria	2014BG05M2OP001	Operational Programme Science and Education for Smart Growth	Science and Education for Smart Growth - BG - ESF/ERDF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BE/2014BE05SFOP002_en	ESF/ERDF	National	Multi-fund	5	M2	OP	14-20
16	BG	Bulgaria	2014BG05M9OP001	Operational Programme Human Resources Development	Human Resources Development - BG - ESF/YEI	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BG/2014BG05M2OP001_en	ESF/YEI	National	Mono-fund	5	M9	OP	14-20
17	BG	Bulgaria	2014BG05SFOP001	Operational Programme Good Governance	Good Governance - BG - ESF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BG/2014BG05M9OP001_en	ESF	National	Mono-fund	5	SF	OP	14-20
25	CY	Cyprus	2014CY05M9OP001	Employment, Human Capital and Social Cohesion	Employment, Human Capital and Social Cohesion - CY - ESF/YEI	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/BG/2014BG05SFOP001_en	ESF/YEI	National	Mono-fund	5	M9	OP	14-20
29	CZ	Czechia	2014CZ05M2OP001	OP Research, Development and Education	Research, Development and Education - CZ - ESF/ERDF	https://ec.europa.eu/regional_policy/in-your-country/programmes/2014-2020/CY/2014CY05M9OP001_en	ESF/ERDF	National	Multi-fund	5	M2	OP	14-20


CREATE TABLE table_1 (
  "natord" DOUBLE,
  "ms" VARCHAR,
  "country" VARCHAR,
  "cci" VARCHAR,
  "official_titles" VARCHAR,
  "op_short_title" VARCHAR,
  "weblink" VARCHAR,
  "fundcombo" VARCHAR,
  "scope" VARCHAR,
  "mono_multi" VARCHAR,
  "dg" BIGINT,
  "type" VARCHAR,
  "nature" VARCHAR,
  "period" VARCHAR
);