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/CBMizAFBVV95cUxPTzhnTjdsV3pGS21BbW1iN2c4TGhWcHQzMmdLQXlzcWlQZTRmTWtOQzdrcVFIdWZhc1RDZzVTa0lxQmxhRFVtY2Y0VlNDbVpMb1BEb3NMZi1MNzFWTGpkMkxXTWJ6TGRfSWFMZG12bHRTd2VDRTRxSEFzX3FsNUVldEVuRk5qSkhQMzhCTEhtNEZnOEN0Y2JRUFRwc21qMU4zY0JNT1o2RFpSLUpnWUdoRkdRa1FGbmRjdWxBR3FrSHB0ZFFjbEk5MXFTYWs?oc=5","as_of":"2026-04-09T00:07:15.882110+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/CBMizAFBVV95cUxPTzhnTjdsV3pGS21BbW1iN2c4TGhWcHQzMmdLQXlzcWlQZTRmTWtOQzdrcVFIdWZhc1RDZzVTa0lxQmxhRFVtY2Y0VlNDbVpMb1BEb3NMZi1MNzFWTGpkMkxXTWJ6TGRfSWFMZG12bHRTd2VDRTRxSEFzX3FsNUVldEVuRk5qSkhQMzhCTEhtNEZnOEN0Y2JRUFRwc21qMU4zY0JNT1o2RFpSLUpnWUdoRkdRa1FGbmRjdWxBR3FrSHB0ZFFjbEk5MXFTYWs?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_14298cc7dcb65a75","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:20:33.333784+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxPTzhnTjdsV3pGS21BbW1iN2c4TGhWcHQzMmdLQXlzcWlQZTRmTWtOQzdrcVFIdWZhc1RDZzVTa0lxQmxhRFVtY2Y0VlNDbVpMb1BEb3NMZi1MNzFWTGpkMkxXTWJ6TGRfSWFMZG12bHRTd2VDRTRxSEFzX3FsNUVldEVuRk5qSkhQMzhCTEhtNEZnOEN0Y2JRUFRwc21qMU4zY0JNT1o2RFpSLUpnWUdoRkdRa1FGbmRjdWxBR3FrSHB0ZFFjbEk5MXFTYWs?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxPTzhnTjdsV3pGS21BbW1iN2c4TGhWcHQzMmdLQXlzcWlQZTRmTWtOQzdrcVFIdWZhc1RDZzVTa0lxQmxhRFVtY2Y0VlNDbVpMb1BEb3NMZi1MNzFWTGpkMkxXTWJ6TGRfSWFMZG12bHRTd2VDRTRxSEFzX3FsNUVldEVuRk5qSkhQMzhCTEhtNEZnOEN0Y2JRUFRwc21qMU4zY0JNT1o2RFpSLUpnWUdoRkdRa1FGbmRjdWxBR3FrSHB0ZFFjbEk5MXFTYWs?oc=5","source_event_id":"evt_ef6855d55bb3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c99b5adda52b6f8a","published_at":"2026-04-08T18:13:44+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Israel","relevance":"primary_strike_actor","symbol":"","type":"state_actor"},{"asset_class":"n/a","name":"Gaza","relevance":"location_of_strikes","symbol":"","type":"territory"},{"asset_class":"n/a","name":"Al Jazeera","relevance":"employer_of_reported_victim","symbol":"","type":"media_organization"},{"asset_class":"n/a","name":"Mohammed Wishah","relevance":"reported_deceased_journalist","symbol":"","type":"individual"},{"asset_class":"n/a","name":"Medics","relevance":"attribution_for_deaths","symbol":"","type":"source_group"},{"asset_class":"n/a","name":"Reuters","relevance":"source","symbol":"","type":"news_organization"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not the Reuters article content (it appears to be page styling/HTML), so only the headline and the provided source summary can be relied upon.","The exact timing/date of the strikes is not included in the provided text.","The identities of the other three victims are not provided.","Whether the attack is specifically described as a drone strike in Reuters (vs. in other snippets) is uncertain.","No details are provided on location within Gaza, strike mechanism, or circumstances of death beyond the medics attribution."],"key_facts":["Reuters headline states Israeli strikes in Gaza killed four people.","Reuters headline states one of the four killed was Al Jazeera journalist Mohammed Wishah.","Reuters headline attributes the death toll to medics.","The strike is described as a drone strike in the provided source summary text (uncertain if this is from the same Reuters article or from other linked snippets)."],"numeric_claims":[{"label":"Deaths","value":"4"}],"primary_claim":"Israeli strikes in Gaza killed four people, including Al Jazeera journalist Mohammed Wishah, according to medics (Reuters).","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Reuters reports that Israeli strikes in Gaza killed four people, including Al Jazeera journalist Mohammed Wishah, according to medics. The incident is a near-term escalation with immediate implications for journalists\u2019 safety and civilian harm reporting.","topics":["Israeli strikes","Gaza conflict","journalist deaths","Al Jazeera","civilian casualties","media safety"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Israeli strikes in Gaza kill four, including Al Jazeera journalist, medics say Reuters Israeli attack kills Al Jazeera journalist Mohammed Wishah in Gaza Al Jazeera Al Jazeera journalist Mohammed Washah killed by Israeli drone strike Le Monde.fr Palestinian Journalists\u2019 Syndicate documents 2 killings, 53 offences against journalists in March Arab News PK Israel Kills Journalist Mohammed Washah in Gaza Strike as Media Death Toll Surges Palestine Chronicle","title":"Israeli strikes in Gaza kill four, including Al Jazeera journalist, medics say - Reuters","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_6524c7c7c275 in signals