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/CBMi0wFBVV95cUxPc3Ztakk5YnFMcXozdEdSaXRxU1RQYnZNTm5rMm1mWktkNzctVzRqQ0tNekRvb2VtTkJjYmdVTHJKeDFxRWZfQ1pSV1BiYThkaDI2cEc5d2cyek9wbVU4NEl0bGpNQUMxb2c3SEROUHAzZFhTaHBZR0REcjBQMTlpTUYyMXdRSW9KOXY5VFVRWFJfQ1o4V09ITGdyV3Q0U05nYk9qWTdNeTBwYkdCR0lycEFmekNWVUlCdFZ0dlFaY3RtMmQ2ZnFtcU5XVTRiamRIbEFr?oc=5","as_of":"2026-04-09T08:24:00.870069+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/CBMi0wFBVV95cUxPc3Ztakk5YnFMcXozdEdSaXRxU1RQYnZNTm5rMm1mWktkNzctVzRqQ0tNekRvb2VtTkJjYmdVTHJKeDFxRWZfQ1pSV1BiYThkaDI2cEc5d2cyek9wbVU4NEl0bGpNQUMxb2c3SEROUHAzZFhTaHBZR0REcjBQMTlpTUYyMXdRSW9KOXY5VFVRWFJfQ1o4V09ITGdyV3Q0U05nYk9qWTdNeTBwYkdCR0lycEFmekNWVUlCdFZ0dlFaY3RtMmQ2ZnFtcU5XVTRiamRIbEFr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a84401b945ec05c7","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:53:16.959006+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi0wFBVV95cUxPc3Ztakk5YnFMcXozdEdSaXRxU1RQYnZNTm5rMm1mWktkNzctVzRqQ0tNekRvb2VtTkJjYmdVTHJKeDFxRWZfQ1pSV1BiYThkaDI2cEc5d2cyek9wbVU4NEl0bGpNQUMxb2c3SEROUHAzZFhTaHBZR0REcjBQMTlpTUYyMXdRSW9KOXY5VFVRWFJfQ1o4V09ITGdyV3Q0U05nYk9qWTdNeTBwYkdCR0lycEFmekNWVUlCdFZ0dlFaY3RtMmQ2ZnFtcU5XVTRiamRIbEFr?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/CBMi0wFBVV95cUxPc3Ztakk5YnFMcXozdEdSaXRxU1RQYnZNTm5rMm1mWktkNzctVzRqQ0tNekRvb2VtTkJjYmdVTHJKeDFxRWZfQ1pSV1BiYThkaDI2cEc5d2cyek9wbVU4NEl0bGpNQUMxb2c3SEROUHAzZFhTaHBZR0REcjBQMTlpTUYyMXdRSW9KOXY5VFVRWFJfQ1o4V09ITGdyV3Q0U05nYk9qWTdNeTBwYkdCR0lycEFmekNWVUlCdFZ0dlFaY3RtMmQ2ZnFtcU5XVTRiamRIbEFr?oc=5","source_event_id":"evt_70933742a859","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"88772e8b2b3398f0","published_at":"2026-04-09T07:00:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Red Cross","relevance":"High","symbol":"","type":"NGO/humanitarian organization"},{"asset_class":"other","name":"Israel","relevance":"High","symbol":"","type":"country/state"},{"asset_class":"other","name":"Lebanon","relevance":"High","symbol":"","type":"country/state"},{"asset_class":"other","name":"Donald Trump","relevance":"Medium","symbol":"","type":"political figure"},{"asset_class":"other","name":"United States military","relevance":"Medium","symbol":"","type":"military force"},{"asset_class":"other","name":"Iran","relevance":"Medium","symbol":"","type":"country/state"}],"event_type":"geopolitical_risk","information_gaps":["The provided content is dominated by page styling/HTML and does not include the full article body; only the headline and the supplied source summary are usable for extraction.","It is unclear whether the 254 figure is final, preliminary, or time-bounded (e.g., deaths reported by a specific agency at a specific time).","The exact details of Trump\u2019s statement (timing, scope, and whether it refers to specific bases/forces) are not included in the provided text.","The \u2018after Iran ceasefire was declared\u2019 linkage is mentioned in the source summary but not evidenced with specifics in the provided excerpt."],"key_facts":["The Guardian headline states Israeli strikes on Lebanon killed 254 people.","The Guardian headline states the Red Cross is \u2018outraged\u2019 about the strikes.","The Guardian headline states Trump said US military will remain in the region.","Source summary adds that Israel launched sprawling attacks on Lebanon after an Iran ceasefire was declared (uncertainty: exact timing/causality not fully specified in provided text)."],"numeric_claims":[{"label":"Lebanon deaths from Israeli strikes (as stated in headline)","value":"254"}],"primary_claim":"Israeli strikes on Lebanon have killed 254 people, and the Red Cross is \u2018outraged,\u2019 while Trump says US military will remain in the region.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that Israeli strikes on Lebanon have killed 254 people, prompting outrage from the Red Cross, while Donald Trump says US military forces will remain in the region. The broader live coverage also references an Israel\u2013Lebanon escalation following a declared Iran ceasefire.","topics":["Middle East crisis","Israel-Lebanon strikes","humanitarian response","US military posture","ceasefire developments"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Middle East crisis live: Red Cross \u2018outraged\u2019 as Israeli strikes on Lebanon kill 254 people; Trump says US military to remain in region The Guardian Israel launches sprawling attacks on Lebanon after Iran ceasefire was declared NBC News Spain condemns Israeli attacks on Lebanon, reopens Tehran embassy Reuters Lebanon Mourns After Israeli Barrage Kills at Least 182 People The New York Times World reacts to \u2018brutal\u2019 Israeli attacks on Lebanon after US-Iran truce Al Jazeera","title":"Middle East crisis live: Red Cross \u2018outraged\u2019 as Israeli strikes on Lebanon kill 254 people; Trump says US military to remain in region - 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_d83d6af09630 in signals