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/CBMiqwFBVV95cUxNNVpqbXd0T1c3NjlrZUZSUFFsOGZaZzBYSHlCVHJ2dFRPNVJjeGRIcGFVMDBEaV9OR3F2OWtKUzYzRVBKak1nS3kybkVsS3VJUkd0Wk1ha0hJT0NTQ0s3TTZueXk2TXNaNjFuZVhBUEg4UlFjS0xqbEFFWU0xN2FoNDVYUGJoYzNUcEhvd1RET0VnSXZxc2dMc1NYc3EtMWdJbUhkaVo2ZnF0dk3SAbABQVVfeXFMTTZQMzAwTUZxcmtjR1dWYnlsaVRTX050YzE4UlE1XzJaYVI2WHN3UFFfdFZyc3RZVER2b0k1Z09vT3hrb3BYaDNTQTVwZVEzN0kxRXRWTy1pT081SUtWdDVKRUNJbHZrWVk3OGJ6ZHlJOXpUVjlzMkhpZmlfaHI3d19DYTNfbGwwRHVfTGRwcHJxZ2pVSS0xT0NoSGFDQkpsb1FUaHVkTUVoY21DRmQtSVo?oc=5","as_of":"2026-04-07T11:15:38.705036+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNNVpqbXd0T1c3NjlrZUZSUFFsOGZaZzBYSHlCVHJ2dFRPNVJjeGRIcGFVMDBEaV9OR3F2OWtKUzYzRVBKak1nS3kybkVsS3VJUkd0Wk1ha0hJT0NTQ0s3TTZueXk2TXNaNjFuZVhBUEg4UlFjS0xqbEFFWU0xN2FoNDVYUGJoYzNUcEhvd1RET0VnSXZxc2dMc1NYc3EtMWdJbUhkaVo2ZnF0dk3SAbABQVVfeXFMTTZQMzAwTUZxcmtjR1dWYnlsaVRTX050YzE4UlE1XzJaYVI2WHN3UFFfdFZyc3RZVER2b0k1Z09vT3hrb3BYaDNTQTVwZVEzN0kxRXRWTy1pT081SUtWdDVKRUNJbHZrWVk3OGJ6ZHlJOXpUVjlzMkhpZmlfaHI3d19DYTNfbGwwRHVfTGRwcHJxZ2pVSS0xT0NoSGFDQkpsb1FUaHVkTUVoY21DRmQtSVo?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7ef889a59c3259e7","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T19:24:14.359974+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNNVpqbXd0T1c3NjlrZUZSUFFsOGZaZzBYSHlCVHJ2dFRPNVJjeGRIcGFVMDBEaV9OR3F2OWtKUzYzRVBKak1nS3kybkVsS3VJUkd0Wk1ha0hJT0NTQ0s3TTZueXk2TXNaNjFuZVhBUEg4UlFjS0xqbEFFWU0xN2FoNDVYUGJoYzNUcEhvd1RET0VnSXZxc2dMc1NYc3EtMWdJbUhkaVo2ZnF0dk3SAbABQVVfeXFMTTZQMzAwTUZxcmtjR1dWYnlsaVRTX050YzE4UlE1XzJaYVI2WHN3UFFfdFZyc3RZVER2b0k1Z09vT3hrb3BYaDNTQTVwZVEzN0kxRXRWTy1pT081SUtWdDVKRUNJbHZrWVk3OGJ6ZHlJOXpUVjlzMkhpZmlfaHI3d19DYTNfbGwwRHVfTGRwcHJxZ2pVSS0xT0NoSGFDQkpsb1FUaHVkTUVoY21DRmQtSVo?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"aljazeera.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNNVpqbXd0T1c3NjlrZUZSUFFsOGZaZzBYSHlCVHJ2dFRPNVJjeGRIcGFVMDBEaV9OR3F2OWtKUzYzRVBKak1nS3kybkVsS3VJUkd0Wk1ha0hJT0NTQ0s3TTZueXk2TXNaNjFuZVhBUEg4UlFjS0xqbEFFWU0xN2FoNDVYUGJoYzNUcEhvd1RET0VnSXZxc2dMc1NYc3EtMWdJbUhkaVo2ZnF0dk3SAbABQVVfeXFMTTZQMzAwTUZxcmtjR1dWYnlsaVRTX050YzE4UlE1XzJaYVI2WHN3UFFfdFZyc3RZVER2b0k1Z09vT3hrb3BYaDNTQTVwZVEzN0kxRXRWTy1pT081SUtWdDVKRUNJbHZrWVk3OGJ6ZHlJOXpUVjlzMkhpZmlfaHI3d19DYTNfbGwwRHVfTGRwcHJxZ2pVSS0xT0NoSGFDQkpsb1FUaHVkTUVoY21DRmQtSVo?oc=5","source_event_id":"evt_6c48f52414bc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8f9e9123756d1763","published_at":"2026-04-07T10:09:56+00:00","publisher_domain":"aljazeera.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Israeli consulate","relevance":"high","symbol":"","type":"location"},{"asset_class":"city","name":"Istanbul","relevance":"high","symbol":"","type":"location"},{"asset_class":"country","name":"Turkiye","relevance":"high","symbol":"TR","type":"country"}],"event_type":"conflict","information_gaps":["Details on the motive behind the shooting are unclear","No information on the identities of the victims or perpetrators"],"key_facts":["Three fatalities reported","Incident occurred near Israeli consulate","Multiple media outlets confirmed the event"],"numeric_claims":[],"primary_claim":"Three people were killed in a shooting near the Israeli consulate in Istanbul, Turkey.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"A shooting incident near the Israeli consulate in Istanbul resulted in three fatalities, raising concerns about security in the region.","topics":["security","geopolitical risk","Turkey","Israel"]},"source":"Al Jazeera","source_domain":"aljazeera.com","source_url":"https://www.aljazeera.com","summary":"Three killed in shooting near Israeli consulate in Turkiye\u2019s Istanbul Al Jazeera Shooting reported near Israeli consulate in Istanbul BBC Three people killed in gun clash near Israeli consulate in Istanbul, media says Reuters Turkish Police Clash with Gunmen Near Israeli Consulate, NTV Reports Bloomberg.com At least two killed in shooting near Israeli consulate in Istanbul, media reports say CBS News","title":"Three killed in shooting near Israeli consulate in Turkiye\u2019s Istanbul - Al Jazeera","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_3d81885909b0 in signals