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/CBMiuAFBVV95cUxNckFzWkN5Q0tCMlJDNzhxczdKZDRCN0UtRWhOd1BnUVNKcHY0Nm9ia01JUWZ5SlY3eWNYbU9uSVFxSWhXd180YmtMV3FfTUkzcm5HM2hqUjVYeHZaakIzeHFoOFVqYk5OWW5CZ2dLeEd6WW9pMU1fU3VWbEo2aFBOeFBidnl6UW5KeU44WXJWRVVrREJydWU1aUNFWEFjSi1BWlQ5WkJBWGpJQmdSN3FJUzBkdVZsb1Et?oc=5","as_of":"2026-04-07T04:04:22.064106+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNckFzWkN5Q0tCMlJDNzhxczdKZDRCN0UtRWhOd1BnUVNKcHY0Nm9ia01JUWZ5SlY3eWNYbU9uSVFxSWhXd180YmtMV3FfTUkzcm5HM2hqUjVYeHZaakIzeHFoOFVqYk5OWW5CZ2dLeEd6WW9pMU1fU3VWbEo2aFBOeFBidnl6UW5KeU44WXJWRVVrREJydWU1aUNFWEFjSi1BWlQ5WkJBWGpJQmdSN3FJUzBkdVZsb1Et?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6025c531d2d6d8c0","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T17:20:07.522261+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNckFzWkN5Q0tCMlJDNzhxczdKZDRCN0UtRWhOd1BnUVNKcHY0Nm9ia01JUWZ5SlY3eWNYbU9uSVFxSWhXd180YmtMV3FfTUkzcm5HM2hqUjVYeHZaakIzeHFoOFVqYk5OWW5CZ2dLeEd6WW9pMU1fU3VWbEo2aFBOeFBidnl6UW5KeU44WXJWRVVrREJydWU1aUNFWEFjSi1BWlQ5WkJBWGpJQmdSN3FJUzBkdVZsb1Et?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNckFzWkN5Q0tCMlJDNzhxczdKZDRCN0UtRWhOd1BnUVNKcHY0Nm9ia01JUWZ5SlY3eWNYbU9uSVFxSWhXd180YmtMV3FfTUkzcm5HM2hqUjVYeHZaakIzeHFoOFVqYk5OWW5CZ2dLeEd6WW9pMU1fU3VWbEo2aFBOeFBidnl6UW5KeU44WXJWRVVrREJydWU1aUNFWEFjSi1BWlQ5WkJBWGpJQmdSN3FJUzBkdVZsb1Et?oc=5","source_event_id":"evt_9bf27f33445e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e50fd1dd4b9e9e13","published_at":"2026-04-07T02:26:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"To Lam","relevance":"primary","symbol":"","type":"person"},{"asset_class":"political","name":"Vietnam","relevance":"primary","symbol":"VN","type":"country"}],"event_type":"other","information_gaps":["Details on the implications of To Lam's presidency are not provided.","No specific timeline for expected changes or policies under his leadership."],"key_facts":["To Lam has been elected as state president of Vietnam.","The mandate is described as similar to China's leadership style."],"numeric_claims":[],"primary_claim":"To Lam wins the state presidency in Vietnam, gaining a China-style mandate.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"To Lam has been elected as Vietnam's state president, receiving a mandate similar to China's leadership style, which may consolidate power further in the country.","topics":["politics","leadership","Vietnam","China"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Vietnam's top leader To Lam wins state presidency, gets China-style mandate Reuters Vietnam\u2019s To Lam Secures Presidency, Tightens Grip on Power Bloomberg.com Vietnamese party chief elected state president chinadailyasia.com Vietnam reelects Chairman of the National Assembly Asia News Network Expectations for double-digit economic growth and institutional perfection Nhan Dan Online","title":"Vietnam's top leader To Lam wins state presidency, gets China-style mandate - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_db9ea73836ec in signals