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-10T03:46:52.525050+00:00","dedupe_key":"signal_enriched:news_delta:ebaf6e353cb448f0","evidence_event_ids":["evt_eb4125454250"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxOdU1RUWVEX3N1b2xOdjVhMjR2OV9MOFBuQjREUEhNdmZxQUEyV0d5SE53R0FCRVl2YmxiR0ZDSFZvaWpHRkc3TzJJeTVMYmwtZUR5eWpvZjlhMGpmRnRmZGdwN0Rha0Q1X01hNkVkY2lXTnN5eGZwaE9rYUdTU0VlRTRnVjFvbWlDZFp6RGdaNW5KYVA4aXJIVTZLMl9JLVR4UHUteXNYNVRWUzZSNmlDVDJrcXV0LS1jQ1g5ZWlzaThaajR3V3FkaDdsMXE?oc=5","as_of":"2026-04-10T03:46:52.525050+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/CBMizAFBVV95cUxOdU1RUWVEX3N1b2xOdjVhMjR2OV9MOFBuQjREUEhNdmZxQUEyV0d5SE53R0FCRVl2YmxiR0ZDSFZvaWpHRkc3TzJJeTVMYmwtZUR5eWpvZjlhMGpmRnRmZGdwN0Rha0Q1X01hNkVkY2lXTnN5eGZwaE9rYUdTU0VlRTRnVjFvbWlDZFp6RGdaNW5KYVA4aXJIVTZLMl9JLVR4UHUteXNYNVRWUzZSNmlDVDJrcXV0LS1jQ1g5ZWlzaThaajR3V3FkaDdsMXE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7d6f67ea599b1222","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-10T03:48:13.069204+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxOdU1RUWVEX3N1b2xOdjVhMjR2OV9MOFBuQjREUEhNdmZxQUEyV0d5SE53R0FCRVl2YmxiR0ZDSFZvaWpHRkc3TzJJeTVMYmwtZUR5eWpvZjlhMGpmRnRmZGdwN0Rha0Q1X01hNkVkY2lXTnN5eGZwaE9rYUdTU0VlRTRnVjFvbWlDZFp6RGdaNW5KYVA4aXJIVTZLMl9JLVR4UHUteXNYNVRWUzZSNmlDVDJrcXV0LS1jQ1g5ZWlzaThaajR3V3FkaDdsMXE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"variety.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxOdU1RUWVEX3N1b2xOdjVhMjR2OV9MOFBuQjREUEhNdmZxQUEyV0d5SE53R0FCRVl2YmxiR0ZDSFZvaWpHRkc3TzJJeTVMYmwtZUR5eWpvZjlhMGpmRnRmZGdwN0Rha0Q1X01hNkVkY2lXTnN5eGZwaE9rYUdTU0VlRTRnVjFvbWlDZFp6RGdaNW5KYVA4aXJIVTZLMl9JLVR4UHUteXNYNVRWUzZSNmlDVDJrcXV0LS1jQ1g5ZWlzaThaajR3V3FkaDdsMXE?oc=5","source_event_id":"evt_eb4125454250","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"341b7ad92a58af93","published_at":"2026-04-09T21:29:00+00:00","publisher_domain":"variety.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Tucker Carlson","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Megyn Kelly","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Candace Owens","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Alex Jones","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"location"},{"asset_class":"","name":"Variety","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so details of the quote context, timing, and whether it was a post/interview are not verifiable from the supplied content.","The signal does not specify what specific Iran-war policy/action Trump supports (e.g., strike, escalation, authorization) beyond \u201copposing an Iran war.\u201d","No near-term catalyst timing is stated in the provided headline/summary beyond the fact of Trump\u2019s remarks."],"key_facts":["Variety headline states Donald Trump \u201cslams\u201d Tucker Carlson, Megyn Kelly, Candace Owens, and Alex Jones.","The criticism is tied to their opposition to an Iran war.","Trump is quoted using derogatory terms including \u201cnut jobs\u201d and \u201cstupid people.\u201d"],"numeric_claims":[],"primary_claim":"Donald Trump criticized Tucker Carlson, Megyn Kelly, Candace Owens, and Alex Jones for opposing an Iran war, using derogatory language (\u201cnut jobs,\u201d \u201cstupid people\u201d).","relevance_score":0.55,"sentiment":"negative","source_quality":"high","summary":"Variety reports that Donald Trump attacked several prominent media/political commentators\u2014Tucker Carlson, Megyn Kelly, Candace Owens, and Alex Jones\u2014calling them \u201cnut jobs\u201d and \u201cstupid people\u201d for opposing an Iran war.","topics":["Iran war","Trump criticism","MAGA media figures","political commentary","U.S. foreign policy debate"]},"source":"Variety","source_domain":"variety.com","source_url":"https://variety.com","summary":"Donald Trump Slams 'Nut Jobs' Tucker Carlson, Megyn Kelly, Candace Owens, Alex Jones for Opposing Iran War: 'They're Stupid People' Variety Trump bashes MAGA media figures over their Iran war criticism NBC News Trump Lashes Out at \u2018NUT JOBS\u2019 Tucker Carlson, Alex Jones, Megyn Kelly Rolling Stone Trump blasts MAGA influencers who have split with him over Iran ABC News Donald Trump Rails Against Tucker Carlson, Megyn Kelly & Candace Owens Deadline","title":"Donald Trump Slams 'Nut Jobs' Tucker Carlson, Megyn Kelly, Candace Owens, Alex Jones for Opposing Iran War: 'They're Stupid People' - Variety","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 14035 in events