Readme for the flat file of November 2009 EUKLEMS database (all_countries_09I.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-2007. Commas have been used as delimiters. For BEL, JPN, POL, PRT and SVN data is available up to 2006 for some or all variables. Data for Japan and Korea is still available at the 72 industry level in this release. For all other countries data is available at the 32 industry level. country: 3-character country code var: variable code (see below) code: industry code (see below) columns 1970 - 2007: data for each of these years Description of country codes used: AUS Australia AUT Austria BEL Belgium CYP Cyprus CZE Czech Republic DNK Denmark EST Estonia ESP Spain FIN Finland FRA France GER Germany GRC Greece HUN Hungary IRL Ireland ITA Italy JPN Japan KOR Korea 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-NAICS United States-NAICS based 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 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)* CAP_GFCF Capital compensation (in millions of local currency) adjusted for negative rental prices 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 TFPva_I TFP (value added based) growth, 1995=100 VA_Q Growth rate of value added volume (% per year) 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 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) LAB_QPH Labour services per hour worked, 1995 reference LAB_AVG Labour compensation per hour worked H_AVG Average Number of hours worked 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, November 2009, www.euklems.net