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/CBMihAFBVV95cUxPblplQXE4NmxoVHRHZjVIOXZyaFNXb0ZKcmRQMnVKcmE3eFR5cGpKUHhoT01JMHdOUXlZaC1iMTd5QncxX25mQjUyZ0pOQnlrRl9WalZ4V1BlZU1NMUozeUVhc0hSR0kteTZKc0xWOGphMGNDMDd1amxKRjJoM25IbU41NUM?oc=5","as_of":"2026-04-10T19:36:12.013806+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/CBMihAFBVV95cUxPblplQXE4NmxoVHRHZjVIOXZyaFNXb0ZKcmRQMnVKcmE3eFR5cGpKUHhoT01JMHdOUXlZaC1iMTd5QncxX25mQjUyZ0pOQnlrRl9WalZ4V1BlZU1NMUozeUVhc0hSR0kteTZKc0xWOGphMGNDMDd1amxKRjJoM25IbU41NUM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5a35d10a1b0276c8","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-10T20:15:45.597837+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPblplQXE4NmxoVHRHZjVIOXZyaFNXb0ZKcmRQMnVKcmE3eFR5cGpKUHhoT01JMHdOUXlZaC1iMTd5QncxX25mQjUyZ0pOQnlrRl9WalZ4V1BlZU1NMUozeUVhc0hSR0kteTZKc0xWOGphMGNDMDd1amxKRjJoM25IbU41NUM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPblplQXE4NmxoVHRHZjVIOXZyaFNXb0ZKcmRQMnVKcmE3eFR5cGpKUHhoT01JMHdOUXlZaC1iMTd5QncxX25mQjUyZ0pOQnlrRl9WalZ4V1BlZU1NMUozeUVhc0hSR0kteTZKc0xWOGphMGNDMDd1amxKRjJoM25IbU41NUM?oc=5","source_event_id":"evt_ceeaa7465ca8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"50a6ee87946f3544","published_at":"2026-04-10T14:10:11+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["Sunday"],"entities":[{"asset_class":"political_leader","name":"Viktor Orb\u00e1n","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign_state","name":"Hungary","relevance":"high","symbol":"","type":"country"},{"asset_class":"media_outlet","name":"NPR","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media_outlet","name":"The Atlantic","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media_outlet","name":"Politico","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media_outlet","name":"The Economist","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media_outlet","name":"The New York Times","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"political_leader","name":"Donald Trump","relevance":"low","symbol":"","type":"person"}],"event_type":"earnings","information_gaps":["The cleaned article text provided is not readable content (appears to be HTML/CSS), so specific details from NPR\u2019s \u201cfive things\u201d are not extractable here.","No vote totals, polling numbers, or specific election mechanics are included in the provided text.","The exact election date/year and whether it is parliamentary vs. presidential is not specified in the provided content.","No direct economic/market impact is stated in the provided text; only political risk is implied by the headlines."],"key_facts":["NPR published an article titled \u201cFive things to know about Hungary's election.\u201d","The provided source summary includes claims that Viktor Orb\u00e1n could actually lose Sunday\u2019s Hungarian election.","The provided source summary includes additional outlet headlines/opinions indicating Orb\u00e1n is in trouble and that even skewed elections might not save him.","The provided source summary includes a reference to Donald Trump in connection with Orb\u00e1n (\u201cOpinion | Viktor Orban\u2019s Fate Is a Warning Not to Get Too Close to Trump\u201d)."],"numeric_claims":[],"primary_claim":"Hungary\u2019s election on Sunday may put Viktor Orb\u00e1n\u2019s position at risk, with reporting suggesting he could actually lose.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"NPR\u2019s roundup highlights that Hungary\u2019s election on Sunday could be a political test for Viktor Orb\u00e1n, with multiple outlets suggesting he may face real electoral trouble. The near-term catalyst is the election outcome itself (Sunday).","topics":["Hungary election","Viktor Orb\u00e1n","European politics","electoral competitiveness","political risk","media roundup"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Five things to know about Hungary's election NPR Viktor Orb\u00e1n Could Actually Lose Sunday\u2019s Hungarian Election The Atlantic Trump\u2019s Favorite European Strongman Is in Trouble. Soccer Explains Why. Politico Even Hungary\u2019s skewed elections might not save Viktor Orban The Economist Opinion | Viktor Orban\u2019s Fate Is a Warning Not to Get Too Close to Trump The New York Times","title":"Five things to know about Hungary's election - NPR","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_2513bde05dee in signals