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

{"at":"2026-04-16T02:40:19.086644+00:00","queue":{"cutoff_iso":"2026-04-16T02:30:19.095079+00:00","dead_letters_in_window":1,"dead_letters_total":1,"failed_in_window":0,"requeued_expired":0,"requeued_failed":0,"status_counts":{"dead":1,"done":78,"leased":2,"queued":2}},"reducers":{"max_seq":54686,"stale":[],"stale_minutes":10,"top":[{"cursor":54670,"lag":16,"max_pos":54686,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-16T02:39:14.431Z"},{"cursor":54673,"lag":13,"max_pos":54686,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-16T02:40:17.388Z"},{"cursor":54673,"lag":13,"max_pos":54686,"reducer":"commitment_checkin_answers_v1","stream":"events","updated_at":"2026-04-16T02:39:19.425Z"},{"cursor":54680,"lag":6,"max_pos":54686,"reducer":"portfolio_resolver_v3","stream":"events","updated_at":"2026-04-16T02:39:56.014Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-16T02:40:06.719Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-16T02:40:06.878Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-16T02:40:06.917Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-16T02:40:06.933Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-16T02:40:06.957Z"},{"cursor":54683,"lag":3,"max_pos":54686,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-16T02:40:06.979Z"}],"worst_lag":16,"worst_reducer":"resolver_v3"},"subsystem":"housekeeping"}

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