Helix the Robot
Helix AI data analyst
Helix
arrow_backAll datasets

Hormuz Shipping Crisis

Sample

Synthetic Hormuz shipping crisis dataset with vessel transits, energy throughput, prices, attacks, insurance premiums, and reroute impacts.

descriptionhormuz-shipping-crisis.csv view_list125 rows
boltOpen in Helix

Ask a question about this data

Type any question in plain English — Helix builds the chart with AI. Sign in to run it and save your charts.

auto_awesome
line chart of daily ship transits with annotation at strait closure scatter Brent crude vs transit pct of pre-war colored by period_type grouped bar comparing pre_war vs war_crisis averages for transits oil and war risk insurance stacked area chart of oil and LNG throughput over time

Data preview

125 rows · 26 columns · showing first 12
# date text period_type text days_since_closure integer daily_ship_transits integer monthly_vessel_count integer monthly_count_is_exact boolean transit_pct_of_prewar_avg float oil_throughput_mbpd float lng_throughput_bcfd float brent_crude_usd_bbl float wti_crude_usd_bbl float vessels_attacked_cumulative integer new_attacks_today integer attack_type text vessels_stranded_in_gulf integer maersk_status text cma_cgm_status text hapag_lloyd_status text cosco_status text msc_status text iran_approved_flags text war_risk_insurance_pct float cape_reroute_extra_days integer diesel_usd_gallon_us float key_event text source_citation text
1 2026-01-01pre_war01033000False10019.710.375.2972.0600none0operatingoperatingoperatingoperatingoperatingall0.12503.27Normal operationsEIA; IEA; Lloyd's List
2 2026-01-02pre_war01083000False10019.510.375.7572.0600none0operatingoperatingoperatingoperatingoperatingall0.12503.28Normal operationsEIA; IEA; Lloyd's List
3 2026-01-03pre_war01083000False10019.710.675.9772.2700none0operatingoperatingoperatingoperatingoperatingall0.12503.37Normal operationsEIA; IEA; Lloyd's List
4 2026-01-04pre_war01083000False10019.810.375.1871.2600none0operatingoperatingoperatingoperatingoperatingall0.12503.39Normal operationsEIA; IEA; Lloyd's List
5 2026-01-05pre_war0983000False10019.910.474.9571.6700none0operatingoperatingoperatingoperatingoperatingall0.12503.29Normal operationsEIA; IEA; Lloyd's List
6 2026-01-06pre_war0983000False10020.510.474.2270.6100none0operatingoperatingoperatingoperatingoperatingall0.12503.33Normal operationsEIA; IEA; Lloyd's List
7 2026-01-07pre_war01063000False10020.110.674.8371.0700none0operatingoperatingoperatingoperatingoperatingall0.12503.26Normal operationsEIA; IEA; Lloyd's List
8 2026-01-08pre_war0973000False10020.410.774.4270.9600none0operatingoperatingoperatingoperatingoperatingall0.12503.31Normal operationsEIA; IEA; Lloyd's List
9 2026-01-09pre_war01003000False10019.910.374.3970.4400none0operatingoperatingoperatingoperatingoperatingall0.12503.29Normal operationsEIA; IEA; Lloyd's List
10 2026-01-10pre_war01003000False1002010.375.1871.400none0operatingoperatingoperatingoperatingoperatingall0.12503.32Normal operationsEIA; IEA; Lloyd's List
11 2026-01-11pre_war01023000False10020.210.774.8470.8100none0operatingoperatingoperatingoperatingoperatingall0.12503.37Normal operationsEIA; IEA; Lloyd's List
12 2026-01-12pre_war01053000False10019.910.274.4371.200none0operatingoperatingoperatingoperatingoperatingall0.12503.39Normal operationsEIA; IEA; Lloyd's List

What happened

Daily tracking from Jan-May 2026: pre-war Hormuz traffic (~105 transits/day), the Feb 28 closure after US-Israel strikes, carrier Cape reroutes, insurance spikes, and selective reopening for approved flags.

Date range2026-01-01 to 2026-05-05
Closure2026-02-28
Transits pre-war102.7/day
Transits crisis5.8/day
Peak Brent$104.0
Max war risk4.19%
Cape penalty+14 days
Vessels attacked25

Key events from the data

  1. Insurance premiums rising Brent $72.5 · 101 transits
  2. US-Israel strikes Iran Brent $86.0 · 50 transits
  3. No tankers broadcast AIS signals in strait Brent $89.0 · 0 transits
  4. IRGC officially closes strait to 'unfriendly nations' Brent $91.5 · 0 transits
  5. Strait remains largely closed Brent $92.42 · 1 transits
  6. IRGC claims 'complete control' of strait Brent $93.0 · 2 transits
  7. LPG tanker Bogazici transits broadcasting Muslim/Turkish ownership Brent $92.5 · 3 transits
  8. Tugboat assisting Safeen Prestige struck by 2 missiles, sinks Brent $94.0 · 2 transits
  9. IRGC hits oil tanker Prima and US tanker Louis P with drones in Persian… Brent $95.2 · 2 transits
  10. US intelligence: Iran begins planting naval mines Brent $96.0 · 3 transits
  11. Large wave of attacks: Thai bulk carrier Mayuree Naree struck, smoke vi… Brent $97.5 · 4 transits
  12. Trump says US Navy will escort oil tankers through strait Brent $99.0 · 5 transits
  13. CENTCOM deploys A-10s and AH-64 Apaches Brent $100.5 · 6 transits
  14. Iran FM: Hormuz open to China, Russia, India, Iraq, Pakistan, Malaysia,… Brent $101.0 · 8 transits
  15. Iran allows UN humanitarian and fertilizer shipments through strait Brent $100.0 · 7 transits
  16. Container ship Express Rome reports 2 projectiles nearby NE of Ras Tanu… Brent $101.5 · 6 transits
  17. Kuwaiti VLCC Al Salmi struck by Iranian drone at Port of Dubai at full… Brent $102.0 · 5 transits
  18. QatarEnergy tanker Aqua 1 hit by 2 projectiles north of Doha Brent $103.0 · 6 transits
  19. Iran grants Philippine-flagged vessels access Brent $102.5 · 5 transits
  20. IRGC attacks MSC Ishyka container ship with drone in strait, claims Isr… Brent $103.5 · 5 transits
  21. Russia and China veto UN Security Council resolution authorizing force… Brent $101.0 · 6 transits
  22. Ceasefire declared US-Iran Brent $97.0 · 8 transits
  23. IRGC re-halts traffic citing Israeli ceasefire violation in Lebanon Brent $98.0 · 8 transits
  24. JD Vance: US-Iran talks failed Brent $99.0 · 8 transits
  25. US naval blockade of Iranian ports takes effect 10am ET Brent $100.5 · 5 transits
  26. 22 total ships attacked since war start: 8 in UAE waters, 6 Omani, 2 Ir… Brent $101.5 · 4 transits
  27. Iran re-closes strait Brent $103.0 · 3 transits
  28. Iranian gunboat attacks Greek cargo ship Epaminondas off Oman with RPGs… Brent $104.0 · 4 transits
  29. Trump orders US Navy to destroy Iranian mine-laying boats in Hormuz Brent $103.5 · 4 transits
  30. Russian superyacht Nord (Alexey Mordashov) exits Gulf without incident Brent $103.0 · 5 transits
  31. April total: 191 vessels crossed entire month vs ~3000 pre-war (Kpler) Brent $102.5 · 6 transits
  32. HMM Panama-flagged ship explosion near UAE Brent $101.5 · 7 transits
  33. Trump announces 'Operation Project Freedom' to escort neutral ships out… Brent $100.5 · 8 transits
  34. 2 US-flagged merchant ships successfully transit strait under US Navy e… Brent $100.0 · 9 transits
  35. Polymarket: 99.9% probability Hormuz will NOT return to normal (60+ shi… Brent $99.5 · 8 transits

Charts

Daily ship transits through Hormuz

Pre-war baseline ~105/day; transits collapsed to near-zero after the Feb 28 closure.

Brent crude vs transit disruption

Scatter view: prices climbed as strait traffic fell during the crisis.

Pre-war vs crisis averages

Grouped bars comparing mean daily transits, oil flow, and war-risk insurance.

Oil & LNG throughput

Energy flows through the strait — both collapsed as carriers rerouted via the Cape.

War risk insurance & diesel prices

Insurance premiums spiked while US Gulf Coast diesel rose with crude.

Cumulative vessel attacks

Running attack count climbed through March-April as transit remained minimal.

Attack types during the crisis

Horizontal bar of non-zero attack_type counts across war_crisis days.

Cape reroute penalty & stranded vessels

Extra transit days jumped to ~14 while hundreds of vessels remained stranded in the Gulf.

Interesting queries to try

Columns

  • date date Observation date
  • period_type categorical pre_war or war_crisis
  • daily_ship_transits int Vessels transiting the strait per day
  • transit_pct_of_prewar_avg float Transit volume as % of pre-war baseline
  • oil_throughput_mbpd float Oil throughput (million barrels per day)
  • lng_throughput_bcfd float LNG throughput (billion cubic feet per day)
  • brent_crude_usd_bbl float Brent crude spot price USD/bbl
  • vessels_attacked_cumulative int Running total of attacked vessels
  • vessels_stranded_in_gulf int Vessels stranded in the Persian Gulf
  • war_risk_insurance_pct float War risk insurance premium %
  • cape_reroute_extra_days int Extra transit days via Cape reroute
  • key_event text Notable daily event annotation

Related datasets

Login to Helix

Don't have an account? Sign up here

Sign Up for Helix

Already have an account? Login here