SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T11:15:38.705036+00:00","dedupe_key":"signal_enriched:news_delta:e28d69c8c7923b11","evidence_event_ids":["evt_6c48f52414bc"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 40108 in events