===============
WTO
===============

Provider
========

:provider_name: wto
:provider_longname: World Trade Organization 
:provider URL: https://www.wto.org
:region: World
:terms of use: see Copyright on
	       https://www.wto.org/english/res_e/statis_e/merch_trade_stat_e.htm. It
	       seems that one needs to ask permission to republish.
:approximate number of datasets: 3
   

Data accessibility
==================

:SDMX: no
:REST API: no
:Bulk Download: https://www.wto.org/english/res_e/statis_e/trade_datasets_e.htm
:Account: no

Desired datasets
================

:Description:
   - csv files:
     - WTO-UNCTAD-ITC annual trade in services dataset
     - WTO merchandise trade values annual dataset
     - WTO merchandise trade indices annual dataset
   - Excel files:
     - Quarterly merchandise trade value
     - Quarterly merchandise trade volume
     - Quarterly trade in commercial services value
     - Monthly merchandise trade value
     - Monthly trade in commercial services value
     - Monthly changes in export and import price of manufactured goods

Data tree
=========

:Existence of a hierachy of datasets on web site: no
:How to recover the information: no
	* category: code: annual, name: Annual trade data 
		* dataset: code: a1, name: WTO-UNCTAD-ITC annual trade in services dataset
		* dataset: code: a2, name: WTO merchandise trade values annual dataset
		* dataset: code: a3, name: WTO merchandise trade indices annual dataset
	* category: code: quater, name: Quaterly trade data
		* dataset: code: q1, name: Quarterly merchandise trade value
		* dataset: code: q2, name: Quarterly, name: merchandise trade volume
		* dataset: code: q3: name: Quarterly trade in commercial services value
	* category: code: month, name: Monthly trade data
		* dataset: code: m1, name: Monthly merchandise trade value 
		* dataset: code: m2, name: Monthly trade in commercial services value 
		* dataset: code: m3, name: Monthly changes in export and import price of manufactured goods



				 
Datasets
========

:datasetCode: to be made up
:how to get release date: date of file in zip archive
:dataset docHref: yes
:dataset notes: https://www.wto.org/english/res_e/statis_e/trade_datasets_e.htm
:dimension_list: on first line of csv file (see below for Excel files)
:use of attributes: column Flag, need to find signification of the flags
:attribute_list: to be made up if it exists		
:available frequencies: annual, quarterly, monthly
:availability of previous updates: no
:existence of real time datasets: no
:Excel files:
- skip Summary sheets
- check for empty rows at end of tables
- Quarterly merchandise trade value:
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M
  - dimension units with (Million dollars and percentage change,
    year-on-year). Percent change starts at column BF
  - Series notes on row 131 132
  - Dataset notes on rows 134-136
- Quarterly merchandise trade volume
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M
  - dimension Adjustment with SA (seasonally adjuste) and NSA
    (non seasonaly adjusted)  
  - Put Sheet Data sources in dataset notes
- Quarterly trade in commercial services value
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M
  - dimension units with (Million dollars and percentage change,
    year-on-year). Percent change starts at column BA
  - Put Sheet Methodology in dataset notes
- Monthly merchandise trade value
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M
  - Series notes on row 51 52
- Monthly trade in commercial services value
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M
  - Series notes on row 51 52
- Monthly changes in export and import price of manufactured goods
  - treat Exports and Imports as values of dimension "Flow" with codes
    X and M. Put blank or NA for World manufacture price
  - Put sheets Methodological note and Data sources in dataset notes 
   
   
			
Series
======

:Series key: to be made up with dimension codes.
	     - For WTO merchandise trade indices annual dataset, add
	       codes M: Imports, X: Exports 
:Series name: to be made up from dimensions label
:Series docHref: no
:Series notes: column Note (not sure that it is used)
:missing values: ? check that observations are continuous
:date format: yyyy
:mixed frequencies in the same dataset: no

Updates
=======

:calendar of future updates: https://www.wto.org/english/res_e/statis_e/trade_datasets_e.htm
:summary of previous updates: no			     
:regular updates:
   - WTO-UNCTAD-ITC annual trade in services dataset: May
   - WTO merchandise trade values annual dataset: April, October
   - WTO merchandise trade indices annual dataset: April
:RSS flow: https://www.wto.org/english/res_e/webcas_e/rss_e.htm
	   (probably too many information)
:best way to monitor updates: check daily during the month of update
		     
Special problems
================
(like variable names in ESRI)

Other remarks
=============

Data samples
============
:location: in test_xxx file or light files in dlstats/dlstats/tests/resources
:description: a very brief description of the data samples