Frankfurt

1
United Nations Commodity Trade Statistics
Database
2
Overview

• Database System
• Collection and Processing
• Management of Usage and Data
• Dissemination
• Key elements
• Key features

3
Collection and Processing

• Joint UN/OECD Data Collection and Processing
  System (COPRA)
• Joint collection Reduced response burden
• Joint standards Increased Quality
• Joint processing Full harmonization of data

4
Management Dashboard

• Daily Usage Statistics
• Who are the Users?
• What is their interest?
• Performance of System
• Information on collection and processing

Daily Download in millions of records
5
UN Comtrade HOME PAGE
6
Dissemination database

• Imports, Exports, Re-exports, Re-imports
• Commodity by Trading Partner
• Annual data
• Value in US dollars
• Net weight and secondary quantities
• Over 150 reporters per year (gt95 of the World
  Trade)

7
Key elements

• Classifications and Commodity Codes
• Harmonized System
• SITC
• Reporter country
• Partner country
• Trade Flow
• Year

8
Data Selection

• Shortcut Query
• Basic Selection
• Express Selection
• Comtrade Explorer
• Data Search
• Via Data Availability

9
Text sensitive search of commodities and countries

• Express Selection
• Auto convert from text to code
• More features than Basic Selection
• Expert User

EXAMPLE
Possibility to execute data requests off-line
10

• Comtrade Explorer
• Google like search
• Data results in table and graph
• Modification in Basic or Express Selection
• For data mining and overviews

EXAMPLE
11
Summary of data request
EXAMPLE
View Map
Germany main exporter of cars over the last 4
years
12
Map shows World Exports of motor vehicles
Germany and Japan are leaders
13
Data Availability

• Interactive
• In Graph
• Reporters
• Commodities
• Years
• By Date of Loading RSS

14

• Data Availability by Reporter
• Click to get all data
• Drill down possibility
• Modify with Express Selection

EXAMPLE
Commodity Classification
Years available
Iceland Reporting Country
15

• Data Availability by Year
• Overview per year and classification
• Click to get all data
• Drill down possibility
• Modify with Express Selection

EXAMPLE
All the Reporters available for Year 2005
Classification HS-2002
16
Data Download
For Subscribers, not for Guest User

• Direct Download
• Max. 150,000 records to CSV output file
• Instant extraction. Uncompressed file.
• Batch Download
• Max. 20,000,000 records to CSV output file
• Background extraction. Compressed file
• Notification of completion via e-mail.
• Output format can be customized

17
Personalization
For Subscribers, not for Guest User

• Favorites
• Saved Queries
• FrontPage
• Download Format
• Automated Data Extraction
• E-mail alerts

18
Favorites

• Country Groups (as reporter or partner)
• Commodity Groups Commodities
• Reporters
• Partners
• Years

19
Metadata Reference

• Commodity List
• HS, SITC, Data Availability and Snapshot
• Countries List
• Data Availability, Snapshot, National Practices
  and ITC Country Profile

20
Knowledge Base

• HOW TO
• Manuals and examples on use of all functions
• FAQ
• Explanation of terminology and codes
  Interpretation of data

21
UN Comtrade Support Information
Frequently Asked Questions
22
UN Comtrade Summary

• Over 1 Billion merchandise trade data
• Coverage of reporting countries not available
  anywhere else
• Data extraction and Data mining
• Personalization of your requirements
• Comprehensive Help and Support in Knowledge Base