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-08T19:34:52.227899+00:00","dedupe_key":"signal_enriched:news_delta:b406f7b0a6d23a50","evidence_event_ids":["evt_9c512b8cc2c6"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNVHg2V2kyRFJnYmVkQXUyYmxXX0prSDc0d3lTYnFhbjkwMC1zYTIwMXlHdndXNEVIdEdSOHBKM18wSmZoVDJTZ0RELWhpX1Z3eU5LUFk2SmJzWHhKaTJ6TUtCMF9UOTNVZ2R3WjZ3cnBWOWRSU2hHMHNJWlBxTi1QV0V4SkRfRDBXTmRIVzdhMVVnbHJsTkN5QzljN0lIZWpPN0hvV3VVRlA4QdIBrwFBVV95cUxOamVsOGZPR2o2cGRuVGVqT3Q1RkN0WTBsZC1iWHhIM1hCekRSM3dNRGZWUkUwUkV1bjRWVGE3VlFSWDlZYkVhXzZkZTlLS1cwRmtqMVNWeU1PYjhJUnpyUzAxdUxMcF9La3pIRXN5d2V6VHhpd0o2ODA0WXBCcncxNkFOamRUUU9kX2tmSERwYU5mVTRCTHRuaHJCcXgyYVNqaHdMdERXZFVGNExoVjV3?oc=5","as_of":"2026-04-08T19:34:52.227899+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/CBMiqgFBVV95cUxNVHg2V2kyRFJnYmVkQXUyYmxXX0prSDc0d3lTYnFhbjkwMC1zYTIwMXlHdndXNEVIdEdSOHBKM18wSmZoVDJTZ0RELWhpX1Z3eU5LUFk2SmJzWHhKaTJ6TUtCMF9UOTNVZ2R3WjZ3cnBWOWRSU2hHMHNJWlBxTi1QV0V4SkRfRDBXTmRIVzdhMVVnbHJsTkN5QzljN0lIZWpPN0hvV3VVRlA4QdIBrwFBVV95cUxOamVsOGZPR2o2cGRuVGVqT3Q1RkN0WTBsZC1iWHhIM1hCekRSM3dNRGZWUkUwUkV1bjRWVGE3VlFSWDlZYkVhXzZkZTlLS1cwRmtqMVNWeU1PYjhJUnpyUzAxdUxMcF9La3pIRXN5d2V6VHhpd0o2ODA0WXBCcncxNkFOamRUUU9kX2tmSERwYU5mVTRCTHRuaHJCcXgyYVNqaHdMdERXZFVGNExoVjV3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0b0c00010957c511","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:04:07.450942+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNVHg2V2kyRFJnYmVkQXUyYmxXX0prSDc0d3lTYnFhbjkwMC1zYTIwMXlHdndXNEVIdEdSOHBKM18wSmZoVDJTZ0RELWhpX1Z3eU5LUFk2SmJzWHhKaTJ6TUtCMF9UOTNVZ2R3WjZ3cnBWOWRSU2hHMHNJWlBxTi1QV0V4SkRfRDBXTmRIVzdhMVVnbHJsTkN5QzljN0lIZWpPN0hvV3VVRlA4QdIBrwFBVV95cUxOamVsOGZPR2o2cGRuVGVqT3Q1RkN0WTBsZC1iWHhIM1hCekRSM3dNRGZWUkUwUkV1bjRWVGE3VlFSWDlZYkVhXzZkZTlLS1cwRmtqMVNWeU1PYjhJUnpyUzAxdUxMcF9La3pIRXN5d2V6VHhpd0o2ODA0WXBCcncxNkFOamRUUU9kX2tmSERwYU5mVTRCTHRuaHJCcXgyYVNqaHdMdERXZFVGNExoVjV3?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/CBMiqgFBVV95cUxNVHg2V2kyRFJnYmVkQXUyYmxXX0prSDc0d3lTYnFhbjkwMC1zYTIwMXlHdndXNEVIdEdSOHBKM18wSmZoVDJTZ0RELWhpX1Z3eU5LUFk2SmJzWHhKaTJ6TUtCMF9UOTNVZ2R3WjZ3cnBWOWRSU2hHMHNJWlBxTi1QV0V4SkRfRDBXTmRIVzdhMVVnbHJsTkN5QzljN0lIZWpPN0hvV3VVRlA4QdIBrwFBVV95cUxOamVsOGZPR2o2cGRuVGVqT3Q1RkN0WTBsZC1iWHhIM1hCekRSM3dNRGZWUkUwUkV1bjRWVGE3VlFSWDlZYkVhXzZkZTlLS1cwRmtqMVNWeU1PYjhJUnpyUzAxdUxMcF9La3pIRXN5d2V6VHhpd0o2ODA0WXBCcncxNkFOamRUUU9kX2tmSERwYU5mVTRCTHRuaHJCcXgyYVNqaHdMdERXZFVGNExoVjV3?oc=5","source_event_id":"evt_9c512b8cc2c6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6ccb930a4da2ad06","published_at":"2026-04-08T17:24:20+00:00","publisher_domain":"aljazeera.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["March"],"entities":[{"asset_class":"journalist","name":"Mohammed Wishah","relevance":"primary","symbol":"","type":"person"},{"asset_class":"media","name":"Al Jazeera","relevance":"primary","symbol":"","type":"organization"},{"asset_class":"military","name":"Israeli occupation forces / Israeli forces","relevance":"primary","symbol":"","type":"organization"},{"asset_class":"journalist union","name":"Palestinian Journalists\u2019 Syndicate","relevance":"supporting","symbol":"","type":"organization"},{"asset_class":"region","name":"Gaza Strip","relevance":"primary","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["Exact date/time of the attack is not provided in the provided text.","The article text provided is largely non-informative HTML/CSS; only the headline and the supplied source summary contain the substantive claims.","Details on the circumstances of the killing (location within Gaza, method, whether Wishah was targeted) are not included in the provided material.","The source summary references other outlets/figures (e.g., U.S. News & World Report) but the specific attribution and wording are not fully available here."],"key_facts":["Al Jazeera states that an Israeli attack in Gaza killed its correspondent Mohammed Wishah.","The source summary indicates that medics reported four deaths in the Israeli strikes, including an Al Jazeera journalist (Mohammed Wishah).","The Palestinian Journalists\u2019 Syndicate is described as documenting 2 killings and 53 offences against journalists in March (as referenced in the source summary)."],"numeric_claims":[{"label":"journalist offences documented in March","value":"53"},{"label":"journalist killings documented in March","value":"2"},{"label":"deaths reported in the Israeli strikes (including the journalist)","value":"4"}],"primary_claim":"Israeli forces killed Al Jazeera journalist Mohammed Wishah in Gaza, according to Al Jazeera.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Al Jazeera reports that Israeli forces killed its Gaza correspondent Mohammed Wishah in an Israeli attack. The report also cites documentation of additional killings and violations against Palestinian journalists in March.","topics":["journalist safety","Gaza conflict","Israeli strikes","media freedom","reported killings of journalists"]},"source":"Al Jazeera","source_domain":"aljazeera.com","source_url":"https://www.aljazeera.com","summary":"Israeli attack kills Al Jazeera journalist Mohammed Wishah in Gaza Al Jazeera Israeli Strikes in Gaza Kill Four, Including Al Jazeera Journalist, Medics Say U.S. News & World Report Palestinian Journalists\u2019 Syndicate documents 2 killings, 53 offences against journalists in March Arab News PK Al Jazeera condemns the killing of its correspondent Mohammed Wishah in the Gaza Strip by Israeli occupation forces \u0627\u0644\u062c\u0632\u064a\u0631\u0629 \u0646\u062a 53 Israeli Violations Against Palestinian Journalists in One Month jordannews.jo","title":"Israeli attack kills Al Jazeera journalist Mohammed Wishah in Gaza - Al Jazeera","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

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 8199 in events