Readme for flat file of EUKLEMS database (all_countries_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-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 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) GOS Gross operating surplus (in millions of local currency) TXSP Taxes minus subsidies on production (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_P Gross output, price indices, 1995 = 100 II_P Intermediate inputs, price indices, 1995 = 100 VA_P Gross value added, price indices, 1995 = 100 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 GO_Q Growth rate of gross output volume (% per year) GOConII Contribution of intermediate inputs to output growth (percentage points) GOConIIM Contribution of intermediate energy inputs to output growth (percentage points) GOConIIE Contribution of intermediate material 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) GOConK Contribution of capital services to output growth (percentage points) GOConTFP Contribution of TFP to output growth (percentage points) TFPgo_I TFP (gross output 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 CAPIT_QPH ICT capital services per hour worked, 1995 reference CAPNIT_QPH Non-ICT capital 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) 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) H_M Hours worked by male persons engaged (share in total hours) H_F Hours worked by female persons engaged (share in total hours) H_29 Hours worked by persons engaged aged 15-29 (share in total hours) H_49 Hours worked by persons engaged aged 30-49 (share in total hours) H_50+ Hours worked by persons engaged aged 50 and over (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 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 Inland transport 61 Water transport 62 Air transport 63 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 2007, www.euklems.net