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/CBMixwFBVV95cUxPcGgyTXhfMFd3MGpjVFBPc2tpZmF3YVYzRjZLYWZQeUMyUDBsdVh3TVhyTWhVTjlCcWx6YnRNZy1lZGRaNVF5MW91S1BNOFhFWDVlTWthYXFfdEhGUHAzUFlydGxlaGRtNkRJV1luSWktR2NudFcydXl6MmdESVBtM09LVmFBejdVTTlaZ08zMWV3RlpaOGpOUEswLVRENFV1T0pMOTkxRWhoc2I1MFVyUnRmczYydUNOajhQYkpLMDZBVEc2TTU4?oc=5","as_of":"2026-04-18T22:33:11.863243+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/CBMixwFBVV95cUxPcGgyTXhfMFd3MGpjVFBPc2tpZmF3YVYzRjZLYWZQeUMyUDBsdVh3TVhyTWhVTjlCcWx6YnRNZy1lZGRaNVF5MW91S1BNOFhFWDVlTWthYXFfdEhGUHAzUFlydGxlaGRtNkRJV1luSWktR2NudFcydXl6MmdESVBtM09LVmFBejdVTTlaZ08zMWV3RlpaOGpOUEswLVRENFV1T0pMOTkxRWhoc2I1MFVyUnRmczYydUNOajhQYkpLMDZBVEc2TTU4?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3948ca0118c1b3df","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-18T22:56:38.403748+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxPcGgyTXhfMFd3MGpjVFBPc2tpZmF3YVYzRjZLYWZQeUMyUDBsdVh3TVhyTWhVTjlCcWx6YnRNZy1lZGRaNVF5MW91S1BNOFhFWDVlTWthYXFfdEhGUHAzUFlydGxlaGRtNkRJV1luSWktR2NudFcydXl6MmdESVBtM09LVmFBejdVTTlaZ08zMWV3RlpaOGpOUEswLVRENFV1T0pMOTkxRWhoc2I1MFVyUnRmczYydUNOajhQYkpLMDZBVEc2TTU4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sun-sentinel.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxPcGgyTXhfMFd3MGpjVFBPc2tpZmF3YVYzRjZLYWZQeUMyUDBsdVh3TVhyTWhVTjlCcWx6YnRNZy1lZGRaNVF5MW91S1BNOFhFWDVlTWthYXFfdEhGUHAzUFlydGxlaGRtNkRJV1luSWktR2NudFcydXl6MmdESVBtM09LVmFBejdVTTlaZ08zMWV3RlpaOGpOUEswLVRENFV1T0pMOTkxRWhoc2I1MFVyUnRmczYydUNOajhQYkpLMDZBVEc2TTU4?oc=5","source_event_id":"evt_6e217b0fecb6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f9a60118741805f","published_at":"2026-04-18T21:59:48+00:00","publisher_domain":"sun-sentinel.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: The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again - Sun Sentinel","Source summary: The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again Sun Sentinel Live updates: Two Indian ships come under fire in Strait of Hormuz after Iran reasserts control NBC News Iran war live updates: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again AP News Merchant vessels report gunfire as they attempt to cross Hormuz, shipping sources say Reuters Iran\u2019s Hard"],"numeric_claims":[],"primary_claim":"The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again - Sun Sentinel","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again Sun Sentinel Live updates: Two Indian ships come under fire in Strait of Hormuz after Iran reasserts control NBC News Iran war live updates: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again AP News Merchant vessels report gunfire as they attempt to cross Hormuz, shipping sources say","topics":["news headline"]},"source":"Sun Sentinel","source_domain":"sun-sentinel.com","source_url":"https://www.sun-sentinel.com","summary":"The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again Sun Sentinel Live updates: Two Indian ships come under fire in Strait of Hormuz after Iran reasserts control NBC News Iran war live updates: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again AP News Merchant vessels report gunfire as they attempt to cross Hormuz, shipping sources say Reuters Iran\u2019s Hard-Liners Flex Their Muscle With a U-Turn Over Hormuz WSJ","title":"The Latest: Iran fires on ships in Strait of Hormuz as Tehran imposes restrictions again - Sun Sentinel","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_e548e927ca71 in signals