SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T03:15:56.762672+00:00","dedupe_key":"signal_enriched:news_delta:01bd006b9341363b","evidence_event_ids":["evt_1bb0f52a9894"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQZnQ3VEVjeTRWSWZFNWtTSjUwenM1dGFlaW95Q3pmcUxackF0ZlBYTkdUeEZ4QWROdGpDbGpPb2Q4VFdWeW1hV0w2U1cxaW82ZXNIMU82U3J2V0VOMk1XRndMQzlfMmVBbmpORFFvdWF6R094THE0bGk2cXl4Z0hqUTVDM01sQ09XOG83QXVvOTByRzBMaW9jOHZycTFMZmVOb29B?oc=5","as_of":"2026-04-08T03:15:56.762672+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/CBMiowFBVV95cUxQZnQ3VEVjeTRWSWZFNWtTSjUwenM1dGFlaW95Q3pmcUxackF0ZlBYTkdUeEZ4QWROdGpDbGpPb2Q4VFdWeW1hV0w2U1cxaW82ZXNIMU82U3J2V0VOMk1XRndMQzlfMmVBbmpORFFvdWF6R094THE0bGk2cXl4Z0hqUTVDM01sQ09XOG83QXVvOTByRzBMaW9jOHZycTFMZmVOb29B?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_81232864b98e470f","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-08T03:48:31.716782+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQZnQ3VEVjeTRWSWZFNWtTSjUwenM1dGFlaW95Q3pmcUxackF0ZlBYTkdUeEZ4QWROdGpDbGpPb2Q4VFdWeW1hV0w2U1cxaW82ZXNIMU82U3J2V0VOMk1XRndMQzlfMmVBbmpORFFvdWF6R094THE0bGk2cXl4Z0hqUTVDM01sQ09XOG83QXVvOTByRzBMaW9jOHZycTFMZmVOb29B?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/CBMiowFBVV95cUxQZnQ3VEVjeTRWSWZFNWtTSjUwenM1dGFlaW95Q3pmcUxackF0ZlBYTkdUeEZ4QWROdGpDbGpPb2Q4VFdWeW1hV0w2U1cxaW82ZXNIMU82U3J2V0VOMk1XRndMQzlfMmVBbmpORFFvdWF6R094THE0bGk2cXl4Z0hqUTVDM01sQ09XOG83QXVvOTByRzBMaW9jOHZycTFMZmVOb29B?oc=5","source_event_id":"evt_1bb0f52a9894","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a9f1854815868f76","published_at":"2026-04-07T15:47:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"China","relevance":"primary vetoing party","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"primary vetoing party","symbol":"","type":"country"},{"asset_class":"institutional","name":"United Nations Security Council","relevance":"voting forum where resolution was vetoed","symbol":"","type":"international body"},{"asset_class":"sovereign","name":"United States","relevance":"backed the resolution","symbol":"","type":"country"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"geographic focus of the resolution","symbol":"","type":"maritime chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not substantive (appears to be page styling/HTML), so details like the resolution number, exact wording, and the precise vote outcome (e.g., vote count) are not verifiable from the supplied text.","The excerpt mentions a \u201cTrump deadline,\u201d but the exact deadline date/time and how it relates to the UN vote are not specified.","The number of supporting countries is referenced in the source summary (\u201c10 countries join US\u201d), but the specific list is not included in the provided content."],"key_facts":["China and Russia vetoed a UN Security Council resolution related to protecting shipping through the Strait of Hormuz (Reuters).","The resolution was supported by the US and additional countries (as indicated in the provided source summary).","The veto occurred in the context of a near-term deadline referenced in the source summary (timing relative to a \u201cTrump deadline\u201d is mentioned, but exact date/time is not provided in the excerpt)."],"numeric_claims":[],"primary_claim":"China and Russia vetoed a UN Security Council resolution aimed at protecting/reopening shipping through the Strait of Hormuz.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"China and Russia vetoed a UN Security Council resolution intended to protect shipping through the Strait of Hormuz. The veto blocks the proposed UN action despite support from the US and other countries.","topics":["UN Security Council vote","Strait of Hormuz shipping","China-Russia veto","maritime security","Iran-related regional risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"China and Russia veto UN resolution on protecting Hormuz shipping Reuters China, Russia sink UN vote on Strait of Hormuz; 10 countries join US in support The Hill Russia, China veto UN resolution aimed at reopening Strait of Hormuz, hours before Trump deadline Fox News Russia and China block UN resolution on Strait of Hormuz Al Jazeera New Security Council Draft on Hormuz Eases Off Threats of Force Bloomberg.com","title":"China and Russia veto UN resolution on protecting Hormuz shipping - 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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 4297 in events