Readme for the flat file of the EU Aggregates of November 2009 EUKLEMS database (aggregates_09I.txt).

This flat file is a comma delimited file
The file contains a first line with column descriptors.
Columns 1-3 refer to the different dimensions of the database.
All following columns represent a year 1970-2007.
Commas have been used as delimiters.
Data for the EU10 aggregate is only available up to 2006.

country: EU aggregate code (see below)
var: variable code (see below)
code: industry code (see below)
columns 1970 - 2007: data for each of these years

Description of aggregates used:

EU15	European Union: 15 old member states (AUT, BEL, DNK, ESP, FIN, FRA, GER, GRC, IRL, ITA, LUX, NLD, PRT, SWE, UK)
EU15ex	European Union: 10 growth accounting countries (AUT, BEL, DNK, ESP, FIN, FRA, GER, ITA, NLD, UK)
EU10	European Union: 10 New member states (CYP, CZE, EST, HUN, LTU, LVA, MLT, POL, SVK, SVN)
EU25	European Union: all 25 members (AUT, BEL, CYP, CZE, DNK, FIN, FRA, GER, GRC, HUN, IRL, ITA, LTU, LVA, LUX, 
					MLT, NLD, POL, SVK, SVN, ESP, PRT, SWE, UK)
EURO	Eurozone: 12 countries (AUT, BEL, ESP, FIN, FRA, GER, GRC, IRL, ITA, LUX, NLD, PRT)
EUROex	Eurozone: 8 growth accounting countries (AUT, BEL, ESP, FIN, FRA, GER, ITA, NLD)

Description of variable codes used:

GO		Gross output at current basic prices (in millions of local currency)
GO_QI		Gross output, volume indices, 1995 = 100
GO_P		Gross output, price indices, 1995 = 100
II		Intermediate inputs at current purchasers' prices (in millions of local currency)
II_QI		Intermediate inputs, volume indices, 1995 = 100
II_P		Intermediate inputs, price indices, 1995 = 100
VA		Gross value added at current basic prices (in millions of local currency)
VA_QI		Gross value added, volume indices, 1995 = 100
VA_P		Gross value added, price indices, 1995 = 100
EMP		Number of persons engaged (thousands)
EMPE		Number of employees (thousands)
H_EMP		Total hours worked by persons engaged (millions)
H_EMPE		Total hours worked by employees (millions)
LP_I		Gross value added per hour worked, volume indices, 1995=100
COMP		Compensation of employees (in millions of local currency)
LAB		Labour compensation (in millions of local currency)
CAP		Capital compensation (in millions of local currency)
LAB_QI		Labour services, volume indices, 1995 = 100
LAB_QPH		Labour services per hour worked, 1995 reference
CAPIT		ICT capital compensation (share in total capital compensation)*
CAPNIT		Non-ICT capital compensation (share in total capital compensation)*
CAP_QI		Capital services, volume indices, 1995 = 100
CAPIT_QI	ICT capital services, volume indices, 1995 = 100
CAPNIT_QI	Non-ICT capital services, volume indices, 1995 = 100
TFPva_I		TFP (value added based) growth, 1995=100
VA_Q		Growth rate of value added volume (% per year)
VAConH		Contribution of hours worked to value added growth (percentage points)
VAConLC		Contribution of labour composition change to value added growth (percentage points)
VAConKIT	Contribution of ICT capital services to value added growth (percentage points)
VAConKNIT	Contribution of non-ICT capital services to value added growth (percentage points)
VAConTFP	Contribution of TFP to value added growth (percentage points)


Description of industry codes:

TOT	TOTAL INDUSTRIES
AtB	 AGRICULTURE, HUNTING, FORESTRY AND FISHING
C	 MINING AND QUARRYING
D	 TOTAL MANUFACTURING
15t16	  FOOD , BEVERAGES AND TOBACCO
17t19	  TEXTILES, TEXTILE , LEATHER AND FOOTWEAR
20	  WOOD AND OF WOOD AND CORK
21t22	  PULP, PAPER, PAPER , PRINTING AND PUBLISHING
23t25	  CHEMICAL, RUBBER, PLASTICS AND FUEL
23	   Coke, refined petroleum and nuclear fuel
24	   Chemicals and chemical products
25	   Rubber and plastics
26	  OTHER NON-METALLIC MINERAL
27t28	  BASIC METALS AND FABRICATED METAL
29	  MACHINERY, NEC
30t33	  ELECTRICAL AND OPTICAL EQUIPMENT
34t35	  TRANSPORT EQUIPMENT
36t37	  MANUFACTURING NEC; RECYCLING
E	 ELECTRICITY, GAS AND WATER SUPPLY
F	 CONSTRUCTION
G	 WHOLESALE AND RETAIL TRADE
50	  Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of fuel
51	  Wholesale trade and commission trade, except of motor vehicles and motorcycles
52	  Retail trade, except of motor vehicles and motorcycles; repair of household goods
H	 HOTELS AND RESTAURANTS
I	 TRANSPORT AND STORAGE AND COMMUNICATION
60t63	  TRANSPORT AND STORAGE
64	  POST AND TELECOMMUNICATIONS
JtK	 FINANCE, INSURANCE, REAL ESTATE AND BUSINESS SERVICES
J	  FINANCIAL INTERMEDIATION
K	  REAL ESTATE, RENTING AND BUSINESS ACTIVITIES
70	   Real estate activities
71t74	   Renting of m&eq and other business activities
LtQ	 COMMUNITY SOCIAL AND PERSONAL SERVICES
L	  PUBLIC ADMIN AND DEFENCE; COMPULSORY SOCIAL SECURITY
M	  EDUCATION
N	  HEALTH AND SOCIAL WORK
O	  OTHER COMMUNITY, SOCIAL AND PERSONAL SERVICES
P	  PRIVATE HOUSEHOLDS WITH EMPLOYED PERSONS
Q	  EXTRA-TERRITORIAL ORGANIZATIONS AND BODIES



Source: EU KLEMS database, November 2009, www.euklems.net