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-19T15:01:01.648941+00:00","signal_type":"news_headline_delta","source":"news_rss","url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNWmtiMVNCNkZiZERvSHQtLVg2TDU0QjBObnNNcXI4Uk9Jdi1SeGRSWVR6YlUyT1A3aVh4cHhOa3NnTTlHOXV0SU1BcGNSUk51NFBTVDN6UDhsTXBveFJJUGRlMy15VmhiVXJTZ1dCa1FrR3pWSC1pTlIwcFJvWEtTTTlLRDJ6SHpRZEpiY09vSDdhMzQ?oc=5","value":{"fp":"bf9afa0e0d1c5bef","published_at":"2026-04-19T13:23:00+00:00","source":"KCCI","source_domain":"kcci.com","source_url":"https://www.kcci.com","summary":"What we know about downtown Iowa City shooting: Multiple victims at Ped Mall KCCI Three students wounded in shooting at Iowa City Ped Mall KCRG 3 UI students injured in downtown Iowa City shooting, no arrests made Iowa City Press-Citizen UI president says 3 students were hurt in overnight shooting near UIowa campus KGAN At least 3 students injured in shooting near University of Iowa NBC News","title":"What we know about downtown Iowa City shooting: Multiple victims at Ped Mall - KCCI","url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNWmtiMVNCNkZiZERvSHQtLVg2TDU0QjBObnNNcXI4Uk9Jdi1SeGRSWVR6YlUyT1A3aVh4cHhOa3NnTTlHOXV0SU1BcGNSUk51NFBTVDN6UDhsTXBveFJJUGRlMy15VmhiVXJTZ1dCa1FrR3pWSC1pTlIwcFJvWEtTTTlLRDJ6SHpRZEpiY09vSDdhMzQ?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 315422 in events