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-08T02:13:53.681108+00:00","dedupe_key":"signal_enriched:news_delta:a502c9b3ee84b7ef","evidence_event_ids":["evt_d8127b37b1bd"],"signal_type":"news_headline_delta","source":"news_rss","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

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 3459 in events