slide1 n.
Skip this Video
Download Presentation
Overview of Databases operated by UNCTAD-World Bank World Integrated Trade Solution (WITS) and its main functionalitie

Loading in 2 Seconds...

play fullscreen
1 / 26

Overview of Databases operated by UNCTAD-World Bank World Integrated Trade Solution (WITS) and its main functionalitie - PowerPoint PPT Presentation

  • Uploaded on

Overview of Databases operated by UNCTAD-World Bank World Integrated Trade Solution (WITS) and its main functionalities. Virtual Institute, TDA Workshop 11-14 September, 2006. WITS vs Databases.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Overview of Databases operated by UNCTAD-World Bank World Integrated Trade Solution (WITS) and its main functionalitie' - Mia_John

Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Overview of Databasesoperated byUNCTAD-World Bank World Integrated Trade Solution (WITS) and its main functionalities

Virtual Institute, TDA Workshop

11-14 September, 2006

wits vs databases
WITS vs Databases

WITSis a software which is designed to integrate several trade-related databases and provide easy access

Five databases are currently accessible throughWITS

databases of wits

COMTRADE (UN Statistics Division)

Integrated Database (IDB-WTO)

Consolidated Tariff Schedule (CTS-WTO)

Agricultural Market Access Database (AMAD)

Databases of WITS
data accessibility
COMTRADE: Free access to International Organizations, others against a fee

TRAINS: Access to governments and international and regional organizations and donors to TRAINS Trust Fund

WTO: Access to WTO member governments and selected international organizations

AMAD: Free for all

Data Accessibility
data contents of trains as of 15 april 2006
Data contents of TRAINS(as of 15 April 2006)
  • Tariff measures at national tariff line level for 161 countries (889 country/years since 1988), including preferential rates such as RTA and GSP in many cases

Primary data are drawn from


UN Tariff and Market Access Database

A joint effort with the

International Trade Centre (ITC)

data contents of trains continued
Data contents of TRAINS(continued)
  • Import statistics by origin at Harmonized System (HS) 6-digit level for every country-year by constructing mirror imports where necessary
  • Non-Tariff Measures classified according to UNCTAD Coding System of Trade Control Measures (97 countries, 150 country/years)
wits functionality
WITS Functionality
  • Data retrieval and analysis
      • Quick query
      • Advanced query
      • Tariff Change Simulations
      • Other options
quick query
Quick Query

Direct access to the Database

  • By country and/or by product
  • Export raw data
  • Extraction by criteria
advanced query
Advanced Query

Users construct queries comprising of:

  • Reporter countries
  • Products
  • Partner countries
  • Years
custom query parameters
Custom Query – Parameters

Reporter Countries

  • Individual countries or user-defined groups of countries


  • Individual products or user-defined aggregates of products in various product classifications (HS, SITC,ISIC, etc)
custom query parameters1
Custom Query – Parameters

Partner Countries

  • Same as Reporter Countries. “World” is treated as an individual country


  • From 1988
custom query submission
Custom Query – submission

Further options before submitting

  • MFN rates (default) , Bound Rates and/or Effectively Applied (preferential) rates
  • Latest available year for each reporter country
  • Substitution of unavailable year with the nearest available year
  • Breakdown of country groups
custom query results
Custom Query – results

Main indicators

  • Simple and trade weighted tariff averages
  • Value of imports
    • Duty free
    • Dutiable
    • Non-ad valorem rates
  • Distribution of tariff rates
tariff change simulation single market simulation model
Tariff Change Simulation(Single market simulation model)
  • Trade Creation and Diversion effects
  • Tariff revenue effect
  • Welfare effect
  • Importer and Exporter Views
tariff change simulation single market simulation model1
Tariff Change Simulation(Single market simulation model)


  • Each product is independent
  • A same product from different supplier is an imperfect substitute
  • Three sets of elasticties (Demand, Supply and Substitution between two suppliers)
tariff change simulation
Tariff Change Simulation

Results of Simulation

  • First round effect of tariff reduction
  • No time horizon
  • No cost of structural adjustment
doha proposals in wits
Doha Proposals in WITS
  • WTO Doha Proposals” simulates the tariff reduction proposals submitted to the WTO’s Negotiating Group on Market Access.

More flexible, user-defined tariff change formula option is under development

advance tariff change simulation atcs
Advance Tariff Change Simulation(ATCS)

Apply tariff change formula to tariff schedules and assess impact

  • Pre-defined or user-defined formula
  • Multiple formula in terms of affected countries and products
atcs two parts
Simulation query

Defines a specific simulation by selecting countries, products and scenarios

Scenario Definition

Defines a scope of tariff changes in terms of group of countries, product categories, bound and unbound tariff lines, etc.

ATCS: Two Parts
improvement for immediate future
Improvement for immediate future
  • Ad Valorem Equivalents:
    • Estimation of % equivalents of non ad-valorem rates
  • Multi-market Simulation Model
    • Incorporation of GSIM model in WITS/TRAINS
computer requirement
Computer Requirement
  • PC of reasonable speed (minimum 200MHZ)
  • Windows 98, 2000 or XP
  • Internet Explorer version 5.0 or higher
  • Internet Access with 50mb of disk space
how to install wits
How to Install WITS

Register at

Receive userid and passwordvia e-mail

Downloadinstallation file from



Trade Information Section


Palais des Nations

1211 Geneva 10, Switzerland


Fax: +41 22 917 0044