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/CBMie0FVX3lxTFBjalpqUTZwdk1DbU4td09KRW1jeFF5ektUQ2h1T2lFbElLUFMwRDhIVlpNRXVWbVVyVFNoM3hLR2x5NlZMa19tV1A3aW5lT1NWczV0emZCb0RhQUZVcmxoU2JCLXp4c0RWWkU4dmJOY3F2eGpLcXItLTZkdw?oc=5","as_of":"2026-04-19T09:01:05.710685+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/CBMie0FVX3lxTFBjalpqUTZwdk1DbU4td09KRW1jeFF5ektUQ2h1T2lFbElLUFMwRDhIVlpNRXVWbVVyVFNoM3hLR2x5NlZMa19tV1A3aW5lT1NWczV0emZCb0RhQUZVcmxoU2JCLXp4c0RWWkU4dmJOY3F2eGpLcXItLTZkdw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_22a298eadc68e0ad","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-19T09:24:32.099812+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBjalpqUTZwdk1DbU4td09KRW1jeFF5ektUQ2h1T2lFbElLUFMwRDhIVlpNRXVWbVVyVFNoM3hLR2x5NlZMa19tV1A3aW5lT1NWczV0emZCb0RhQUZVcmxoU2JCLXp4c0RWWkU4dmJOY3F2eGpLcXItLTZkdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBjalpqUTZwdk1DbU4td09KRW1jeFF5ektUQ2h1T2lFbElLUFMwRDhIVlpNRXVWbVVyVFNoM3hLR2x5NlZMa19tV1A3aW5lT1NWczV0emZCb0RhQUZVcmxoU2JCLXp4c0RWWkU4dmJOY3F2eGpLcXItLTZkdw?oc=5","source_event_id":"evt_2231b96c7fed","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"7ec889d7cedcf72e","published_at":"2026-04-19T04:01:55+00:00","publisher_domain":"cnn.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 to read Bible verse from Oval Office after feud with Pope and deleted AI image - CNN","Source summary: Trump to read Bible verse from Oval Office after feud with Pope and deleted AI image CNN Trump to release reading of scripture days after angering many Christians Politico \u2018America Reads the Bible\u2019 kicks off in DC as hundreds gather on red carpet for weeklong event Fox News Trump Will Participate in a Marathon Bible Reading The New York Times Trump to join public Bible reading as Pope Leo clash simmers The Hill"],"numeric_claims":[],"primary_claim":"Trump to read Bible verse from Oval Office after feud with Pope and deleted AI image - CNN","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Trump to read Bible verse from Oval Office after feud with Pope and deleted AI image CNN Trump to release reading of scripture days after angering many Christians Politico \u2018America Reads the Bible\u2019 kicks off in DC as hundreds gather on red carpet for weeklong event Fox News Trump Will Participate in a Marathon Bible Reading The New York Times Trump to join public Bible reading as Pope Leo clash si","topics":["news headline"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Trump to read Bible verse from Oval Office after feud with Pope and deleted AI image CNN Trump to release reading of scripture days after angering many Christians Politico \u2018America Reads the Bible\u2019 kicks off in DC as hundreds gather on red carpet for weeklong event Fox News Trump Will Participate in a Marathon Bible Reading The New York Times Trump to join public Bible reading as Pope Leo clash simmers The Hill","title":"Trump to read Bible verse from Oval Office after feud with Pope and deleted AI image - CNN","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_28e8cdda9930 in signals