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/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","as_of":"2026-04-20T01:17:56.239426+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/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fc7daab6fa2edcce","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-20T01:18:14.484227+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?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/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","source_event_id":"evt_1700f0fb6c84","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"238d3a5f3f00b852","published_at":"2026-04-19T21:45:26+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: Trump DOJ redoubling election scrutiny efforts - Politico","Source summary: Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 2020 Election Mediaite"],"numeric_claims":[],"primary_claim":"Trump DOJ redoubling election scrutiny efforts - Politico","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 202","topics":["news headline"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 2020 Election Mediaite","title":"Trump DOJ redoubling election scrutiny efforts - 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_43dbb74cc6ca in signals