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/CBMisgFBVV95cUxPdFRfbmJ2SUZBeW1XS2YzbUxWYS0zNXg0ang5RW9rTGNrUFlnVmxEVjFLVEpFVERDcEZhUzAwaHNVSTBJd3JoQjUyckF6dmpWVkxzaEVDMkpfdjVvU0loRjRfeTdGa1M1YUhaSWplRkNUTmYxR2U5Q2pZUW5lcHR1MmhyWGxtWEEtM3M4RHVPeE9nRW1nYU9oOGE3cGNYUkh1NTY2ZTdMNU50a2pualoxTVd3?oc=5","as_of":"2026-04-13T11:10:14.224400+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPdFRfbmJ2SUZBeW1XS2YzbUxWYS0zNXg0ang5RW9rTGNrUFlnVmxEVjFLVEpFVERDcEZhUzAwaHNVSTBJd3JoQjUyckF6dmpWVkxzaEVDMkpfdjVvU0loRjRfeTdGa1M1YUhaSWplRkNUTmYxR2U5Q2pZUW5lcHR1MmhyWGxtWEEtM3M4RHVPeE9nRW1nYU9oOGE3cGNYUkh1NTY2ZTdMNU50a2pualoxTVd3?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_41d212fa03747772","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T13:03:52.985863+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPdFRfbmJ2SUZBeW1XS2YzbUxWYS0zNXg0ang5RW9rTGNrUFlnVmxEVjFLVEpFVERDcEZhUzAwaHNVSTBJd3JoQjUyckF6dmpWVkxzaEVDMkpfdjVvU0loRjRfeTdGa1M1YUhaSWplRkNUTmYxR2U5Q2pZUW5lcHR1MmhyWGxtWEEtM3M4RHVPeE9nRW1nYU9oOGE3cGNYUkh1NTY2ZTdMNU50a2pualoxTVd3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPdFRfbmJ2SUZBeW1XS2YzbUxWYS0zNXg0ang5RW9rTGNrUFlnVmxEVjFLVEpFVERDcEZhUzAwaHNVSTBJd3JoQjUyckF6dmpWVkxzaEVDMkpfdjVvU0loRjRfeTdGa1M1YUhaSWplRkNUTmYxR2U5Q2pZUW5lcHR1MmhyWGxtWEEtM3M4RHVPeE9nRW1nYU9oOGE3cGNYUkh1NTY2ZTdMNU50a2pualoxTVd3?oc=5","source_event_id":"evt_85c3fd162ce0","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"0838e484f4a83568","published_at":"2026-04-13T09:15:43+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"China","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["No article body text was provided, so details such as who specifically in China made the statement, the timing of the U.S. blockade, and any proposed talk format/agenda are not available.","The signal includes other outlet snippets (CNN/WSJ/CNBC) but no Reuters-specific details beyond the headline/summary are provided."],"key_facts":["Reuters headline states China urged restraint over a U.S. blockade of the Strait of Hormuz.","Reuters headline states China backs talks."],"numeric_claims":[],"primary_claim":"China urged restraint over the U.S. blockade of the Strait of Hormuz and backed talks.","relevance_score":0.78,"sentiment":"mixed","source_quality":"unknown","summary":"China urged restraint regarding a U.S. blockade of the Strait of Hormuz and said it supports talks, according to Reuters.","topics":["Strait of Hormuz","U.S. blockade","China urges restraint","diplomatic talks","geopolitical risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"China urges restraint over US blockade of Strait of Hormuz, backs talks Reuters How the US Navy could blockade Iran\u2019s ports and sweep mines from the Strait of Hormuz CNN Iran war live: Trump says US to begin naval blockade of Iran's ports in the Strait of Hormuz Reuters U.S. Threat to Blockade Hormuz Sets Up Risky New Showdown WSJ Oil prices surge above $100 as U.S. Navy to blockade Iran's ports after peace talks fail CNBC","title":"China urges restraint over US blockade of Strait of Hormuz, backs talks - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/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_43dfab46ae30 in signals