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-17T12:43:12.562437+00:00","signal_type":"real_estate_discovery_snapshot","source":"discovery_real_estate","value":{"as_of":"2026-04-17T12:43:12.562437+00:00","bucket":"2026-04-17T12:00Z","geo_count":6,"items":[{"days_on_market":null,"fp":"0a8d22ee4012f1da","geo":"Miami","geo_name":"Miami, FL","geo_type":"primary","patterns":["price_drop"],"price":34.0,"published_at":"2026-04-13T20:00:00+00:00","quality_hint":1.0,"source":"The Real Deal","source_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQRVd1R2JmaEZTWS1LalFiYmcxUEVOeWFrNENpTTVSM2JqU3VTbFl0RXlVclZfRTBSTUdaRVU1S1FZYWVrcEZqTGYxMGdMQXdrS29KZEprZ0xkLXB0OWljWlVHc3RrVFFlSVhDblpDdk9xbExSeXhWcmMwWDRuTkw4djBVZGVtVk0zQ0g3cjlqWHdQVmtteTdBWmJTcVVfMXp4ejVv?oc=5","summary":"GOP megadonor, WeatherTech founder sells mansion for $34M after massive price drop The Real Deal","tickers":[],"title":"GOP megadonor, WeatherTech founder sells mansion for $34M after massive price drop - The Real Deal","url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQRVd1R2JmaEZTWS1LalFiYmcxUEVOeWFrNENpTTVSM2JqU3VTbFl0RXlVclZfRTBSTUdaRVU1S1FZYWVrcEZqTGYxMGdMQXdrS29KZEprZ0xkLXB0OWljWlVHc3RrVFFlSVhDblpDdk9xbExSeXhWcmMwWDRuTkw4djBVZGVtVk0zQ0g3cjlqWHdQVmtteTdBWmJTcVVfMXp4ejVv?oc=5"}],"quality_hint":1.0,"source":"discovery_real_estate","source_ref":"rss"}}

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