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/CBMiiAFBVV95cUxPUjRNU0dwd1NQTkxVZWV2XzkwNjB5bDR0ek9xZzB2cnJUZldSUnNCM3VoODRDdWJyQ0pHME93V0hWR2lhUnQ5SW92QXdYcVZoOWx2U3JGZ2ZXNWxEd2ltaDk5cmdEWjh0dHRKY3FxdXNfbVpPODFFb0VzNVM1dUVid0lJSFRCLTc2?oc=5","as_of":"2026-04-17T17:17:12.247117+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/CBMiiAFBVV95cUxPUjRNU0dwd1NQTkxVZWV2XzkwNjB5bDR0ek9xZzB2cnJUZldSUnNCM3VoODRDdWJyQ0pHME93V0hWR2lhUnQ5SW92QXdYcVZoOWx2U3JGZ2ZXNWxEd2ltaDk5cmdEWjh0dHRKY3FxdXNfbVpPODFFb0VzNVM1dUVid0lJSFRCLTc2?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e2fa34062a854b84","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-17T22:07:23.181566+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPUjRNU0dwd1NQTkxVZWV2XzkwNjB5bDR0ek9xZzB2cnJUZldSUnNCM3VoODRDdWJyQ0pHME93V0hWR2lhUnQ5SW92QXdYcVZoOWx2U3JGZ2ZXNWxEd2ltaDk5cmdEWjh0dHRKY3FxdXNfbVpPODFFb0VzNVM1dUVid0lJSFRCLTc2?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPUjRNU0dwd1NQTkxVZWV2XzkwNjB5bDR0ek9xZzB2cnJUZldSUnNCM3VoODRDdWJyQ0pHME93V0hWR2lhUnQ5SW92QXdYcVZoOWx2U3JGZ2ZXNWxEd2ltaDk5cmdEWjh0dHRKY3FxdXNfbVpPODFFb0VzNVM1dUVid0lJSFRCLTc2?oc=5","source_event_id":"evt_b8e96430f5f3","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ce06739f73613757","published_at":"2026-04-17T16:40:34+00:00","publisher_domain":"politico.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: Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal - Politico","Source summary: Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal Politico Tufts Student Who Was Held in Immigration Detention Returns to Turkey The New York Times Tufts scholar Rumeysa Ozturk returns to Turkey after immigration arrest, detention WCVB Tufts University graduate detained by ICE last year in Somerville to return to Turkey WHDH R\u00fcmeysa \u00d6zt\u00fcrk, Tufts University grad arreste"],"numeric_claims":[],"primary_claim":"Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal - Politico","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal Politico Tufts Student Who Was Held in Immigration Detention Returns to Turkey The New York Times Tufts scholar Rumeysa Ozturk returns to Turkey after immigration arrest, detention WCVB Tufts University graduate detained by ICE last year in Somerville to return to Turkey WHDH R\u00fcmeysa \u00d6zt\u00fcrk, Tufts Uni","topics":["news headline"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal Politico Tufts Student Who Was Held in Immigration Detention Returns to Turkey The New York Times Tufts scholar Rumeysa Ozturk returns to Turkey after immigration arrest, detention WCVB Tufts University graduate detained by ICE last year in Somerville to return to Turkey WHDH R\u00fcmeysa \u00d6zt\u00fcrk, Tufts University grad arrested by ICE agents last year, returns to Turkey The Boston Globe","title":"Former Tufts student detained over pro-Palestinian op-ed self-deports as part of Trump admin deal - Politico","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_386738f4bdfb in signals