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-03T11:58:33.773954+00:00","dedupe_key":"signal_enriched:news_delta:8b87363ab02aa313","evidence_event_ids":["evt_89a2a92927a7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QckdwWGdaUWRfeUstYnlMOXgwN19xWHc3NjhEMi01M2FTMWFHN0JSQzJHLXh5VVRUSFVHLTk5UDJVdW1vVkJVaHFMdFZHUjE3eU1EVFIwVkNVZw?oc=5","as_of":"2026-04-03T11:58:33.773954+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QckdwWGdaUWRfeUstYnlMOXgwN19xWHc3NjhEMi01M2FTMWFHN0JSQzJHLXh5VVRUSFVHLTk5UDJVdW1vVkJVaHFMdFZHUjE3eU1EVFIwVkNVZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_68fdae779c2e2b3f","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T22:19:02.355056+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QckdwWGdaUWRfeUstYnlMOXgwN19xWHc3NjhEMi01M2FTMWFHN0JSQzJHLXh5VVRUSFVHLTk5UDJVdW1vVkJVaHFMdFZHUjE3eU1EVFIwVkNVZw?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/CBMiWkFVX3lxTE1QckdwWGdaUWRfeUstYnlMOXgwN19xWHc3NjhEMi01M2FTMWFHN0JSQzJHLXh5VVRUSFVHLTk5UDJVdW1vVkJVaHFMdFZHUjE3eU1EVFIwVkNVZw?oc=5","source_event_id":"evt_89a2a92927a7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2df03a0fb679bb7f","published_at":"2026-04-03T10:18:11+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"IR","type":"country"},{"asset_class":"geopolitical","name":"United States","relevance":"high","symbol":"US","type":"country"}],"event_type":"regulation","information_gaps":["Specific details on the nature of the strikes are not provided.","No timeline for potential legal actions or responses is mentioned."],"key_facts":["Over 100 international law experts have condemned U.S. strikes on Iran.","The allegations suggest violations of the UN Charter."],"numeric_claims":[],"primary_claim":"Over 100 international law experts allege that U.S. strikes on Iran may constitute violations of international law and potential war crimes.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"International law experts have raised concerns that U.S. military strikes on Iran may violate the UN Charter and could be classified as war crimes.","topics":["international law","military strikes","war crimes","UN Charter"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"International law experts allege violations in Iran war BBC Over 100 International Law Experts Warn: U.S. Strikes on Iran Violate UN Charter and May Be War Crimes Just Security Trump pursues era of unshackled warfare Axios US experts say American strikes on Iran may amount to war crimes Reuters Over 100 US legal experts condemn strikes on Iran as possible \u2018war crimes\u2019 Al Jazeera","title":"International law experts allege violations in Iran war - BBC","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/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 6157 in events