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/CBMiWkFVX3lxTFBHSFNORWttZHZabzY5T2VJT2ZkWEZjUzQxLWFFZk5oUTNIY3VKejl1TmwzSHFvQjRhZ2JLbkRTUmJjdzJNbWZUZDV0UVlETkQ3VVdJZ0dRd3RBZw?oc=5","as_of":"2026-04-08T02:13:53.681108+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/CBMiWkFVX3lxTFBHSFNORWttZHZabzY5T2VJT2ZkWEZjUzQxLWFFZk5oUTNIY3VKejl1TmwzSHFvQjRhZ2JLbkRTUmJjdzJNbWZUZDV0UVlETkQ3VVdJZ0dRd3RBZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f2413920209c3431","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-08T02:14:42.202581+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBHSFNORWttZHZabzY5T2VJT2ZkWEZjUzQxLWFFZk5oUTNIY3VKejl1TmwzSHFvQjRhZ2JLbkRTUmJjdzJNbWZUZDV0UVlETkQ3VVdJZ0dRd3RBZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBHSFNORWttZHZabzY5T2VJT2ZkWEZjUzQxLWFFZk5oUTNIY3VKejl1TmwzSHFvQjRhZ2JLbkRTUmJjdzJNbWZUZDV0UVlETkQ3VVdJZ0dRd3RBZw?oc=5","source_event_id":"evt_d8127b37b1bd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"50ae3c77b87ae9ad","published_at":"2026-04-08T00:37:00+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"politics","name":"Clay Fuller","relevance":"primary","symbol":"","type":"person"},{"asset_class":"politics","name":"Marjorie Taylor Greene","relevance":"primary","symbol":"","type":"person"},{"asset_class":"politics","name":"Donald Trump","relevance":"supporting","symbol":"","type":"person"},{"asset_class":"politics","name":"Georgia House (special election runoff)","relevance":"context","symbol":"","type":"election"}],"event_type":"listing","information_gaps":["The provided article text is not actually present (only CSS/HTML), so details like vote totals, election date, and district number are not verifiable from the supplied content.","The signal does not specify whether the seat is Georgia\u2019s 14th congressional district (commonly associated with Greene) or another seat; this is not confirmed in the provided text.","Timing (exact date of the runoff and when Fuller will take office) is not included in the supplied material."],"key_facts":["BBC headline states Clay Fuller (Trump-backed Republican) won an election to replace Marjorie Taylor Greene.","The election is described as a runoff/special election to pick Greene\u2019s successor."],"numeric_claims":[],"primary_claim":"Clay Fuller, a Trump-backed Republican, won the election to replace Marjorie Taylor Greene.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"BBC reports that Trump-backed Republican Clay Fuller won a Georgia House special election runoff to replace Marjorie Taylor Greene in Congress.","topics":["US politics","Georgia special election","Republican Party","Trump-backed candidate","Congressional seat change"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Trump-backed Republican Clay Fuller wins election to replace Marjorie Taylor Greene BBC Election Live Updates: Georgia House Special and Wisconsin Supreme Court Races Tonight The New York Times Republican wins runoff to replace Marjorie Taylor Greene in Congress The Washington Post Here\u2019s what Cobb County voters had to say about the race to pick Marjorie Taylor Greene\u2019s successor Georgia Recorder Georgia House Special Runoff Election 2026 Live Results NBC News","title":"Trump-backed Republican Clay Fuller wins election to replace Marjorie Taylor Greene - BBC","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_4f96f344fd29 in signals