Readme for the flat file of the EU Aggregates of March 2008 EUKLEMS database (aggregates_08I.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: EU aggregate code (see below) 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: 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 IIE Intermediate energy inputs at current purchasers' prices (in millions of local currency) IIE_QI Intermediate energy inputs, volume indices, 1995 = 100 IIM Intermediate material inputs at current purchasers' prices (in millions of local currency) IIM_QI Intermediate material inputs, volume indices, 1995 = 100 IIS Intermediate service inputs at current purchasers' prices (in millions of local currency) IIS_QI Intermediate service inputs, volume 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 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) VAConK Contribution of capital services 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) TFPgo_I TFP (gross output based) growth, 1995=100 GO_Q Growth rate of gross output volume (% per year) GOConII Contribution of intermediate inputs to output growth (percentage points) GOConIIM Contribution of intermediate material inputs to output growth (percentage points) GOConIIE Contribution of intermediate energy inputs to output growth (percentage points) GOConIIS Contribution of intermediate services inputs to output growth (percentage points) GOConL Contribution of labour services to output growth (percentage points) GOConH Contribution of hours worked to output growth (percentage points) GOConLC Contribution of labour composition change to output growth (percentage points) GOConK Contribution of capital services to output growth (percentage points) GOConKIT Contribution of ICT capital services to output growth (percentage points) GOConKNIT Contribution of non-ICT capital services to output growth (percentage points) GOConTFP Contribution of TFP to output growth (percentage points) LAB_QPH Labour services per hour worked, 1995 reference LABHS High-skilled labour compensation (share in total labour compensation) LABMS Medium-skilled labour compensation (share in total labour compensation) LABLS Low-skilled labour compensation (share in total labour compensation) H_HS Hours worked by high-skilled persons engaged (share in total hours) H_MS Hours worked by medium-skilled persons engaged (share in total hours) H_LS Hours worked by low-skilled persons engaged (share in total hours) Description of industry codes: TOT TOTAL INDUSTRIES AtB AGRICULTURE, HUNTING, FORESTRY AND FISHING A AGRICULTURE, HUNTING AND FORESTRY 1 Agriculture 2 Forestry B FISHING C MINING AND QUARRYING 10t12 MINING AND QUARRYING OF ENERGY PRODUCING MATERIALS 10 Mining of coal and lignite; extraction of peat 11 Extraction of crude petroleum and natural gas and services 12 Mining of uranium and thorium ores 13t14 MINING AND QUARRYING EXCEPT ENERGY PRODUCING MATERIALS 13 Mining of metal ores 14 Other mining and quarrying D TOTAL MANUFACTURING 15t16 FOOD , BEVERAGES AND TOBACCO 15 Food and beverages 16 Tobacco 17t19 TEXTILES, TEXTILE , LEATHER AND FOOTWEAR 17t18 Textiles and textile 17 Textiles 18 Wearing Apparel, Dressing And Dying Of Fur 19 Leather, leather and footwear 20 WOOD AND OF WOOD AND CORK 21t22 PULP, PAPER, PAPER , PRINTING AND PUBLISHING 21 Pulp, paper and paper 22 Printing, publishing and reproduction 221 Publishing 22x Printing and reproduction 23t25 CHEMICAL, RUBBER, PLASTICS AND FUEL 23 Coke, refined petroleum and nuclear fuel 24 Chemicals and chemical 244 Pharmaceuticals 24x Chemicals excluding pharmaceuticals 25 Rubber and plastics 26 OTHER NON-METALLIC MINERAL 27t28 BASIC METALS AND FABRICATED METAL 27 Basic metals 28 Fabricated metal 29 MACHINERY, NEC 30t33 ELECTRICAL AND OPTICAL EQUIPMENT 30 Office, accounting and computing machinery 31t32 Electrical engineering 31 Electrical machinery and apparatus, nec 313 Insulated wire 31x Other electrical machinery and apparatus nec 32 Radio, television and communication equipment 321 Electronic valves and tubes 322 Telecommunication equipment 323 Radio and television receivers 33 Medical, precision and optical instruments 331t3 Scientific instruments 334t5 Other instruments 34t35 TRANSPORT EQUIPMENT 34 Motor vehicles, trailers and semi-trailers 35 Other transport equipment 351 Building and repairing of ships and boats 353 Aircraft and spacecraft 35x Railroad equipment and transport equipment nec 36t37 MANUFACTURING NEC; RECYCLING 36 Manufacturing nec 37 Recycling E ELECTRICITY, GAS AND WATER SUPPLY 40 ELECTRICITY AND GAS 40x Electricity supply 402 Gas supply 41 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 60 Other Inland transport 61 Other Water transport 62 Other Air transport 63 Other Supporting and auxiliary transport activities; activities of travel agencies 64 POST AND TELECOMMUNICATIONS JtK FINANCE, INSURANCE, REAL ESTATE AND BUSINESS SERVICES J FINANCIAL INTERMEDIATION 65 Financial intermediation, except insurance and pension funding 66 Insurance and pension funding, except compulsory social security 67 Activities related to financial intermediation K REAL ESTATE, RENTING AND BUSINESS ACTIVITIES 70 Real estate activities 71t74 Renting of m&eq and other business activities 71 Renting of machinery and equipment 72 Computer and related activities 73 Research and development 74 Other business activities 741t4 Legal, technical and advertising 745t8 Other business activities, nec 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 90 Sewage and refuse disposal, sanitation and similar activities 91 Activities of membership organizations nec 92 Recreational, cultural and sporting activities 921t2 Media activities 923t7 Other recreational activites 93 Other service activities P PRIVATE HOUSEHOLDS WITH EMPLOYED PERSONS Q EXTRA-TERRITORIAL ORGANIZATIONS AND BODIES Source: EU KLEMS database, March 2008, www.euklems.net