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/CBMitgFBVV95cUxOZjQzRHhTVEczLXhuNXItN1ZhVzZDQ0NzV1lrX3daVHU3ZXRGdmxHczRxdnRiY3lLcmVIMkxuNHUzM3EwYlE0RGpqeFNTYWZSMGNFcC1TWVlLcjlXaUcwLUw0NkxGZ1J6Z0ZPMTJqZ3BNMDB3dWNwU000Zm9vMDRGV0J1UEgwYTNNZ2pGVGlCMjhGZWNnckpxOFQ5MlhIaC1kNExpTEtFaV8wQkh1M3VSX3dUN2w0dw?oc=5","as_of":"2026-04-22T14:40:52.735279+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOZjQzRHhTVEczLXhuNXItN1ZhVzZDQ0NzV1lrX3daVHU3ZXRGdmxHczRxdnRiY3lLcmVIMkxuNHUzM3EwYlE0RGpqeFNTYWZSMGNFcC1TWVlLcjlXaUcwLUw0NkxGZ1J6Z0ZPMTJqZ3BNMDB3dWNwU000Zm9vMDRGV0J1UEgwYTNNZ2pGVGlCMjhGZWNnckpxOFQ5MlhIaC1kNExpTEtFaV8wQkh1M3VSX3dUN2w0dw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6ba2c35fd42bd7ea","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T15:04:17.269381+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOZjQzRHhTVEczLXhuNXItN1ZhVzZDQ0NzV1lrX3daVHU3ZXRGdmxHczRxdnRiY3lLcmVIMkxuNHUzM3EwYlE0RGpqeFNTYWZSMGNFcC1TWVlLcjlXaUcwLUw0NkxGZ1J6Z0ZPMTJqZ3BNMDB3dWNwU000Zm9vMDRGV0J1UEgwYTNNZ2pGVGlCMjhGZWNnckpxOFQ5MlhIaC1kNExpTEtFaV8wQkh1M3VSX3dUN2w0dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nydailynews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOZjQzRHhTVEczLXhuNXItN1ZhVzZDQ0NzV1lrX3daVHU3ZXRGdmxHczRxdnRiY3lLcmVIMkxuNHUzM3EwYlE0RGpqeFNTYWZSMGNFcC1TWVlLcjlXaUcwLUw0NkxGZ1J6Z0ZPMTJqZ3BNMDB3dWNwU000Zm9vMDRGV0J1UEgwYTNNZ2pGVGlCMjhGZWNnckpxOFQ5MlhIaC1kNExpTEtFaV8wQkh1M3VSX3dUN2w0dw?oc=5","source_event_id":"evt_e1caee8eee4c","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"0cbfe887e4f94a14","published_at":"2026-04-22T02:01:27+00:00","publisher_domain":"nydailynews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat - New York Daily News","Source summary: Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat New York Daily News Inside the numbers on New York Mets' 12-game losing streak ESPN Season From HeLLLLLLLLLLLL: Miserable Mets Can\u2019t Stop Losing WSJ Burning sage, Lindor's HR not enough as Mets' skid hits 12 MLB.com Twins playfully roast Mets on social media after giving them 12th loss in a row USA Today"],"numeric_claims":[],"primary_claim":"Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat - New York Daily News","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat New York Daily News Inside the numbers on New York Mets' 12-game losing streak ESPN Season From HeLLLLLLLLLLLL: Miserable Mets Can\u2019t Stop Losing WSJ Burning sage, Lindor's HR not enough as Mets' skid hits 12 MLB.com Twins playfully roast Mets on social media after giving them 12th loss in a row USA Today","topics":["news headline"]},"source":"New York Daily News","source_domain":"nydailynews.com","source_url":"https://www.nydailynews.com","summary":"Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat New York Daily News Inside the numbers on New York Mets' 12-game losing streak ESPN Season From HeLLLLLLLLLLLL: Miserable Mets Can\u2019t Stop Losing WSJ Burning sage, Lindor's HR not enough as Mets' skid hits 12 MLB.com Twins playfully roast Mets on social media after giving them 12th loss in a row USA Today","title":"Mets\u2019 Devin Williams disastrous 9th inning leads to loss vs. Twins and 12th straight defeat - New York Daily News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/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_e737c445c6fc in signals