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/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","as_of":"2026-04-08T22:21:15.507341+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/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2db2b813726bc0ff","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-09T22:16:18.713524+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"economist.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","source_event_id":"evt_82bffd91fb23","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"17ceae403c0a58ca","published_at":"2026-04-08T21:55:04+00:00","publisher_domain":"economist.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Economist","relevance":"source of claim","symbol":"","type":"publisher"},{"asset_class":"commodity/energy","name":"Energy markets","relevance":"affected market category","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided on which countries/actors are involved in the \u201cthird Gulf war.\u201d","No specific mechanisms are stated (e.g., supply disruption, shipping risk, sanctions) for how energy markets would be scarred.","No time horizon or magnitude (duration in months/years, price impact) is specified beyond \u201cfor a long time yet.\u201d","No specific energy commodities or tradable instruments are named."],"key_facts":["The Economist headline states that the \u201cthird Gulf war\u201d will \u201cscar energy markets for a long time yet.\u201d"],"numeric_claims":[],"primary_claim":"The third Gulf war will scar energy markets for a long time yet.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Economist argues that a \u201cthird Gulf war\u201d would have long-lasting damage effects on energy markets.","topics":["Gulf war","geopolitical risk","energy markets","market disruption","long-lasting impact"]},"source":"The Economist","source_domain":"economist.com","source_url":"https://www.economist.com","summary":"The third Gulf war will scar energy markets for a long time yet The Economist","title":"The third Gulf war will scar energy markets for a long time yet - The Economist","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_93d539647229 in signals