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/CBMisAFBVV95cUxPTjZNMWppMUFhTjBqSWI5RGtTcEhXd2hfSFQtT0Z1VFRqRm5zS1NtalN5T1BSVjBkdnRaRTV0ZlNxazFpVG5YRzJKa1VFUmgxSHo1QXJWbDlidkZYa24tZE9UVEFycG94YzRJTnBGZDdSay1vRnR3WVpQcTFfTXdKYTRVZU5hRWVMUWFPc3N1QUpDNmF3YzhMWDBQSlJlQXVmcFg5R0p3X2hSRXNaZTJtdw?oc=5","as_of":"2026-04-10T18:06:52.254629+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/CBMisAFBVV95cUxPTjZNMWppMUFhTjBqSWI5RGtTcEhXd2hfSFQtT0Z1VFRqRm5zS1NtalN5T1BSVjBkdnRaRTV0ZlNxazFpVG5YRzJKa1VFUmgxSHo1QXJWbDlidkZYa24tZE9UVEFycG94YzRJTnBGZDdSay1vRnR3WVpQcTFfTXdKYTRVZU5hRWVMUWFPc3N1QUpDNmF3YzhMWDBQSlJlQXVmcFg5R0p3X2hSRXNaZTJtdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8757e5b494efab07","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-10T18:46:41.509043+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPTjZNMWppMUFhTjBqSWI5RGtTcEhXd2hfSFQtT0Z1VFRqRm5zS1NtalN5T1BSVjBkdnRaRTV0ZlNxazFpVG5YRzJKa1VFUmgxSHo1QXJWbDlidkZYa24tZE9UVEFycG94YzRJTnBGZDdSay1vRnR3WVpQcTFfTXdKYTRVZU5hRWVMUWFPc3N1QUpDNmF3YzhMWDBQSlJlQXVmcFg5R0p3X2hSRXNaZTJtdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPTjZNMWppMUFhTjBqSWI5RGtTcEhXd2hfSFQtT0Z1VFRqRm5zS1NtalN5T1BSVjBkdnRaRTV0ZlNxazFpVG5YRzJKa1VFUmgxSHo1QXJWbDlidkZYa24tZE9UVEFycG94YzRJTnBGZDdSay1vRnR3WVpQcTFfTXdKYTRVZU5hRWVMUWFPc3N1QUpDNmF3YzhMWDBQSlJlQXVmcFg5R0p3X2hSRXNaZTJtdw?oc=5","source_event_id":"evt_14eb59304e61","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"89281955b9fa2949","published_at":"2026-04-10T14:07:18+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"industry","name":"Europe (airports/aviation sector)","relevance":"high","symbol":"","type":"region"},{"asset_class":"country","name":"UK","relevance":"high","symbol":"","type":"country"},{"asset_class":"region","name":"EU","relevance":"high","symbol":"","type":"region"},{"asset_class":"industry_association","name":"Airports body (unnamed in provided text)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"geopolitical_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic chokepoint"}],"event_type":"supply_disruption","information_gaps":["The specific airports body name is not present in the provided text.","The exact mechanism linking a closed Strait of Hormuz to European jet fuel availability is not detailed in the provided content.","No quantitative figures (e.g., days of inventory, volume shortfall, affected airports/airlines) are included in the provided text.","The Reuters article\u2019s publication date and the precise near-term catalyst timing beyond 'within weeks' are not provided."],"key_facts":["Reuters headline indicates Europe could face a jet fuel crunch within weeks.","The warning is attributed to an airports industry body.","The risk described includes potential UK and EU flight cancellations due to jet fuel shortages.","The underlying driver cited in the provided source summary is concern that the Strait of Hormuz stays closed."],"numeric_claims":[{"label":"time_to_crunch","value":"within weeks"}],"primary_claim":"Europe could face a jet fuel crunch within weeks, with risks of UK and EU flight cancellations, according to an airports body warning reported by Reuters.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Reuters reports that an airports industry body warns Europe could face a jet fuel crunch within weeks, raising the risk of flight cancellations. The concern is tied to potential disruption to supply linked to the Strait of Hormuz remaining closed.","topics":["jet fuel","aviation fuel supply","airports","flight cancellations","Strait of Hormuz","UK-EU aviation risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Europe could face jet fuel crunch within weeks, airports body warns Reuters Fears of UK and EU flight cancellations as airports warn of jet fuel shortages The Guardian EU airline industry fears fuel shortages if Strait of Hormuz stays closed BBC European airports face jet fuel shortages within three weeks Financial Times Volcano Eruption Forces Evacuation as Lava Spews Into the Air The Daily Beast","title":"Europe could face jet fuel crunch within weeks, airports body warns - Reuters","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_fcb61782865c in signals