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-10T09:50:18.744332+00:00","dedupe_key":"signal_enriched:news_delta:c3a53d10b1a0b2f5","evidence_event_ids":["evt_753eb5d24949"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE9zWFM4TkZjeE1mcHZFcUtDUmRuWm1xTDcybEtsTU5ZU3NiLVdpeFdLNVBJTFlpTjR0dFB3ajFmRnRXV2dvbk1KQXpYZmUwajJTcE9tcy1MV2JwcFlOVEJXTDRHMlRwenU0bE9TWGNGSEwxeVluY0pv?oc=5","as_of":"2026-04-10T09:50:18.744332+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/CBMid0FVX3lxTE9zWFM4TkZjeE1mcHZFcUtDUmRuWm1xTDcybEtsTU5ZU3NiLVdpeFdLNVBJTFlpTjR0dFB3ajFmRnRXV2dvbk1KQXpYZmUwajJTcE9tcy1MV2JwcFlOVEJXTDRHMlRwenU0bE9TWGNGSEwxeVluY0pv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7906b3655fd19e01","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-10T09:50:58.913121+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE9zWFM4TkZjeE1mcHZFcUtDUmRuWm1xTDcybEtsTU5ZU3NiLVdpeFdLNVBJTFlpTjR0dFB3ajFmRnRXV2dvbk1KQXpYZmUwajJTcE9tcy1MV2JwcFlOVEJXTDRHMlRwenU0bE9TWGNGSEwxeVluY0pv?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.eu","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE9zWFM4TkZjeE1mcHZFcUtDUmRuWm1xTDcybEtsTU5ZU3NiLVdpeFdLNVBJTFlpTjR0dFB3ajFmRnRXV2dvbk1KQXpYZmUwajJTcE9tcy1MV2JwcFlOVEJXTDRHMlRwenU0bE9TWGNGSEwxeVluY0pv?oc=5","source_event_id":"evt_753eb5d24949","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1d5cb4e743c9efaa","published_at":"2026-04-10T03:00:00+00:00","publisher_domain":"politico.eu","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Hungary","relevance":"high","symbol":"","type":"country"},{"asset_class":"person","name":"Viktor Orb\u00e1n","relevance":"high","symbol":"","type":"politician"},{"asset_class":"media","name":"politico.eu","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not contain the substantive content needed to extract additional concrete details (e.g., election date, polling, specific watchpoints).","The signal does not specify the exact election date/time or the specific \u201chow to watch\u201d mechanics (e.g., which results to track, when polls close).","The event_type is set to earnings by the schema enum; however, this is clearly political/election coverage, so the categorization is uncertain/mismatched."],"key_facts":["Politico.eu published an article titled along the lines of \u201cHow to watch the Hungarian election like a pro.\u201d","The provided source summary indicates Hungarian election campaigns are in their final stretch.","The provided source summary states Orb\u00e1n is fighting to remain in power.","The signal includes references to other outlets (The Guardian, The New York Times, Council on Foreign Relations) discussing aspects of the election and Orb\u00e1n\u2019s prospects."],"numeric_claims":[],"primary_claim":"Hungary\u2019s election campaigns are in the final stretch, with Viktor Orb\u00e1n seeking to remain in power, and Politico.eu provides guidance on how to watch the election.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Politico.eu is running a guide-style piece on how to follow the Hungarian election as campaigning enters its final stretch. The coverage frames the election as a contest over whether Viktor Orb\u00e1n can remain in power.","topics":["Hungarian election","Viktor Orb\u00e1n","campaigning","election coverage","Europe live"]},"source":"politico.eu","source_domain":"politico.eu","source_url":"https://www.politico.eu","summary":"How to watch the Hungarian election like a pro politico.eu Hungary election campaigns enter final stretch as Orb\u00e1n fights to remain in power \u2013 Europe live The Guardian This Hungarian Town Explains Why Orban Could Lose on Sunday The New York Times How Soccer Assisted Viktor Orb\u00e1n\u2019s Rise \u2014 and Maybe His Fall Politico Ousting Orb\u00e1n May Be the Easy Part Council on Foreign Relations","title":"How to watch the Hungarian election like a pro - politico.eu","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 15326 in events