UN COMTRADE

Search Tips

Depending on your information need and level of expertise of the UN Comtrade system, the website offers flexibility in finding the necessary trade data. 

1) Using Shortcut Query [Front Page] 

If reporter or partner is known, Shortcut Query is the easiest tool. Just type the commodity text on the box, select reporter/partner and click Search. The system will search the latest available data.  

2) Using Search for data Box, also known as Comtrade Explorer [on any page]  

There are two search options available, data and help. For data, you can enter only commodity code or text, partner or reporter code or name, and related commodity trade variables. The output would yield several pages with the results in tag clouds.  For example, the search term could be the name of the country, the country's abbreviation, a commodity key word or a year. Examples: "aircraft" or "aircraft engine". The tag clouds appear as years for which the commodity selected is available. The first result shows that year 2004 has the largest value for that commodity. Clicking data availability option just below gives all the reporters and years for which the selected commodity (-ies) is/are available.  

3) Using Basic Selection [Menu Data Query à Basic Selection]  

Basic selection option is a little more sophisticated but still user friendly. You can search for commodities within the commodities tab. Within the reporters tab you can select one or more reporters from the drop down list or choose your customized country groups or my favorite reporters. It is the same for partners tab also.  You can select years depending on your need in the years tab. The others tab allows the user to filter trade data by value and also allows the user to choose a preset sort order.  

After choosing all the appropriate options for your query you can save your query for future use. You can also allow for batch notification. Batch notification will send a notice to your email address once the query execution is completed.  Please note these two options are also limited to subscribers of the UN Comtrade database only.

The tricky thing is that not all countries report statistics in the same way, at the same level of detail, with the same frequency, etc.  So, for the commodities, countries, and time frames for which you're seeking trade data, you'll have to ascertain the availability and the correct classification:

Determining the Classification Code

  1. From the choices across the top, mouse over Metadata & Reference and choose Country List
  2. Look up countries one at a time, click on Data Availability, and determine which code will cover the time-frame you need.  (Depending on the level of industry granularity, you may find that some of the codes that cover the right years are not at the right level of detail, so there is some trial and error involved here depending on what you’re looking for.)

Finding Data

  1. From the choices across the top, mouse over Data Query and choose Express Selection
  2. Ignore Step 0
  3. In Step 1, Choose the Classification (choose only one)
  4. In Step 2, click on Lookup for each item
    1. For commodities, put a term, e.g. sugar, in the search box and use the drop-down to select the classification
    2. Hit the Search button
    3. Expand (hit the + on) the highlighted item
    4. Check off all relevant items
    5. Scroll down and hit the Add button
    6. Scroll down and hit the Apply & Close button
    7. Follow the same process for Reporters (countries), Partners (countries or World), and Years
  5. Under Select Trade Flow, check off Import or Export or both, depending on what you're looking for
  6. To save the search criteria, hit the Save link for each selection and follow the directions that appear
  7. Hit the Submit Query button

Results

After the results appear, there are choices to apply a filter, modify the selection, switch classifications, download into excel, and more. 

Using Express Selection [Menu Data Query à Express Selection] 

The Express selection query option is for the more advanced user of UN Comtrade. It too has all the features of the Basic Selection query but in a more compact window.  

For commodities, you have the option to choose individual commodities or just chapters.

  • "All" specifies all commodities within the selected revision.
  • AG0, AG1, … AG6 are aggregate level and refer to all commodity codes beginning with the specified digits.
  • LF or leaf refers to the basic code and does not include any of the detailed children.
  • Wildcard * is used to find a string of zero or more characters.
  • Wildcard ? is used to find individual characters.
  • The Advanced Items tab is the same as in the Basic Selection.