SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-10T16:36:01.286819+00:00","dedupe_key":"signal_enriched:news_delta:7849c691a76ab338","evidence_event_ids":["evt_ad77a080d50a"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9heDlXZDMtdlU4elQyNTc0anhzdEY1UXdVVU4yMDNaclJJS1lwellqWW5SbVR4R1QyY2kwck50TXF2TE5DVEM1NVd3RkVHTjVWakxab0tHTUVVZw?oc=5","as_of":"2026-04-10T16:36:01.286819+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/CBMiWkFVX3lxTE9heDlXZDMtdlU4elQyNTc0anhzdEY1UXdVVU4yMDNaclJJS1lwellqWW5SbVR4R1QyY2kwck50TXF2TE5DVEM1NVd3RkVHTjVWakxab0tHTUVVZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5d3cdbc8fd1c5c1a","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:15:37.532969+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9heDlXZDMtdlU4elQyNTc0anhzdEY1UXdVVU4yMDNaclJJS1lwellqWW5SbVR4R1QyY2kwck50TXF2TE5DVEM1NVd3RkVHTjVWakxab0tHTUVVZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9heDlXZDMtdlU4elQyNTc0anhzdEY1UXdVVU4yMDNaclJJS1lwellqWW5SbVR4R1QyY2kwck50TXF2TE5DVEM1NVd3RkVHTjVWakxab0tHTUVVZw?oc=5","source_event_id":"evt_ad77a080d50a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"94b4af99cf4adcea","published_at":"2026-04-10T15:12:57+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"industry","name":"European airline industry","relevance":"high","symbol":"","type":"industry"},{"asset_class":"infrastructure","name":"European airports","relevance":"high","symbol":"","type":"infrastructure"},{"asset_class":"geopolitical_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic chokepoint"},{"asset_class":"industry","name":"EU airlines","relevance":"high","symbol":"","type":"industry_region"},{"asset_class":"media","name":"BBC","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided is not usable for extracting additional details beyond the headline and the provided source summary.","No specific airports, airlines, or quantitative shortage volumes are stated in the provided material.","The probability of the shortage and the exact conditions under which the Strait of Hormuz closure would translate into EU fuel shortages are not specified.","The timeline is described as a warning/estimate; the exact date of the estimate relative to publication is not provided."],"key_facts":["BBC headline states EU airline industry fears fuel shortages if the Strait of Hormuz stays closed.","BBC source summary indicates airports could face a jet fuel crunch within about 3 weeks.","The reported mechanism is that airlines are weighing flight cancellations due to the potential fuel shortage risk."],"numeric_claims":[{"label":"time_to_shortage","value":"within ~3 weeks"}],"primary_claim":"If the Strait of Hormuz stays closed, European airports could face jet fuel shortages within roughly three weeks, leading airlines to weigh flight cancellations.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"BBC reports that EU airlines and European airports fear jet fuel shortages if the Strait of Hormuz remains closed. The risk is described as potentially materializing within about three weeks, prompting airlines to consider flight cancellations.","topics":["jet fuel","fuel supply","Strait of Hormuz closure","European aviation","flight cancellations","fuel logistics"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"EU airline industry fears fuel shortages if Strait of Hormuz stays closed BBC Airports could face a jet fuel crunch within 3 weeks as airlines weigh flight cancellations CNBC European airports face jet fuel shortages within three weeks Financial Times Europe could face jet fuel crunch within weeks, airports body warns Reuters European airports \u2018face jet fuel shortages within three weeks\u2019; Irish army called in over fuel protests - business live The Guardian","title":"EU airline industry fears fuel shortages if Strait of Hormuz stays closed - BBC","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 18430 in events