Readme for additional flat file of EUKLEMS database (all_countries_alt_07I.txt). This flat file is a tab 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-2004. Commas have been used as delimiters. country: 3-character country code var: variable code (see below) code: industry code (see below) columns 1970 - 2004: data for each of these years Description of country codes used: AUT Austria BEL Belgium CYP Cyprus CZE Czech Republic DNK Denmark DEW West Germany EST Estonia ESP Spain FIN Finland FRA France GER Germany GRC Greece HUN Hungary IRL Ireland ITA Italy JPN Japan LTU Lithuania LVA Latvia LUX Luxembourg MLT Malta NLD Netherlands POL Poland PRT Portugal SVK Slovak Republic SVN Slovenia SWE Sweden UK United Kingdom USA United States-SIC based US2 United States-NAICS based Description of variable codes used: GO Gross output at current basic prices (in millions of local currency) II Intermediate inputs at current purchasers' prices (in millions of local currency) IIE Intermediate energy inputs at current purchasers' prices (in millions of local currency) IIM Intermediate material inputs at current purchasers' prices (in millions of local currency) IIS Intermediate service inputs at current purchasers' prices (in millions of local currency) VA Gross value added at current basic prices (in millions of local currency) COMP Compensation of employees (in millions of local currency) 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) GO_QI Gross output, volume indices, 1995 = 100 II_QI Intermediate inputs, volume indices, 1995 = 100 IIE_QI Intermediate energy inputs, volume indices, 1995 = 100 IIM_QI Intermediate material inputs, volume indices, 1995 = 100 IIS_QI Intermediate service inputs, volume indices, 1995 = 100 VA_QI Gross value added, volume indices, 1995 = 100 LP_I Gross value added per hour worked, volume indices, 1995=100 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 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) TFPva_I TFP (value added based) growth, 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 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) LAB_QPH Labour services per hour worked, 1995 reference 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) One special variable is used only for Poland: VAConK Contribution of capital services 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, March 2007, www.euklems.net