Readme for the flat file of the September 2017 (Revised Juyly 2018) EUKLEMS database (ALL_output_17ii.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-2015. Commas have been used as delimiters. country: 2-character country code (see below) var: variable code (see below) code: industry code (see below) columns 1970 - 2015: data for each of these years Description of country codes used: AT Austria BE Belgium BG Bulgaria CY Cyprus CZ Czech Republic DE Germany DK Denmark EA Euro Area EE Estonia EL Greece ES Spain EU12 The EU member states for which growth accounting could be performed from 2001 onwards, namely: AT, BE, CZ, DK, FI, FR, DE, IT, NL, ES, SE, and UK EU15 The EU15 member states as of 1 January 1995, namely: AT, BE, DK, FI, FR, DE, EL, IE, IT, LU, NL, PT, ES, SE, and UK EU16 The EU member states for which growth accounting could be performed from 2009 onwards, namely: AT, BE, CZ, DK, FI, FR, DE, IT, LV, LU, NL, SK, SI, ES, SE, and UK EU28 All member states of the EU as of 1 September 2013, namely: AT, BE, BG, HR, CY, CZ, DK, EE, FI, FR, DE, EL, HU, IE, IT, LV, LT, LU, MT, NL, PL, PT, RO, SK, SI, ES, SE, and UK FI Finland FR France HR Croatia HU Hungary IE Ireland IT Italy LT Lithuania LU Luxembourg LV Latvia MT Malta NL Netherlands PL Poland PT Portugal RO Romania SE Sweden SI Slovenia SK Slovak Republic UK United Kingdom US United States Description of variable codes used: CAP Capital compensation (in millions of national currency) CAP_QI Capital services, volume indices, 2010 = 100 CAPIT_QI ICT capital services, volume indices, 2010 = 100 CAPNIT_QI Non-ICT capital services, volume indices, 2010 = 100 COMP Compensation of employees (in millions of national currency) EMP Number of persons engaged (thousands) EMPE Number of employees (thousands) GO Gross Output at current basic prices (in millions of national currency) GO_P Gross output, price indices, 2010 = 100 GO_QI Gross output, volume (2010 prices) H_EMP Total hours worked by persons engaged (thousands) H_EMPE Total hours worked by employees (thousands) II Intermediate inputs at current purchasers prices (in millions of national currency) II_P Intermediate inputs, price indices, 2010 = 100 II_QI Intermediate inputs, volume (2010 prices) LAB Labour compensation (in millions of national currency) LAB_QI Labour services, volume indices, 2010 = 100 LP_I Gross value added per hour worked, volume indices, 2010 = 100 LP1_Q Growth rate of value added per hour worked (% per year) LP1ConKIT Contribution of ICT capital services to value added per hour worked (percentage points) LP1ConKNIT Contribution of non-ICT capital services to value added per hour worked (percentage points) LP1ConLC Contribution of labour composition change to value added per hour worked growth (percentage points) LP1ConTFP Contribution of TFP to value added per hour worked growth (percentage points) LP2_Q Growth rate of value added per person employed (% per year) LP2ConKIT Contribution of ICT capital services to value added per person employed (percentage points) LP2ConKNIT Contribution of non-ICT capital services to value added per person employed (percentage points) LP2ConLC Contribution of labour composition change to value added per person employed growth (percentage points) LP2ConTFP Contribution of TFP to value added per person employed growth (percentage points) TFPlp1_I TFP ( value added per hour worked based) growth, 2010=100 TFPlp2_I TFP ( value added per person employed based) growth, 2010=100 TFPva_I TFP (value added based) growth, 2010 = 100 VA Gross value added at current basic prices (in millions of national currency) VA_P Gross value added, price indices, 2010 = 100 VA_Q Growth rate of value added volume (% per year) VA_QI Gross value added, volume (2010 prices) VAConH Contribution of hours worked 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) VAConLC Contribution of labour composition change to value added growth (percentage points) VAConTFP Contribution of TFP to value added growth (percentage points) Description of industry codes: TOT TOTAL INDUSTRIES MARKT MARKET ECONOMY A AGRICULTURE, FORESTRY AND FISHING B MINING AND QUARRYING C TOTAL MANUFACTURING 10-12 Food products, beverages and tobacco 13-15 Textiles, wearing apparel, leather and related prodcuts 16-18 Wood and paper products; printing and reproduction of recorded media 19 Coke and refined petroleum products 20-21 Chemicals and chemical products 22-23 Rubber and plastics products, and other non-metallic mineral products 24-25 Basic metals and fabricated metal products, except machinery and equipment 26-27 Electrical and optical equipment 28 Machinery and equipment n.e.c. 29-30 Transport equipment 31-33 Other manufacturing; repair and installation of machinery and equipment D-E ELECTRICITY, GAS AND WATER SUPPLY F CONSTRUCTION G WHOLESALE AND RETAIL TRADE; REPAIR OF MOTOR VEHICLES AND MOTORCYCLES 45 Wholesale and retail trade and repair of motor vehicles and motorcycles 46 Wholesale trade, except of motor vehicles and motorcycles 47 Retail trade, except of motor vehicles and motorcycles H TRANSPORTATION AND STORAGE 49-52 Transport and storage 53 Postal and courier activities I ACCOMMODATION AND FOOD SERVICE ACTIVITIES J INFORMATION AND COMMUNICATION 58-60 Publishing, audiovisual and broadcasting activities 61 Telecommunications 62-63 IT and other information services K FINANCIAL AND INSURANCE ACTIVITIES L REAL ESTATE ACTIVITIES M-N PROFESSIONAL, SCIENTIFIC, TECHNICAL, ADMINISTRATIVE AND SUPPORT SERVICE ACTIVITIES O-U COMMUNITY SOCIAL AND PERSONAL SERVICES O Public administration and defence; compulsory social security P Education Q Health and social work R-S ARTS, ENTERTAINMENT, RECREATION AND OTHER SERVICE ACTIVITIES R Arts, entertainment and recreation S Other service activities T Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use U Activities of extraterritorial organizations and bodies Source: EU KLEMS database, July 2018, www.euklems.net