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-20T08:58:45.473684+00:00","signal_type":"news_headline_delta","source":"news_rss","url":"https://news.google.com/rss/articles/CBMiYkFVX3lxTE91YXNLWHd2NWNNREYtWDhOR0o4S0syOGUtamRLRHJjNmhaZi1MV1VrMzh2b3o1aUVOLVBDaDFLS1dvVFRJUzlZdXUxRW5aSVpfRE5UbDE3RU5GUkNIYUFLbmN3?oc=5","value":{"fp":"67d0e4d8f2c398ff","published_at":"2026-04-20T03:04:21+00:00","source":"nhk.or.jp","source_domain":"www3.nhk.or.jp","source_url":"https://www3.nhk.or.jp","summary":"Recovery efforts underway in quake-affected areas in Japan's Nagano Prefecture nhk.or.jp Japan: Tsunami warning after massive earthquake off north-east coast BBC Major 7.5-magnitude quake hits off Japan, tsunami warning issued Reuters Japan earthquake live: Tsunami warning as 7.4-magnitude earthquake hits off northeast coast Sky News Powerful quake triggers tsunami warning for Iwate and Hokkaido The Japan Times","title":"Recovery efforts underway in quake-affected areas in Japan's Nagano Prefecture - nhk.or.jp","url":"https://news.google.com/rss/articles/CBMiYkFVX3lxTE91YXNLWHd2NWNNREYtWDhOR0o4S0syOGUtamRLRHJjNmhaZi1MV1VrMzh2b3o1aUVOLVBDaDFLS1dvVFRJUzlZdXUxRW5aSVpfRE5UbDE3RU5GUkNIYUFLbmN3?oc=5"}}

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