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-08T21:48:34.629124+00:00","dedupe_key":"signal_enriched:news_delta:3891e9ea98f7886b","evidence_event_ids":["evt_75290c7c26a0"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNYi1Wd0tqT3FPcnUzdmNJRExISlcxb2NmUGdLSnBEbnFaaENsdTdRS25ydnh1SzdmZHFuTTloSkx3bjB2cmdnM3A5ZzBzaTJNVFpOY0NBdjlfWTVfN1dVWUR6bnNfSU1BZWQtaGIzUDF6Zk4wLXFRWUtETWZkcWVhcUtmVzJ4eG4xVFBFdkFzZFgxLWpJR09tbUxZendRUV9jRjNveDg5NmVYZ2UtZ0RlNjVyaTBkWjRfaDJtQ2xyYUdtMGJPZ3c?oc=5","as_of":"2026-04-08T21:48:34.629124+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/CBMixgFBVV95cUxNYi1Wd0tqT3FPcnUzdmNJRExISlcxb2NmUGdLSnBEbnFaaENsdTdRS25ydnh1SzdmZHFuTTloSkx3bjB2cmdnM3A5ZzBzaTJNVFpOY0NBdjlfWTVfN1dVWUR6bnNfSU1BZWQtaGIzUDF6Zk4wLXFRWUtETWZkcWVhcUtmVzJ4eG4xVFBFdkFzZFgxLWpJR09tbUxZendRUV9jRjNveDg5NmVYZ2UtZ0RlNjVyaTBkWjRfaDJtQ2xyYUdtMGJPZ3c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b334ef569427558e","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-09T22:15:46.263417+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNYi1Wd0tqT3FPcnUzdmNJRExISlcxb2NmUGdLSnBEbnFaaENsdTdRS25ydnh1SzdmZHFuTTloSkx3bjB2cmdnM3A5ZzBzaTJNVFpOY0NBdjlfWTVfN1dVWUR6bnNfSU1BZWQtaGIzUDF6Zk4wLXFRWUtETWZkcWVhcUtmVzJ4eG4xVFBFdkFzZFgxLWpJR09tbUxZendRUV9jRjNveDg5NmVYZ2UtZ0RlNjVyaTBkWjRfaDJtQ2xyYUdtMGJPZ3c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNYi1Wd0tqT3FPcnUzdmNJRExISlcxb2NmUGdLSnBEbnFaaENsdTdRS25ydnh1SzdmZHFuTTloSkx3bjB2cmdnM3A5ZzBzaTJNVFpOY0NBdjlfWTVfN1dVWUR6bnNfSU1BZWQtaGIzUDF6Zk4wLXFRWUtETWZkcWVhcUtmVzJ4eG4xVFBFdkFzZFgxLWpJR09tbUxZendRUV9jRjNveDg5NmVYZ2UtZ0RlNjVyaTBkWjRfaDJtQ2xyYUdtMGJPZ3c?oc=5","source_event_id":"evt_75290c7c26a0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d989a6db7cec5e58","published_at":"2026-04-08T15:39:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Hungary","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Viktor Orb\u00e1n","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Hezbollah","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Israel","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is largely non-informative (appears to be page styling/HTML), so the extraction relies on the user-provided source summary rather than the full Guardian article content.","No specific details are provided about what constitutes \u201cinterfering\u201d or what evidence/accusations Vance is responding to.","No timing/date for the Hungary\u2013Iran intelligence offer is included in the provided summary.","No market/financial entities are mentioned; directional impact is inferred only in geopolitical terms (risk/relations), not quantified."],"key_facts":["The Guardian reports JD Vance claimed the US is not interfering in Hungary\u2019s election.","The Washington Post reports that after a pager attack on Hezbollah, Hungary offered help to Iran.","The Times of Israel reports (as summarized) that Hungary offered Iran intelligence regarding the Hezbollah pager attack by Israel.","Politico and The New York Times are referenced in the provided source summary as covering Vance/Trump cheering on Orb\u00e1n in the Hungarian race and Vance\u2019s \u201cEuropean front\u201d war framing; specific claims are not included in the provided text."],"numeric_claims":[],"primary_claim":"JD Vance said the US is not interfering in Hungary\u2019s election (as reported by The Guardian).","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"JD Vance publicly denies that the US is interfering in Hungary\u2019s election, while multiple outlets also report Hungary offered Iran intelligence related to a Hezbollah pager attack. The near-term catalyst is the ongoing political campaign and the immediate post-attack diplomatic/security response.","topics":["US-Hungary relations","Hungarian election","political interference allegations","Middle East security","Hezbollah pager attack","Iran intelligence sharing","diplomatic response"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"JD Vance claims US is not interfering in Hungary election The Guardian After pager attack on Hezbollah, Hungary offered help to Iran The Washington Post Vance fights the war on the European front Politico \u2018I Love Viktor\u2019: Trump and Vance Cheer on Orban in Hungarian Race The New York Times Report: Hungary offered Iran intel on Hezbollah pager attack by Israel The Times of Israel","title":"JD Vance claims US is not interfering in Hungary election - The Guardian","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 8483 in events