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-06T18:37:01.222933+00:00","dedupe_key":"signal_enriched:news_delta:26bc8c6a0103e04e","evidence_event_ids":["evt_109baf7929af"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE13SkRzV3ZmWXMwX2dnUUl3VDk5V2U2RVJSdlBydXpvd2RQVkR3amZUM1l2SVpOaEFkTVJzZlVmY1pHendqTmdpVGpXN0dUaUVZc1EzVWh3V3h6R0NIQVJ6Y1d2UGxtazMtOWZGRlNjYWc1VUN4WWRoR0RTWTFmZWc?oc=5","as_of":"2026-04-06T18:37:01.222933+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/CBMif0FVX3lxTE13SkRzV3ZmWXMwX2dnUUl3VDk5V2U2RVJSdlBydXpvd2RQVkR3amZUM1l2SVpOaEFkTVJzZlVmY1pHendqTmdpVGpXN0dUaUVZc1EzVWh3V3h6R0NIQVJ6Y1d2UGxtazMtOWZGRlNjYWc1VUN4WWRoR0RTWTFmZWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bbb3bd3f143d29eb","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-06T19:12:17.065872+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE13SkRzV3ZmWXMwX2dnUUl3VDk5V2U2RVJSdlBydXpvd2RQVkR3amZUM1l2SVpOaEFkTVJzZlVmY1pHendqTmdpVGpXN0dUaUVZc1EzVWh3V3h6R0NIQVJ6Y1d2UGxtazMtOWZGRlNjYWc1VUN4WWRoR0RTWTFmZWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"justsecurity.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE13SkRzV3ZmWXMwX2dnUUl3VDk5V2U2RVJSdlBydXpvd2RQVkR3amZUM1l2SVpOaEFkTVJzZlVmY1pHendqTmdpVGpXN0dUaUVZc1EzVWh3V3h6R0NIQVJ6Y1d2UGxtazMtOWZGRlNjYWc1VUN4WWRoR0RTWTFmZWc?oc=5","source_event_id":"evt_109baf7929af","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0649cd29d600eb16","published_at":"2026-04-06T12:45:51+00:00","publisher_domain":"justsecurity.org","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":"geopolitical_risk","information_gaps":["Specific timing of potential U.S. military actions is unclear.","The response from Iran to U.S. threats is not detailed."],"key_facts":["Trump has made threats regarding military action in Iran.","Over 100 international law experts have expressed concerns about U.S. actions in Iran.","The rhetoric surrounding potential military actions raises fears of escalating conflict."],"numeric_claims":[],"primary_claim":"Over 100 international law experts warn that U.S. strikes on Iran may violate the UN Charter and could be classified as war crimes.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"The article discusses the implications of U.S. rhetoric regarding potential war crimes in Iran, highlighting concerns from international law experts about violations of the UN Charter.","topics":["war crimes","Iran","U.S. foreign policy","international law"]},"source":"Just Security","source_domain":"justsecurity.org","source_url":"https://www.justsecurity.org","summary":"When War Crimes Rhetoric Becomes Battlefield Reality: The Slippery Slope to Total War on Iran Just Security Trump Revels in Threats to Commit War Crimes in Iran The New York Times Trump pursues era of unshackled warfare Axios Over 100 International Law Experts Warn: U.S. Strikes on Iran Violate UN Charter and May Be War Crimes Just Security International law experts allege violations in Iran war BBC","title":"When War Crimes Rhetoric Becomes Battlefield Reality: The Slippery Slope to Total War on Iran - Just Security","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 33159 in events