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/CBMiWkFVX3lxTE5IV3V2TGFmUTdrRUdQSlNmY1RISWN1V245Y0VvQ0E5bHZBd1BDaTd1UDQ1eEphMWxEeGxGMHNaODhOVDhuUGpxblltblNVanp0SEpXZTAyeWkwQQ?oc=5","as_of":"2026-04-06T21:50:13.364591+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/CBMiWkFVX3lxTE5IV3V2TGFmUTdrRUdQSlNmY1RISWN1V245Y0VvQ0E5bHZBd1BDaTd1UDQ1eEphMWxEeGxGMHNaODhOVDhuUGpxblltblNVanp0SEpXZTAyeWkwQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_32f7970b4184ec32","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-07T11:21:16.017709+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5IV3V2TGFmUTdrRUdQSlNmY1RISWN1V245Y0VvQ0E5bHZBd1BDaTd1UDQ1eEphMWxEeGxGMHNaODhOVDhuUGpxblltblNVanp0SEpXZTAyeWkwQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5IV3V2TGFmUTdrRUdQSlNmY1RISWN1V245Y0VvQ0E5bHZBd1BDaTd1UDQ1eEphMWxEeGxGMHNaODhOVDhuUGpxblltblNVanp0SEpXZTAyeWkwQQ?oc=5","source_event_id":"evt_906c1446324b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"71fa5475499cb921","published_at":"2026-04-06T19:11:20+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Israel","relevance":"directly involved","symbol":"ISR","type":"country"},{"asset_class":"political","name":"Hamas","relevance":"directly involved","symbol":"HAMAS","type":"militant group"},{"asset_class":"geopolitical","name":"Gaza","relevance":"location of conflict","symbol":"GZA","type":"region"}],"event_type":"conflict","information_gaps":["Exact timing of the strikes and clashes is unclear","Details on the identities of the deceased are not provided","Context on ceasefire status is not specified"],"key_facts":["Ten killed in airstrikes and clashes","Involvement of Hamas and pro-Israel militia","Local sources report the casualties"],"numeric_claims":[{"label":"Number of casualties","value":"10"}],"primary_claim":"Ten people were killed in Israeli strikes and clashes in Gaza.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"Israeli airstrikes and clashes in Gaza have resulted in the deaths of ten individuals, according to local sources, amid ongoing tensions between Hamas and pro-Israel militias.","topics":["Middle East conflict","Israeli-Palestinian relations","military action"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Ten killed in Israeli strikes and clashes between Hamas and militia in Gaza, local sources say BBC Israeli Strike Kills 10 People Near Gaza School Haaretz 10 Gazans reported killed in airstrikes amid firefight involving pro-Israel militia The Times of Israel Israeli fire kills four Palestinians in Gaza, medics say Reuters Israeli Airstrike Kills at Least 10 Near Gaza School as Ceasefire Strains U.S. News & World Report","title":"Ten killed in Israeli strikes and clashes between Hamas and militia in Gaza, local sources say - BBC","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_d4de6be43edf in signals