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-07T11:15:38.807677+00:00","signal_type":"news_headline_delta","source":"news_rss","url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNRXJHbDdMX1F4LU12RnJMRkxnemM2SjdObVU0M2xKSXYyTFBCeGl2anN3dkpyR1hIMGdJa193U0tuT0tvbDlJa3BTaV8zOWZVeWNESDVzWTZ0RFVaUGN4Y1NvNGRfek9NSmVTeTBLSGFGNHF4eGhwcEtkTjNldDQwcmRZNDg4dmZMZzJiRUJfbmZfYzRucWIzSnRheHhtZ3VGVjdyVUlFd1BzeDVVV2cw?oc=5","value":{"fp":"4795a80fcc7fd710","published_at":"2026-04-07T09:11:14+00:00","source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Australia Charges Ex-Soldier With War Crimes in Afghanistan The New York Times Ben Roberts-Smith: Australia\u2019s most decorated soldier arrested over alleged war crimes cnn.com One of Australia's most-decorated soldiers charged with committing 5 war crime murders in Afghanistan CBS News Ben Roberts-Smith: Australian soldier charged over alleged war crimes BBC Former Australian soldier charged with committing five war crime murders in Afghanistan Yahoo","title":"Australia Charges Ex-Soldier With War Crimes in Afghanistan - The New York Times","url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNRXJHbDdMX1F4LU12RnJMRkxnemM2SjdObVU0M2xKSXYyTFBCeGl2anN3dkpyR1hIMGdJa193U0tuT0tvbDlJa3BTaV8zOWZVeWNESDVzWTZ0RFVaUGN4Y1NvNGRfek9NSmVTeTBLSGFGNHF4eGhwcEtkTjNldDQwcmRZNDg4dmZMZzJiRUJfbmZfYzRucWIzSnRheHhtZ3VGVjdyVUlFd1BzeDVVV2cw?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 37004 in events