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/CBMigwFBVV95cUxOQTlkRGNxWmVGVjZtS2owVWotSDhFaUdRT01RNDdEa3NOcTFYWVhhUkdIV01fWkNxajUtaUM0aThmcm5fOEpMcnBla1dxQVplV1llVnhaOFFtSkhjTnVja2g0MENMZExXdnVqVTJSRWVKb09hWTVmMEpkdDRpVjJwS2hqMA?oc=5","as_of":"2026-04-19T23:16:50.866461+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/CBMigwFBVV95cUxOQTlkRGNxWmVGVjZtS2owVWotSDhFaUdRT01RNDdEa3NOcTFYWVhhUkdIV01fWkNxajUtaUM0aThmcm5fOEpMcnBla1dxQVplV1llVnhaOFFtSkhjTnVja2g0MENMZExXdnVqVTJSRWVKb09hWTVmMEpkdDRpVjJwS2hqMA?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f6d4f5844a8a60b7","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-19T23:17:10.477556+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOQTlkRGNxWmVGVjZtS2owVWotSDhFaUdRT01RNDdEa3NOcTFYWVhhUkdIV01fWkNxajUtaUM0aThmcm5fOEpMcnBla1dxQVplV1llVnhaOFFtSkhjTnVja2g0MENMZExXdnVqVTJSRWVKb09hWTVmMEpkdDRpVjJwS2hqMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOQTlkRGNxWmVGVjZtS2owVWotSDhFaUdRT01RNDdEa3NOcTFYWVhhUkdIV01fWkNxajUtaUM0aThmcm5fOEpMcnBla1dxQVplV1llVnhaOFFtSkhjTnVja2g0MENMZExXdnVqVTJSRWVKb09hWTVmMEpkdDRpVjJwS2hqMA?oc=5","source_event_id":"evt_4711c86668e5","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"d75ee677d21edfc3","published_at":"2026-04-19T22:34:18+00:00","publisher_domain":"axios.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: U.S. takes Iran-flagged ship into custody, Trump says - Axios","Source summary: U.S. takes Iran-flagged ship into custody, Trump says Axios Oil prices jump 7% after Iran and U.S. attack ships as tensions escalate over Strait of Hormuz CNBC Trump says U.S. seized Iranian ship trying to bypass blockade of Strait of Hormuz The Washington Post US military seized Iranian-flagged container ship, Trump says The Guardian U.S. seizes Iranian ship amid tense ceasefire, and 8 kids killed in a mass shooting"],"numeric_claims":[],"primary_claim":"U.S. takes Iran-flagged ship into custody, Trump says - Axios","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"U.S. takes Iran-flagged ship into custody, Trump says Axios Oil prices jump 7% after Iran and U.S. attack ships as tensions escalate over Strait of Hormuz CNBC Trump says U.S. seized Iranian ship trying to bypass blockade of Strait of Hormuz The Washington Post US military seized Iranian-flagged container ship, Trump says The Guardian U.S. seizes Iranian ship amid tense ceasefire, and 8 kids kille","topics":["news headline"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"U.S. takes Iran-flagged ship into custody, Trump says Axios Oil prices jump 7% after Iran and U.S. attack ships as tensions escalate over Strait of Hormuz CNBC Trump says U.S. seized Iranian ship trying to bypass blockade of Strait of Hormuz The Washington Post US military seized Iranian-flagged container ship, Trump says The Guardian U.S. seizes Iranian ship amid tense ceasefire, and 8 kids killed in a mass shooting: Weekend Rundown NBC News","title":"U.S. takes Iran-flagged ship into custody, Trump says - Axios","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_7beb3587f70d in signals