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/CBMioAFBVV95cUxPcllZUm1COWZlMUxpTkJmSTI3TERCdWFHRUtBRG5FdWxfZDc5d0ZXOEhHTk1YRDBZU1FRUF9IQkkxdTMtZU1RWkNaLWpFdHhkTGhYaGg3czVHTFJFQ3lqU1VWUDhqVnRwdlNXemhreEN5YTZLQXdtRFBmdUdxTmhsNzlMNTVoYzlHOUZlRkY3WjUxaExnUjBXTURydW54V3Nk?oc=5","as_of":"2026-04-19T17:09:55.332899+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxPcllZUm1COWZlMUxpTkJmSTI3TERCdWFHRUtBRG5FdWxfZDc5d0ZXOEhHTk1YRDBZU1FRUF9IQkkxdTMtZU1RWkNaLWpFdHhkTGhYaGg3czVHTFJFQ3lqU1VWUDhqVnRwdlNXemhreEN5YTZLQXdtRFBmdUdxTmhsNzlMNTVoYzlHOUZlRkY3WjUxaExnUjBXTURydW54V3Nk?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6ee7e76e6f7da2e4","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T17:11:26.057402+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxPcllZUm1COWZlMUxpTkJmSTI3TERCdWFHRUtBRG5FdWxfZDc5d0ZXOEhHTk1YRDBZU1FRUF9IQkkxdTMtZU1RWkNaLWpFdHhkTGhYaGg3czVHTFJFQ3lqU1VWUDhqVnRwdlNXemhreEN5YTZLQXdtRFBmdUdxTmhsNzlMNTVoYzlHOUZlRkY3WjUxaExnUjBXTURydW54V3Nk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxPcllZUm1COWZlMUxpTkJmSTI3TERCdWFHRUtBRG5FdWxfZDc5d0ZXOEhHTk1YRDBZU1FRUF9IQkkxdTMtZU1RWkNaLWpFdHhkTGhYaGg3czVHTFJFQ3lqU1VWUDhqVnRwdlNXemhreEN5YTZLQXdtRFBmdUdxTmhsNzlMNTVoYzlHOUZlRkY3WjUxaExnUjBXTURydW54V3Nk?oc=5","source_event_id":"evt_19de318e6c93","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"8902508a3d2d4654","published_at":"2026-04-19T14:31:00+00:00","publisher_domain":"apnews.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: UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies - AP News","Source summary: UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies AP News Arson attacks 'gathering momentum', Chief Rabbi says BBC British Counterterrorism Police Investigating Attacks Against Jewish Sites The New York Times Attempted arson at London synagogue is 3rd attack on Jewish site in past week: \"Sustained campaign of violence\" CBS News Britain\u2019s chief rabbi says Jews are facin"],"numeric_claims":[],"primary_claim":"UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies - AP News","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies AP News Arson attacks 'gathering momentum', Chief Rabbi says BBC British Counterterrorism Police Investigating Attacks Against Jewish Sites The New York Times Attempted arson at London synagogue is 3rd attack on Jewish site in past week: \"Sustained campaign of violence\" CBS News Britain\u2019s chief rabbi","topics":["news headline"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies AP News Arson attacks 'gathering momentum', Chief Rabbi says BBC British Counterterrorism Police Investigating Attacks Against Jewish Sites The New York Times Attempted arson at London synagogue is 3rd attack on Jewish site in past week: \"Sustained campaign of violence\" CBS News Britain\u2019s chief rabbi says Jews are facing campaign of violence after spate of arson attacks Politico","title":"UK police investigating if arson attacks on Jewish sites in London are the work of Iranian proxies - AP News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_7ff9dd32981c in signals