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-20T17:59:52.305762+00:00","dedupe_key":"signal_enriched:news_delta:9c660b453839061f","evidence_event_ids":["evt_3b9f0a9a783a"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNZkdubGZUbTlsd3QyclBOWVdlM2lHZDVlMXBBR0pONDQycGdKOU9oX09tWU5lY1Y5cExNNWUtZEYzQVppbXloa3JFYThjOFVQcUhJUXo5MVBsaXBiaWptbElITTc1bXVjS2luT205LVE5bFl3Y0YtNGVnbVd1T1locGZMc0J0UWdvOGgyRDRfVQ?oc=5","as_of":"2026-04-20T17:59:52.305762+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAwCAA2YBAwpA/d=1/ed=1/rs=ALs0n2NV-71auisiPoMssa7fQQcI34pwVg/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNZkdubGZUbTlsd3QyclBOWVdlM2lHZDVlMXBBR0pONDQycGdKOU9oX09tWU5lY1Y5cExNNWUtZEYzQVppbXloa3JFYThjOFVQcUhJUXo5MVBsaXBiaWptbElITTc1bXVjS2luT205LVE5bFl3Y0YtNGVnbVd1T1locGZMc0J0UWdvOGgyRDRfVQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6d3d0c2afb313ecd","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAwCAA2YBAwpA/d=1/ed=1/rs=ALs0n2NV-71auisiPoMssa7fQQcI34pwVg/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T18:28:45.079417+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNZkdubGZUbTlsd3QyclBOWVdlM2lHZDVlMXBBR0pONDQycGdKOU9oX09tWU5lY1Y5cExNNWUtZEYzQVppbXloa3JFYThjOFVQcUhJUXo5MVBsaXBiaWptbElITTc1bXVjS2luT205LVE5bFl3Y0YtNGVnbVd1T1locGZMc0J0UWdvOGgyRDRfVQ?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/CBMijwFBVV95cUxNZkdubGZUbTlsd3QyclBOWVdlM2lHZDVlMXBBR0pONDQycGdKOU9oX09tWU5lY1Y5cExNNWUtZEYzQVppbXloa3JFYThjOFVQcUhJUXo5MVBsaXBiaWptbElITTc1bXVjS2luT205LVE5bFl3Y0YtNGVnbVd1T1locGZMc0J0UWdvOGgyRDRfVQ?oc=5","source_event_id":"evt_3b9f0a9a783a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"8f4b72c361326909","published_at":"2026-04-20T09:02:39+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Big Names Wait in the Wings as Virginians Decide Their House Maps - The New York Times","Source summary: Big Names Wait in the Wings as Virginians Decide Their House Maps The New York Times Pinwheels and the \u2018lobster district\u2019: How Virginia Democrats drew up a US House map to all but lock out Republicans CNN Voters say they feel confused and misled on Virginia's redistricting vote NPR Eric Holder accuses GOP of 'stealing seats' while defending 'fair' Democratic redistricting push Fox News Virginia redistricting referend"],"numeric_claims":[],"primary_claim":"Big Names Wait in the Wings as Virginians Decide Their House Maps - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Big Names Wait in the Wings as Virginians Decide Their House Maps The New York Times Pinwheels and the \u2018lobster district\u2019: How Virginia Democrats drew up a US House map to all but lock out Republicans CNN Voters say they feel confused and misled on Virginia's redistricting vote NPR Eric Holder accuses GOP of 'stealing seats' while defending 'fair' Democratic redistricting push Fox News Virginia re","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Big Names Wait in the Wings as Virginians Decide Their House Maps The New York Times Pinwheels and the \u2018lobster district\u2019: How Virginia Democrats drew up a US House map to all but lock out Republicans CNN Voters say they feel confused and misled on Virginia's redistricting vote NPR Eric Holder accuses GOP of 'stealing seats' while defending 'fair' Democratic redistricting push Fox News Virginia redistricting referendum could have national implications WTOP","title":"Big Names Wait in the Wings as Virginians Decide Their House Maps - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAwCAA2YBAwpA/d=1/ed=1/rs=ALs0n2NV-71auisiPoMssa7fQQcI34pwVg/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 462090 in events