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-08T10:39:13.369653+00:00","dedupe_key":"signal_enriched:news_delta:7b56527a71fb766d","evidence_event_ids":["evt_ef5723d1da30"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","as_of":"2026-04-08T10:39:13.369653+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/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5004ef0e3ecc23cd","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-08T10:39:45.876900+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","source_event_id":"evt_ef5723d1da30","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ea6537439e5dc1a2","published_at":"2026-04-08T09:01:59+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Clay Fuller","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Marjorie Taylor Greene","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"","name":"G.O.P. (Republican Party)","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"","name":"Georgia","relevance":"high","symbol":"","type":"location"},{"asset_class":"","name":"Wisconsin","relevance":"medium","symbol":"","type":"location"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"CNN","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"BBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Politico","relevance":"low","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The supplied content does not include the article\u2019s full details or the specific \u201c3 takeaways\u201d mentioned in the headline.","Wisconsin election specifics (which race(s), margins, and winners/losers) are not provided in the supplied text.","The exact timing/date of the elections and runoffs is not included in the supplied text.","The provided text does not specify whether the Georgia result was a runoff election date or the final certification timing.","No direct market/sector impact is stated; any directional impact is therefore limited to political implications."],"key_facts":["The New York Times article frames the Georgia and Wisconsin election results as warnings for the GOP (exact takeaways not provided in the supplied text).","Democrats lost in Marjorie Taylor Greene\u2019s old district (Georgia 14th Congressional District), per the provided source summary.","CNN/BBC reporting in the provided summary states that Republican Clay Fuller won the election/runoff to replace Marjorie Taylor Greene\u2019s seat.","The provided summary states Democrats still had one of their best election nights in recent memory (context of Wisconsin results not included in the supplied text).","Politico is referenced in the provided summary as saying Democrats made big gains in key battlegrounds (specifics not included in the supplied text)."],"numeric_claims":[{"label":"District","value":"14th Congressional District"},{"label":"Takeaways","value":"3"}],"primary_claim":"Republican Clay Fuller won the Georgia 14th Congressional District runoff to replace Marjorie Taylor Greene, while Democrats still had one of their best election nights in recent memory.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The New York Times highlights election results in Georgia and Wisconsin as warning signs for the GOP, focusing on outcomes in Marjorie Taylor Greene\u2019s former district and broader battleground performance by Democrats.","topics":["U.S. elections","U.S. House races","Georgia 14th Congressional District","runoff election","partisan political strategy","battleground states"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Warnings for the G.O.P.: 3 Takeaways From the Elections in Georgia and Wisconsin The New York Times Democrats lost in Marjorie Taylor Greene\u2019s old district. They still had one of their best election nights in recent memory CNN Trump-backed Republican Clay Fuller wins election to replace Marjorie Taylor Greene BBC Republican Clay Fuller wins 14th Congressional District runoff, claims Marjorie Taylor Greene's seat gpb.org \u2018A wow moment\u2019: Democrats make big gains in key battlegrounds Politico","title":"Warnings for the G.O.P.: 3 Takeaways From the Elections in Georgia and Wisconsin - The New York Times","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 5983 in events