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-06T19:27:27.991611+00:00","dedupe_key":"signal_enriched:news_delta:3db639a7cbef47ab","evidence_event_ids":["evt_695fa4c1c83d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQVzhwV0JRcmc5eWZaUHJHbU1xZEtmM0J1Z191ZTktaHRpdlpMQ1N1Ni1kRGxKZTZ6QW5TMFVVN2x1eWFQcVo0WXVRLVdqY2JGMy1ER2NlOWdRbk5IQmdHalkwLWpUaWRBWHREUUY5TGROM0NFX3JZdGZoeF9yUEo2NVM0YndYNm9LY21mdndCbHQ5UjluOTVGTGRKU0FIX2w3OHdDalkzcXZfckhqWmVXOXh5VkdPeFZtYzc5ZDYybUJ3Nk9NYTVfTUNEcXdCVl9QQThJR0I0dHRfSlIwaFYyMUpHU0toT3pBc2s2N1NxWFM3MEJncVdNdXJnb2N6dw?oc=5","as_of":"2026-04-06T19:27:27.991611+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/CBMi_gFBVV95cUxQVzhwV0JRcmc5eWZaUHJHbU1xZEtmM0J1Z191ZTktaHRpdlpMQ1N1Ni1kRGxKZTZ6QW5TMFVVN2x1eWFQcVo0WXVRLVdqY2JGMy1ER2NlOWdRbk5IQmdHalkwLWpUaWRBWHREUUY5TGROM0NFX3JZdGZoeF9yUEo2NVM0YndYNm9LY21mdndCbHQ5UjluOTVGTGRKU0FIX2w3OHdDalkzcXZfckhqWmVXOXh5VkdPeFZtYzc5ZDYybUJ3Nk9NYTVfTUNEcXdCVl9QQThJR0I0dHRfSlIwaFYyMUpHU0toT3pBc2s2N1NxWFM3MEJncVdNdXJnb2N6dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_529fd9e218788510","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-06T22:13:49.632268+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQVzhwV0JRcmc5eWZaUHJHbU1xZEtmM0J1Z191ZTktaHRpdlpMQ1N1Ni1kRGxKZTZ6QW5TMFVVN2x1eWFQcVo0WXVRLVdqY2JGMy1ER2NlOWdRbk5IQmdHalkwLWpUaWRBWHREUUY5TGROM0NFX3JZdGZoeF9yUEo2NVM0YndYNm9LY21mdndCbHQ5UjluOTVGTGRKU0FIX2w3OHdDalkzcXZfckhqWmVXOXh5VkdPeFZtYzc5ZDYybUJ3Nk9NYTVfTUNEcXdCVl9QQThJR0I0dHRfSlIwaFYyMUpHU0toT3pBc2s2N1NxWFM3MEJncVdNdXJnb2N6dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"detroitnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQVzhwV0JRcmc5eWZaUHJHbU1xZEtmM0J1Z191ZTktaHRpdlpMQ1N1Ni1kRGxKZTZ6QW5TMFVVN2x1eWFQcVo0WXVRLVdqY2JGMy1ER2NlOWdRbk5IQmdHalkwLWpUaWRBWHREUUY5TGROM0NFX3JZdGZoeF9yUEo2NVM0YndYNm9LY21mdndCbHQ5UjluOTVGTGRKU0FIX2w3OHdDalkzcXZfckhqWmVXOXh5VkdPeFZtYzc5ZDYybUJ3Nk9NYTVfTUNEcXdCVl9QQThJR0I0dHRfSlIwaFYyMUpHU0toT3pBc2s2N1NxWFM3MEJncVdNdXJnb2N6dw?oc=5","source_event_id":"evt_695fa4c1c83d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"906ab17ada1e1ec0","published_at":"2026-04-06T17:07:00+00:00","publisher_domain":"detroitnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026"],"entities":[{"asset_class":"political","name":"Mike Rogers","relevance":"high","symbol":"","type":"person"},{"asset_class":"political","name":"Republican super PAC","relevance":"high","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["Details on the specific strategies for the $45 million investment","Potential opponents in the Michigan Senate race"],"key_facts":["Investment of $45 million by a Republican group","Targeting the Michigan Senate race for the 2026 Midterms"],"numeric_claims":[{"label":"Amount of investment","value":"$45 million"}],"primary_claim":"A Republican super PAC is committing $45 million to help elect Mike Rogers to the Senate in Michigan.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"A Republican group plans to invest $45 million to support Mike Rogers in the Michigan Senate race ahead of the 2026 Midterms.","topics":["politics","elections","Republican Party","Senate race"]},"source":"The Detroit News","source_domain":"detroitnews.com","source_url":"https://www.detroitnews.com","summary":"Republican group to spend $45M to help Rogers win Michigan Senate race The Detroit News Ahead of 2026 Midterms, Republicans Unveil a $342 Million Battle Plan to Keep the Senate nytimes.com Republican super PAC's multi-hundred-million dollar ad buy shows a Senate GOP on defense Politico National Republicans to spend $29 million in Iowa's open Senate race The Des Moines Register Republican PAC commits $45 million to elect Mike Rogers to Senate Detroit Free Press","title":"Republican group to spend $45M to help Rogers win Michigan Senate race - The Detroit News","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 34027 in events