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/CBMiygFBVV95cUxNUW93QVkzVUdBRElqa3lybm9DTWRtUG5jS05rS19lZmo2ajJES1l2aHl0VzhGejVEZ2NmNU9tQXc3REZTdkU0N2REMDNZcnVDNFI5V2dmODd6OFFUQTJtaVQxeVQ1SkJ6Xzhmd21sa3Qydjh6SkR6akpwTXNObzNuUGVoX0MxMlZIQ0xERkhjUU8tYmdZRjBJOFBIcFhnbW1qQXg4bUpXQjNUX1pSbFdjZS1SNjhqbWtIOU1tY2tyQWpjSnJ0ZldMYkRB0gHPAUFVX3lxTFB6S3RiRmx4MURYZTg4SGFTMlpETFd2clZ0SzdwVGgxRGZuRVlsc3pLelNQVjQ1Qmx3Qk5mX1pieVUxeUN1LTdQTEY4eVNKem51MVdNVnNFM2k5TXllSmNzY0lxWE9RdVZLWjdOdzY2TVNfZjVscmVlNTZSTV95ekI1MTZKYjNrNkoyN25LN242b0FNUlBUUjAtOWZCQkJ1cVZGdW5MLWM0cjZaemd1SXJ2UHlVUHphdmgzQ1FaRm1td29GZkdSUVdWUVRzbXBYWQ?oc=5","as_of":"2026-04-07T06:14:48.822310+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNUW93QVkzVUdBRElqa3lybm9DTWRtUG5jS05rS19lZmo2ajJES1l2aHl0VzhGejVEZ2NmNU9tQXc3REZTdkU0N2REMDNZcnVDNFI5V2dmODd6OFFUQTJtaVQxeVQ1SkJ6Xzhmd21sa3Qydjh6SkR6akpwTXNObzNuUGVoX0MxMlZIQ0xERkhjUU8tYmdZRjBJOFBIcFhnbW1qQXg4bUpXQjNUX1pSbFdjZS1SNjhqbWtIOU1tY2tyQWpjSnJ0ZldMYkRB0gHPAUFVX3lxTFB6S3RiRmx4MURYZTg4SGFTMlpETFd2clZ0SzdwVGgxRGZuRVlsc3pLelNQVjQ1Qmx3Qk5mX1pieVUxeUN1LTdQTEY4eVNKem51MVdNVnNFM2k5TXllSmNzY0lxWE9RdVZLWjdOdzY2TVNfZjVscmVlNTZSTV95ekI1MTZKYjNrNkoyN25LN242b0FNUlBUUjAtOWZCQkJ1cVZGdW5MLWM0cjZaemd1SXJ2UHlVUHphdmgzQ1FaRm1td29GZkdSUVdWUVRzbXBYWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a0ef9b3bcc6ec8a9","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=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T18:56:04.305253+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNUW93QVkzVUdBRElqa3lybm9DTWRtUG5jS05rS19lZmo2ajJES1l2aHl0VzhGejVEZ2NmNU9tQXc3REZTdkU0N2REMDNZcnVDNFI5V2dmODd6OFFUQTJtaVQxeVQ1SkJ6Xzhmd21sa3Qydjh6SkR6akpwTXNObzNuUGVoX0MxMlZIQ0xERkhjUU8tYmdZRjBJOFBIcFhnbW1qQXg4bUpXQjNUX1pSbFdjZS1SNjhqbWtIOU1tY2tyQWpjSnJ0ZldMYkRB0gHPAUFVX3lxTFB6S3RiRmx4MURYZTg4SGFTMlpETFd2clZ0SzdwVGgxRGZuRVlsc3pLelNQVjQ1Qmx3Qk5mX1pieVUxeUN1LTdQTEY4eVNKem51MVdNVnNFM2k5TXllSmNzY0lxWE9RdVZLWjdOdzY2TVNfZjVscmVlNTZSTV95ekI1MTZKYjNrNkoyN25LN242b0FNUlBUUjAtOWZCQkJ1cVZGdW5MLWM0cjZaemd1SXJ2UHlVUHphdmgzQ1FaRm1td29GZkdSUVdWUVRzbXBYWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"abc7.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNUW93QVkzVUdBRElqa3lybm9DTWRtUG5jS05rS19lZmo2ajJES1l2aHl0VzhGejVEZ2NmNU9tQXc3REZTdkU0N2REMDNZcnVDNFI5V2dmODd6OFFUQTJtaVQxeVQ1SkJ6Xzhmd21sa3Qydjh6SkR6akpwTXNObzNuUGVoX0MxMlZIQ0xERkhjUU8tYmdZRjBJOFBIcFhnbW1qQXg4bUpXQjNUX1pSbFdjZS1SNjhqbWtIOU1tY2tyQWpjSnJ0ZldMYkRB0gHPAUFVX3lxTFB6S3RiRmx4MURYZTg4SGFTMlpETFd2clZ0SzdwVGgxRGZuRVlsc3pLelNQVjQ1Qmx3Qk5mX1pieVUxeUN1LTdQTEY4eVNKem51MVdNVnNFM2k5TXllSmNzY0lxWE9RdVZLWjdOdzY2TVNfZjVscmVlNTZSTV95ekI1MTZKYjNrNkoyN25LN242b0FNUlBUUjAtOWZCQkJ1cVZGdW5MLWM0cjZaemd1SXJ2UHlVUHphdmgzQ1FaRm1td29GZkdSUVdWUVRzbXBYWQ?oc=5","source_event_id":"evt_0fe825303b98","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a333df1c42838869","published_at":"2026-04-07T03:07:37+00:00","publisher_domain":"abc7.com","signal_understanding":{"analysis_basis":"article","claim_confidence":1.0,"dates_mentioned":[],"entities":[{"asset_class":"none","name":"Ryan Jennings","relevance":"high","symbol":"","type":"individual"}],"event_type":"other","information_gaps":["Details on the children he saved are not provided.","Circumstances leading to the rip current incident are unclear."],"key_facts":["Ryan Jennings was a beloved coach and father of three.","The incident occurred at Juno Beach, Florida.","He drowned while rescuing children from a rip current."],"numeric_claims":[],"primary_claim":"Ryan Jennings drowned while saving children from a rip current off Juno Beach, Florida.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"Ryan Jennings, a coach and father from Maine, tragically drowned while attempting to save children from a rip current at Juno Beach, Florida.","topics":["tragedy","heroism","family"]},"source":"ABC7 Los Angeles","source_domain":"abc7.com","source_url":"https://abc7.com","summary":"Ryan Jennings, beloved coach and father from Maine, drowns saving children from rip current off Juno Beach, Florida ABC7 Los Angeles Father of 3 drowns while saving children from rip current during Florida vacation NBC News Maine father dies after rescuing children from rip current in Florida The Boston Globe 'The love of her life is gone': Maine man drowns saving his kids from rip current wmtw.com Maine father dies after saving his children from a rip current Boston.com","title":"Ryan Jennings, beloved coach and father from Maine, drowns saving children from rip current off Juno Beach, Florida - ABC7 Los Angeles","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/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_439ea44f4f29 in signals