🌍 International Trade Analysis

← Back to Home
Total Records
69,639
Countries
6
Commodities
124
Date Range
201511 - 202510
Total Trade Value
$271,423M

📡 API Endpoints

Test Connection Get Data (100 records) Get Full Data (50 records)

📊 Sample Records (Top 10 by Value)

Period Partner Code Country Commodity Trade Value Collection Time Source
202510 484 Mexico 730890 $140.33M 2026-01-25 08:02 comtrade_api
202510 156 China 732690 $101.50M 2026-01-25 08:01 comtrade_api
202510 156 China 732393 $81.09M 2026-01-25 08:01 comtrade_api
202510 484 Mexico 732690 $69.30M 2026-01-25 08:02 comtrade_api
202510 484 Mexico 732290 $49.57M 2026-01-25 08:02 comtrade_api
202510 124 Canada 730890 $41.77M 2026-01-25 08:01 comtrade_api
202510 484 Mexico 732111 $39.60M 2026-01-25 08:02 comtrade_api
202510 156 China 731815 $39.46M 2026-01-25 08:01 comtrade_api
202510 484 Mexico 732010 $37.75M 2026-01-25 08:02 comtrade_api
202510 124 Canada 732690 $35.72M 2026-01-25 08:01 comtrade_api

🗄️ Database Schema (50 columns)

id
integer NOT NULL
period
character varying
period_date
date
reportercode
integer
partnercode
integer
cmdcode
character varying
flowcode
character varying
primaryvalue
numeric
qty
numeric
altqty
numeric
netwgt
numeric
grosswgt
numeric
netwgt_tons
double precision
grosswgt_tons
double precision
reporterdesc
text
partnerdesc
text
cmddesc
text
flowdesc
text
qtydesc
text
altqtydesc
text
country_name
character varying
trade_value_millions
double precision
price_per_ton_usd
double precision
collection_timestamp
timestamp without time zone
batch_number
integer
data_source
character varying
scrape_date
timestamp without time zone
data_hash
character varying
typecode
character varying
freqcode
character varying
reporteriso
character varying
partneriso
character varying
classificationcode
character varying
aggrlevel
integer
customscode
character varying
customsdesc
text
motcode
character varying
motdesc
text
qtyunitcode
character varying
qtyunitabbr
character varying
isqtyestimated
boolean
altqtyunitcode
character varying
altqtyunitabbr
character varying
isaltqtyestimated
boolean
isnetwgtestimated
boolean
isgrosswgtestimated
boolean
cifvalue
numeric
fobvalue
numeric
isreported
boolean
isaggregate
boolean

📊 Interactive Trade Visualizations

Coming Soon: Phase 4 - Dash Application Development

📈
Time Series Analysis

Track trade flows over time with interactive charts

🗺️
Geographic Heatmaps

Visualize trade patterns by country and region

🔍
Commodity Breakdown

Analyze specific steel and metal product categories

💹
Trade Balance Metrics

Compare import values across trading partners

📥
Export Features

Download charts as PNG and data as CSV

🎯
Custom Filtering

Filter by date range, country, and commodity type

Development Status: Data collection complete (1,494 records). Interactive Dash application in development.

✅ Data Quality Assurance

All data has been collected using bulletproof checkpointing with zero data loss. The database contains comprehensive UN Comtrade import data for steel and metal commodities (HS codes: 730630, 730650, 732690, 731431, 731439, 731420, 731300, 730890) from July 2023 to May 2025.