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:nuclear_renaissance","field":"heat_score","new_event_id":"evt_f0872827eedd","new_ts":"2026-04-18T00:04:12.396784+00:00","new_value":{"components":{"news":0.3862,"pa":0.0,"sm":0.1216,"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.0964,"pa":0.0375,"sm":0.2241,"ta":0.3177},"d":"2026-04-17","direction":"up","score":0.1485},{"components":{"news":0.3862,"pa":0.0,"sm":0.1216,"ta":0.0},"d":"2026-04-18","direction":"neutral","score":0.1402}],"score":0.1402,"updated_at":"2026-04-18T00:04:12.396784+00:00"},"previous_event_id":"evt_abe978cfc7cd","previous_ts":"2026-04-17T00:01:30.273988+00:00","previous_value":{"components":{"news":0.0964,"pa":0.0375,"sm":0.2241,"ta":0.3177},"components_passing":0,"direction":"up","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.0964,"pa":0.0375,"sm":0.2241,"ta":0.3177},"d":"2026-04-17","direction":"up","score":0.1485}],"score":0.1485,"updated_at":"2026-04-17T00:01:30.273988+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 107341 in events