Every table, every source, every byte
The workbench is backed by 73 Parquet tables (1.31 GB on disk, 224.09M rows in total) spanning CEPII (BACI, Gravity, TRADHIST), the IMF (WEO, BoP, IIP, IFS), the World Bank (WDI, Pink Sheet, Doing Business), FAOSTAT, OECD (TiVA, GeoDep), UN Comtrade and UNCTAD (TRAINS, NTMs), UN ESCAP, Eurostat, the US Census / FRED / BLS, and derived Hausmann-Hidalgo complexity metrics. Every figure on the site is a SELECT against one of these files.
Licensing. Data is redistributed under upstream terms, which in most cases is CC-BY-4.0 with attribution (World Bank, FAOSTAT, Eurostat, ESCAP). CEPII, IMF, OECD, and UNCTAD datasets are free for research with attribution per their respective terms. US federal statistics (FRED, BLS, Census, OFAC, BIS) are public domain. Each section below links to its upstream source and quotes the canonical citation; please cite both that source and this workbench when reusing.
Partitioned tables (BACI bilateral_year, country_year_product, unit_values, gravity_bilateral, rca_matrix, product_proximity, pref_tariff_hs6) are split by year. For those, download a specific year partition rather than the whole directory; a sample download link is shown per table.
CEPII, BACI (bilateral trade, HS6)
Harmonized bilateral trade flows at the HS6 product level, derived from UN Comtrade with reconciliation of mirror flows and CIF/FOB adjustment. BACI 202501 vintage (HS 2022 nomenclature).
Citation. Gaulier, G., and Zignago, S. (2010). BACI: International Trade Database at the Product-Level. The 1994 to 2007 Version. CEPII Working Paper No. 2010-23.
Source: http://www.cepii.fr/CEPII/en/bdd_modele/bdd_modele_item.asp?id=37 · License: CEPII terms; free for research with attribution
| table | rows | size | years | schema | download | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
bilateral_yearpartitioned Exporter x importer x HS6 x year flows. BACI core. | 870.8k | 4.8 MB | 1995-2024 |
| download sample year=1995 | ||||||||||
country_year_productpartitioned Country x HS6 x year aggregates (RCA inputs). | 24.02M |
CEPII, Gravity
Country-pair panel of bilateral gravity covariates (distance, contiguity, common language, colonial history, RTA, WTO, currency union, GDP) used for trade-cost and gravity-model estimation. Gravity V202411 release.
Citation. Conte, M., Cotterlaz, P., and Mayer, T. (2022). The CEPII Gravity Database. CEPII Working Paper No. 2022-05.
Source: http://www.cepii.fr/CEPII/en/bdd_modele/bdd_modele_item.asp?id=8 · License: CEPII terms; free for research with attribution
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
gravity_bilateralpartitioned Bilateral country-pair x year gravity covariates. | 1.59M | 20.4 MB | 1995-2021 |
|
CEPII, TRADHIST (historical trade)
Bilateral trade and GDP panel covering the First Globalization (1827 to 1913) and Second Globalization (1950 to 2014). Allows long-run comparative analysis across two centuries of trade integration.
Citation. Fouquin, M., and Hugot, J. (2016). Two Centuries of Bilateral Trade and Gravity Data: 1827 to 2014. CEPII Working Paper No. 2016-14.
Source: http://www.cepii.fr/CEPII/en/bdd_modele/bdd_modele_item.asp?id=32 · License: CEPII terms; free for research with attribution
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
historical_trade Bilateral annual flows, 1827 to 2014. | 2.50M | 18.6 MB | 1827-2014 |
|
IMF, WEO, BoP, IIP, IFS
IMF statistical suites: World Economic Outlook (macro forecasts and history), Balance of Payments (BPM6 analytical presentation), International Investment Position, International Financial Statistics (CPI, exchange rates, debt), Financial Access Survey, Financial Development Index, Fiscal Monitor, Primary Commodity Prices, and commodity terms of trade (Gruss-Kebhaj).
Citation. International Monetary Fund. (2024). World Economic Outlook Database, October 2024. Washington, DC: IMF. Supplementary: Balance of Payments and IIP Statistics (BPM6); International Financial Statistics; Gruss, B., and Kebhaj, S. (2019). Commodity Terms of Trade: A New Database. IMF Working Paper 19/21.
Source: https://data.imf.org/ · License: IMF terms; free for research with attribution
| table | rows | size | years | schema | download | |||
|---|---|---|---|---|---|---|---|---|
imf/weo.parquet World Economic Outlook database (country x indicator x year). | 354.2k | 1.8 MB | 1980-2030 |
|
World Bank, World Development Indicators
The World Development Indicators (WDI) compile roughly 1,400 country-by-year series on the economy, demographics, trade, human capital, poverty, environment, and governance, sourced from WB, UN agencies, OECD, and IMF.
Citation. World Bank. (2024). World Development Indicators. Washington, DC: The World Bank Group. DOI:10.57966/Z0S5-MM20.
Source: https://data.worldbank.org/ · License: CC-BY-4.0
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
wdi_data Country x indicator x year long-format values. | 368.2k | 2.4 MB | 1990-2024 |
|
World Bank, Pink Sheet (commodity prices)
Monthly and annual nominal USD prices for 71 commodities across energy, metals, precious metals, agricultural raw materials, beverages, food and fertilizers. Published by the World Bank Prospects Group as the Commodity Markets Outlook.
Citation. World Bank. (2024). Commodity Markets Outlook. Washington, DC: The World Bank Group. Pink Sheet monthly release.
Source: https://www.worldbank.org/en/research/commodity-markets · License: CC-BY-4.0
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
pink_sheet_annual Annual nominal prices, 1960 to present. | 4.2k | 58.6 KB | 1960-2025 |
|
World Bank, Doing Business (archive)
The World Bank Doing Business project (discontinued in 2021) measured regulation of business operations across 190 economies. Archived scores and sub-indices cover starting a business, trading across borders, enforcing contracts, and more.
Citation. World Bank. (2020). Doing Business 2020: Comparing Business Regulation in 190 Economies. Washington, DC: The World Bank.
Source: https://archive.doingbusiness.org/ · License: CC-BY-4.0 (archive)
| table | rows | size | years | schema | download | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
eodb Ease of Doing Business sub-index scores and ranks. | 3.4k | 391.7 KB | - |
|
World Bank / UNCTAD, WITS x TRAINS tariffs
Applied and preferential tariffs at the HS6 level from the World Integrated Trade Solution (WITS), which aggregates UNCTAD TRAINS, WTO IDB and CTS.
Citation. United Nations Conference on Trade and Development. (2024). Trade Analysis Information System (TRAINS). Geneva: UNCTAD. Accessed via World Bank WITS.
Source: https://wits.worldbank.org/ · License: World Bank / UNCTAD terms; free use with attribution
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
pref_tariff_hs6partitioned Preferential + MFN applied tariffs at HS6, reporter x partner x year. | 36.54M | 52.5 MB | 1988-2023 |
|
FAOSTAT (FAO Statistics Division)
FAO compiles food, agriculture, trade, food security, and Sustainable Development Goal indicators for roughly 245 countries and territories, starting in 1961 for most series.
Citation. Food and Agriculture Organization of the United Nations. (2024). FAOSTAT Statistical Database. Rome: FAO. Includes Trade and SDG Indicators modules.
Source: https://www.fao.org/faostat/en/ · License: CC-BY-4.0
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
fao_trade Agricultural trade flows (value, quantity) by country x item x year. | 8.73M | 53.3 MB | 1980-2024 |
|
OECD, TiVA (Trade in Value Added)
Trade in Value Added decomposes gross bilateral trade into domestic and foreign value-added components using the OECD Inter-Country Input-Output (ICIO) tables. Captures global value chain participation, backward and forward linkages, and value-added exports.
Citation. OECD. (2023). Trade in Value Added (TiVA) Database, 2023 edition. Paris: OECD Publishing. Based on the 2021 release of the OECD Inter-Country Input-Output tables.
Source: https://www.oecd.org/sti/ind/measuring-trade-in-value-added.htm · License: OECD terms; free for research with attribution
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
tiva TiVA indicators (country x activity x partner x year). | 356.8k | 1.1 MB | 1995-2020 |
|
OECD, Geographic Dependence (GeoDep)
OECD indicators of supply-side concentration and market power at the HS6 x importer level, used for strategic dependency and economic security analysis.
Citation. OECD. (2023). Quantifying Industrial Strategies (QuIS): Mapping Strategic Dependencies. Paris: OECD Publishing.
Source: https://www.oecd.org/trade/topics/trade-policy/ · License: OECD terms; free for research with attribution
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
geodep HS6 x importer geographic dependence indicators. | 2.95M | 66.0 MB | 2019-2022 |
|
UN, Comtrade (monthly)
Monthly bilateral commodity trade flows reported to the United Nations Statistics Division by national statistical offices. Near real-time at the HS6 level.
Citation. United Nations Statistics Division. (2024). UN Comtrade Database (Monthly). New York: UNSD. https://comtrade.un.org/
Source: https://comtrade.un.org/ · License: UN Comtrade terms; free for research with attribution
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
comtrade_monthly Reporter x partner x HS x period monthly trade (value, qty, net weight). | 6.95M | 118.6 MB | 2023-2025 |
|
UN ESCAP / World Bank Trade Costs
Symmetric bilateral ad valorem equivalent trade costs (tau) derived from gravity inversion following Novy (2013). Covers manufactures and agriculture separately.
Citation. Arvis, J.-F., Duval, Y., Shepherd, B., Utoktham, C., and Raj, A. (2016). Trade Costs in the Developing World: 1996 to 2010. World Trade Review, 15(3), 451 to 474. Novy, D. (2013). Gravity Redux. Economic Inquiry, 51(1), 101 to 121.
Source: https://www.unescap.org/resources/escap-world-bank-trade-cost-database · License: CC-BY-4.0
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
escap_trade_costs Bilateral tau, 1995 to 2019, manufactures and agriculture. | 859.3k | 4.0 MB | 1995-2018 |
|
WTO / UNCTAD, non-tariff measures
Notifications of SPS, TBT, quantitative restrictions, export and licensing measures classified by the UNCTAD Multi-Agency Support Team (MAST) taxonomy, accessed via WTO I-TIP Goods. Intensity counts only (no ad valorem equivalents).
Citation. UNCTAD. (2019). International Classification of Non-Tariff Measures, 2019 Version. Geneva: UNCTAD. UNCTAD/DITC/TAB/2019/5.
Source: https://i-tip.wto.org/goods · License: WTO/UNCTAD terms; free for research with attribution
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
ntm_country Reporter country x NTM chapter count. | 125 | 4.8 KB | 2012-2024 |
|
Eurostat, NUTS 2 regional statistics
Sub-national regional accounts and trade for EU NUTS 2 regions: GDP (nama_10r_2gdp), Gross Value Added by NACE activity (nama_10r_2gvagr), and extra-EU regional trade.
Citation. Eurostat. (2024). Regional Statistics by NUTS classification. Luxembourg: Publications Office of the European Union.
Source: https://ec.europa.eu/eurostat/web/regions/data/database · License: Eurostat terms; free reuse with attribution
| table | rows | size | years | schema | download |
|---|---|---|---|---|---|
eu_nuts2_gdp NUTS 2 GDP by year and unit. | - | - | - | missing on this machine | - |
eu_nuts2_gva NUTS 2 GVA by NACE R2 activity. | - |
US Census, State Exports
State-level origin of movement merchandise exports to the world: annual totals and HS2 detail for 2024, published by the US Census Bureau via USA Trade Online.
Citation. US Census Bureau. (2024). USA Trade Online, State Exports by Origin of Movement. Washington, DC: US Department of Commerce.
Source: https://usatrade.census.gov/ · License: Public domain (US federal statistics)
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
us_states_exports US state x year total exports to world (USD). | 510 | 3.7 KB | 2015-2024 |
|
FRED (Federal Reserve Bank of St. Louis)
FRED aggregates roughly 800,000 macro and financial time series from federal statistical agencies, foreign central banks, and international organizations.
Citation. Federal Reserve Bank of St. Louis. (2024). FRED Economic Data. St. Louis, MO. https://fred.stlouisfed.org/
Source: https://fred.stlouisfed.org/ · License: Public domain / Federal Reserve terms
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
fred_series FRED series observations (series_id x date x value). | 34.7k | 109.8 KB | - |
|
BLS (US Bureau of Labor Statistics)
BLS public data API for Producer and Consumer Price Indices, Current Employment Statistics, Productivity, and Import/Export Price Indexes.
Citation. US Bureau of Labor Statistics. (2024). BLS Public Data API v2. Washington, DC: US Department of Labor.
Source: https://www.bls.gov/data/ · License: Public domain
| table | rows | size | years | schema | download | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
bls_series BLS series observations (series_id x period x value). | 1.8k | 5.6 KB | - |
|
Global / macro aggregates
Country and world aggregates assembled from IMF WEO, UNCTAD stats, BACI, and BEC (Broad Economic Categories). Used for world-level trade trajectories and stage-of-production decompositions.
Citation. Compiled from: IMF (2024) World Economic Outlook; UNCTAD (2024) Handbook of Statistics; Gaulier and Zignago (2010) BACI; United Nations Statistics Division (2016) Classification by Broad Economic Categories, Rev. 5.
Source: https://www.imf.org/en/Publications/WEO · License: Mixed; see upstream sources
| table | rows | size | years | schema | download | |||||
|---|---|---|---|---|---|---|---|---|---|---|
macro_gdp Country x year GDP (nominal, PPP, per capita). | 17.9k | 765.8 KB | 1960-2029 |
|
Derived, ECI / PCI / Product Space
Economic Complexity Index (ECI), Product Complexity Index (PCI), Hidalgo and Klinger product proximity, and rankings derived from BACI using the Balassa RCA, then Mcp matrix, then method of reflections.
Citation. Hidalgo, C. A., and Hausmann, R. (2009). The building blocks of economic complexity. Proceedings of the National Academy of Sciences, 106(26), 10570 to 10575. Hidalgo, C. A., Klinger, B., Barabasi, A.-L., and Hausmann, R. (2007). The Product Space Conditions the Development of Nations. Science, 317(5837), 482 to 487.
Source: https://doi.org/10.1073/pnas.0900943106 · License: Derived; redistributable under CC-BY-4.0
| table | rows | size | years | schema | download | ||||
|---|---|---|---|---|---|---|---|---|---|
eci_rankings Country x year Economic Complexity Index. | 6.7k | 33.1 KB | 1995-2024 |
|
Derived, Trade and demand elasticities
Elasticity estimates compiled from published Armington / CES trade models and demand-system estimations. Used for partial-equilibrium tariff simulation in the Tariff Lab.
Citation. Broda, C., and Weinstein, D. E. (2006). Globalization and the Gains from Variety. Quarterly Journal of Economics, 121(2), 541 to 585. Caliendo, L., and Parro, F. (2015). Estimates of the Trade and Welfare Effects of NAFTA. Review of Economic Studies, 82(1), 1 to 44. Kee, H. L., Nicita, A., and Olarreaga, M. (2008). Import Demand Elasticities and Trade Distortions. Review of Economics and Statistics, 90(4), 666 to 682.
Source: https://doi.org/10.1162/qjec.2006.121.2.541 · License: Mixed; see upstream sources
| table | rows | size | years | schema | download | |||
|---|---|---|---|---|---|---|---|---|
tariff_elasticity HS6 x importer tariff pass-through elasticities. | 1.2k | 6.7 KB | - |
|
Sanctions and export controls
OFAC Specially Designated Nationals (SDN) list, EU Consolidated Financial Sanctions List, and US Export Administration Regulations (EAR) ECCN catalog. Country-level flag counts and ECCN classification reference used for economic-security views.
Citation. US Department of the Treasury, Office of Foreign Assets Control. (2024). Specially Designated Nationals and Blocked Persons List. European Union. (2024). Consolidated Financial Sanctions List. US Bureau of Industry and Security. (2024). Commerce Control List, 15 CFR Part 774.
Source: https://sanctionssearch.ofac.treas.gov/ · License: Public domain (US Treasury) / EU open data
| table | rows | size | years | schema | download |
|---|---|---|---|---|---|
sanctions/country_flags Country-level sanctions flag counts (OFAC, EU, total). | - | - | - | missing on this machine | - |
sanctions/eccn_catalog |
How to use
Each .parquet file can be queried directly by DuckDB, Polars, pandas (via pd.read_parquet), or Apache Arrow. In DuckDB:
-- single-file table
SELECT COUNT(*) FROM read_parquet('countries.parquet');
-- partitioned table (BACI bilateral, all years)
SELECT exporter, SUM(value) AS v
FROM read_parquet('bilateral_year/**/*.parquet')
WHERE year = 2023
GROUP BY exporter
ORDER BY v DESC
LIMIT 10;Citation
When reusing a table, cite both the upstream source (quoted under each section above) and this workbench as the assembly layer. BACI values are in thousands of USD (multiply by 1000 for current-USD display); PCI is zero-centered and routinely negative; RCA is dimensionless. ISO3 codes are uppercase.