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

{"created_at":"2026-04-17T11:58:31.142999+00:00","signal_type":"news_headline_delta","source":"news_rss","url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxNeG01R1pVVDhqZXB3NHJPVktnV1hYZDBMNEw3ZUxkcnpOcHZzMzl1aVlRZnhzYUlsdFR0TURIanc5RlRWaTFjNkUtY3pndmx4RGVTS3dNU25KWEd6UzBuczRTaGh2a1BZcWlqVGFaWUlzbnUzTHlkV2owNHI2ems4bDY4MTE2QmFOWDF4SkZFLVl6ZUZYZFBHT2Z4ZndxTG9teVAwZmxNbHVrcTNJbmxoWngtZzdPUdIBuwFBVV95cUxPT2c1OVRnbGtuV01HVHhndU1uNDJocmRfeFJhYWtVeUlnMXlXTHdfRE9WRU1mX2s2SFZqa0diaHFhZU4tU0pFZUZTR1JZbDNIb19DdXNTQlJEc3JhMkVlWEc2MDNhejg5cnh1cFJudUxVcEZmR29GeXFUTi1UMDNDXy1sU3FLTEoyZ1pSbm1CR01KOXJnNmhHZ1VNQlFkTER0RFZ2ZUh1MlFsdWR1SlZTVkZkZW0wYzJoRHJn?oc=5","value":{"fp":"bcff9be699e4c75e","published_at":"2026-04-17T04:59:12+00:00","source":"Al Jazeera","source_domain":"aljazeera.com","source_url":"https://www.aljazeera.com","summary":"Australian ex-soldier Roberts-Smith granted bail in Afghan war crimes case Al Jazeera Ben Roberts-Smith: Australia's most decorated living soldier released on bail over war crimes charges BBC Ben Roberts-Smith\u2019s comrades say he ordered them to execute unarmed civilians, court documents show The Guardian Sign Ben Roberts-Smith made as he left jail News.com.au Australian former soldier gets bail on Afghanistan war crime charges The Jerusalem Post","title":"Australian ex-soldier Roberts-Smith granted bail in Afghan war crimes case - Al Jazeera","url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxNeG01R1pVVDhqZXB3NHJPVktnV1hYZDBMNEw3ZUxkcnpOcHZzMzl1aVlRZnhzYUlsdFR0TURIanc5RlRWaTFjNkUtY3pndmx4RGVTS3dNU25KWEd6UzBuczRTaGh2a1BZcWlqVGFaWUlzbnUzTHlkV2owNHI2ems4bDY4MTE2QmFOWDF4SkZFLVl6ZUZYZFBHT2Z4ZndxTG9teVAwZmxNbHVrcTNJbmxoWngtZzdPUdIBuwFBVV95cUxPT2c1OVRnbGtuV01HVHhndU1uNDJocmRfeFJhYWtVeUlnMXlXTHdfRE9WRU1mX2s2SFZqa0diaHFhZU4tU0pFZUZTR1JZbDNIb19DdXNTQlJEc3JhMkVlWEc2MDNhejg5cnh1cFJudUxVcEZmR29GeXFUTi1UMDNDXy1sU3FLTEoyZ1pSbm1CR01KOXJnNmhHZ1VNQlFkTER0RFZ2ZUh1MlFsdWR1SlZTVkZkZW0wYzJoRHJn?oc=5"}}

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