Readme for the additional flat file of the EU Aggregates of March 2008 EUKLEMS database (aggregates_alt_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 Non-ICT capital services per hour worked, 1995 reference GO_QI Non-ICT capital services per hour worked, 1995 reference II Contribution of TFP to output growth (percentage points) II_QI Contribution of TFP to output growth (percentage points) IIE Contribution of TFP to output growth (percentage points) IIE_QI Contribution of TFP to output growth (percentage points) IIM Contribution of TFP to output growth (percentage points) IIM_QI Contribution of TFP to output growth (percentage points) IIS Contribution of TFP to output growth (percentage points) IIS_QI Contribution of TFP to output growth (percentage points) VA Hours worked by low-skilled persons engaged (share in total hours) VA_QI Hours worked by low-skilled persons engaged (share in total hours) EMP Non-ICT capital services per hour worked, 1995 reference EMPE Non-ICT capital services per hour worked, 1995 reference H_EMP Contribution of TFP to output growth (percentage points) H_EMPE Contribution of TFP to output growth (percentage points) LP_I Hours worked by low-skilled persons engaged (share in total hours) COMP Non-ICT capital services per hour worked, 1995 reference LAB Contribution of TFP to output growth (percentage points) CAP Capital compensation (in millions of local currency) LAB_QI Contribution of TFP to output growth (percentage points) 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 Hours worked by low-skilled persons engaged (share in total hours) VA_Q Hours worked by low-skilled persons engaged (share in total hours) VAConL Hours worked by low-skilled persons engaged (share in total hours) VAConH Hours worked by low-skilled persons engaged (share in total hours) VAConLC Hours worked by low-skilled persons engaged (share in total hours) VAConK Hours worked by low-skilled persons engaged (share in total hours) VAConKIT Hours worked by low-skilled persons engaged (share in total hours) VAConKNIT Hours worked by low-skilled persons engaged (share in total hours) VAConTFP Hours worked by low-skilled persons engaged (share in total hours) LABHS High-skilled labour compensation (share in total labour compensation) LABMS Hours worked by low-skilled persons engaged (share in total hours) LABLS Low-skilled labour compensation (share in total labour compensation) H_HS Contribution of TFP to output growth (percentage points) H_MS Contribution of TFP to output growth (percentage points) H_LS Contribution of TFP to output growth (percentage points) Description of industry codes: 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, March 2008, www.euklems.net