SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_f93af90393db in signals