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/CBMirwFBVV95cUxNNjJLdGJIV0JiYmNxMmdGWmUxOS1BS1E4QWgtbEVEVkI2bDRCMkdqMXhCc1RobWtMOHAwOVVuZXNNdG4tS3FseEFZSGVsNDVhZXl6Si01U2dXdnNwelJkdU5FVlNzR2tfTVhsZ011OVdaWjJUV0txT2ZxbWJfVWFhRVNNMy1RNkVxZ2pUMnJWVnJFaXlsaF84blJEN0NabzNUYVl3bXNzUURJWEVaREF3?oc=5","as_of":"2026-04-08T00:10:40.943922+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/CBMirwFBVV95cUxNNjJLdGJIV0JiYmNxMmdGWmUxOS1BS1E4QWgtbEVEVkI2bDRCMkdqMXhCc1RobWtMOHAwOVVuZXNNdG4tS3FseEFZSGVsNDVhZXl6Si01U2dXdnNwelJkdU5FVlNzR2tfTVhsZ011OVdaWjJUV0txT2ZxbWJfVWFhRVNNMy1RNkVxZ2pUMnJWVnJFaXlsaF84blJEN0NabzNUYVl3bXNzUURJWEVaREF3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fff78abdf94f37d4","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-08T00:42:23.918018+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNNjJLdGJIV0JiYmNxMmdGWmUxOS1BS1E4QWgtbEVEVkI2bDRCMkdqMXhCc1RobWtMOHAwOVVuZXNNdG4tS3FseEFZSGVsNDVhZXl6Si01U2dXdnNwelJkdU5FVlNzR2tfTVhsZ011OVdaWjJUV0txT2ZxbWJfVWFhRVNNMy1RNkVxZ2pUMnJWVnJFaXlsaF84blJEN0NabzNUYVl3bXNzUURJWEVaREF3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNNjJLdGJIV0JiYmNxMmdGWmUxOS1BS1E4QWgtbEVEVkI2bDRCMkdqMXhCc1RobWtMOHAwOVVuZXNNdG4tS3FseEFZSGVsNDVhZXl6Si01U2dXdnNwelJkdU5FVlNzR2tfTVhsZ011OVdaWjJUV0txT2ZxbWJfVWFhRVNNMy1RNkVxZ2pUMnJWVnJFaXlsaF84blJEN0NabzNUYVl3bXNzUURJWEVaREF3?oc=5","source_event_id":"evt_b7d76fce81c5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"91dcec25a9017845","published_at":"2026-04-07T17:32:41+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"China","relevance":"vetoing party","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"vetoing party","symbol":"","type":"country"},{"asset_class":"institution","name":"UN Security Council","relevance":"resolution venue","symbol":"","type":"international body"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"subject of the resolution","symbol":"","type":"maritime chokepoint"},{"asset_class":"political","name":"Trump (deadline referenced)","relevance":"timeline/catalyst reference","symbol":"","type":"political figure"}],"event_type":"geopolitical_risk","information_gaps":["The specific UN Security Council resolution number and the exact language of its measures are not provided in the supplied text.","The exact timing and date of the \u201cTrump deadline\u201d are not included.","The provided content does not specify which other Security Council members supported or opposed the resolution.","No direct market/price impact is stated in the provided text; only geopolitical risk implications are inferable."],"key_facts":["China and Russia vetoed a UN Security Council resolution concerning the Strait of Hormuz.","The resolution was described as aimed at reopening the Strait of Hormuz and/or protecting Hormuz shipping.","The veto reportedly occurred hours before a Trump deadline (exact deadline time not provided in the provided text).","China warned of \u201cserious consequences\u201d and \u201cfurther escalation\u201d while resisting the UN resolution (wording attributed in the provided source summary)."],"numeric_claims":[],"primary_claim":"China and Russia vetoed a UN Security Council resolution aimed at reopening/protecting shipping in the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"China and Russia vetoed a UN Security Council resolution related to reopening/protecting shipping in the Strait of Hormuz. The veto occurred hours before a stated Trump deadline, increasing near-term uncertainty around Hormuz shipping security.","topics":["UN Security Council veto","Strait of Hormuz shipping security","China-Russia alignment","Middle East maritime risk","diplomatic escalation"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"China and Russia Veto Security Council Resolution on Hormuz Bloomberg.com Russia, China veto UN resolution aimed at reopening Strait of Hormuz, hours before Trump deadline Fox News China and Russia veto UN resolution on protecting Hormuz shipping Reuters China Warns Of 'Serious Consequences' And 'Further Escalation' As Beijing Resists UN Resolution To Protect Hormuz Strait Shipping Yahoo Russia and China block UN resolution on Strait of Hormuz Al Jazeera","title":"China and Russia Veto Security Council Resolution on Hormuz - Bloomberg.com","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_ebdb16708a51 in signals