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/CBMi_gFBVV95cUxNTDFrR0NVczZrVEc0NXRTQUUzUTZQTEU5SUF1MVk1aFVvSko1RUw5a3BUUlhfZHkwS2JRWlp0b1V4N1EwTFB1VlVGamRPMzJDakRWYmdzOThmX1NDU3g3cGlXcXlyUl9wODNPb2s1X2FPV1BjcWdoVmlOUGtDLW5PeWZ1bk8tcWdyZjZGQy1xUFhfVURxX0Ryekh3NjM1U2ZnTUtWWm83UVBWYWhPQW9QSi1uQXp4ZW9FbnJHZ2l6QjNuMHlGQVVFRUk3RUcyMF96WUFxU2E4RElnSmFVc05jRkE2V3hEWGpFdG9XRF9XcXZBazM5aUxIdkZLNW9JZw?oc=5","as_of":"2026-04-08T04:49:08.338959+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/CBMi_gFBVV95cUxNTDFrR0NVczZrVEc0NXRTQUUzUTZQTEU5SUF1MVk1aFVvSko1RUw5a3BUUlhfZHkwS2JRWlp0b1V4N1EwTFB1VlVGamRPMzJDakRWYmdzOThmX1NDU3g3cGlXcXlyUl9wODNPb2s1X2FPV1BjcWdoVmlOUGtDLW5PeWZ1bk8tcWdyZjZGQy1xUFhfVURxX0Ryekh3NjM1U2ZnTUtWWm83UVBWYWhPQW9QSi1uQXp4ZW9FbnJHZ2l6QjNuMHlGQVVFRUk3RUcyMF96WUFxU2E4RElnSmFVc05jRkE2V3hEWGpFdG9XRF9XcXZBazM5aUxIdkZLNW9JZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_96ef326087018db1","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-08T04:49:30.575012+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxNTDFrR0NVczZrVEc0NXRTQUUzUTZQTEU5SUF1MVk1aFVvSko1RUw5a3BUUlhfZHkwS2JRWlp0b1V4N1EwTFB1VlVGamRPMzJDakRWYmdzOThmX1NDU3g3cGlXcXlyUl9wODNPb2s1X2FPV1BjcWdoVmlOUGtDLW5PeWZ1bk8tcWdyZjZGQy1xUFhfVURxX0Ryekh3NjM1U2ZnTUtWWm83UVBWYWhPQW9QSi1uQXp4ZW9FbnJHZ2l6QjNuMHlGQVVFRUk3RUcyMF96WUFxU2E4RElnSmFVc05jRkE2V3hEWGpFdG9XRF9XcXZBazM5aUxIdkZLNW9JZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reliefweb.int","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxNTDFrR0NVczZrVEc0NXRTQUUzUTZQTEU5SUF1MVk1aFVvSko1RUw5a3BUUlhfZHkwS2JRWlp0b1V4N1EwTFB1VlVGamRPMzJDakRWYmdzOThmX1NDU3g3cGlXcXlyUl9wODNPb2s1X2FPV1BjcWdoVmlOUGtDLW5PeWZ1bk8tcWdyZjZGQy1xUFhfVURxX0Ryekh3NjM1U2ZnTUtWWm83UVBWYWhPQW9QSi1uQXp4ZW9FbnJHZ2l6QjNuMHlGQVVFRUk3RUcyMF96WUFxU2E4RElnSmFVc05jRkE2V3hEWGpFdG9XRF9XcXZBazM5aUxIdkZLNW9JZw?oc=5","source_event_id":"evt_82899fb5bff2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"72437108ec7f47d0","published_at":"2026-04-08T03:00:03+00:00","publisher_domain":"reliefweb.int","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["March 2026","September 2026"],"entities":[{"asset_class":"sovereign_state","name":"El Salvador","relevance":"primary subject","symbol":"","type":"country"},{"asset_class":"index_framework","name":"IPC (Integrated Food Security Phase Classification)","relevance":"defines severity phase","symbol":"","type":"framework"},{"asset_class":"news_platform","name":"ReliefWeb","relevance":"source of key message update","symbol":"","type":"publisher"}],"event_type":"supply_disruption","information_gaps":["The text provided does not specify the geographic scope within El Salvador (e.g., departments/regions) where IPC Phase 2 expands.","No drivers are given beyond \u201catypically early depletion of food stocks\u201d (e.g., drought, conflict, market shocks).","No magnitude is provided (e.g., number of people affected, severity levels beyond Phase 2).","The exact wording of the IPC expansion (how much it expands) is not included in the provided content."],"key_facts":["ReliefWeb published a \u201cKey Message Update\u201d for El Salvador.","The update states that food stocks were depleted atypically early.","This atypically early depletion expands Stressed (IPC Phase 2) outcomes.","The expanded outcomes are for the period March\u2013September 2026."],"numeric_claims":[{"label":"IPC phase","value":"Phase 2 (Stressed)"},{"label":"Time window","value":"March\u2013September 2026"}],"primary_claim":"Atypically early depletion of food stocks in El Salvador expands Stressed (IPC Phase 2) outcomes for March\u2013September 2026.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"El Salvador\u2019s food security outlook has worsened due to an atypically early depletion of food stocks, leading to expanded areas in IPC Phase 2 (Stressed) for March\u2013September 2026.","topics":["food security","IPC Phase 2 (Stressed)","food stock depletion","El Salvador","March\u2013September 2026 outlook"]},"source":"ReliefWeb","source_domain":"reliefweb.int","source_url":"https://reliefweb.int","summary":"El Salvador - Key Message Update: Atypically early depletion of food stocks expands Stressed (IPC Phase 2) outcomes, March - September 2026 ReliefWeb","title":"El Salvador - Key Message Update: Atypically early depletion of food stocks expands Stressed (IPC Phase 2) outcomes, March - September 2026 - ReliefWeb","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_8846ee5d5759 in signals