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

{"entity_id":"theme:electrification_grid","field":"heat_score","new_event_id":"evt_d44acef4379a","new_ts":"2026-04-20T00:04:34.031122+00:00","new_value":{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"components_passing":0,"direction":"neutral","emergent":false,"history":[{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"d":"2026-04-16","direction":"neutral","score":0.0},{"components":{"news":0.0,"pa":0.0,"sm":0.4318,"ta":0.0},"d":"2026-04-17","direction":"neutral","score":0.0864},{"components":{"news":0.0,"pa":0.0429,"sm":0.5546,"ta":0.0},"d":"2026-04-18","direction":"neutral","score":0.1238},{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"d":"2026-04-19","direction":"neutral","score":0.0},{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"d":"2026-04-20","direction":"neutral","score":0.0}],"score":0.0,"updated_at":"2026-04-20T00:04:34.031122+00:00"},"previous_event_id":"evt_d6350e80b4fd","previous_ts":"2026-04-19T00:01:57.899937+00:00","previous_value":{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"components_passing":0,"direction":"neutral","emergent":false,"history":[{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"d":"2026-04-16","direction":"neutral","score":0.0},{"components":{"news":0.0,"pa":0.0,"sm":0.4318,"ta":0.0},"d":"2026-04-17","direction":"neutral","score":0.0864},{"components":{"news":0.0,"pa":0.0429,"sm":0.5546,"ta":0.0},"d":"2026-04-18","direction":"neutral","score":0.1238},{"components":{"news":0.0,"pa":0.0,"sm":0.0,"ta":0.0},"d":"2026-04-19","direction":"neutral","score":0.0}],"score":0.0,"updated_at":"2026-04-19T00:01:57.899937+00:00"},"resolution":"corrected","source":"resolver_recency_policy"}

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