You are here: Protection Data Query > Advanced Query > The Result Table

Advanced Query The Result Table

When clicking on the magnifying glass in the View and Download Request screen, you will be displayed with a popup window, giving you options to select columns to be displayed in the result and the pivoting options. Some columns are mandatory and cannot be unselected.

Information is organized in rows and contains the following fields

Column Heading


Selected Nomen

is the nomenclature used for selecting products (GP for GTAP for example);


is the native nomenclature (H2 for HS 2002 for example) from which the Selected Nomenclature was converted to produce results;


is the reporter 3-digit alphabetic country code(ARG for example) or country group code (ANDEAN for example);

Reporter Name

is the full name of the reporting country (Argentina) or group of countries (ANDEAN ANDEAN country group);


is the partner 3-digit alphabetic country code(WLD) or country group code;

Partner Name

is the full name of the partner country or country group;

Tariff Year

is the year of the tariff data;

Trade Year

is the year of the trade data. If available, WITS takes the same year for trade as for tariffs, if not it uses any closest alternative year);

Trade Source

is the database used for trade data (CMT for UN COMTRADE, INV for inverted UN COMTRADE trade (partner's mirroring), TRN for TRAINS and WTO for WTO IDB);


is the product code or product group code;

Product Name

is the description of the product or group of products;

Duty Type

is the code of the considered type of tariffs (BND for bound tariffs, MFN for MFN applied tariffs, PRF for preferential tariffs or AHS for effectively applied tariffs);

Simple average

(in percentage points)is the simple average tariff of included 6-digit lines. The 6-digit tariff is itself an average of included tariff line level lines. The Simple Tariff Line Average, which is the average of the tariff line level lines, is also calculated by WITS and can be included in the table (see Customizing Output Tables for more information);

Weighted Average

(in percentage points)is the average of tariffs weighted by their corresponding trade value;

Standard Deviation

is a statistical measure of tariff dispersion. It takes into account the difference between a tariff and the average of all tariffs within the considered product category;

Minimum Rate

(in percentage points)returns the lowest tariff value at the tariff line level within the product category;

Maximum Rate

(in percentage points)returns the highest tariff value at the tariff line level within the product category;

Nbr Of Total Lines

is the number of tariffs at the tariff line level;

Nbr Of Domestic Peaks

is the number of tariffs at the tariff line level which value is above 3 times the simple average tariff;

Nbr of International Peaks

is the number of tariffs at the tariff line level which value is above 15;

Imports Value

(in thousand US $) is trade coming from the partner country and entering the importing country under the considered product category;

Binding Coverage

is the number of bound lines divided by the total number of lines.

After selecting the desired columns click on Proceed to view the results. Rows are sorted by the first column name in the selected column list.

Next: Changing Output Results

WITS Online Help

The World Bank, 2010