The Data menu links all types of data available in the UN Comtrade database. Each link directs the user to the standard query page for the selected type of data.
The query page maintains a consistent structure across various data pages, ensuring a standardized approach to data retrieval.
Querying Data #
Standard Query Page: For illustration purposes, see the example below for Trade Data:
Query parameters: Each query parameter has a drill-down list from which users can choose and submit single or multiple values to query. Users can also input or type a search text, and the drill-down list will return values that match the text or string.
For example, for query parameter Periods, the user can expand the list by clicking the chevron or expansion symbol on the right. This expands the available values for the parameter, and the user can scroll and choose by clicking on value(s) available.
Additionally, users have the option to manually input search text into the query field. The drill-down functionality will then retrieve matches based on this entered text.
Parameter value ALL #
The parameter value ALL is available under the reporter, partner, 2nd partner, trade flows, modes of transport and customs codes criteria. Passing ALL will return all individual values under the data item. For partner and 2nd partner, passing ALL will return all individual partners and the WORLD aggregate.
Parameter value WORLD as partner and 2nd partner #
Passing WORLD as partner and 2nd partner returns the world the aggregate value. “World” as partner is the same as the sum of individual partners.
Saving Parameters and Searches #
As a standard feature, full query and query parameters may be saved for future use. This becomes useful for users who periodically retrieve data with the same parameters. This feature is available at both the parameter (field) and query levels. Note: to enable aggregation on specific parameters, you will have to select those parameters in the “aggregate by” option.
Saving Parameters #
You must be logged in to save your parameters. Once you have defined a list or group, click the Save Group icon to the right of each parameter field. This will save the current values selected in the parameter field.
In this example, ASEAN member countries were selected as trade partners. The user clicks on the Save Group icon.
A window will pop up and ask the user to provide a search name. A user provides “ASEAN Partners.” The user clicks on “Submit,” and the partner grouping is saved.
The saved partner group will now appear under the Partners query field and be available for future queries.
Saving Queries / Searches #
A window will pop up and ask the user to provide a search name. A user provides the search name, “USA Imports From ASEAN.” The user clicks on “Submit,” and the query is saved
First, construct your query by selecting a value for each parameter to save your full query. Click on the Save Query icon on the bottom right.
Saved parameters and queries can be found under your My Comtrade profile.
Query Options #
In addition to specifying selection criteria, the system offers two options for querying:
- Breakdown Mode
Accepted values: Plus or Classic. The Plus enables the breakdown of new data items in Comtrade+ notably detailed trade flow, mode of transport, customs procedure codes, and the 2nd partner (when reported by countries). Whereas the Classic, the selection criteria are automatically set to the following values: trade flows to exports, imports, re-imports, and re-exports), mode of transport to total, customs procedure codes to total, and the 2nd partner to World. The classic mode returns the same dataset as the legacy Comtrade.
- Aggregate By
Accepted values: None, or any combinations of Commodity Code, Period, Reporter, Partner, 2nd Partner, Mode of Transports and Customs Procedure Codes. If the Aggregate By is active, then the trade values, netweight and gross weight will be aggregated along the selected combination. For example, the following selection will return four records because all reporters will be aggregated into single code.
And by adding the Period in the Aggregate By, the query will return two records.
Viewing and saving query results #
Users can choose Preview, Download, or Deliver options to receive the requested data. See the table below for the differences.
| Data Extraction Mode | Description | Access |
| Preview | The data will be shown on screen and be limited to 500 records (regardless of the actual results) | Public (no-registration) |
| Download | The data will be downloaded directly and limited to 100K and 250K records for registered users and subscribers, respectively | Registration required |
| Deliver | The data will be prepared in the background, and the link will be sent to the email. The data is limited to 2.5M records | Subscription required |
