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/CBMivgFBVV95cUxQcHNVVldhTmc2clpkY19uZUdoOTNSQnZMWVdpWVVIQ2RtaWVnbzgzRl9EZ1BTMzNhcWN5dUoyQUdtWGsybFRZbE5zWVVZb1dkWnFJZVdHX09SZlEtYnNEdTBkR0RSZkdWNWRFT0poR0JvNm15OE51WnNKYnNBZ3VQNEVRSUxTMVd3elVZYWgwaVNRalpMUTh5eVRiaDh4Qlc4NndWQ1NaeWpzcXdTaFJidVUxbHMtNWx1MUtJb1Fn?oc=5","as_of":"2026-04-08T07:21:41.251119+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/CBMivgFBVV95cUxQcHNVVldhTmc2clpkY19uZUdoOTNSQnZMWVdpWVVIQ2RtaWVnbzgzRl9EZ1BTMzNhcWN5dUoyQUdtWGsybFRZbE5zWVVZb1dkWnFJZVdHX09SZlEtYnNEdTBkR0RSZkdWNWRFT0poR0JvNm15OE51WnNKYnNBZ3VQNEVRSUxTMVd3elVZYWgwaVNRalpMUTh5eVRiaDh4Qlc4NndWQ1NaeWpzcXdTaFJidVUxbHMtNWx1MUtJb1Fn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_917d01059d296fa9","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-08T07:22:06.285464+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxQcHNVVldhTmc2clpkY19uZUdoOTNSQnZMWVdpWVVIQ2RtaWVnbzgzRl9EZ1BTMzNhcWN5dUoyQUdtWGsybFRZbE5zWVVZb1dkWnFJZVdHX09SZlEtYnNEdTBkR0RSZkdWNWRFT0poR0JvNm15OE51WnNKYnNBZ3VQNEVRSUxTMVd3elVZYWgwaVNRalpMUTh5eVRiaDh4Qlc4NndWQ1NaeWpzcXdTaFJidVUxbHMtNWx1MUtJb1Fn?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/CBMivgFBVV95cUxQcHNVVldhTmc2clpkY19uZUdoOTNSQnZMWVdpWVVIQ2RtaWVnbzgzRl9EZ1BTMzNhcWN5dUoyQUdtWGsybFRZbE5zWVVZb1dkWnFJZVdHX09SZlEtYnNEdTBkR0RSZkdWNWRFT0poR0JvNm15OE51WnNKYnNBZ3VQNEVRSUxTMVd3elVZYWgwaVNRalpMUTh5eVRiaDh4Qlc4NndWQ1NaeWpzcXdTaFJidVUxbHMtNWx1MUtJb1Fn?oc=5","source_event_id":"evt_1d0c865069b9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1205ac75044ad684","published_at":"2026-04-07T17:21:53+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"US EIA (US Energy Information Administration)","relevance":"high","symbol":"","type":"government_agency"},{"asset_class":"commodity_supply_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"},{"asset_class":"sovereign","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"media","name":"Reuters","relevance":"medium","symbol":"","type":"news_outlet"}],"event_type":"macro_policy","information_gaps":["No specific magnitude (e.g., % or $) of the fuel price increase is provided in the supplied content.","No exact timing for when the EIA forecast applies (which months/quarters) is included.","The cleaned article text appears to contain mostly page styling/HTML and does not provide the substantive Reuters/EIA figures in the excerpt.","The signal mentions related supply outlook items (e.g., oil output dropping) but the excerpt provided does not include those details directly from Reuters."],"key_facts":["Reuters headline states the US EIA expects fuel prices could keep rising for months even if Hormuz reopens.","The signal links the price outlook to disruptions affecting oil supply through/around the Strait of Hormuz.","The provided text does not include specific numeric price forecasts or dates for the EIA update."],"numeric_claims":[],"primary_claim":"The US EIA says fuel prices could keep rising for months even if Hormuz reopens.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports the US EIA expects fuel prices to remain elevated and could keep rising for months even if the Strait of Hormuz reopens. The outlook is tied to ongoing supply tightness from disruptions related to the Iran conflict.","topics":["fuel prices","oil supply disruption","Hormuz reopening","US EIA forecast","months-long price pressure","Middle East oil market"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Fuel prices could keep rising for months even if Hormuz reopens, US EIA says Reuters Mideast Oil Output Seen Dropping by 9 Million Barrels a Day Bloomberg.com The Strait of Hormuz Is Blocked: This Is What It Means for You usnews.com US raises 2026 oil price forecast as disruptions in Strait of Hormuz tighten supply outlook Anadolu Ajans\u0131 Article | EIA raises forecast for oil, gasoline prices as Iran war crimps supply POLITICO Pro","title":"Fuel prices could keep rising for months even if Hormuz reopens, US EIA says - 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_f7677d8853e2 in signals