SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOWVJuSFdKOXVVQm9jdk9RanF3NlMwVWhlZGhTeXV0dVlDVkhKZ0VGMDNWVEEwNDNWUkx5QnNUeGgtcjhkV01GSmhfSDhreWVWbjUwZHE5MG5VYm5SRmdZOVpORVc4czFEWGVyM2FDeU5icWVpYXpCSUFTOFRKMUJPRGIyclY?oc=5","as_of":"2026-04-10T17:15:06.249813+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOWVJuSFdKOXVVQm9jdk9RanF3NlMwVWhlZGhTeXV0dVlDVkhKZ0VGMDNWVEEwNDNWUkx5QnNUeGgtcjhkV01GSmhfSDhreWVWbjUwZHE5MG5VYm5SRmdZOVpORVc4czFEWGVyM2FDeU5icWVpYXpCSUFTOFRKMUJPRGIyclY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2e34ef141b1073bd","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T17:18:26.402539+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOWVJuSFdKOXVVQm9jdk9RanF3NlMwVWhlZGhTeXV0dVlDVkhKZ0VGMDNWVEEwNDNWUkx5QnNUeGgtcjhkV01GSmhfSDhreWVWbjUwZHE5MG5VYm5SRmdZOVpORVc4czFEWGVyM2FDeU5icWVpYXpCSUFTOFRKMUJPRGIyclY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOWVJuSFdKOXVVQm9jdk9RanF3NlMwVWhlZGhTeXV0dVlDVkhKZ0VGMDNWVEEwNDNWUkx5QnNUeGgtcjhkV01GSmhfSDhreWVWbjUwZHE5MG5VYm5SRmdZOVpORVc4czFEWGVyM2FDeU5icWVpYXpCSUFTOFRKMUJPRGIyclY?oc=5","source_event_id":"evt_96cfcd47cf74","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7d443fad8e8ed6d9","published_at":"2026-04-10T09:46:40+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"infrastructure","name":"European airports","relevance":"directly affected","symbol":"","type":"location/sector"},{"asset_class":"commodity","name":"Jet fuel","relevance":"subject of shortage","symbol":"","type":"commodity"},{"asset_class":"industry","name":"European airline industry","relevance":"likely impacted downstream","symbol":"","type":"sector"},{"asset_class":"geopolitical_risk","name":"Strait of Hormuz","relevance":"implied driver of supply risk (from provided multi-source summary)","symbol":"","type":"geopolitical chokepoint"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling; only the headline and the user-provided source summary are usable for extraction.","No specific countries/airports, shortage magnitude, or which fuel supply chain segment (refining, shipping, storage) is identified in the provided text.","The causal link to the Strait of Hormuz closure is only present in the user\u2019s multi-source summary, not in the Financial Times headline itself; confirmation is uncertain."],"key_facts":["Financial Times headline states European airports face jet fuel shortages within three weeks.","The signal implies a near-term catalyst window of roughly three weeks.","The provided source summary mentions EU airline industry fears if the Strait of Hormuz stays closed (driver not fully confirmed in the cleaned article text)."],"numeric_claims":[{"label":"time_to_shortage","value":"within three weeks"}],"primary_claim":"European airports could face jet fuel shortages within three weeks, according to the Financial Times.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Financial Times reports that European airports may face jet fuel shortages within about three weeks. The risk is tied to ongoing geopolitical supply concerns affecting fuel availability and could pressure airline operations and flight schedules near-term.","topics":["jet fuel shortages","aviation fuel supply","European airports","airline operations","geopolitical risk","Strait of Hormuz"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"European airports face jet fuel shortages within three weeks Financial Times European airports could face jet fuel shortages within three weeks The Guardian EU airline industry fears fuel shortages if Strait of Hormuz stays closed BBC How to save money on flights as airlines raise prices CNBC NASA Reveals What Happens When Its Space Toilet Doesn't Work The Daily Beast","title":"European airports face jet fuel shortages within three weeks - Financial Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_9d7cb1c59145 in signals