Datasets / Curated (shared with askfelix)

Hormuz shipping crisis

Daily transits, oil and LNG flows, insurance and carrier status through a strait closure, with the key events annotated.

Ask a question of it Download CSV Jupyter notebook

125 rows26 columns Curated (shared with askfelix)

Worked examples

Each of these is a real run: the pipeline picked the columns, shaped the rows and chose the form. Open the trace to see what it decided and why.

Daily transits through the strait, pre-war to crisis

Transits run flat until the closure, then step down and stay down: the period_type column marks the day the regime changes.

line chart of daily ship transits with the closure marked — 125 rows charted from 125, drawn as a line

Ask this yourself See the working

How it decided

Finding the data110 ms

Hormuz shipping crisis: 125 rows, 26 columns. date, period_type and daily_ship_transits.

Shaping the data11 ms

125 rows in, 125 out across 3 columns. Transits run flat until the closure, then step down and stay down: the period_type column marks the day the regime changes.

Choosing the chart19 ms

line. A daily series with a step change reads best as a line; the period split names the two regimes instead of a guessed annotation.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

Schema

26 columns, typed as the pipeline sees them — which is how it knows what can go on a time axis and what can be summed.

Column	Type	Example
date	text	2026-01-01
period_type	text	pre_war
days_since_closure	number	0
daily_ship_transits	number	103
monthly_vessel_count	number	3000
monthly_count_is_exact	boolean	False
transit_pct_of_prewar_avg	number	100.0
oil_throughput_mbpd	number	19.7
lng_throughput_bcfd	number	10.3
brent_crude_usd_bbl	number	75.29
wti_crude_usd_bbl	number	72.06
vessels_attacked_cumulative	number	0
new_attacks_today	number	0
attack_type	text	none
vessels_stranded_in_gulf	number	0
maersk_status	text	operating
cma_cgm_status	text	operating
hapag_lloyd_status	text	operating
cosco_status	text	operating
msc_status	text	operating
iran_approved_flags	text	all
war_risk_insurance_pct	number	0.125
cape_reroute_extra_days	number	0
diesel_usd_gallon_us	number	3.27
key_event	text	Normal operations
source_citation	text	EIA; IEA; Lloyd's List

First 8 rows

date	period_type	daily_ship_transits	monthly_vessel_count	monthly_count_is_exact	transit_pct_of_prewar_avg	oil_throughput_mbpd	lng_throughput_bcfd	brent_crude_usd_bbl	wti_crude_usd_bbl	attack_type	maersk_status	cma_cgm_status	hapag_lloyd_status	cosco_status	msc_status	iran_approved_flags	war_risk_insurance_pct	diesel_usd_gallon_us	key_event	source_citation
2026-01-01	pre_war	103	3000	False	100.0	19.7	10.3	75.29	72.06	none	operating	operating	operating	operating	operating	all	0.125	3.27	Normal operations	EIA; IEA; Lloyd's List
2026-01-02	pre_war	108	3000	False	100.0	19.5	10.3	75.75	72.06	none	operating	operating	operating	operating	operating	all	0.125	3.28	Normal operations	EIA; IEA; Lloyd's List
2026-01-03	pre_war	108	3000	False	100.0	19.7	10.6	75.97	72.27	none	operating	operating	operating	operating	operating	all	0.125	3.37	Normal operations	EIA; IEA; Lloyd's List
2026-01-04	pre_war	108	3000	False	100.0	19.8	10.3	75.18	71.26	none	operating	operating	operating	operating	operating	all	0.125	3.39	Normal operations	EIA; IEA; Lloyd's List
2026-01-05	pre_war	98	3000	False	100.0	19.9	10.4	74.95	71.67	none	operating	operating	operating	operating	operating	all	0.125	3.29	Normal operations	EIA; IEA; Lloyd's List
2026-01-06	pre_war	98	3000	False	100.0	20.5	10.4	74.22	70.61	none	operating	operating	operating	operating	operating	all	0.125	3.33	Normal operations	EIA; IEA; Lloyd's List
2026-01-07	pre_war	106	3000	False	100.0	20.1	10.6	74.83	71.07	none	operating	operating	operating	operating	operating	all	0.125	3.26	Normal operations	EIA; IEA; Lloyd's List
2026-01-08	pre_war	97	3000	False	100.0	20.4	10.7	74.42	70.96	none	operating	operating	operating	operating	operating	all	0.125	3.31	Normal operations	EIA; IEA; Lloyd's List

Ask it something else

line chart of daily ship transits with the closure marked scatter Brent crude vs transit share of pre-war average area chart of cumulative vessels attacked over the timeline which carriers kept operating during the crisis?

Start free