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/CBMidEFVX3lxTE0wLWM0UVUzUDVpNHJzMkx1WTZzcFlfaEhPekhPeUMxZk5xZjhzSHYwUDBHb241bWpMQlQ3eTdsTE90djdxUGZDRWlSQjdQaDd3c2ZoMTFmYnFiSzV3ck5ZRG9JYk96ZkRSWi12bHZKaGFLd2pB?oc=5","as_of":"2026-04-20T01:33:03.125805+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/CBMidEFVX3lxTE0wLWM0UVUzUDVpNHJzMkx1WTZzcFlfaEhPekhPeUMxZk5xZjhzSHYwUDBHb241bWpMQlQ3eTdsTE90djdxUGZDRWlSQjdQaDd3c2ZoMTFmYnFiSzV3ck5ZRG9JYk96ZkRSWi12bHZKaGFLd2pB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_87fc6305c5743c49","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:33:16.169992+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMidEFVX3lxTE0wLWM0UVUzUDVpNHJzMkx1WTZzcFlfaEhPekhPeUMxZk5xZjhzSHYwUDBHb241bWpMQlQ3eTdsTE90djdxUGZDRWlSQjdQaDd3c2ZoMTFmYnFiSzV3ck5ZRG9JYk96ZkRSWi12bHZKaGFLd2pB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMidEFVX3lxTE0wLWM0UVUzUDVpNHJzMkx1WTZzcFlfaEhPekhPeUMxZk5xZjhzSHYwUDBHb241bWpMQlQ3eTdsTE90djdxUGZDRWlSQjdQaDd3c2ZoMTFmYnFiSzV3ck5ZRG9JYk96ZkRSWi12bHZKaGFLd2pB?oc=5","source_event_id":"evt_e626f87ca818","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"884cafe3f80cffa7","published_at":"2026-04-19T15:54:00+00:00","publisher_domain":"wsj.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\u2019s Fears on the Iran War - WSJ","Source summary: Trump\u2019s Fears on the Iran War WSJ Behind Trump\u2019s Public Bravado on the War, He Grapples With His Own Fears WSJ White House Leak Reveals Trump Booted From Briefing After Hours-Long Freakout The Daily Beast Trump managing Iran war based on conflicting caprices that blindside his aides \u2014 report The Times of Israel Trump kept out of the room during operation to find downed pilots in Iran after \u2018screaming\u2019 at aides for ho"],"numeric_claims":[],"primary_claim":"Trump\u2019s Fears on the Iran War - WSJ","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Trump\u2019s Fears on the Iran War WSJ Behind Trump\u2019s Public Bravado on the War, He Grapples With His Own Fears WSJ White House Leak Reveals Trump Booted From Briefing After Hours-Long Freakout The Daily Beast Trump managing Iran war based on conflicting caprices that blindside his aides \u2014 report The Times of Israel Trump kept out of the room during operation to find downed pilots in Iran after \u2018scream","topics":["news headline"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Trump\u2019s Fears on the Iran War WSJ Behind Trump\u2019s Public Bravado on the War, He Grapples With His Own Fears WSJ White House Leak Reveals Trump Booted From Briefing After Hours-Long Freakout The Daily Beast Trump managing Iran war based on conflicting caprices that blindside his aides \u2014 report The Times of Israel Trump kept out of the room during operation to find downed pilots in Iran after \u2018screaming\u2019 at aides for hours, report says The Independent","title":"Trump\u2019s Fears on the Iran War - WSJ","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_6d9512912046 in signals