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-11T09:40:55.764443+00:00","queue":{"cutoff_iso":"2026-04-11T09:30:55.770114+00:00","dead_letters_in_window":0,"dead_letters_total":0,"failed_in_window":0,"requeued_expired":0,"requeued_failed":0,"status_counts":{"done":99,"leased":1,"queued":8}},"reducers":{"max_seq":22412,"stale":[],"stale_minutes":10,"top":[{"cursor":22395,"lag":17,"max_pos":22412,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-11T09:36:56.950Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-11T09:39:34.328Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-11T09:38:24.166Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-11T09:38:24.251Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-11T09:38:24.257Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-11T09:38:24.271Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-11T09:38:24.619Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-11T09:38:24.931Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"signal_candidate_reducer_v2","stream":"events","updated_at":"2026-04-11T09:38:25.030Z"},{"cursor":22412,"lag":0,"max_pos":22412,"reducer":"action_reducer_v2","stream":"events","updated_at":"2026-04-11T09:38:25.142Z"}],"worst_lag":17,"worst_reducer":"memory_ingest:default"},"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 22413 in events