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-19T12:01:23.059531+00:00","dedupe_key":"signal_enriched:news_delta:0f9965e2c464d386","evidence_event_ids":["evt_48c0f1a7f94f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxPS0cwNG5ycUlDdnRpZTNCUXRxLUNzWkl0MkNOVVV1NS1oZUM4MVlpU3pfNFRZcWIzcFlzNlY5em8xRlRCTDFQbnVhNnlJOElnQVFBbW56TG1mbGVjYWNfY1B1NTh2b2FlNDN0SUJ5el83b0pJWHNVYkQ3TFhIbWt3aXQxYlY0U0FMTnhyZw?oc=5","as_of":"2026-04-19T12:01:23.059531+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/CBMijAFBVV95cUxPS0cwNG5ycUlDdnRpZTNCUXRxLUNzWkl0MkNOVVV1NS1oZUM4MVlpU3pfNFRZcWIzcFlzNlY5em8xRlRCTDFQbnVhNnlJOElnQVFBbW56TG1mbGVjYWNfY1B1NTh2b2FlNDN0SUJ5el83b0pJWHNVYkQ3TFhIbWt3aXQxYlY0U0FMTnhyZw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0ce010bded5c0c4a","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-19T12:24:59.844727+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxPS0cwNG5ycUlDdnRpZTNCUXRxLUNzWkl0MkNOVVV1NS1oZUM4MVlpU3pfNFRZcWIzcFlzNlY5em8xRlRCTDFQbnVhNnlJOElnQVFBbW56TG1mbGVjYWNfY1B1NTh2b2FlNDN0SUJ5el83b0pJWHNVYkQ3TFhIbWt3aXQxYlY0U0FMTnhyZw?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/CBMijAFBVV95cUxPS0cwNG5ycUlDdnRpZTNCUXRxLUNzWkl0MkNOVVV1NS1oZUM4MVlpU3pfNFRZcWIzcFlzNlY5em8xRlRCTDFQbnVhNnlJOElnQVFBbW56TG1mbGVjYWNfY1B1NTh2b2FlNDN0SUJ5el83b0pJWHNVYkQ3TFhIbWt3aXQxYlY0U0FMTnhyZw?oc=5","source_event_id":"evt_48c0f1a7f94f","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"70b4730e8170d48a","published_at":"2026-04-19T04:01:06+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: What to Know About the Bulgarian Election - The New York Times","Source summary: What to Know About the Bulgarian Election The New York Times Bulgaria votes as pro-Russian former president leads the polls Reuters Bulgarians head to polls for eighth time in five years Al Jazeera Fighter pilot Rumen Radev looks to break Bulgaria\u2019s political deadlock politico.eu After Orban\u2019s defeat in Hungary, Bulgaria offers Kremlin\u2019s next best bet The Washington Post"],"numeric_claims":[],"primary_claim":"What to Know About the Bulgarian Election - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"What to Know About the Bulgarian Election The New York Times Bulgaria votes as pro-Russian former president leads the polls Reuters Bulgarians head to polls for eighth time in five years Al Jazeera Fighter pilot Rumen Radev looks to break Bulgaria\u2019s political deadlock politico.eu After Orban\u2019s defeat in Hungary, Bulgaria offers Kremlin\u2019s next best bet The Washington Post","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"What to Know About the Bulgarian Election The New York Times Bulgaria votes as pro-Russian former president leads the polls Reuters Bulgarians head to polls for eighth time in five years Al Jazeera Fighter pilot Rumen Radev looks to break Bulgaria\u2019s political deadlock politico.eu After Orban\u2019s defeat in Hungary, Bulgaria offers Kremlin\u2019s next best bet The Washington Post","title":"What to Know About the Bulgarian Election - The New York Times","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 304951 in events