62.9 kB across 1 part, newest sealed 16 November 2026 at 09:54 UTC.
The check passed.
One row per date area passed.
date
date
UTC date of the satellite pass.
2025-10-012026-10-01
per quarter
Valid
548 · 100%
Missing
0 · 0%
Distinct
244 · 44.5% of valid
aoi
string
Area code: hormuz_strait (transit lanes), fujairah (anchorage), gulf_of_oman (approach) or ras_tanura (anchorage).
hormuz_strait28%
ras_tanura27%
fujairah22%
Valid
548 · 100%
Missing
0 · 0%
Distinct
4 · 0.7% of valid
aoi_name
string
Area name.
Strait of Hormuz transit box (Musandam narrows, both lanes)28%
Ras Tanura / Ju'aymah anchorage27%
Fujairah / Khor Fakkan anchorage22%
Valid
548 · 100%
Missing
0 · 0%
Distinct
4 · 0.7% of valid
month
string
Month and year of the date in words, such as March 2026.
May 202610%
December 20259%
June 20269%
Other (1)
Valid
548 · 100%
Missing
0 · 0%
Distinct
13 · 2.4% of valid
summary
string
The row in one plain sentence: area, date, ship counts, ships waiting, level against normal, strait traffic state, oil price and PortWatch count.
548 distinct values, no chart
Valid
548 · 100%
Missing
0 · 0%
Distinct
548 · 100% of valid
n_ships
integer
Ships counted in the area at the pass instant: detector score at least 0.7, on water, not within 100 m of known marine infrastructure.
0374
Valid
548 · 100%
Missing
0 · 0%
Distinct
177 · 32.3% of valid
Min
0
25%
29
Median
64
75%
91
Max
374
n_ships_ge100m
integer
Counted ships with estimated length of 100 m or more.
0282
Valid
548 · 100%
Missing
0 · 0%
Distinct
126 · 23% of valid
Min
0
25%
7
Median
17
75%
41
Max
282
n_ships_lt100m
integer
Counted ships with estimated length under 100 m. Less reliable than the large-ship count.
0102
Valid
548 · 100%
Missing
0 · 0%
Distinct
93 · 17% of valid
Min
0
25%
9
Median
39
75%
67
Max
102
n_tanker_ge100m
integer
Counted ships labelled tanker with estimated length of 100 m or more.
0177
Valid
548 · 100%
Missing
0 · 0%
Distinct
106 · 19.3% of valid
Min
0
25%
2
Median
8
75%
27
Max
177
n_cargo_ge100m
integer
Counted ships labelled cargo with estimated length of 100 m or more.
0142
Valid
548 · 100%
Missing
0 · 0%
Distinct
94 · 17.2% of valid
Min
0
25%
3
Median
8
75%
17
Max
142
n_moving_ge100m
integer
Counted ships of 100 m or more with estimated speed of 2 knots or more.
048
Valid
548 · 100%
Missing
0 · 0%
Distinct
31 · 5.7% of valid
Min
0
25%
1
Median
3
75%
8
Max
48
n_stationary_ge100m
integer
Counted ships of 100 m or more with estimated speed under 2 knots, such as ships at anchor.
0272
Valid
548 · 100%
Missing
0 · 0%
Distinct
117 · 21.4% of valid
Min
0
25%
3
Median
12
75%
33
Max
272
n_inbound_ge100m
integer
Moving ships of 100 m or more heading west into the Gulf, by estimated heading. Strait of Hormuz area only.
020
Valid
152 · 27.7%
Missing
396 · 72.3%
Missing over time
Distinct
18 · 11.8% of valid
Min
0
25%
0
Median
1
75%
6
Max
20
n_outbound_ge100m
integer
Moving ships of 100 m or more heading east out of the Gulf, by estimated heading. Strait of Hormuz area only.
016
Valid
152 · 27.7%
Missing
396 · 72.3%
Missing over time
Distinct
15 · 9.9% of valid
Min
0
25%
0
Median
1
75%
5
Max
16
n_vlcc
integer
Tankers with estimated length of 300 m or more, the very large crude carrier class.
050
Valid
548 · 100%
Missing
0 · 0%
Distinct
43 · 7.8% of valid
Min
0
25%
0
Median
1
75%
6
Max
50
n_suezmax
integer
Tankers with estimated length from 260 m to under 300 m.
023
Valid
548 · 100%
Missing
0 · 0%
Distinct
21 · 3.8% of valid
Min
0
25%
0
Median
0
75%
2
Max
23
n_aframax
integer
Tankers with estimated length from 235 m to under 260 m.
024
Valid
548 · 100%
Missing
0 · 0%
Distinct
21 · 3.8% of valid
Min
0
25%
0
Median
1
75%
3
Max
24
tanker_capacity_mbbl_est
decimal
Rough carrying capacity of the tankers of 100 m or more present, in million barrels, from a typical capacity per size class. Capacity of the ships, not cargo on board.
0.0158.3
Valid
548 · 100%
Missing
0 · 0%
Distinct
253 · 46.2% of valid
Min
0.0
25%
1.6
Median
5.4
75%
19.4
Max
158.3
n_waiting_7d
integer
Stationary ships of 100 m or more seen at the same spot for 7 days or longer, by matching positions across passes.
0116
Valid
548 · 100%
Missing
0 · 0%
Distinct
80 · 14.6% of valid
Min
0
25%
0
Median
3
75%
12
Max
116
n_waiting_30d
integer
Stationary ships of 100 m or more seen at the same spot for 30 days or longer. Undercounted before 10 December 2025 because tracking starts on 10 November 2025.
031
Valid
548 · 100%
Missing
0 · 0%
Distinct
29 · 5.3% of valid
Min
0
25%
0
Median
0
75%
3
Max
31
median_days_at_anchor
decimal
Median days the stationary ships of 100 m or more have been seen at their spot.
0.091.5
Valid
508 · 92.7%
Missing
40 · 7.3%
Missing over time
Distinct
63 · 12.4% of valid
Min
0.0
25%
0.0
Median
2.5
75%
6.0
Max
91.5
n_ships_ge100m_avg5
decimal
Mean of n_ships_ge100m over this and the four previous passes of the area.
0.2271.2
Valid
548 · 100%
Missing
0 · 0%
Distinct
275 · 50.2% of valid
Min
0.2
25%
7.0
Median
17.8
75%
39.4
Max
271.2
baseline_n_ships_ge100m
decimal
Median n_ships_ge100m of the area from 2025-11-10 to 2026-01-09, the fixed baseline.
11.0151.0
Valid
548 · 100%
Missing
0 · 0%
Distinct
4 · 0.7% of valid
Min
11.0
25%
11.0
Median
19.0
75%
37.0
Max
151.0
pct_of_baseline
integer
n_ships_ge100m_avg5 as a percent of the baseline.
1180
Valid
548 · 100%
Missing
0 · 0%
Distinct
146 · 26.6% of valid
Min
1
25%
50
Median
88
75%
104
Max
180
level_vs_baseline
string
far_below (under 50 percent of baseline), below (50 to 80), normal (80 to 125), above (125 to 200) or far_above.
normal45%
far_below25%
below18%
Valid
548 · 100%
Missing
0 · 0%
Distinct
4 · 0.7% of valid
strait_regime
string
State of Strait of Hormuz transit traffic on the date, the same for every area: normal (five-pass average of large ships at 80 percent of baseline or more), reduced (40 to 80) or disrupted (under 40).
disrupted67%
normal31%
reduced2%
Valid
548 · 100%
Missing
0 · 0%
Distinct
3 · 0.5% of valid
change_vs_previous_pass
integer
n_ships_ge100m minus its value at the area's previous pass.
-4136
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
51 · 9.4% of valid
Min
-41
25%
-3
Median
0
75%
3
Max
36
days_since_previous_pass
integer
Days since the area's previous pass.
19
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
7 · 1.3% of valid
Min
1
25%
2
Median
3
75%
3
Max
9
brent_usd
decimal
Latest Europe Brent spot close on or before the date, US dollars per barrel.
59.93135.51
Valid
548 · 100%
Missing
0 · 0%
Distinct
186 · 33.9% of valid
Min
59.93
25%
69.96
Median
92.84
75%
111.86
Max
135.51
brent_date
date
Date of that Brent close.
2025-10-012026-10-01
per quarter
Valid
548 · 100%
Missing
0 · 0%
Distinct
187 · 34.1% of valid
portwatch_transits
integer
IMF PortWatch count of ships transiting the Strait of Hormuz on the date, from ship transponder data. Empty for the latest days PortWatch has not published.
0127
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
65 · 11.9% of valid
Min
0
25%
4
Median
7
75%
50
Max
127
portwatch_tanker_transits
integer
IMF PortWatch count of tankers transiting the Strait of Hormuz on the date.
069
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
48 · 8.8% of valid
Min
0
25%
1
Median
2
75%
26
Max
69
portwatch_transits_7d_avg
decimal
Seven-day average of PortWatch daily transits ending on the date.
1.3105.0
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
122 · 22.4% of valid
Min
1.3
25%
4.0
Median
5.3
75%
54.1
Max
105.0
portwatch_pct_of_baseline
integer
PortWatch seven-day average as a percent of its median from 10 November 2025 to 9 January 2026.
2178
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
69 · 12.7% of valid
Min
2
25%
7
Median
9
75%
92
Max
178
satellite_vs_portwatch_delta
integer
Satellite level minus PortWatch level, in percentage points of each one's own baseline. The satellite level is the strait's five-pass average of large ships. Positive means the satellite sees more traffic than PortWatch reports.
-3562
Valid
544 · 99.3%
Missing
4 · 0.7%
Missing over time
Distinct
57 · 10.5% of valid
Min
-35
25%
-5
Median
4
75%
10
Max
62
portwatch_available
boolean
True when PortWatch has published a transit count for the date.
true99%
false1%
Valid
548 · 100%
Missing
0 · 0%
Distinct
2 · 0.4% of valid
portwatch_port_calls
integer
IMF PortWatch count of ships calling at the port on the date: Fujairah for the fujairah area, Ras Tanura for the ras_tanura area. Empty for the other areas.
016
Valid
271 · 49.5%
Missing
277 · 50.5%
Missing over time
Distinct
17 · 6.3% of valid
Min
0
25%
1
Median
2
75%
6
Max
16
portwatch_tanker_port_calls
integer
IMF PortWatch count of tankers calling at the port on the date, for the fujairah and ras_tanura areas.
015
Valid
271 · 49.5%
Missing
277 · 50.5%
Missing over time
Distinct
16 · 5.9% of valid
Min
0
25%
0
Median
1
75%
4
Max
15
portwatch_week_transit_calls
integer
IMF PortWatch transit calls through the Strait of Hormuz for the Monday to Sunday week containing the date, as recorded at settlement of Kalshi's weekly market. Null before September 2026 and until the week settles, about ten days late.
1931
Valid
74 · 13.5%
Missing
474 · 86.5%
Missing over time
Distinct
7 · 9.5% of valid
Min
19
25%
22
Median
23
75%
27
Max
31
portwatch_week_end
date
Sunday ending the week the PortWatch count covers.
2026-09-142026-11-02
per week
Valid
74 · 13.5%
Missing
474 · 86.5%
Missing over time
Distinct
8 · 10.8% of valid
kalshi_event_ticker
string
Kalshi event ticker of the KXHORMUZWEEKLY week (Monday to Sunday) that contains the date. Empty when the date is in no Kalshi week, or when no Kalshi trade happened before the pass time. All Kalshi columns are empty together in those cases.
KXHORMUZWEEKLY-26AUG235%
KXHORMUZWEEKLY-26SEP135%
KXHORMUZWEEKLY-26AUG025%
Other (17)
Valid
258 · 47.1%
Missing
290 · 52.9%
Missing over time
Distinct
29 · 11.2% of valid
kalshi_week_end
date
Sunday ending that Kalshi week.
2026-04-012026-11-01
per month
Valid
258 · 47.1%
Missing
290 · 52.9%
Missing over time
Distinct
29 · 11.2% of valid
kalshi_implied_expected_transits
decimal
Expected weekly IMF PortWatch transit calls implied by the week's Kalshi prices. Uses, for each strike, the last traded Yes price in an hourly candle that ended before pass_time_utc; strikes not yet traded by then are left out, and at least two priced strikes are needed. Yes prices are read as the chance the week ends above each strike. Where a higher strike is priced above a lower one, prices are made non-increasing by averaging the running minimum from the lowest strike upward with the running maximum from the highest strike downward. The chance between two neighbouring strikes is placed at the middle of the whole numbers between them, the chance at or below the lowest strike at half the lowest strike, and the chance above the highest strike at the middle of one more band as wide as the last gap between strikes.
21.3217.5
Valid
258 · 47.1%
Missing
290 · 52.9%
Missing over time
Distinct
123 · 47.7% of valid
Min
21.3
25%
26.2
Median
33.5
75%
49.7
Max
217.5
kalshi_strikes_priced
integer
Number of strikes of the week with a traded price before the pass time, the strikes kalshi_implied_expected_transits is computed from.
514
Valid
258 · 47.1%
Missing
290 · 52.9%
Missing over time
Distinct
9 · 3.5% of valid
Min
5
25%
10
Median
11
75%
12
Max
14
kalshi_reference_transit_calls
integer
Weekly IMF PortWatch transit calls of the latest Kalshi week settled before the pass time, as a number. Weeks Kalshi settled only with a bracket, such as Above 35, are skipped. kalshi_nearest_strike is measured from this count.
15228
Valid
252 · 46%
Missing
296 · 54%
Missing over time
Distinct
21 · 8.3% of valid
Min
15
25%
23
Median
30
75%
42
Max
228
kalshi_nearest_strike
integer
Strike of the week, among strikes with a traded price before the pass time, closest to kalshi_reference_transit_calls. A tie goes to the lower strike.
15225
Valid
252 · 46%
Missing
296 · 54%
Missing over time
Distinct
14 · 5.6% of valid
Min
15
25%
23
Median
30
75%
40
Max
225
kalshi_nearest_strike_yes_price
decimal
Last traded Yes price of the nearest-strike market in an hourly candle that ended before the pass time, US dollars from 0 to 1, as traded and not adjusted.
0.01000.9700
Valid
252 · 46%
Missing
296 · 54%
Missing over time
Distinct
78 · 31% of valid
Min
0.0100
25%
0.1600
Median
0.3900
75%
0.7200
Max
0.9700
kalshi_market_ticker
string
Kalshi market ticker of the nearest strike; joins to kalshi_hormuz_price_history and kalshi_hormuz_weekly_markets.
KXHORMUZWEEKLY-26SEP13-T305%
KXHORMUZWEEKLY-26AUG02-T705%
KXHORMUZWEEKLY-26MAY24-T155%
Other (29)
Valid
252 · 46%
Missing
296 · 54%
Missing over time
Distinct
41 · 16.3% of valid
kalshi_price_as_of_utc
timestamp_utc
End of the latest hourly Kalshi candle used on the row, UTC. Always before pass_time_utc.
2026-04-012026-11-01
per month
Valid
258 · 47.1%
Missing
290 · 52.9%
Missing over time
Distinct
157 · 60.9% of valid
pass_time_utc
timestamp_utc
When the satellite imaged the area, UTC. Counts are a snapshot at this instant, not a daily total.
2025-10-012026-10-01
per quarter
Valid
548 · 100%
Missing
0 · 0%
Distinct
459 · 83.8% of valid
n_passes
integer
Passes over the area that day; the row uses the one with the best coverage.
12
Valid
548 · 100%
Missing
0 · 0%
Distinct
2 · 0.4% of valid
Min
1
25%
1
Median
1
75%
1
Max
2
coverage_pct
decimal
Share of the area's water the pass imaged, percent.
81.9100.0
Valid
548 · 100%
Missing
0 · 0%
Distinct
22 · 4% of valid
Min
81.9
25%
100.0
Median
100.0
75%
100.0
Max
100.0
platform
string
Satellite of the pass.
sentinel-1c41%
sentinel-1a33%
sentinel-1d26%
Valid
548 · 100%
Missing
0 · 0%
Distinct
3 · 0.5% of valid
scene_key
string
Pass key; joins to ship_counts_by_pass and ship_detections.
548 distinct values, no chart
Valid
548 · 100%
Missing
0 · 0%
Distinct
548 · 100% of valid
qa_image_url
string
Radar quicklook of the pass with counted ships circled.
548 distinct values, no chart
Valid
548 · 100%
Missing
0 · 0%
Distinct
548 · 100% of valid
Table profile
Profile of the served version, all rows, computed 16 Nov 2026, 10:07 UTC
Warning
Freshness
Latest event 7 d before this version
Warning
Gaps
121 empty days, 11 Nov, 14 Nov, 17 Nov and 112 more
Warning
Anomalies
Gap on 11 Nov, 0 rows against about 1, and 49 more
Passed
Unique keys
Every date · aoi is unique
Passed
Change since last profile
No change, 548 rows, 4 columns with a new distinct count