Readme for the flat file of the Capital Input Files of March 2008 EUKLEMS database (all_capital_input_08I.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-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: AUS Australia 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: 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* 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 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, March 2008, www.euklems.net