Example B: oil and gas
Which countries would be hit hardest if oil and gas from the Gulf or Russia stopped flowing?
Compare the imports at risk with the size of each economy, then check what that comparison leaves out.
The exposure ranking
Higher means more imports at risk relative to GDP, not a forecast of lost output.
Charts need JavaScript and the chart download. The table and CSV remain available.
| Rank | Country | Russia % | Gulf % | Total % | Data |
|---|---|---|---|---|---|
| 1 | Brunei Darussalam | 3.83% | 8.40% | 12.23% | Importer |
| 2 | Kyrgyzstan | 6.07% | 0.00% | 6.07% | Importer |
| 3 | Mongolia | 5.64% | 0.00% | 5.65% | Importer |
| 4 | Singapore | 0.50% | 4.55% | 5.05% | Importer |
| 5 | Greece | 1.77% | 2.76% | 4.53% | Importer |
| 6 | Mauritius | 0.00% | 4.31% | 4.31% | Importer |
| 7 | Armenia | 3.78% | 0.47% | 4.25% | Importer |
| 8 | Slovakia | 4.21% | 0.00% | 4.21% | Importer |
| 9 | Jordan | 0.03% | 4.13% | 4.17% | Importer |
| 10 | Mozambique | 0.00% | 4.13% | 4.13% | Importer |
| 11 | Thailand | 0.08% | 3.91% | 3.99% | Importer |
| 12 | Rep. of Korea | 0.26% | 3.71% | 3.98% | Importer |
| 13 | Lithuania | 1.86% | 1.91% | 3.77% | Importer |
| 14 | India | 0.89% | 2.76% | 3.65% | Importer |
| 15 | Belarus | 3.64% | 0.01% | 3.65% | mirror: 2021, 2022, 2023 |
| 16 | East and West Pakistan (...1971) | 0.00% | 3.58% | 3.58% | Importer |
| 17 | Bulgaria | 2.87% | 0.30% | 3.17% | Importer |
| 18 | Hungary | 2.72% | 0.02% | 2.74% | Importer |
| 19 | Serbia | 1.58% | 1.09% | 2.68% | Importer |
| 20 | Lebanon | 1.41% | 1.25% | 2.65% | Importer |
| 21 | Senegal | 1.65% | 1.00% | 2.65% | Importer |
| 22 | Malaysia | 0.24% | 2.41% | 2.65% | Importer |
| 23 | Namibia | 0.00% | 2.49% | 2.49% | Importer |
| 24 | Uganda | 0.00% | 2.39% | 2.39% | Importer |
| 25 | Kenya | 0.00% | 2.37% | 2.37% | Importer |
ASEAN and G7
| Rank | Country | Group | Exposure |
|---|---|---|---|
| 1 | Brunei Darussalam | ASEAN | 12.23% |
| 4 | Singapore | ASEAN | 5.05% |
| 11 | Thailand | ASEAN | 3.99% |
| 22 | Malaysia | ASEAN | 2.65% |
| 32 | Japan | G7 | 1.78% |
| 49 | Rep. of Vietnam (...1974) | ASEAN | 1.10% (mirror) |
| 53 | Italy | G7 | 1.05% |
| 54 | Philippines | ASEAN | 0.93% |
| 64 | France | G7 | 0.64% |
| 68 | Indonesia | ASEAN | 0.44% |
| 77 | United Kingdom | G7 | 0.33% |
| 78 | Fed. Rep. of Germany (...1990) | G7 | 0.30% |
| 94 | USA | G7 | 0.12% |
| 96 | Canada | G7 | 0.10% |
| 107 | Myanmar | ASEAN | 0.05% |
| 121 | Cambodia | ASEAN | 0.01% |
| 135 | Lao People's Dem. Rep. | ASEAN | 0.00% (mirror) |
Data: UN Comtrade (importer-reported, mirror where noted), IMF WEO April 2026 GDP. Fetched: PROVISIONAL partial fetch.
Try it yourself
Download the data
✅ Free pending testSave exposure.csv to your computer.
Prompt
What does an at-risk energy import share of GDP measure? Explain it in one sentence. A saved CSV file and a definition that compares at-risk imports with the size of the economy.
Ask for a ranking and chart
⚠️ Free, limit: free file-upload and message limits pending testUpload the CSV to your AI chat, then paste this prompt.
Prompt
Use only the attached exposure.csv. Show the 10 countries with the highest exposure_pct_gdp. Make a horizontal stacked bar chart split into Russia and Gulf. For each part, divide russia_usd or gulf_usd by gdp_usd and multiply by 100. Label the units and mark mirror rows. Do not invent missing values. Ten countries in descending order, with two parts per bar measured as a percentage of GDP.
Make the AI explain its method
⚠️ Free, limit: free message cap pending test Prompt
Explain the method back to me: average 2020 to 2024 imports of HS 2709, 2710 and 2711 from Russia and the eight Gulf suppliers, divided by average GDP. Name two weaknesses. Explain why this is not a prediction of GDP loss. A clear explanation of the numerator, denominator and two limits, including re-exports or alternative supplies.
Separate the two supply shocks
⚠️ Free, limit: free message cap pending test Prompt
Using the CSV, rank countries first by russia_usd / gdp_usd and then by gulf_usd / gdp_usd. Which countries move most compared with the total exposure ranking if only Russia stops supplying, versus only the Gulf? Show the old and new ranks. Two different rankings with named countries and rank changes. Compare them with the explorer.
Write a short ASEAN briefing
⚠️ Free, limit: free message cap pending test Prompt
Write a 300-word briefing on the five most exposed ASEAN members in the CSV. Name each country, its exposure as a share of GDP and its Russia versus Gulf split. Explain the method and two limitations. Distinguish evidence from policy suggestions. Flag provisional or mirror data. A short briefing grounded in five CSV rows, with caveats and no unsupported forecasts.
Spot-check two numbers
✅ Free pending testOpen the CSV in a spreadsheet. Choose two countries and calculate their at-risk imports divided by GDP, multiplied by 100.
Prompt
For these two countries, show russia_usd, gulf_usd and gdp_usd from the CSV. Calculate (russia_usd + gulf_usd) / gdp_usd * 100. Compare with exposure_pct_gdp, allowing for rounding. Do the numbers in your briefing agree? Two calculations you can reproduce from the CSV. Correct the briefing if a figure does not match.
Advanced: how the data was pulled
The UN Comtrade public preview API needs no key. This example requests imports from Russia for crude oil in 2023:
https://comtradeapi.un.org/public/v1/preview/C/A/HS?partnerCode=643&period=2023&cmdCode=2709&flowCode=MRepeat for each supplier, year and product. Where an importer has no report, use the supplier’s export report and record the mirror year. The preview returns about 500 rows per call; split a query if it reaches that cap. The free preview has an hourly quota, so pull once and save.