|
|
===============
|
|
|
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
|
|
|
|
|
|
|