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-17T02:58:03.999489+00:00","dedupe_key":"signal_enriched:news_delta:1c438b124ea630d1","evidence_event_ids":["evt_5043b4bb7f3f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNSUVJWjlRTC1ja1JTZmdjanNlNHlBbURCdVpNYm1scm14OEVXaUJIcjBvdi1adnVYbFUzY3BVZ0Q0R2tXbkhVUmpLVlZPUndxSTdrM3VHNGFjS3JsUW95VWpCbm5kY1FSazE5amhRX3B5NUVGZ01xWUtrTWRDUW5yX1RWdVdTYnpGTUlWc2EzMkotVEVwM2hwNEVpT1RDUnpHVVhsNThIdkgwcmpQN3FzSEpqaGF0QWg2VUp2UG12WTRCWFlsNURSSg?oc=5","as_of":"2026-04-17T02:58:03.999489+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNSUVJWjlRTC1ja1JTZmdjanNlNHlBbURCdVpNYm1scm14OEVXaUJIcjBvdi1adnVYbFUzY3BVZ0Q0R2tXbkhVUmpLVlZPUndxSTdrM3VHNGFjS3JsUW95VWpCbm5kY1FSazE5amhRX3B5NUVGZ01xWUtrTWRDUW5yX1RWdVdTYnpGTUlWc2EzMkotVEVwM2hwNEVpT1RDUnpHVVhsNThIdkgwcmpQN3FzSEpqaGF0QWg2VUp2UG12WTRCWFlsNURSSg?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_be6d4446340da610","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T10:14:39.593160+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNSUVJWjlRTC1ja1JTZmdjanNlNHlBbURCdVpNYm1scm14OEVXaUJIcjBvdi1adnVYbFUzY3BVZ0Q0R2tXbkhVUmpLVlZPUndxSTdrM3VHNGFjS3JsUW95VWpCbm5kY1FSazE5amhRX3B5NUVGZ01xWUtrTWRDUW5yX1RWdVdTYnpGTUlWc2EzMkotVEVwM2hwNEVpT1RDUnpHVVhsNThIdkgwcmpQN3FzSEpqaGF0QWg2VUp2UG12WTRCWFlsNURSSg?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/CBMiyAFBVV95cUxNSUVJWjlRTC1ja1JTZmdjanNlNHlBbURCdVpNYm1scm14OEVXaUJIcjBvdi1adnVYbFUzY3BVZ0Q0R2tXbkhVUmpLVlZPUndxSTdrM3VHNGFjS3JsUW95VWpCbm5kY1FSazE5amhRX3B5NUVGZ01xWUtrTWRDUW5yX1RWdVdTYnpGTUlWc2EzMkotVEVwM2hwNEVpT1RDUnpHVVhsNThIdkgwcmpQN3FzSEpqaGF0QWg2VUp2UG12WTRCWFlsNURSSg?oc=5","source_event_id":"evt_5043b4bb7f3f","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ace44afe5141348f","published_at":"2026-04-17T01:21:00+00:00","publisher_domain":"theguardian.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: Progressive Democrat Analilia Mejia wins New Jersey special election for US House - The Guardian","Source summary: Progressive Democrat Analilia Mejia wins New Jersey special election for US House The Guardian Democrat Analilia Mejia will win House special election in New Jersey, CNN projects, further narrowing GOP majority CNN New Jersey 11th Congressional District Special 2026: Live Election Results, Mejia vs. Hathaway The New York Times Bernie Sanders, AOC-backed Democrat wins key House race as GOP fails to expand fragile majo"],"numeric_claims":[],"primary_claim":"Progressive Democrat Analilia Mejia wins New Jersey special election for US House - The Guardian","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Progressive Democrat Analilia Mejia wins New Jersey special election for US House The Guardian Democrat Analilia Mejia will win House special election in New Jersey, CNN projects, further narrowing GOP majority CNN New Jersey 11th Congressional District Special 2026: Live Election Results, Mejia vs. Hathaway The New York Times Bernie Sanders, AOC-backed Democrat wins key House race as GOP fails to","topics":["news headline"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Progressive Democrat Analilia Mejia wins New Jersey special election for US House The Guardian Democrat Analilia Mejia will win House special election in New Jersey, CNN projects, further narrowing GOP majority CNN New Jersey 11th Congressional District Special 2026: Live Election Results, Mejia vs. Hathaway The New York Times Bernie Sanders, AOC-backed Democrat wins key House race as GOP fails to expand fragile majority Fox News Progressive Democrat Analilia Mejia wins New Jersey special election for US House seat \u2013 US politics live The Guardian","title":"Progressive Democrat Analilia Mejia wins New Jersey special election for US House - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 63484 in events