methods, notes and classification STAN Bilateral Trade Database (ed. 2011) methods, notes and classification

STAN Bilateral Trade Database

Data source(s) used

The STAN Bilateral Trade Database for industrial analysis (BTD) belongs to the STAN Family datasets and is designed to provide analysts and researchers with information on trade in goods broken down by reporter, partner country (or geographical/economic area) and economic activity.

BTD tables for OECD countries are derived from the OECD's International Trade by Commodity Statistics (ITCS) database where (values and quantities of) imports and exports are compiled according to product classifications and by partner country. Due to the convergence of OECD's ITCS and United Nations Statistics Division (UNSD) COMTRADE updating processes, data sharing and other related co-operation between the two organisations, BTD tables can also be computed for non-OECD members as declaring countries, notably the Russian Federation and the countries which belong to the OECD Enhanced Engagement Program (Brazil, China, India, Indonesia and South Africa). However, owing to the terms of the agreement between OECD and UNSD, tables for non-OECD countries cannot be published on OECD's official online services, such as OECD.STAT, which are used for commercial purposes. Nevertheless, BTD tables for non-OECD countries can be transmitted for free on request (write to sti.contact@oecd.org mentioning BTD in the title of the message).

To compile this edition of Bilateral Trade Database, ITCS and COMTRADE values of imports and exports are converted from product classification schemes to an activity classification scheme using a standard conversion key.

In BTD, the list of industries is based on the International Standard Classification of All Economic Activities (ISIC) Revision 3 and is compatible with other OECD databases such as STAN database for Industrial Analysis, Business Expenditure on R&D by Industry (ANBERD), the OECD Input-Output tables and the STAN Indicators.

BTD is updated on a 'rolling basis' like the STAN Industry database. Most series are presented from 1988 onwards. Data are presented in US dollars, at current prices.

Users should note that not all trade is included in BTD (e.g. exports from Saudi Arabia to Pakistan). However, based on 2005 data from UNSD's COMTRADE Database, it is estimated that when considering data for OECD declaring countries, about 90% of world trade is covered by BTD. When also considering the non-OECD declaring countries processed for BTD, about 99% of world trade is covered.

Information on previous versions of BTD can be found on the database's internet page, here. For further details on Science, Technology and Industry statistics, please visit the web site page at www.oecd.org/sti/.

Aggregation and consolidation

To compile the current version of BTD, ITCS data are converted from product classifications schemes to an activity classification scheme using a standard conversion key.

********************************************************************************
*                                                                              *
* OECD STATISTICS                                                              *
* PARIS                 STAN Bilateral Trade Database                          *
*                       -----------------------------                          *
*                                                                              *
* Internet & DVD:                            DSI   DATA SERVICE & INFORMATION  *
*                                            D-47476 Rheinberg   P.O. Box 1127 *
*                                            Phone:  +49 2843-3368  FAX: -3230 *
********************************************************************************



CLASSIFICATION PLAN
-------------------


STRUCTURE OF THE CODE :   XXX / X / XX / XX / X


SUB-CODES :

    1   XXX......   Country
    2   ...X.....   Variable
    3   ....XX...   Industry
    4   ......XX.   Partner country
    5   ........X   Blank



SUB-CODE  1 : Country
-----------

          AUS Australia
          AUT Austria
          BLX Belgium-Luxembourg
          CAN Canada
          CHL Chile
          TWN Chinese Taipei
          CZE Czech Republic
          DNK Denmark
          EST Estonia
          FIN Finland
          FRA France
          DEU Germany
          GRC Greece
          HUN Hungary
          ISL Iceland
          IRL Ireland
          ISR Israel
          ITA Italy
          JPN Japan
          KOR Korea
          LUX Luxembourg
          MEX Mexico
          NLD Netherlands
          NZL New Zealand
          NOR Norway
          POL Poland
          PRT Portugal
          SVK Slovak Republic
          SVN Slovenia
          ESP Spain
          SWE Sweden
          CHE Switzerland
          TUR Turkey
          GBR United Kingdom
          USA United States



SUB-CODE  2 : Variable
-----------

           I Imports
           E Exports



SUB-CODE  3 : Industry
-----------

           00 GRAND TOTAL
           01 AGRICULTURE FORESTRY AND FISHING
           02 MINING AND QUARRYING
           03 TOTAL MANUFACTURING
           04 + Food beverages and tobacco
           05 + Textiles leather and footwear
           06 + Wood and cork
           07 + Pulp paper printing and publishing
           08 + Chemical rubber plastics and fuel
           09 ++ Coke refined petroleum and nuclear fuel
           10 ++ Chemicals and chemical products
           11 +++ Chemicals excluding pharmaceuticals
           12 +++ Pharmaceuticals
           13 ++ Rubber and plastics
           14 + Non-metallic products
           15 + Basic metals and fabricated metal products
           16 ++ Basic metals
           17 +++ Iron and steel
           18 +++ Non-ferrous metals
           19 ++ Fabricated metal products
           20 + Machinery and equipment
           21 ++ Machinery and equipment n.e.c
           22 ++ Electrical and optical equipment
           23 +++ Office accounting and computing machinery
           24 +++ Electrical machinery and apparatus n.e.c
           25 +++ Radio TV communication equipment
           26 +++ Medical precision and optical instrument
           27 + Transport equipment
           28 ++ Motor vehicles trailers and semi-trailers
           29 ++ Other transport equipment
           30 +++ Shipbuilding
           31 +++ Aircraft and spacecraft
           32 +++ Railroad and transport equipment n.e.c
           33 + Manufacturing n.e.c and recycling
           34 ELECTRICITY GAS AND WATER
           35 SCRAP METALS
           36 WASTE
           37 UNALLOCATED AND CONFIDENTIAL
           38 HIGH TECHNOLOGY MANUFACTURES
           39 MEDIUM-HIGH TECHNOLOGY MANUFACTURES
           40 MEDIUM-LOW TECHNOLOGY MANUFACTURES
           41 LOW TECHNOLOGY MANUFACTURES
           42 ICT MANUFACTURES



SUB-CODE  4 : Partner country
-----------

           00 Australia
           01 Austria
           02 Belgium-Luxembourg
           03 Canada
           04 Chile
           05 Czech Republic
           06 Denmark
           07 Estonia
           08 Finland
           09 France
           10 Germany
           11 Greece
           12 Hungary
           13 Iceland
           14 Ireland
           15 Israel
           16 Italy
           17 Japan
           18 Korea
           19 Luxembourg
           20 Mexico
           21 Netherlands
           22 New Zealand
           23 Norway
           24 Poland
           25 Portugal
           26 Slovak Republic
           27 Slovenia
           28 Spain
           29 Sweden
           30 Switzerland
           31 Turkey
           32 United Kingdom
           33 United States
           34 Argentina
           35 Brazil
           36 Bulgaria
           37 China
           38 Chinese Taipei
           39 Cyprus
           40 Former Czechoslovakia
           41 Hong Kong, China
           42 India
           43 Indonesia
           44 Latvia
           45 Lithuania
           46 Malaysia
           47 Malta
           48 Philippines
           49 Romania
           50 Russia (Federation of)
           51 Saudi Arabia
           52 Singapore
           53 South Africa
           54 Thailand
           55 Viet Nam
           56 OPEC countries (excl. Saudi Arabia shown separately)
           57 Rest of the World
           58 Total World
           59 Major seven
           60 EU 15 countries
           61 EU 19 countries
           62 EU 25 countries
           63 European Union
           64 OECD
           65 Total Non-OECD
           66 Unspecified
           67 World excluding EU15
           68 World excluding EU19
           69 World excluding EU25
           70 World excluding EU27
           71 World excluding OECD


           
Units:
------

in thousands US$ current prices

    • Variable
      • I Imports (in thousands US$)
      • E Exports (in thousands US$)
    • Industry
      • 00 GRAND TOTAL
      • 01 AGRICULTURE FORESTRY AND FISHING
      • 02 MINING AND QUARRYING
      • 03 TOTAL MANUFACTURING
      • 04 + Food beverages and tobacco
      • 05 + Textiles leather and footwear
      • 06 + Wood and cork
      • 07 + Pulp paper printing and publishing
      • 08 + Chemical rubber plastics and fuel
      • 09 ++ Coke refined petroleum and nuclear fuel
      • 10 ++ Chemicals and chemical products
      • 11 +++ Chemicals excluding pharmaceuticals
      • 12 +++ Pharmaceuticals
      • 13 ++ Rubber and plastics
      • 14 + Non-metallic products
      • 15 + Basic metals and fabricated metal products
      • 16 ++ Basic metals
      • 17 +++ Iron and steel
      • 18 +++ Non-ferrous metals
      • 19 ++ Fabricated metal products
      • 20 + Machinery and equipment
      • 21 ++ Machinery and equipment n.e.c
      • 22 ++ Electrical and optical equipment
      • 23 +++ Office accounting and computing machinery
      • 24 +++ Electrical machinery and apparatus n.e.c
      • 25 +++ Radio TV communication equipment
      • 26 +++ Medical precision and optical instrument
      • 27 + Transport equipment
      • 28 ++ Motor vehicles trailers and semi-trailers
      • 29 ++ Other transport equipment
      • 30 +++ Shipbuilding
      • 31 +++ Aircraft and spacecraft
      • 32 +++ Railroad and transport equipment n.e.c
      • 33 + Manufacturing n.e.c and recycling
      • 34 ELECTRICITY GAS AND WATER
      • 35 SCRAP METALS
      • 36 WASTE
      • 37 UNALLOCATED AND CONFIDENTIAL
      • 38 HIGH TECHNOLOGY MANUFACTURES
      • 39 MEDIUM-HIGH TECHNOLOGY MANUFACTURES
      • 40 MEDIUM-LOW TECHNOLOGY MANUFACTURES
      • 41 LOW TECHNOLOGY MANUFACTURES
      • 42 ICT MANUFACTURES
    • Partner country
      • 00 Australia
      • 01 Austria
      • 02 Belgium-Luxembourg
      • 03 Canada
      • 04 Chile
      • 05 Czech Republic
      • 06 Denmark
      • 07 Estonia
      • 08 Finland
      • 09 France
      • 10 Germany
      • 11 Greece
      • 12 Hungary
      • 13 Iceland
      • 14 Ireland
      • 15 Israel
      • 16 Italy
      • 17 Japan
      • 18 Korea
      • 19 Luxembourg
      • 20 Mexico
      • 21 Netherlands
      • 22 New Zealand
      • 23 Norway
      • 24 Poland
      • 25 Portugal
      • 26 Slovak Republic
      • 27 Slovenia
      • 28 Spain
      • 29 Sweden
      • 30 Switzerland
      • 31 Turkey
      • 32 United Kingdom
      • 33 United States
      • 34 Argentina
      • 35 Brazil
      • 36 Bulgaria
      • 37 China
      • 38 Chinese Taipei
      • 39 Cyprus
      • 40 Former Czechoslovakia
      • 41 Hong Kong, China
      • 42 India
      • 43 Indonesia
      • 44 Latvia
      • 45 Lithuania
      • 46 Malaysia
      • 47 Malta
      • 48 Philippines
      • 49 Romania
      • 50 Russia (Federation of)
      • 51 Saudi Arabia
      • 52 Singapore
      • 53 South Africa
      • 54 Thailand
      • 55 Viet Nam
      • 56 OPEC countries (excl. Saudi Arabia shown separately)
      • 57 Rest of the World
      • 58 Total World
      • 59 Major seven
      • 60 EU 15 countries
      • 61 EU 19 countries
      • 62 EU 25 countries
      • 63 European Union
      • 64 OECD
      • 65 Total Non-OECD
      • 66 Unspecified
      • 67 World excluding EU15
      • 68 World excluding EU19
      • 69 World excluding EU25
      • 70 World excluding EU27
      • 71 World excluding OECD
    • Reporting Country
      • AUS Australia
      • AUT Austria
      • BLX Belgium-Luxembourg
      • CAN Canada
      • CHL Chile
      • TWN Chinese Taipei
      • CZE Czech Republic
      • DNK Denmark
      • EST Estonia
      • FIN Finland
      • FRA France
      • DEU Germany
      • GRC Greece
      • HUN Hungary
      • ISL Iceland
      • IRL Ireland
      • ISR Israel
      • ITA Italy
      • JPN Japan
      • KOR Korea
      • LUX Luxembourg
      • MEX Mexico
      • NLD Netherlands
      • NZL New Zealand
      • NOR Norway
      • POL Poland
      • PRT Portugal
      • SVK Slovak Republic
      • SVN Slovenia
      • ESP Spain
      • SWE Sweden
      • CHE Switzerland
      • TUR Turkey
      • GBR United Kingdom
      • USA United States