Readme for flat file of EU Aggregates from the November 2007 EU KLEMS database (aggregates_alt_07I.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-2005.
Commas have been used as delimiters.

country: 3-character country code
var: variable code (see below)
code: industry code (see below)
columns 1970 - 2005: 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:

VA		Gross value added at current basic prices (in millions of local currency)
VA_QI		Gross value added, volume 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
CAP_QI		Capital services, volume indices, 1995 = 100
CAPIT		ICT capital compensation (share in total capital compensation)
CAPNIT		Non-ICT capital compensation (share in total capital compensation)
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)
VAConL		Contribution of labour services to value added growth (percentage points)
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 output growth (percentage points)
VAConKNIT	Contribution of non-ICT capital services to output growth (percentage points)
VAConTFP	Contribution of TFP to value added growth (percentage points)

Description of industry codes (indentation with space signifies subindustry):

TOT	TOTAL INDUSTRIES
MARKT	 MARKET ECONOMY
ELECOM	 ELECTRICAL MACHINERY, POST AND COMMUNICATION SERVICES
30t33	 Electrical and optical equipment
64	 Post and telecommunications
GOODS	 GOODS PRODUCING, EXCLUDING ELECTRICAL MACHINERY
MexElec	 TOTAL MANUFACTURING, EXCLUDING ELECTRICAL
Mcons	 Consumer manufacturing
15t16	 Food products, beverages and tobacco
17t19	 Textiles, textile products, leather and footwear
36t37	 Manufacturing nec; recycling
Minter	 Intermediate manufacturing
20	 Wood and products of wood and cork
21t22	 Pulp, paper, paper products, printing and publishing
23	 Coke, refined petroleum products and nuclear fuel
24	 Chemicals and chemical products
25	 Rubber and plastics products
26	 Other non-metallic mineral products
27t28	 Basic metals and fabricated metal products
Minves	 Investment goods, excluding hightech
29	 Machinery, nec
34t35	 Transport equipment
OtherG	 OTHER PRODUCTION
C	 Mining and quarrying
E	 Electricity, gas and water supply
F	 Construction
AtB	 Agriculture, hunting, forestry and fishing
MSERV	 MARKET SERVICES, EXCLUDING POST AND TELECOMMUNICATIONS
DISTR	 DISTRIBUTION
50t52	 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
60t63	 Transport and storage
FINBU	 FINANCE AND BUSINESS, EXCEPT REAL ESTATE
J	 Financial intermediation
71t74	 Renting of m&eq and other business activities
PERS	 PERSONAL SERVICES
H	 Hotels and restaurants
O	 Other community, social and personal services
P	 Private households with employed persons
NONMAR	 NON-MARKET SERVICES
LtN	 Public admin, education and health
L	 Public admin and defence; compulsory social security
M	 Education
N	 Health and social work
70	 Real estate activities

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