🌍 International Trade Analysis

← Back to Home
Total Records
68,677
Countries
6
Commodities
124
Date Range
201511 - 202508
Total Trade Value
$267,781M

📡 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
202508 156 China 732690 $22.13M 2025-10-29 18:40 comtrade_corrected
202508 156 China 731815 $14.96M 2025-10-29 18:40 comtrade_corrected
202508 156 China 730890 $8.48M 2025-10-29 18:40 comtrade_corrected
202508 156 China 730900 $6.69M 2025-10-29 18:40 comtrade_corrected
202508 156 China 732020 $6.13M 2025-10-29 18:40 comtrade_corrected
202508 156 China 731816 $5.62M 2025-10-29 18:40 comtrade_corrected
202508 704 Viet Nam 731210 $5.47M 2025-10-29 18:59 comtrade_corrected
202508 156 China 732619 $5.39M 2025-10-29 18:40 comtrade_corrected
202508 124 Canada 732690 $4.84M 2025-10-29 18:31 comtrade_corrected
202508 156 China 731511 $4.45M 2025-10-29 18:40 comtrade_corrected

🗄️ 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.