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-06T21:50:13.364591+00:00","dedupe_key":"signal_enriched:news_delta:efcac013303515a9","evidence_event_ids":["evt_906c1446324b"],"signal_type":"news_headline_delta","source":"news_rss","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

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