wto

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

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

Existence of a hierachy of datasets on web site:

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