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/CBMihwFBVV95cUxON0c3ODhuRHJWMDJ0QmVlRW9USzdsTjBRRDNhVlVySmoyZUFaSy13cmZMRG56LVJlT0hEanNUQ2F3YjByZFU3ejdHTmdnNFV4dzQzQUtFOUhyc0g3M1dmOXh4VFNGVDJRcFNERE9JazdZY1BNZW1xWG5UdDZkMzVHR0tReFdrSms?oc=5","as_of":"2026-04-08T21:48:34.645404+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/CBMihwFBVV95cUxON0c3ODhuRHJWMDJ0QmVlRW9USzdsTjBRRDNhVlVySmoyZUFaSy13cmZMRG56LVJlT0hEanNUQ2F3YjByZFU3ejdHTmdnNFV4dzQzQUtFOUhyc0g3M1dmOXh4VFNGVDJRcFNERE9JazdZY1BNZW1xWG5UdDZkMzVHR0tReFdrSms?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_98825c1e0f17b950","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:55.355973+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxON0c3ODhuRHJWMDJ0QmVlRW9USzdsTjBRRDNhVlVySmoyZUFaSy13cmZMRG56LVJlT0hEanNUQ2F3YjByZFU3ejdHTmdnNFV4dzQzQUtFOUhyc0g3M1dmOXh4VFNGVDJRcFNERE9JazdZY1BNZW1xWG5UdDZkMzVHR0tReFdrSms?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"vox.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxON0c3ODhuRHJWMDJ0QmVlRW9USzdsTjBRRDNhVlVySmoyZUFaSy13cmZMRG56LVJlT0hEanNUQ2F3YjByZFU3ejdHTmdnNFV4dzQzQUtFOUhyc0g3M1dmOXh4VFNGVDJRcFNERE9JazdZY1BNZW1xWG5UdDZkMzVHR0tReFdrSms?oc=5","source_event_id":"evt_4e4e933f9ef8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cb8d961c04dc9069","published_at":"2026-04-08T15:00:00+00:00","publisher_domain":"vox.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"political_leader","name":"Viktor Orban","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_party","name":"Tisza party","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"political_movement","name":"MAGA","relevance":"medium","symbol":"","type":"political_movement"},{"asset_class":"media","name":"Reuters","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"Bloomberg","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"The Economist","relevance":"low","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"The Washington Post","relevance":"low","symbol":"","type":"news_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual Vox article content, so details beyond the headline and the supplied source summary cannot be verified.","No specific election date, vote share, or confidence interval is provided in the supplied text.","\u201cMedian projection\u201d is mentioned but the underlying methodology/source details are not included.","The nature of the \u201cbrink of defeat\u201d claim is not substantiated with concrete results in the provided text (only described as a possibility)."],"key_facts":["Vox.com headline states that MAGA\u2019s favorite strongman might be on the brink of defeat.","The provided source summary says Hungary's Tisza party is seen winning a two-thirds majority in parliament.","The provided source summary says Median projection shows Reuters\u2019 Viktor Orban is fighting for his political life.","The provided source summary includes: \u201cWhen emigration helps bad rulers survive\u201d (The Economist opinion).","The provided source summary includes: \u201cAs Viktor Orban goes, so goes MAGA?\u201d (The Washington Post)."],"numeric_claims":[{"label":"Parliament majority","value":"two-thirds"}],"primary_claim":"Hungary\u2019s Tisza party is projected to win a two-thirds majority in parliament, and Viktor Orban is described as fighting for his political life and possibly nearing defeat.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Vox.com frames Viktor Orb\u00e1n\u2019s political position in Hungary as potentially nearing defeat, citing projections that Hungary\u2019s Tisza party could win a two-thirds majority. The signal also links Orb\u00e1n\u2019s fate to broader MAGA-aligned politics in the U.S., implying a negative near-term outcome for that influence network if Orb\u00e1n loses.","topics":["Hungary elections/parliament majority projections","Viktor Orb\u00e1n political survival","Tisza party electoral prospects","U.S. MAGA influence linkage (as framed by Vox)"]},"source":"vox.com","source_domain":"vox.com","source_url":"https://www.vox.com","summary":"MAGA\u2019s favorite strongman might be on the brink of defeat vox.com Hungary's Tisza party seen winning two-thirds majority in parliament, Median projection shows Reuters Viktor Orban Is Fighting for His Political Life Bloomberg When emigration helps bad rulers survive The Economist Opinion | As Viktor Orban goes, so goes MAGA? The Washington Post","title":"MAGA\u2019s favorite strongman might be on the brink of defeat - vox.com","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_8303831978de in signals