2007-2013 Cohesion Categorisation Raw Data (from Closure Reports)

DG Regional Policy

@esifunds.qt3c_wiyg

Table List

1 table(49.88 KB)

Table 1

@esifunds.qt3c_wiyg.table_1

49.88 KB
1000 rows
18 columns

ms Ms	ms_name Ms Name	dg Dg	cci Cci	title Title	year Year	priority_cd Priority Cd	priority_description_short Priority Description Short	priority_description_long Priority Description Long	territory_cd Territory Cd	territory Territory	finance_cd Finance Cd	finance Finance	location_cd Location Cd	location Location	economic_cd Economic Cd	economic Economic	ar_com_amnt_eur_mil Ar Com Amnt Eur Mil
CZ	Ceska Republika	16	2007CZ161PO004	OP Podnikání a inovace	9999	43	43 - Energy efficiency, co-generation, energy management	Energy efficiency, co-generation, energy management	1	Urban	1	Non-repayable aid	CZ051	Liberecký kraj	22	Other unspecified services	3.527607
CZ	Ceska Republika	16	2007CZ161PO006	OP Životní prostředí	9999	45	45 - Management and distribution of water (drink water)	Management and distribution of water (drink water)	5	Rural areas	1	Non-repayable aid	CZ071	Olomoucký kraj	9	Collection, purification and distribution of water	5.970109
DE	Deutschland	16	2007DE161PO001	Operationelles Programm EFRE Thüringen 2007 bis 2013	9999	7	07 - Investment in firms directly linked to research and innovat	Investment in firms directly linked to research and innovation (...)	5	Rural areas	1	Non-repayable aid	DEG0	THÜRINGEN	3	Manufacture of food products and beverages	1.757721
ES	España	16	2007ES161PO005	Programa Operativo FEDER de Galicia	9999	41	41 - Renewable energy: biomass	Renewable energy: biomass	5	Rural areas	1	Non-repayable aid	ES11	GALICIA	1	Agriculture, hunting and forestry	0.056377
DE	Deutschland	16	2007DE162PO010	Operationelles Programm EFRE Niedersachsen (ohne Region Lüneburg) 2007-2013	9999	8	08 - Other investment in firms	Other investment in firms	1	Urban	1	Non-repayable aid	DE91B	Wolfenbüttel	17	Public administration	1.155679
DE	Deutschland	16	2007DE162PO003	Operationelles Programm EFRE Schleswig-Holstein 2007-2013	9999	61	61 - Integrated projects for urban and rural regeneration	Integrated projects for urban and rural regeneration	5	Rural areas	1	Non-repayable aid	DEF07	Nordfriesland	16	Real estate, renting and business activities	0.157402
FI	Suomi/Finland	16	2007FI162PO001	Itä-Suomen EAKR-toimenpideohjelma 2007-2013	9999	8	08 - Other investment in firms	Other investment in firms	4	Sparsely and very sparsely populated areas	1	Non-repayable aid	FI13	ITÄ-SUOMI	21	Activities linked to the environment	0.037
DE	Deutschland	5	2007DE052PO007	Operationelles Programm ESF Niedersachsen (ohne Region Lüneburg) 2007-2013	9999	68	68 - Support for self-employment and business start-up	Support for self-employment and business start-up	1	Urban	1	Non-repayable aid	DE91	BRAUNSCHWEIG	19	Human health activities	0.0046
CB	EU cross-border cooperation	16	2007CB163PO032	Nord INTERREG IVA	9999	3	03 - Technology transfer and improvement of cooperation networks	Technology transfer and improvement of cooperation networks ...	8	Cross-border cooperation area	1	Non-repayable aid	EU	EUROPEAN UNION	18	Education	0.022372
FR	France	16	2007FR161PO003	Programme opérationnel FEDER Martinique	9999	9	09 - Other measures to stimulate research and innovation and ent	Other measures to stimulate research and innovation and entrepreneurship in SMEs	7	Outermost region	3	Venture capital (participation, venture-capital fund)	FR92	MARTINIQUE	15	Financial intermediation	5.36


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "ms_name" VARCHAR,
  "dg" BIGINT,
  "cci" VARCHAR,
  "title" VARCHAR,
  "year" BIGINT,
  "priority_cd" BIGINT,
  "priority_description_short" VARCHAR,
  "priority_description_long" VARCHAR,
  "territory_cd" BIGINT,
  "territory" VARCHAR,
  "finance_cd" BIGINT,
  "finance" VARCHAR,
  "location_cd" VARCHAR,
  "location" VARCHAR,
  "economic_cd" BIGINT,
  "economic" VARCHAR,
  "ar_com_amnt_eur_mil" DOUBLE
);