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/CBMigwFBVV95cUxOdlpzRDlRLW1KSXk0SDZWRV9VbG1yeEdJUjYwd2JMYVA4a3ExV2VrYWxRVE9YN3RuUlBJWHNoSzJvR1RoQ21WRElmZXBDVVJVaUFhaFBMSTNGXzFzUXZnZ3o0OHhnOFdhSzNWRDhyNmdGX29aSl9qV2poQ1EtYzFjRXkwTQ?oc=5","as_of":"2026-04-08T03:15:56.586737+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOdlpzRDlRLW1KSXk0SDZWRV9VbG1yeEdJUjYwd2JMYVA4a3ExV2VrYWxRVE9YN3RuUlBJWHNoSzJvR1RoQ21WRElmZXBDVVJVaUFhaFBMSTNGXzFzUXZnZ3o0OHhnOFdhSzNWRDhyNmdGX29aSl9qV2poQ1EtYzFjRXkwTQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_086a56dfa6d2103f","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:48:10.805721+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOdlpzRDlRLW1KSXk0SDZWRV9VbG1yeEdJUjYwd2JMYVA4a3ExV2VrYWxRVE9YN3RuUlBJWHNoSzJvR1RoQ21WRElmZXBDVVJVaUFhaFBMSTNGXzFzUXZnZ3o0OHhnOFdhSzNWRDhyNmdGX29aSl9qV2poQ1EtYzFjRXkwTQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOdlpzRDlRLW1KSXk0SDZWRV9VbG1yeEdJUjYwd2JMYVA4a3ExV2VrYWxRVE9YN3RuUlBJWHNoSzJvR1RoQ21WRElmZXBDVVJVaUFhaFBMSTNGXzFzUXZnZ3o0OHhnOFdhSzNWRDhyNmdGX29aSl9qV2poQ1EtYzFjRXkwTQ?oc=5","source_event_id":"evt_ec5bf9fd6bd2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cd6acb0d735efb31","published_at":"2026-04-08T00:46:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"political_office","name":"Marjorie Taylor Greene","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_party","name":"Republicans","relevance":"high","symbol":"","type":"group"},{"asset_class":"state","name":"Georgia","relevance":"high","symbol":"","type":"place"},{"asset_class":"political_office","name":"Clay Fuller","relevance":"medium","symbol":"","type":"person"}],"event_type":"listing","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual news content, so details like vote margin, date of the runoff, and official election results are not verifiable from the provided text.","The headline delta implies a replacement outcome, but the exact timing (e.g., when the new member is seated) is not specified.","The signal does not include the name of the Republican winner in the headline itself; it is only mentioned in the multi-source summary as Clay Fuller."],"key_facts":["The headline states a Republican won a Georgia runoff election to replace Marjorie Taylor Greene.","The provided source summary includes that the winner is Clay Fuller (described as a Trump-backed Republican) replacing Greene.","The signal indicates this is an election outcome (runoff) rather than a policy or market event."],"numeric_claims":[],"primary_claim":"Republicans won the Georgia runoff election to replace Marjorie Taylor Greene.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"A Republican won a Georgia runoff election to fill the U.S. House seat currently held by Marjorie Taylor Greene. This changes the seat\u2019s representation from Greene to the winning Republican candidate, with near-term implications for House party balance.","topics":["Georgia runoff election","U.S. House seat replacement","Marjorie Taylor Greene","Republican victory","party control"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Republican wins Georgia runoff election to replace Marjorie Taylor Greene The Guardian Election Live Updates: Georgia House Special and Wisconsin Supreme Court Races Tonight The New York Times Republicans win Georgia race \u2014 but Democrats post largest swing yet in special House elections NBC News Trump-backed Republican Clay Fuller wins election to replace Marjorie Taylor Greene bbc.com Opinion | Who will replace Marjorie Taylor Greene? In Georgia\u2019s 14th, I saw clues. The Washington Post","title":"Republican wins Georgia runoff election to replace Marjorie Taylor Greene - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_ef3388dbe6ff in signals