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-08T02:29:41.414143+00:00","dedupe_key":"signal_enriched:news_delta:245b77533416ac78","evidence_event_ids":["evt_c912e674e35e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5","as_of":"2026-04-08T02:29:41.414143+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/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4dfe96d935724fa7","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-08T03:52:14.725787+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5","source_event_id":"evt_c912e674e35e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ef77cc1112dd93d9","published_at":"2026-04-07T22:07:00+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Politico","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"","name":"social media","relevance":"high","symbol":"","type":"platform_category"},{"asset_class":"","name":"White House","relevance":"medium","symbol":"","type":"institution"},{"asset_class":"","name":"MILMAG","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the article\u2019s substantive content, so specific supporting details (e.g., platform, engagement metrics, policy actions, or timeline) are not available.","No date of publication or posting is included in the provided text.","The exact mechanism of \u201cgrowing power\u201d (e.g., algorithmic reach, platform policy changes, or audience size) is not specified in the provided text.","The \u201cMILMAG\u201d portion is only mentioned in the source summary; no concrete claims from that piece are included beyond the question framing."],"key_facts":["The headline references a Trump post containing the phrase \u201cCivilization will die.\u201d","The headline characterizes the post as showing Trump has \u201cno guard rails.\u201d","The headline states this demonstrates Trump\u2019s growing power over social media.","The provided source summary includes a framing question about whether social media is replacing diplomacy (attributed to \u201cRevolution in the White House \u2013 Are social media replacing diplomacy? MILMAG\u201d)."],"numeric_claims":[],"primary_claim":"A Politico article says Trump\u2019s social-media post (\u201cCivilization will die\u201d) demonstrates his growing power over social media and suggests he has \u201cno guard rails.\u201d","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"Politico reports that a Trump social-media post\u2014described as lacking \u201cguard rails\u201d\u2014signals his growing power over social media. The coverage frames this as a broader shift in influence, with implications for diplomacy and governance.","topics":["social media influence","political communication","Trump","White House/diplomacy framing"]},"source":"politico.com","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump with no guard rails: \u2018Civilization will die\u2019 post shows his growing power over social media politico.com Revolution in the White House \u2013 Are social media replacing diplomacy? MILMAG","title":"Trump with no guard rails: \u2018Civilization will die\u2019 post shows his growing power over social media - politico.com","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 4360 in events