EXIOBASE 3.8.1 – Environmentally Extended MRIO Data (1995–2022)
This dataset provides globally consistent, environmentally extended multi-regional input-output (EE-MRIO) tables from EXIOBASE version 3.8.1, covering 44 countries and five rest-of-world regions. It includes detailed data on economic transactions and environmental pressures (e.g. emissions, energy use, land, water, materials) from 1995 to 2020, with nowcasts through 2022. Converted to Apache Parquet for efficient, cloud-native access and analysis.
https://zenodo.org/records/4588235
EXIOBASE 3 is a global, multi-regional input-output database, offering a detailed view of the world economy and its environmental impacts. It covers 49 regions and 200 sectors from 1995 to 2022. This dataset is ideal for analyzing trade, economic structures, and environmental footprints.
Data Structure
The data is stored in Parquet format and partitioned by year, format (ixi/pxp), and matrix type (Z, Y, F_satellite, F_impacts) to allow for efficient querying.
The following examples demonstrate how to effectively query the EXIOBASE 3 dataset using DuckDB.
A Note on Performance
For complex queries, such as time-series analysis or combining large matrices, direct queries may time out. A more robust approach is to break down the query into smaller parts and combine the results in your client application (e.g., Python with Pandas, R, etc.). The examples below follow this best practice.
Top 10 Exporters to the US (2022)
To calculate the total exports to the United States, you should query the inter-industry (Z) and final demand (Y) matrices separately and then sum the results.
Step 1: Get Exports from Inter-Industry Transactions