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/CBMiqwFBVV95cUxPbXM2bVJYVXR4SGJ0SEZkUEp3QU5MZ1hzd1ltS0Nqel9xcVNqVFJXNFgyd25JX3E3TzV0UHB4SThNT0ZlSnJrNjRiUWtFbVlkUVpxNTFlWlA3NFE0NC1UTE9FSFk0MUxEamhzMmhBaU9mTFc0Z0Q0R0hxcURfR1JfeXEyNENKWkVnNi1rbTJUUXFLSXlIdGFXZ3MtTWNuTjByUnY0cG1Wb2NZUHM?oc=5","as_of":"2026-04-10T19:36:11.866868+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/CBMiqwFBVV95cUxPbXM2bVJYVXR4SGJ0SEZkUEp3QU5MZ1hzd1ltS0Nqel9xcVNqVFJXNFgyd25JX3E3TzV0UHB4SThNT0ZlSnJrNjRiUWtFbVlkUVpxNTFlWlA3NFE0NC1UTE9FSFk0MUxEamhzMmhBaU9mTFc0Z0Q0R0hxcURfR1JfeXEyNENKWkVnNi1rbTJUUXFLSXlIdGFXZ3MtTWNuTjByUnY0cG1Wb2NZUHM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9aa9c91448b8e93d","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-10T20:15:00.049808+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxPbXM2bVJYVXR4SGJ0SEZkUEp3QU5MZ1hzd1ltS0Nqel9xcVNqVFJXNFgyd25JX3E3TzV0UHB4SThNT0ZlSnJrNjRiUWtFbVlkUVpxNTFlWlA3NFE0NC1UTE9FSFk0MUxEamhzMmhBaU9mTFc0Z0Q0R0hxcURfR1JfeXEyNENKWkVnNi1rbTJUUXFLSXlIdGFXZ3MtTWNuTjByUnY0cG1Wb2NZUHM?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/CBMiqwFBVV95cUxPbXM2bVJYVXR4SGJ0SEZkUEp3QU5MZ1hzd1ltS0Nqel9xcVNqVFJXNFgyd25JX3E3TzV0UHB4SThNT0ZlSnJrNjRiUWtFbVlkUVpxNTFlWlA3NFE0NC1UTE9FSFk0MUxEamhzMmhBaU9mTFc0Z0Q0R0hxcURfR1JfeXEyNENKWkVnNi1rbTJUUXFLSXlIdGFXZ3MtTWNuTjByUnY0cG1Wb2NZUHM?oc=5","source_event_id":"evt_91add92b0469","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"24569d97e86c4e09","published_at":"2026-04-10T17:47:04+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"James Blair","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"White House","relevance":"high","symbol":"","type":"organization"},{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Trump\u2019s political operation (midterms push)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"","name":"Politico","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"Axios","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Bloomberg","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"News18","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The signal does not specify Blair\u2019s exact White House role/title.","The signal does not provide the timing window (specific dates/weeks) for the temporary departure.","The signal does not state whether Blair has formally resigned or only is considering the move.","The signal does not describe the scope of responsibilities in Trump\u2019s midterms operation (e.g., campaign vs. party vs. advisory role).","The signal does not quantify expected impact on White House operations or on the midterms effort."],"key_facts":["Politico: James Blair is considering a temporary departure from the White House to run or support Trump\u2019s political operation for the midterms.","The signal summary indicates other outlets (Axios, Bloomberg, News18) also frame Blair\u2019s potential move as likely and tied to the midterms push."],"numeric_claims":[],"primary_claim":"James Blair is considering temporarily leaving the White House to run Trump\u2019s political operation for the midterms.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Politico reports that James Blair is considering a temporary departure from the White House to run or support Donald Trump\u2019s political operation for the midterms. Multiple outlets cited in the signal frame this as a likely exit timed around the midterms push.","topics":["White House staffing","political operations","U.S. midterm elections","personnel change","Trump campaign/party strategy"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"James Blair considering temporary White House departure for Trump\u2019s political operation Politico James Blair eyes White House leave to run Trump's midterms push Axios Top White House Aide Weighing Temporary Exit for Midterms Role Bloomberg White House Official James Blair Likely To Depart For Trump\u2019s Political Operation News18","title":"James Blair considering temporary White House departure for Trump\u2019s political operation - Politico","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_b22aef43e6b4 in signals