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-15T23:44:18.835896+00:00","dedupe_key":"signal_enriched:news_delta:9f74f17dc9a4b92f","evidence_event_ids":["evt_7bfaa43fd253"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNcmIzWXA0a09GMWxoQVFqUTRyYkx4MjdRa3h2X3Uzck9JT0J5cWR5ckZfR0N1WnBKS0hRY3BoN0RId1JJeDh3cEp3ODkwTnVxalFmQVJEVkc4Z29zekVyV1dOeGVoemlHM2hwMzNmYkg4QjlGSmFyT3YxdmgwMUNuZ3JCLWlXN1IyTENaM2Fn?oc=5","as_of":"2026-04-15T23:44:18.835896+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/CBMijgFBVV95cUxNcmIzWXA0a09GMWxoQVFqUTRyYkx4MjdRa3h2X3Uzck9JT0J5cWR5ckZfR0N1WnBKS0hRY3BoN0RId1JJeDh3cEp3ODkwTnVxalFmQVJEVkc4Z29zekVyV1dOeGVoemlHM2hwMzNmYkg4QjlGSmFyT3YxdmgwMUNuZ3JCLWlXN1IyTENaM2Fn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_67355bb89b90246e","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-15T23:44:41.312639+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNcmIzWXA0a09GMWxoQVFqUTRyYkx4MjdRa3h2X3Uzck9JT0J5cWR5ckZfR0N1WnBKS0hRY3BoN0RId1JJeDh3cEp3ODkwTnVxalFmQVJEVkc4Z29zekVyV1dOeGVoemlHM2hwMzNmYkg4QjlGSmFyT3YxdmgwMUNuZ3JCLWlXN1IyTENaM2Fn?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/CBMijgFBVV95cUxNcmIzWXA0a09GMWxoQVFqUTRyYkx4MjdRa3h2X3Uzck9JT0J5cWR5ckZfR0N1WnBKS0hRY3BoN0RId1JJeDh3cEp3ODkwTnVxalFmQVJEVkc4Z29zekVyV1dOeGVoemlHM2hwMzNmYkg4QjlGSmFyT3YxdmgwMUNuZ3JCLWlXN1IyTENaM2Fn?oc=5","source_event_id":"evt_7bfaa43fd253","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"622e5d0399d13167","published_at":"2026-04-15T21:54:33+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: Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh - The New York Times","Source summary: Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh The New York Times Justice Sotomayor issues rare apology for remarks about conservative colleague The Washington Post Justice Sonia Sotomayor issues unusual apology over 'hurtful' remarks about colleague Brett Kavanaugh NBC News Justice Sonia Sotomayor apologizes for swipe at Kavanaugh Politico Sotomayor Faults Kavanaugh Over Immigration "],"numeric_claims":[],"primary_claim":"Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh The New York Times Justice Sotomayor issues rare apology for remarks about conservative colleague The Washington Post Justice Sonia Sotomayor issues unusual apology over 'hurtful' remarks about colleague Brett Kavanaugh NBC News Justice Sonia Sotomayor apologizes for swipe at Kavanaugh Politico Sotomayor Faults Kavanau","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh The New York Times Justice Sotomayor issues rare apology for remarks about conservative colleague The Washington Post Justice Sonia Sotomayor issues unusual apology over 'hurtful' remarks about colleague Brett Kavanaugh NBC News Justice Sonia Sotomayor apologizes for swipe at Kavanaugh Politico Sotomayor Faults Kavanaugh Over Immigration Stops Concurrence Bloomberg Law News","title":"Justice Sotomayor Apologizes for Highly Personal Criticism of Justice Kavanaugh - 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 52229 in events