SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxQbHBoUHBNSmlmYVdMZWdycm1YbEp5b2hPWmxkSnA4RGs5ajhTMkV5UkZnZGxYSFdtcW9yV25IQWhteVlWaUJoYzlaeTZHSHR3bkQxdy1YSlFsM3hhNkc0enhYSWZQODRmTEd1QzlOb2trdDNDV29JcDg3WlhXZGtEcC0xbFRLTEhtaDRGU3ZOQkvSAaQBQVVfeXFMUFdQWUJERFFMRnRhVTBaMlRvRFphMnBpaXdkUjdZOWVNelUwRm5oazNxX3N0bWdkTXJjOXJtMGV0ZjVqUVJCMVh5UDZsTmljUEh2bUkwOWVTcWItSjlSRm9vcWhJWUhMWDlKMGdQdG5Fa0E4NWRQaXN0T0dtWDRmVlA0T0I2Tl9oSVZMajlZbzlhLVBiSUYxVkdiUEE4enpQNTJpMHA?oc=5","as_of":"2026-04-06T18:37:01.018729+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxQbHBoUHBNSmlmYVdMZWdycm1YbEp5b2hPWmxkSnA4RGs5ajhTMkV5UkZnZGxYSFdtcW9yV25IQWhteVlWaUJoYzlaeTZHSHR3bkQxdy1YSlFsM3hhNkc0enhYSWZQODRmTEd1QzlOb2trdDNDV29JcDg3WlhXZGtEcC0xbFRLTEhtaDRGU3ZOQkvSAaQBQVVfeXFMUFdQWUJERFFMRnRhVTBaMlRvRFphMnBpaXdkUjdZOWVNelUwRm5oazNxX3N0bWdkTXJjOXJtMGV0ZjVqUVJCMVh5UDZsTmljUEh2bUkwOWVTcWItSjlSRm9vcWhJWUhMWDlKMGdQdG5Fa0E4NWRQaXN0T0dtWDRmVlA0T0I2Tl9oSVZMajlZbzlhLVBiSUYxVkdiUEE4enpQNTJpMHA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cfb5ed1b04e6a5af","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T18:41:51.736851+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxQbHBoUHBNSmlmYVdMZWdycm1YbEp5b2hPWmxkSnA4RGs5ajhTMkV5UkZnZGxYSFdtcW9yV25IQWhteVlWaUJoYzlaeTZHSHR3bkQxdy1YSlFsM3hhNkc0enhYSWZQODRmTEd1QzlOb2trdDNDV29JcDg3WlhXZGtEcC0xbFRLTEhtaDRGU3ZOQkvSAaQBQVVfeXFMUFdQWUJERFFMRnRhVTBaMlRvRFphMnBpaXdkUjdZOWVNelUwRm5oazNxX3N0bWdkTXJjOXJtMGV0ZjVqUVJCMVh5UDZsTmljUEh2bUkwOWVTcWItSjlSRm9vcWhJWUhMWDlKMGdQdG5Fa0E4NWRQaXN0T0dtWDRmVlA0T0I2Tl9oSVZMajlZbzlhLVBiSUYxVkdiUEE4enpQNTJpMHA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"al.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxQbHBoUHBNSmlmYVdMZWdycm1YbEp5b2hPWmxkSnA4RGs5ajhTMkV5UkZnZGxYSFdtcW9yV25IQWhteVlWaUJoYzlaeTZHSHR3bkQxdy1YSlFsM3hhNkc0enhYSWZQODRmTEd1QzlOb2trdDNDV29JcDg3WlhXZGtEcC0xbFRLTEhtaDRGU3ZOQkvSAaQBQVVfeXFMUFdQWUJERFFMRnRhVTBaMlRvRFphMnBpaXdkUjdZOWVNelUwRm5oazNxX3N0bWdkTXJjOXJtMGV0ZjVqUVJCMVh5UDZsTmljUEh2bUkwOWVTcWItSjlSRm9vcWhJWUhMWDlKMGdQdG5Fa0E4NWRQaXN0T0dtWDRmVlA0T0I2Tl9oSVZMajlZbzlhLVBiSUYxVkdiUEE4enpQNTJpMHA?oc=5","source_event_id":"evt_d6bf35d71c83","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9b4d60195e4d6103","published_at":"2026-04-06T17:07:00+00:00","publisher_domain":"al.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"entertainment","name":"Todd Meadows","relevance":"high","symbol":"","type":"person"},{"asset_class":"entertainment","name":"Deadliest Catch","relevance":"high","symbol":"","type":"show"}],"event_type":"other","information_gaps":["Specific cause of death not detailed in the headline.","Details on the potential lawsuit are not provided."],"key_facts":["Todd Meadows was 25 years old at the time of his death.","His family is considering a wrongful death lawsuit against the network."],"numeric_claims":[],"primary_claim":"Todd Meadows, a star from 'Deadliest Catch', has died at the age of 25, and his family is contemplating legal action against the network.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Reality TV star Todd Meadows, known from 'Deadliest Catch', has died at 25, with his cause of death revealed, prompting his family to consider a wrongful death lawsuit against the network.","topics":["celebrity news","entertainment","legal action"]},"source":"AL.com","source_domain":"al.com","source_url":"https://www.al.com","summary":"Reality TV star dead at 25: Cause of death revealed AL.com Deadliest Catch star Todd Meadows\u2019 cause of death revealed amid his mother\u2019s pleas for network to not air footage ca.news.yahoo.com 'Deadliest Catch' Deckhand Todd Meadows Cause of Death Revealed TMZ \u2018Deadliest Catch\u2019 star Todd Meadows\u2019 family lawyer up to file wrongful death lawsuit Page Six 'Deadliest Catch' Star Todd Meadows' Cause of Death Revealed People.com","title":"Reality TV star dead at 25: Cause of death revealed - AL.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp"}

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_2e97da72f0e0 in signals