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/CBMipgFBVV95cUxPdHBlbnA3OEVLSVlrTGp4MUVfMVVkNVJ5T3RNMzJlOGlNQmk5OU5KOGhjMURqMFVTdzNNSnJOMm9PQ21TSVlGVEZZeUFjWFlfTUotZ0NnVXJLY2NUWGJoeHR1ZTQ2N0RrQ21qOGE5aFZ3TnJmY1hscVRBZ091RXJ2VnBPZ1I5Mm82TXpnSnJjZWJDU3lWemRtbU5iVlNxVWw5SElpd0tB?oc=5","as_of":"2026-04-11T22:23:23.546518+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/CBMipgFBVV95cUxPdHBlbnA3OEVLSVlrTGp4MUVfMVVkNVJ5T3RNMzJlOGlNQmk5OU5KOGhjMURqMFVTdzNNSnJOMm9PQ21TSVlGVEZZeUFjWFlfTUotZ0NnVXJLY2NUWGJoeHR1ZTQ2N0RrQ21qOGE5aFZ3TnJmY1hscVRBZ091RXJ2VnBPZ1I5Mm82TXpnSnJjZWJDU3lWemRtbU5iVlNxVWw5SElpd0tB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fd7c5bdfdb833044","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-11T22:56:04.928298+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPdHBlbnA3OEVLSVlrTGp4MUVfMVVkNVJ5T3RNMzJlOGlNQmk5OU5KOGhjMURqMFVTdzNNSnJOMm9PQ21TSVlGVEZZeUFjWFlfTUotZ0NnVXJLY2NUWGJoeHR1ZTQ2N0RrQ21qOGE5aFZ3TnJmY1hscVRBZ091RXJ2VnBPZ1I5Mm82TXpnSnJjZWJDU3lWemRtbU5iVlNxVWw5SElpd0tB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPdHBlbnA3OEVLSVlrTGp4MUVfMVVkNVJ5T3RNMzJlOGlNQmk5OU5KOGhjMURqMFVTdzNNSnJOMm9PQ21TSVlGVEZZeUFjWFlfTUotZ0NnVXJLY2NUWGJoeHR1ZTQ2N0RrQ21qOGE5aFZ3TnJmY1hscVRBZ091RXJ2VnBPZ1I5Mm82TXpnSnJjZWJDU3lWemRtbU5iVlNxVWw5SElpd0tB?oc=5","source_event_id":"evt_d911c489d9a6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ec9adef47a713f02","published_at":"2026-04-11T19:19:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["eve of poll"],"entities":[{"asset_class":"equity","name":"Viktor Orb\u00e1n","relevance":"primary political figure mentioned","symbol":"","type":"person"},{"asset_class":"equity","name":"P\u00e9ter Magyar","relevance":"primary political figure mentioned","symbol":"","type":"person"}],"event_type":"earnings","information_gaps":["No article text is provided beyond the headline and brief source summary.","The election date, polling details, and specific policy or market implications are not included in the provided text.","The mention of other outlets (NYT, NPR, NBC News, CBS News) is present only as a list of related headlines; no concrete details from those items are provided here."],"key_facts":["AP News headline states Orb\u00e1n and Magyar are making a final push for votes on the eve of the poll.","The provided source summary includes the same AP News framing about the final push for votes before the election."],"numeric_claims":[],"primary_claim":"Orb\u00e1n and Magyar are campaigning for votes on the eve of Hungary\u2019s election, according to AP News.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"AP News reports that Hungarian election rivals Viktor Orb\u00e1n and P\u00e9ter Magyar are making a final push for votes on the eve of the election poll.","topics":["Hungary election","political campaign","voting","Orb\u00e1n","Magyar"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Hungarian election rivals Orb\u00e1n and Magyar make final push for votes on eve of poll AP News Growing List of Orban Loyalists Defecting Before Critical Election The New York Times How Hungarian Prime Minister Viktor Orb\u00e1n\u2019s hometown became a symbol of excesses NPR After 16 years in power, Putin's closest friend in Europe faces a pivotal election NBC News Is strongman leader and MAGA darling Viktor Orb\u00e1n about to be ousted? What to know ahead of Hungary's elections CBS News","title":"Hungarian election rivals Orb\u00e1n and Magyar make final push for votes on eve of poll - AP News","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_5f436615aa1f in signals