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/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

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_d7f764fa429a in signals