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

{"action_id":"act_d40302fece8a","applied_at":"2026-04-03T11:18:31.653376+00:00","effect_id":"eff_9f6fa897fc756454","idempotency_key":"56868bbcaa8008f74e3c8d2e4ae7e7ab:effect:state_updated","payload":{"action_type":"web_search","links":{"event_id":"evt_27eeb6ffcc2d","top":{"display":"","extra":{"date":"7 days ago","position":1,"sitelinks":[{"link":"https://www.reddit.com/r/AskSF/comments/1s8g592/what_are_your_favorite_ways_to_find_fun_hidden/","title":"What are your favorite ways to find fun hidden gem events in the city ..."},{"link":"https://www.reddit.com/r/usatravel/comments/1rx17a1/first_time_in_california_san_francisco/","title":"First time in California, San Francisco- Recommendations : r/usatravel"}]},"kind":"organic","rank":1,"snippet":"Take a water taxi to Sausalito from Ferry Building, or go to Alameda, there is a USS Hornet warship museum in Alameda, very cool experience. Stalk and persuade ...","title":"What to do in SF this weekend (or in general) that doesn't involve ...","url":"https://www.reddit.com/r/AskSF/comments/1s5cb59/what_to_do_in_sf_this_weekend_or_in_general_that/"}},"summary":"Web search complete: fun things to do in San Francisco \u2014 What to do in SF this weekend (or in general) that doesn't involve ..."},"type":"state_updated"}

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