SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_cfbb294b3aa2 in signals