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-20T15:20:27.941567+00:00","queue":{"cutoff_iso":"2026-04-20T15:10:27.952856+00:00","dead_letters_in_window":0,"dead_letters_total":0,"failed_in_window":0,"requeued_expired":0,"requeued_failed":0,"status_counts":{"done":41,"leased":3,"queued":6}},"reducers":{"max_seq":449218,"stale":[{"cursor":447790,"lag":1428,"reducer":"entity_reducer_v2_deterministic","updated_at":"2026-04-20T14:56:47.242Z"},{"cursor":447790,"lag":1428,"reducer":"entity_alias_reducer_v2","updated_at":"2026-04-20T14:56:47.352Z"},{"cursor":447790,"lag":1428,"reducer":"event_subjects_reducer_v2","updated_at":"2026-04-20T14:56:47.378Z"},{"cursor":447790,"lag":1428,"reducer":"fact_reducer_v2_deterministic","updated_at":"2026-04-20T14:56:47.440Z"},{"cursor":447790,"lag":1428,"reducer":"signal_reducer_v1","updated_at":"2026-04-20T14:56:47.489Z"},{"cursor":447790,"lag":1428,"reducer":"signal_fp_reducer_v1","updated_at":"2026-04-20T14:56:47.530Z"},{"cursor":447790,"lag":1428,"reducer":"signal_candidate_reducer_v2","updated_at":"2026-04-20T14:56:47.574Z"},{"cursor":447790,"lag":1428,"reducer":"action_reducer_v2","updated_at":"2026-04-20T14:56:47.627Z"},{"cursor":447790,"lag":1428,"reducer":"commitment_reducer_v1","updated_at":"2026-04-20T14:56:47.634Z"},{"cursor":447790,"lag":1428,"reducer":"constraint_reducer_v1","updated_at":"2026-04-20T14:56:47.656Z"}],"stale_minutes":10,"top":[{"cursor":153052,"lag":296166,"max_pos":449218,"reducer":"attention_candidate_reducer_v1","stream":"events","updated_at":"2026-04-20T15:20:16.573Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-20T14:56:47.242Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-20T14:56:47.352Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-20T14:56:47.378Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-20T14:56:47.440Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-20T14:56:47.489Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-20T14:56:47.530Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"signal_candidate_reducer_v2","stream":"events","updated_at":"2026-04-20T14:56:47.574Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"action_reducer_v2","stream":"events","updated_at":"2026-04-20T14:56:47.627Z"},{"cursor":447790,"lag":1428,"max_pos":449218,"reducer":"commitment_reducer_v1","stream":"events","updated_at":"2026-04-20T14:56:47.634Z"}],"worst_lag":296166,"worst_reducer":"attention_candidate_reducer_v1"},"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 449220 in events