Indirect trade of steel through steel-containing components and products, from 1978 to 2017.
This repository is a Data Package: use the viewer to browse the metadata and data.
Data on trade in goods between the UK and the rest of the world are supplied from the UN COMTRADE database. For ease of comparison across years, we use the old SITC version 2 classification, which is available for data from the present (ready-recategorised by COMTRADE) back to 1978.
We have mapped each SITC code onto the 20 sectors used by the ISSB statistics. Each code is assigned or split between components and final goods, and given an average steel content (in kg steel per kg product)
This data was prepared for the TBC report details.
Corrections and improvements are welcome! Please get in touch, or open an issue or a pull request.
This work is licensed under a CC-BY License. Please attribute it as follows:
Richard Lupton & André Cabrera Serrenho. (2019, March 4). ricklupton/uk-steel-trade: Initial release (Version v1.0.0). Zenodo. http://doi.org/10.5281/zenodo.2583078
Install Pipenv, and then use it to set up a Python environment with the necessary packages to prepare the data:
pipenv install
Run the scripts to download and prepare the COMTRADE data using Make:
make
This will:
- Download the raw data to
build/raw_data - Output detailed tables to
build/checking_table.csv - Write the aggregated import and exports data to
data/trade.csv