EXIOBASE

Equinox functionality for exploring the EXIOBASE 3 database.

In this section of the Equinox Reference App documentation we cover the details around the use of EXIOBASE 3. The assumption is that you have a working instance of Equinox running, and have access to its code directory.

EXIOBASE 3 provides a time series of environmentally extended multi-regional input‐output (EE MRIO) tables ranging from 1995 to 2020 (plus now-casted tables for 2021 and 2022) for 44 countries (27 EU member plus 17 major economies) and five rest of the world regions.

Step 1. Download the latest version of EXIOBASE

Use whichever method is most applicable to download the EXIOBASE compressed file. For Linux users there is a script download_exibase.sh in the root directory of the equinox distribution. You may want to adjust the URL for a different version of the database. Run the script inside a data directory that you create at the root equinox directory. Ingestion scripts will expect to find the EXIOBASE files in that location.

Step 2. Extract the EXIOBASE component files

Unzip the downloaded file (in our example here we will use IOT_2022_pxp.zip, which is a product by product IO system). You should then have a collection and directories and files as follows.

EXIOBASE Database Structure

The core IO system is in the txt files. Supplementary environmental and social data are in their own directories.

  • air_emissions/
  • employment/
  • factor_inputs/
  • material/
  • nutrients/
  • water/
  • A.txt
  • x.txt
  • Y.txt
  • Z.txt
  • unit.txt - measurement units per region and product (here all M.EUR)
  • metadata.json - the identity of the data release
  • file_parameters.json - the dimensions of the txt files

Step 3. Insert the EXIOBASE data into Equinox


python3 manage.py load_exiobase