SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_3d562bc1f6ae in signals