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/CBMiqgFBVV95cUxPb1dZTDNGLXdaaV9DbXUxR1AxREt0YkQwbHF0UTNxbHFJSmtKTWI0SGlxbWIwUlRKQkllWExvZkRvbmpQbHFvYTVpcFZKZm1mZzRJeE54VndHQWMwZUktMHQ0V0dvTXJ2dzNnVXpVei1YQUZhTWlLVW8zRTRFT2pKVnpKQVY4cGRLdHRsanozU2FrVjlEbnlHa2N4b1ZTZHlPenR2aGMxWjVWUQ?oc=5","as_of":"2026-04-08T01:12:25.553520+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/CBMiqgFBVV95cUxPb1dZTDNGLXdaaV9DbXUxR1AxREt0YkQwbHF0UTNxbHFJSmtKTWI0SGlxbWIwUlRKQkllWExvZkRvbmpQbHFvYTVpcFZKZm1mZzRJeE54VndHQWMwZUktMHQ0V0dvTXJ2dzNnVXpVei1YQUZhTWlLVW8zRTRFT2pKVnpKQVY4cGRLdHRsanozU2FrVjlEbnlHa2N4b1ZTZHlPenR2aGMxWjVWUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_92ddba3208a515a4","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-08T01:14:28.677277+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxPb1dZTDNGLXdaaV9DbXUxR1AxREt0YkQwbHF0UTNxbHFJSmtKTWI0SGlxbWIwUlRKQkllWExvZkRvbmpQbHFvYTVpcFZKZm1mZzRJeE54VndHQWMwZUktMHQ0V0dvTXJ2dzNnVXpVei1YQUZhTWlLVW8zRTRFT2pKVnpKQVY4cGRLdHRsanozU2FrVjlEbnlHa2N4b1ZTZHlPenR2aGMxWjVWUQ?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/CBMiqgFBVV95cUxPb1dZTDNGLXdaaV9DbXUxR1AxREt0YkQwbHF0UTNxbHFJSmtKTWI0SGlxbWIwUlRKQkllWExvZkRvbmpQbHFvYTVpcFZKZm1mZzRJeE54VndHQWMwZUktMHQ0V0dvTXJ2dzNnVXpVei1YQUZhTWlLVW8zRTRFT2pKVnpKQVY4cGRLdHRsanozU2FrVjlEbnlHa2N4b1ZTZHlPenR2aGMxWjVWUQ?oc=5","source_event_id":"evt_840e4fde6fbd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aac51828b082a9f8","published_at":"2026-04-08T00:25:58+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"Clay Fuller","relevance":"primary","symbol":"","type":"person"},{"asset_class":"equity","name":"Marjorie Taylor Greene","relevance":"primary","symbol":"","type":"person"},{"asset_class":"political_region","name":"Georgia 14th Congressional District","relevance":"primary","symbol":"","type":"electoral_district"},{"asset_class":"political_party","name":"GOP (Republican Party)","relevance":"secondary","symbol":"","type":"political_party"},{"asset_class":"political_institution","name":"U.S. House of Representatives","relevance":"secondary","symbol":"","type":"government_body"}],"event_type":"listing","information_gaps":["The provided text does not include the final vote totals/margins or the exact election date.","\u201cWins\u201d vs \u201cprojected to win\u201d is not fully reconciled in the excerpt; some sources are described as projections (e.g., CNN projection) while Politico headline states the win.","No details are provided on the opponent (e.g., \u201cHarris vs. Fuller\u201d) beyond the name fragment in the source summary."],"key_facts":["Clay Fuller is reported/projected to win a Georgia special election/runoff to replace Marjorie Taylor Greene in the U.S. House.","The seat is described as Marjorie Taylor Greene\u2019s former seat.","The outcome is characterized as increasing/padding the GOP\u2019s narrow/fragile House majority."],"numeric_claims":[],"primary_claim":"Republican Clay Fuller won the Georgia special election/runoff to replace Marjorie Taylor Greene\u2019s former House seat.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Clay Fuller, a Republican, is projected to win (and is reported as winning) Georgia\u2019s special election/runoff to replace Marjorie Taylor Greene in the U.S. House. The result is described as padding the GOP\u2019s fragile House majority.","topics":["U.S. elections","Georgia special election","U.S. House majority","Republican Party","replacement of Marjorie Taylor Greene"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Republican Clay Fuller wins special election to replace Marjorie Taylor Greene Politico Republican Clay Fuller will win Georgia special election to replace Marjorie Taylor Greene, CNN projects CNN Georgia 14th Congressional District Special Runoff 2026: Live Election Results, Harris vs. Fuller The New York Times Trump-backed Republican pads GOP's fragile House majority by winning showdown for MTG's former seat Fox News Republican Clay Fuller projected to win Georgia runoff to replace Marjorie Taylor Greene in House, helping GOP's narrow majority CBS News","title":"Republican Clay Fuller wins special election to replace Marjorie Taylor Greene - 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_f8d47b093444 in signals