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-07T23:39:52.219373+00:00","dedupe_key":"signal_enriched:news_delta:33fa81b35186c38b","evidence_event_ids":["evt_60c3f3a7cf9e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPdTczVTRpdzdFVXZrazNqcTF3X3FIWEdURTZZeHZfSEJIS09ESDFKLXcyc0R5YklkSnVFNU1QeW1vTVVyTjd6eVIxbHBrV3BrZm9vSkJzcXN3VWJZT2JYUHFPNVl6M2h6YmRTb2ROWkVmbHU5WFFhWkJiWjVxbnNtXzVUdkxMV1N3S1NRMW9zY0l3QQ?oc=5","as_of":"2026-04-07T23:39:52.219373+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/CBMikgFBVV95cUxPdTczVTRpdzdFVXZrazNqcTF3X3FIWEdURTZZeHZfSEJIS09ESDFKLXcyc0R5YklkSnVFNU1QeW1vTVVyTjd6eVIxbHBrV3BrZm9vSkJzcXN3VWJZT2JYUHFPNVl6M2h6YmRTb2ROWkVmbHU5WFFhWkJiWjVxbnNtXzVUdkxMV1N3S1NRMW9zY0l3QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bbc235693930190f","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-08T00:38:35.524419+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPdTczVTRpdzdFVXZrazNqcTF3X3FIWEdURTZZeHZfSEJIS09ESDFKLXcyc0R5YklkSnVFNU1QeW1vTVVyTjd6eVIxbHBrV3BrZm9vSkJzcXN3VWJZT2JYUHFPNVl6M2h6YmRTb2ROWkVmbHU5WFFhWkJiWjVxbnNtXzVUdkxMV1N3S1NRMW9zY0l3QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPdTczVTRpdzdFVXZrazNqcTF3X3FIWEdURTZZeHZfSEJIS09ESDFKLXcyc0R5YklkSnVFNU1QeW1vTVVyTjd6eVIxbHBrV3BrZm9vSkJzcXN3VWJZT2JYUHFPNVl6M2h6YmRTb2ROWkVmbHU5WFFhWkJiWjVxbnNtXzVUdkxMV1N3S1NRMW9zY0l3QQ?oc=5","source_event_id":"evt_60c3f3a7cf9e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4868d499237d218b","published_at":"2026-04-07T22:40:43+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Viktor Orb\u00e1n","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Hungary","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"European Union (EU)","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"","name":"Budapest","relevance":"medium","symbol":"","type":"city"},{"asset_class":"","name":"Iran negotiations","relevance":"low","symbol":"","type":"geopolitical_process"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting substantive details (it appears to be page styling/HTML).","No election date, vote share, or specific policy commitments are included in the provided headline/summary.","The exact content of Trump\u2019s phone call and Vance\u2019s rally remarks are not specified.","The nature of the \u201ccheering\u201d (public event vs. social media vs. remarks) is not detailed.","The specific EU criticisms are not enumerated in the provided text."],"key_facts":["The New York Times headline indicates Trump and Vance cheered on Viktor Orb\u00e1n in Hungary\u2019s election race.","The provided source summary states JD Vance backed Orb\u00e1n\u2019s re-election bid and made time to visit Hungary/Budapest to support Orb\u00e1n.","The source summary also states Trump stumped for Orb\u00e1n in a phone call during Vance\u2019s rally.","The source summary frames Vance\u2019s actions as occurring amid Iran negotiations (contextual linkage, not quantified).","The source summary includes that Vance hit out at the EU (directional political stance), but specific claims are not included in the provided text."],"numeric_claims":[],"primary_claim":"Trump and JD Vance cheered and supported Viktor Orb\u00e1n\u2019s re-election campaign in Hungary during the Hungarian race.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports that Donald Trump and JD Vance publicly backed Hungarian Prime Minister Viktor Orb\u00e1n during Hungary\u2019s election campaign, with Vance visiting Budapest to support Orb\u00e1n\u2019s re-election bid. The signal frames this as part of broader US political alignment with Orb\u00e1n amid ongoing international negotiations (notably Iran-related).","topics":["Hungarian election","US political support for foreign leader","Orb\u00e1n re-election","Trump-Vance foreign policy alignment","EU relations","Budapest visit"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"\u2018I Love Viktor\u2019: Trump and Vance Cheer on Orban in Hungarian Race The New York Times JD Vance backs Orb\u00e1n's re-election bid in Budapest visit and hits out at EU BBC Vance makes time to visit Hungary to support Orb\u00e1n amid Iran negotiations CNN MAGA's global model faces existential test in Hungary Axios Trump stumps for Viktor Orb\u00e1n in phone call during Vance\u2019s rally Politico","title":"\u2018I Love Viktor\u2019: Trump and Vance Cheer on Orban in Hungarian Race - The New York Times","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 2359 in events