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/CBMi4gFBVV95cUxQaGk4V0VySUl0WVdCOGY1OG1SRmNQcDBJTExSS0VyRUxiTnVnR0k3RGRJc19kS09NZDdzR0tsRzBGUmFRWldGZ2F1MVZHeVpLT2NjQlRmR2laa0NwQWgzakJMbjJrLTJFWWVSalV6WG5JXzN6d1ExaDNTY1NzeGJNZHN1WTl4ZU9WclYzam9PNmVHZDJNYmVJRzl6NE1sR0lHV0pGQXQzMWN3VU13TDI2bkJTZHVTUnpacE9mMDRuTFRrcFRjTDlXWjRPZDRmX1BOazh1bERWTXVDUjFnblhCcXZ3?oc=5","as_of":"2026-04-10T08:49:48.085986+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/CBMi4gFBVV95cUxQaGk4V0VySUl0WVdCOGY1OG1SRmNQcDBJTExSS0VyRUxiTnVnR0k3RGRJc19kS09NZDdzR0tsRzBGUmFRWldGZ2F1MVZHeVpLT2NjQlRmR2laa0NwQWgzakJMbjJrLTJFWWVSalV6WG5JXzN6d1ExaDNTY1NzeGJNZHN1WTl4ZU9WclYzam9PNmVHZDJNYmVJRzl6NE1sR0lHV0pGQXQzMWN3VU13TDI2bkJTZHVTUnpacE9mMDRuTFRrcFRjTDlXWjRPZDRmX1BOazh1bERWTXVDUjFnblhCcXZ3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bb125695e5df7747","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-10T08:50:22.980793+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi4gFBVV95cUxQaGk4V0VySUl0WVdCOGY1OG1SRmNQcDBJTExSS0VyRUxiTnVnR0k3RGRJc19kS09NZDdzR0tsRzBGUmFRWldGZ2F1MVZHeVpLT2NjQlRmR2laa0NwQWgzakJMbjJrLTJFWWVSalV6WG5JXzN6d1ExaDNTY1NzeGJNZHN1WTl4ZU9WclYzam9PNmVHZDJNYmVJRzl6NE1sR0lHV0pGQXQzMWN3VU13TDI2bkJTZHVTUnpacE9mMDRuTFRrcFRjTDlXWjRPZDRmX1BOazh1bERWTXVDUjFnblhCcXZ3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi4gFBVV95cUxQaGk4V0VySUl0WVdCOGY1OG1SRmNQcDBJTExSS0VyRUxiTnVnR0k3RGRJc19kS09NZDdzR0tsRzBGUmFRWldGZ2F1MVZHeVpLT2NjQlRmR2laa0NwQWgzakJMbjJrLTJFWWVSalV6WG5JXzN6d1ExaDNTY1NzeGJNZHN1WTl4ZU9WclYzam9PNmVHZDJNYmVJRzl6NE1sR0lHV0pGQXQzMWN3VU13TDI2bkJTZHVTUnpacE9mMDRuTFRrcFRjTDlXWjRPZDRmX1BOazh1bERWTXVDUjFnblhCcXZ3?oc=5","source_event_id":"evt_1e2c403b20b6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4e35996dcf755c4e","published_at":"2026-04-10T05:27:47+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"MAGA critics / MAGA media figures","relevance":"high","symbol":"","type":"group"},{"asset_class":"","name":"Alex Jones","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Candace Owens","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"NBC News","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Forbes","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"The Independent","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"ABC News","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"WSJ (The Wall Street Journal)","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The excerpt does not include the full WSJ article text, specific quotes beyond the brief \u201closers\u201d/\u201cno longer care\u201d references, or the exact nature of the Iran policy disagreement.","No timing is provided for when the rant/attacks occurred or when the Iran-related split is expected to resolve.","The excerpt does not specify whether Trump\u2019s comments imply any concrete policy change toward Iran, only that the dispute is occurring amid Iran-related criticism."],"key_facts":["WSJ headline indicates Trump is lashing out at MAGA critics amid an Iran-related split.","The provided source summary states Trump bashes MAGA media figures over their criticism of a potential Iran war.","The source summary says Alex Jones and Candace Owens responded to Trump\u2019s attacks (details not provided in the excerpt).","The source summary says Trump issued a lengthy rant calling former MAGA faithfuls \u201closers,\u201d while also stating he \u201cno longer care[s] about that stuff\u201d (exact context not provided)."],"numeric_claims":[],"primary_claim":"Trump lashed out at MAGA critics who opposed or criticized his Iran-war approach, escalating internal MAGA tensions amid an Iran split.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"WSJ reports that Trump attacked MAGA media/influencer critics who have broken with him over their stance on Iran, deepening a rift within the MAGA movement. The headline frames the dispute as occurring amid an Iran-related split and includes references to responses from prominent figures.","topics":["MAGA internal politics","Iran policy dispute","Trump rhetoric","political media/influencers","party factionalism"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Trump Lashes Out at MAGA Critics Amid Iran Split WSJ Trump bashes MAGA media figures over their Iran war criticism NBC News MAGA Rift Deepens As Trump Attacks Iran War Critics\u2014Alex Jones And Candace Owens Respond Forbes Trump issues lengthy rant against former MAGA faithfuls he calls \u2018losers\u2019 but insists: \u2018I no longer care about that stuff\u2019 The Independent Trump blasts MAGA influencers who have split with him over Iran ABC News","title":"Trump Lashes Out at MAGA Critics Amid Iran Split - WSJ","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_078b226881c7 in signals