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/CBMixgFBVV95cUxNNDlWZmdLS0I0ajhGOGxiVC1KbFd0RjhLNGlEYjlINzBiX1hGRndkeGJpUEdfbS1oYmx2bjZsLWdIdUtTSVFCRWkxNWp5MTdwa3hfaHhhM3JhWV9UM0QycDV5V3pHTmNpTlk3ZGZ4WVc5QXNLcE9DcjJCazJDWWMzSk5INWFJYU0xalowUTlkMklvYTlQSnN0clhhVXRIaUcycndDWWxpQ3I0X2lPVHNqSzR0MU9DNFRKRGlyemZXc3ZBVFBCMUHSAcsBQVVfeXFMTmxPNTdHazhJaFhaN1VrdHd5UEpXLXVkWHlUaW1wWDczTEs3bUNlV2Q0ell3cy0wZVN0a0x1d1NCRXJid2RSVmlJdzRnMWRNTllXSWhHSE9wSG93NzVoby1MbzJ5NVBDX3hySldsZFBlNGM4dWtTd0Z6dDlCbDNIQkFXdXFWNFZfNnBWQWhEMWh6WEJRanV3VDFMaW5DZlVoODFtbVh6OGRlQkdldjZWRWlTV28wVXQ4M1ZBT0gyOXdJeDl0ZzltSDFIenM?oc=5","as_of":"2026-04-22T03:25:36.148278+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/CBMixgFBVV95cUxNNDlWZmdLS0I0ajhGOGxiVC1KbFd0RjhLNGlEYjlINzBiX1hGRndkeGJpUEdfbS1oYmx2bjZsLWdIdUtTSVFCRWkxNWp5MTdwa3hfaHhhM3JhWV9UM0QycDV5V3pHTmNpTlk3ZGZ4WVc5QXNLcE9DcjJCazJDWWMzSk5INWFJYU0xalowUTlkMklvYTlQSnN0clhhVXRIaUcycndDWWxpQ3I0X2lPVHNqSzR0MU9DNFRKRGlyemZXc3ZBVFBCMUHSAcsBQVVfeXFMTmxPNTdHazhJaFhaN1VrdHd5UEpXLXVkWHlUaW1wWDczTEs3bUNlV2Q0ell3cy0wZVN0a0x1d1NCRXJid2RSVmlJdzRnMWRNTllXSWhHSE9wSG93NzVoby1MbzJ5NVBDX3hySldsZFBlNGM4dWtTd0Z6dDlCbDNIQkFXdXFWNFZfNnBWQWhEMWh6WEJRanV3VDFMaW5DZlVoODFtbVh6OGRlQkdldjZWRWlTV28wVXQ4M1ZBT0gyOXdJeDl0ZzltSDFIenM?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_127ecdda74904f98","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-22T03:33:36.076126+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNNDlWZmdLS0I0ajhGOGxiVC1KbFd0RjhLNGlEYjlINzBiX1hGRndkeGJpUEdfbS1oYmx2bjZsLWdIdUtTSVFCRWkxNWp5MTdwa3hfaHhhM3JhWV9UM0QycDV5V3pHTmNpTlk3ZGZ4WVc5QXNLcE9DcjJCazJDWWMzSk5INWFJYU0xalowUTlkMklvYTlQSnN0clhhVXRIaUcycndDWWxpQ3I0X2lPVHNqSzR0MU9DNFRKRGlyemZXc3ZBVFBCMUHSAcsBQVVfeXFMTmxPNTdHazhJaFhaN1VrdHd5UEpXLXVkWHlUaW1wWDczTEs3bUNlV2Q0ell3cy0wZVN0a0x1d1NCRXJid2RSVmlJdzRnMWRNTllXSWhHSE9wSG93NzVoby1MbzJ5NVBDX3hySldsZFBlNGM4dWtTd0Z6dDlCbDNIQkFXdXFWNFZfNnBWQWhEMWh6WEJRanV3VDFMaW5DZlVoODFtbVh6OGRlQkdldjZWRWlTV28wVXQ4M1ZBT0gyOXdJeDl0ZzltSDFIenM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pbs.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNNDlWZmdLS0I0ajhGOGxiVC1KbFd0RjhLNGlEYjlINzBiX1hGRndkeGJpUEdfbS1oYmx2bjZsLWdIdUtTSVFCRWkxNWp5MTdwa3hfaHhhM3JhWV9UM0QycDV5V3pHTmNpTlk3ZGZ4WVc5QXNLcE9DcjJCazJDWWMzSk5INWFJYU0xalowUTlkMklvYTlQSnN0clhhVXRIaUcycndDWWxpQ3I0X2lPVHNqSzR0MU9DNFRKRGlyemZXc3ZBVFBCMUHSAcsBQVVfeXFMTmxPNTdHazhJaFhaN1VrdHd5UEpXLXVkWHlUaW1wWDczTEs3bUNlV2Q0ell3cy0wZVN0a0x1d1NCRXJid2RSVmlJdzRnMWRNTllXSWhHSE9wSG93NzVoby1MbzJ5NVBDX3hySldsZFBlNGM4dWtTd0Z6dDlCbDNIQkFXdXFWNFZfNnBWQWhEMWh6WEJRanV3VDFMaW5DZlVoODFtbVh6OGRlQkdldjZWRWlTV28wVXQ4M1ZBT0gyOXdJeDl0ZzltSDFIenM?oc=5","source_event_id":"evt_6a8b9364bd64","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a64f1bd790157c07","published_at":"2026-04-21T22:14:37+00:00","publisher_domain":"pbs.org","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: U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say - PBS","Source summary: U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say PBS Two CIA officers die in Mexico accident after counternarcotics operation The Washington Post Role of US officials killed in crash in Mexico under scrutiny BBC US officials killed in Mexico car crash following drug raid worked for the CIA, sources say CNN US and Mexican officials assigned to cartel case killed in car acc"],"numeric_claims":[],"primary_claim":"U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say - PBS","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say PBS Two CIA officers die in Mexico accident after counternarcotics operation The Washington Post Role of US officials killed in crash in Mexico under scrutiny BBC US officials killed in Mexico car crash following drug raid worked for the CIA, sources say CNN US and Mexican officials assigned to cartel ca","topics":["news headline"]},"source":"PBS","source_domain":"pbs.org","source_url":"https://www.pbs.org","summary":"U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say PBS Two CIA officers die in Mexico accident after counternarcotics operation The Washington Post Role of US officials killed in crash in Mexico under scrutiny BBC US officials killed in Mexico car crash following drug raid worked for the CIA, sources say CNN US and Mexican officials assigned to cartel case killed in car accident The Guardian","title":"U.S. officials killed in Mexico after anti-drug operation were working for CIA, AP sources say - PBS","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_cb10f516e5e2 in signals