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/CBMiuwFBVV95cUxPUkhyb3dxY2k5bUJMWDdYNlFsZE9faC1CazFOLWY4RkpsT25mbmR2YThCZV9CZkFBRm1SRzNNVXl0UEhpenVEMlpvUi1BdllFZmxfV0ZfWjY0OTJjVEVwcVBvX0JNUXlZSGVEWTVHQWNrQTBWSVNmMmI1cUhhRUdMbjE0dUdFUnRCVWxJSm9tOS1DakRtWUJ4YUNEVVBlZEEwbEZMTXFCOWh0Q1haM1pLdUszX0R5T05OX2w0?oc=5","as_of":"2026-04-09T17:20:47.725130+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/CBMiuwFBVV95cUxPUkhyb3dxY2k5bUJMWDdYNlFsZE9faC1CazFOLWY4RkpsT25mbmR2YThCZV9CZkFBRm1SRzNNVXl0UEhpenVEMlpvUi1BdllFZmxfV0ZfWjY0OTJjVEVwcVBvX0JNUXlZSGVEWTVHQWNrQTBWSVNmMmI1cUhhRUdMbjE0dUdFUnRCVWxJSm9tOS1DakRtWUJ4YUNEVVBlZEEwbEZMTXFCOWh0Q1haM1pLdUszX0R5T05OX2w0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4dd16346458b476d","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-10T00:07:05.238537+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxPUkhyb3dxY2k5bUJMWDdYNlFsZE9faC1CazFOLWY4RkpsT25mbmR2YThCZV9CZkFBRm1SRzNNVXl0UEhpenVEMlpvUi1BdllFZmxfV0ZfWjY0OTJjVEVwcVBvX0JNUXlZSGVEWTVHQWNrQTBWSVNmMmI1cUhhRUdMbjE0dUdFUnRCVWxJSm9tOS1DakRtWUJ4YUNEVVBlZEEwbEZMTXFCOWh0Q1haM1pLdUszX0R5T05OX2w0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxPUkhyb3dxY2k5bUJMWDdYNlFsZE9faC1CazFOLWY4RkpsT25mbmR2YThCZV9CZkFBRm1SRzNNVXl0UEhpenVEMlpvUi1BdllFZmxfV0ZfWjY0OTJjVEVwcVBvX0JNUXlZSGVEWTVHQWNrQTBWSVNmMmI1cUhhRUdMbjE0dUdFUnRCVWxJSm9tOS1DakRtWUJ4YUNEVVBlZEEwbEZMTXFCOWh0Q1haM1pLdUszX0R5T05OX2w0?oc=5","source_event_id":"evt_37ec4cdf2c45","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7dc6b6b11d3bd1ad","published_at":"2026-04-09T16:19:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"macro/institution","name":"International Monetary Fund (IMF)","relevance":"high","symbol":"","type":"institution"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"media","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The IMF head\u2019s name and the exact wording are not provided in the supplied text.","No specific economic channels are described (e.g., inflation, trade disruption, energy prices) beyond the general claim of permanent scarring.","No timeframe or magnitude (e.g., GDP impact, cost estimates) is included in the provided excerpt.","The supplied content includes other outlet snippets (NYT/Axios/WaPo/Reuters) but does not provide their specific details here, so they cannot be grounded as part of this extraction."],"key_facts":["The Guardian headline attributes a statement to the head of the IMF about the Iran war\u2019s economic effects.","The statement characterizes the damage as permanent/long-lasting (\u201cpermanently scar\u201d).","The statement says the damage would persist even if peace is reached."],"numeric_claims":[],"primary_claim":"The head of the IMF says the Iran war will permanently scar the global economy even if peace is reached.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that the IMF\u2019s head warns the Iran war will cause long-lasting damage to the global economy even if a peace agreement is reached.","topics":["IMF","Iran war","global economic impact","peace negotiations","macroeconomic risk"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Head of IMF says Iran war will permanently scar global economy even if peace is reached The Guardian Opinion | I Studied the Economic Fallout From World War I. This Could Be Worse Than We Expect. The New York Times Iran war's economic aftershocks will be felt for some time Axios The war\u2019s economic impact could get worse for Americans The Washington Post Developing countries in Europe, Central Asia face slowdown, World Bank says Reuters","title":"Head of IMF says Iran war will permanently scar global economy even if peace is reached - The Guardian","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_407b391ad83a in signals