Readme for the flat file of the Capital Input Files of November 2009 EUKLEMS database (all_capital_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 Slovenia and Japan data is available up to 2006. 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 CZE Czech Republic DNK Denmark ESP Spain FIN Finland GER Germany ITA Italy JPN Japan NLD Netherlands SVN Slovenia SWE Sweden UK United Kingdom USA United States-SIC based Description of variable codes used: I_IT Nominal gross fixed capital formation, Computing equipment I_CT Nominal gross fixed capital formation, Communications equipment I_Soft Nominal gross fixed capital formation, Software I_TraEq Nominal gross fixed capital formation, Transport Equipment I_OMach Nominal gross fixed capital formation, Other Machinery and Equipment I_OCon Nominal gross fixed capital formation, Total Non-residential investment I_RStruc Nominal gross fixed capital formation, Residential structures I_Other Nominal gross fixed capital formation, Other assets I_ICT Nominal gross fixed capital formation, ICT assets I_NonICT Nominal gross fixed capital formation, Non-ICT assets I_GFCF Nominal gross fixed capital formation, All assets Iq_IT Real gross fixed capital formation, 1995 prices, Computing equipment Iq_CT Real gross fixed capital formation, 1995 prices, Communications equipment Iq_Soft Real gross fixed capital formation, 1995 prices, Software Iq_TraEq Real gross fixed capital formation, 1995 prices, Transport Equipment Iq_OMach Real gross fixed capital formation, 1995 prices, Other Machinery and Equipment Iq_OCon Real gross fixed capital formation, 1995 prices, Total Non-residential investment Iq_RStruc Real gross fixed capital formation, 1995 prices, Residential structures Iq_Other Real gross fixed capital formation, 1995 prices, Other assets Iq_ICT Real gross fixed capital formation, 1995 prices, ICT assets Iq_NonICT Real gross fixed capital formation, 1995 prices, Non-ICT assets Iq_GFCF Real gross fixed capital formation, 1995 prices, All assets Ip_IT Gross fixed capital formation price index (1995=1.00), Computing equipment Ip_CT Gross fixed capital formation price index (1995=1.00), Communications equipment Ip_Soft Gross fixed capital formation price index (1995=1.00), Software Ip_TraEq Gross fixed capital formation price index (1995=1.00), Transport Equipment Ip_OMach Gross fixed capital formation price index (1995=1.00), Other Machinery and Equipment Ip_OCon Gross fixed capital formation price index (1995=1.00), Total Non-residential investment Ip_RStruc Gross fixed capital formation price index (1995=1.00), Residential structures Ip_Other Gross fixed capital formation price index (1995=1.00), Other assets Ip_ICT Gross fixed capital formation price index (1995=1.00), ICT assets Ip_NonICT Gross fixed capital formation price index (1995=1.00), Non-ICT assets Ip_GFCF Gross fixed capital formation price index (1995=1.00), All assets K_IT Real fixed capital stock, 1995 prices, Computing equipment K_CT Real fixed capital stock, 1995 prices, Communications equipment K_Soft Real fixed capital stock, 1995 prices, Software K_TraEq Real fixed capital stock, 1995 prices, Transport Equipment K_OMach Real fixed capital stock, 1995 prices, Other Machinery and Equipment K_OCon Real fixed capital stock, 1995 prices, Total Non-residential investment K_RStruc Real fixed capital stock, 1995 prices, Residential structures K_Other Real fixed capital stock, 1995 prices, Other assets K_ICT Real fixed capital stock, 1995 prices, ICT assets K_NonICT Real fixed capital stock, 1995 prices, Non-ICT assets K_GFCF Real fixed capital stock, 1995 prices, All assets CAP_IT Capital compensation, Computing equipment* CAP_CT Capital compensation, Communications equipment* CAP_Soft Capital compensation, Software* CAP_TraEq Capital compensation, Transport Equipment* CAP_OMach Capital compensation, Other Machinery and Equipment* CAP_OCon Capital compensation, Total Non-residential investment* CAP_RStruc Capital compensation, Residential structures* CAP_Other Capital compensation, Other assets* CAP_ICT Capital compensation, ICT assets* CAP_NonICT Capital compensation, Non-ICT assets* CAP_GFCF Capital compensation, All assets* (adjusted for negative rental prices) D_IT Consumption of fixed capital, 1995 prices, Computing equipment D_CT Consumption of fixed capital, 1995 prices, Communications equipment D_Soft Consumption of fixed capital, 1995 prices, Software D_TraEq Consumption of fixed capital, 1995 prices, Transport Equipment D_OMach Consumption of fixed capital, 1995 prices, Other Machinery and Equipment D_OCon Consumption of fixed capital, 1995 prices, Total Non-residential investment D_RStruc Consumption of fixed capital, 1995 prices, Residential structures D_Other Consumption of fixed capital, 1995 prices, Other assets D_ICT Consumption of fixed capital, 1995 prices, ICT assets D_NonICT Consumption of fixed capital, 1995 prices, Non-ICT assets D_GFCF Consumption of fixed capital, 1995 prices, All assets IRR Industry rate of return on capital Description of industry codes: TOT TOTAL INDUSTRIES AtB AGRICULTURE, HUNTING, FORESTRY AND FISHING C MINING AND QUARRYING D TOTAL MANUFACTURING 15t16 FOOD , BEVERAGES AND TOBACCO 17t19 TEXTILES, TEXTILE , LEATHER AND FOOTWEAR 20 WOOD AND OF WOOD AND CORK 21t22 PULP, PAPER, PAPER , PRINTING AND PUBLISHING 23t25 CHEMICAL, RUBBER, PLASTICS AND FUEL 23 Coke, refined petroleum and nuclear fuel 24 Chemicals and chemical products 25 Rubber and plastics 26 OTHER NON-METALLIC MINERAL 27t28 BASIC METALS AND FABRICATED METAL 29 MACHINERY, NEC 30t33 ELECTRICAL AND OPTICAL EQUIPMENT 34t35 TRANSPORT EQUIPMENT 36t37 MANUFACTURING NEC; RECYCLING E ELECTRICITY, GAS AND 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 64 POST AND TELECOMMUNICATIONS JtK FINANCE, INSURANCE, REAL ESTATE AND BUSINESS SERVICES J FINANCIAL INTERMEDIATION K REAL ESTATE, RENTING AND BUSINESS ACTIVITIES 70 Real estate activities 71t74 Renting of m&eq and other business activities 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 P PRIVATE HOUSEHOLDS WITH EMPLOYED PERSONS Q EXTRA-TERRITORIAL ORGANIZATIONS AND BODIES Source: EU KLEMS database, November 2009, www.euklems.net