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-08T01:58:44.404402+00:00","dedupe_key":"signal_enriched:news_delta:62f99f72d2b276f3","evidence_event_ids":["evt_52e134477ce0"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNSmF3MFZ0d3BianQySG1ydnRIeFB4MlNncmxuWHlMMEktOWVzSUlzaG80QXRjdXRteS1Vbm41VV8zVHpVeXNDMDFLWnhPbkZoZy0xdlZLS0NkM0l4djY1Y0lfaUJ5YjIxYVhlYW1WeDRCWWlFWlJLZjY3TWdLZUI3c3U5dTRGRklSOEFKV1l2UHdBTkI5UmJzRmw4eFROcVRoY3pfWl9jbEtIUkpHQW1YazFETUZ4NEtSTTJ2cENJSTPSAcYBQVVfeXFMTk43Q21DbFYwZkxuV09FNHZ1WC1md3o2aFJ5eE0zY3JMQ2xUU2JNM3JreWNvampDbW1TQndRSkRHamdCVDNJa3pLUXJmbE03eUdZX1VwYWMwcGJyaWFENmNaYTZNMVFzQ1I4c0lwTG5mNG5yU0o0R1VaaUs4UGxjcTB2RTF4N1R1djY2RTFMbUIxTUNCZkJoQ3djLW9sWTJGNTlqcml4dVo3dDlvQll4LXVSSkdTeWxfRHNTVF93NUtFLUF1dDVB?oc=5","as_of":"2026-04-08T01:58:44.404402+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNSmF3MFZ0d3BianQySG1ydnRIeFB4MlNncmxuWHlMMEktOWVzSUlzaG80QXRjdXRteS1Vbm41VV8zVHpVeXNDMDFLWnhPbkZoZy0xdlZLS0NkM0l4djY1Y0lfaUJ5YjIxYVhlYW1WeDRCWWlFWlJLZjY3TWdLZUI3c3U5dTRGRklSOEFKV1l2UHdBTkI5UmJzRmw4eFROcVRoY3pfWl9jbEtIUkpHQW1YazFETUZ4NEtSTTJ2cENJSTPSAcYBQVVfeXFMTk43Q21DbFYwZkxuV09FNHZ1WC1md3o2aFJ5eE0zY3JMQ2xUU2JNM3JreWNvampDbW1TQndRSkRHamdCVDNJa3pLUXJmbE03eUdZX1VwYWMwcGJyaWFENmNaYTZNMVFzQ1I4c0lwTG5mNG5yU0o0R1VaaUs4UGxjcTB2RTF4N1R1djY2RTFMbUIxTUNCZkJoQ3djLW9sWTJGNTlqcml4dVo3dDlvQll4LXVSSkdTeWxfRHNTVF93NUtFLUF1dDVB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_68887df763a0ade1","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T02:00:33.227701+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNSmF3MFZ0d3BianQySG1ydnRIeFB4MlNncmxuWHlMMEktOWVzSUlzaG80QXRjdXRteS1Vbm41VV8zVHpVeXNDMDFLWnhPbkZoZy0xdlZLS0NkM0l4djY1Y0lfaUJ5YjIxYVhlYW1WeDRCWWlFWlJLZjY3TWdLZUI3c3U5dTRGRklSOEFKV1l2UHdBTkI5UmJzRmw4eFROcVRoY3pfWl9jbEtIUkpHQW1YazFETUZ4NEtSTTJ2cENJSTPSAcYBQVVfeXFMTk43Q21DbFYwZkxuV09FNHZ1WC1md3o2aFJ5eE0zY3JMQ2xUU2JNM3JreWNvampDbW1TQndRSkRHamdCVDNJa3pLUXJmbE03eUdZX1VwYWMwcGJyaWFENmNaYTZNMVFzQ1I4c0lwTG5mNG5yU0o0R1VaaUs4UGxjcTB2RTF4N1R1djY2RTFMbUIxTUNCZkJoQ3djLW9sWTJGNTlqcml4dVo3dDlvQll4LXVSSkdTeWxfRHNTVF93NUtFLUF1dDVB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pbs.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNSmF3MFZ0d3BianQySG1ydnRIeFB4MlNncmxuWHlMMEktOWVzSUlzaG80QXRjdXRteS1Vbm41VV8zVHpVeXNDMDFLWnhPbkZoZy0xdlZLS0NkM0l4djY1Y0lfaUJ5YjIxYVhlYW1WeDRCWWlFWlJLZjY3TWdLZUI3c3U5dTRGRklSOEFKV1l2UHdBTkI5UmJzRmw4eFROcVRoY3pfWl9jbEtIUkpHQW1YazFETUZ4NEtSTTJ2cENJSTPSAcYBQVVfeXFMTk43Q21DbFYwZkxuV09FNHZ1WC1md3o2aFJ5eE0zY3JMQ2xUU2JNM3JreWNvampDbW1TQndRSkRHamdCVDNJa3pLUXJmbE03eUdZX1VwYWMwcGJyaWFENmNaYTZNMVFzQ1I4c0lwTG5mNG5yU0o0R1VaaUs4UGxjcTB2RTF4N1R1djY2RTFMbUIxTUNCZkJoQ3djLW9sWTJGNTlqcml4dVo3dDlvQll4LXVSSkdTeWxfRHNTVF93NUtFLUF1dDVB?oc=5","source_event_id":"evt_52e134477ce0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4fb85b2050f9d3a6","published_at":"2026-04-07T16:18:53+00:00","publisher_domain":"pbs.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Russia","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"China","relevance":"high","symbol":"","type":"country"},{"asset_class":"institution","name":"United Nations (UN)","relevance":"high","symbol":"","type":"international_organization"},{"asset_class":"geopolitical_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"},{"asset_class":"sovereign","name":"Trump (US)","relevance":"medium","symbol":"","type":"political_figure"},{"asset_class":"sovereign","name":"United States (US)","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting the actual resolution details (e.g., resolution number, exact language, what was watered down).","The specific timing (exact date/time of the Trump deadline) is not present in the provided text.","Which 10 countries joined the US in support is not listed in the provided content.","Whether the veto definitively blocked the resolution or only altered its scope is not fully specified beyond 'watered-down' in the headline delta."],"key_facts":["Russia and China vetoed a UN resolution concerning the Strait of Hormuz.","The veto resulted in a watered-down UN resolution (per the provided headline delta).","The veto occurred hours before a stated Trump deadline (per the provided source summary snippets).","Other countries reportedly joined the US in support of the resolution (per the provided source summary snippets)."],"numeric_claims":[],"primary_claim":"Russia and China vetoed a UN resolution aimed at reopening the Strait of Hormuz, leading to a watered-down resolution.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Russia and China vetoed a UN resolution related to reopening the Strait of Hormuz, resulting in a watered-down outcome. The action occurred shortly before a stated Trump deadline, with other countries reportedly supporting the US position.","topics":["UN resolution","veto","Strait of Hormuz","Russia-China relations","maritime shipping risk","Middle East geopolitics"]},"source":"pbs.org","source_domain":"pbs.org","source_url":"https://www.pbs.org","summary":"Russia and China veto watered-down UN resolution aimed at reopening the Strait of Hormuz pbs.org Russia and China block UN resolution on Strait of Hormuz Al Jazeera Russia, China veto UN resolution aimed at reopening Strait of Hormuz, hours before Trump deadline Fox News China Warns Of 'Serious Consequences' And 'Further Escalation' As Beijing Resists UN Resolution To Protect Hormuz Strait Shipping Yahoo China, Russia sink UN vote on Strait of Hormuz; 10 countries join US in support thehill.com","title":"Russia and China veto watered-down UN resolution aimed at reopening the Strait of Hormuz - pbs.org","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 3398 in events