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/CBMiugFBVV95cUxQdmRtNFdNeU5aYnl4NGktMTdsdkZlUFFIRnh2S2xELVlzVjNKYS1aaWdGZHpGZ2o1RlF0aXZKUGE4OGREMGl3Y01EUVJWZG9BM29oQTJtRTFJSWpKUk5rMHJBTkFMQ0lxWUtSRnIwdUVVbXdERmg3MEdNZWtNX1pmYWlJNERjWUhDcmNEazVEQmprWE1JQjhfSFNrRldoQmhmSTNUR3NxRXpkMWpVQ1BaSU9XeF8yNmxXcUE?oc=5","as_of":"2026-04-10T15:28:44.216036+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/CBMiugFBVV95cUxQdmRtNFdNeU5aYnl4NGktMTdsdkZlUFFIRnh2S2xELVlzVjNKYS1aaWdGZHpGZ2o1RlF0aXZKUGE4OGREMGl3Y01EUVJWZG9BM29oQTJtRTFJSWpKUk5rMHJBTkFMQ0lxWUtSRnIwdUVVbXdERmg3MEdNZWtNX1pmYWlJNERjWUhDcmNEazVEQmprWE1JQjhfSFNrRldoQmhmSTNUR3NxRXpkMWpVQ1BaSU9XeF8yNmxXcUE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d9313d63fbc66a68","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-10T16:21:23.222474+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQdmRtNFdNeU5aYnl4NGktMTdsdkZlUFFIRnh2S2xELVlzVjNKYS1aaWdGZHpGZ2o1RlF0aXZKUGE4OGREMGl3Y01EUVJWZG9BM29oQTJtRTFJSWpKUk5rMHJBTkFMQ0lxWUtSRnIwdUVVbXdERmg3MEdNZWtNX1pmYWlJNERjWUhDcmNEazVEQmprWE1JQjhfSFNrRldoQmhmSTNUR3NxRXpkMWpVQ1BaSU9XeF8yNmxXcUE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQdmRtNFdNeU5aYnl4NGktMTdsdkZlUFFIRnh2S2xELVlzVjNKYS1aaWdGZHpGZ2o1RlF0aXZKUGE4OGREMGl3Y01EUVJWZG9BM29oQTJtRTFJSWpKUk5rMHJBTkFMQ0lxWUtSRnIwdUVVbXdERmg3MEdNZWtNX1pmYWlJNERjWUhDcmNEazVEQmprWE1JQjhfSFNrRldoQmhmSTNUR3NxRXpkMWpVQ1BaSU9XeF8yNmxXcUE?oc=5","source_event_id":"evt_7ca1562e5973","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c029187a22f46321","published_at":"2026-04-10T13:31:51+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_leader","name":"Xi Jinping","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_leader","name":"Taiwan opposition leader (Cheng Li-wun)","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign_state","name":"China (PRC)","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign_state","name":"Taiwan","relevance":"high","symbol":"","type":"country/region"},{"asset_class":"news_source","name":"NBC News","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable substantive content beyond page styling; therefore, details (e.g., exact date, location specifics, exact military actions/units, and any stated policy changes) cannot be verified from the article text itself.","The identities and claims about \u201cfirst in a decade\u201d and Xi\u2019s \u201cthreat\u201d wording are taken from the provided source summary and may be incomplete or paraphrased.","The headline delta does not specify what changed versus a prior headline (e.g., whether the military pressure increased is new in this update).","No near-term catalyst timing (e.g., days/weeks) is stated in the provided headline/summary beyond the contemporaneous framing."],"key_facts":["NBC News headline states Xi Jinping talked peace with Taiwan\u2019s opposition leader.","NBC News headline states Beijing is raising military pressure even as the peace talks occur.","The provided source summary indicates the meeting was described as the first cross-strait opposition talks in a decade (uncertainty: attributed to the summary, not fully verifiable from the cleaned article text provided).","The provided source summary indicates Xi invoked a \u201cthreat\u201d of Taiwan independence during the meeting (uncertainty: from the summary, not directly verifiable from the cleaned article text provided)."],"numeric_claims":[],"primary_claim":"Xi Jinping held cross-strait peace talks with Taiwan\u2019s opposition leader while Beijing raised military pressure toward Taiwan.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"NBC News reports that Chinese President Xi Jinping met with Taiwan\u2019s opposition leader to discuss peace across the Taiwan Strait while Beijing simultaneously increased military pressure. The headline frames the talks as occurring alongside heightened security rhetoric and pressure from China.","topics":["China-Taiwan relations","cross-strait talks","military pressure","Taiwan independence rhetoric","opposition leader meeting"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"China's Xi talks peace with Taiwan's opposition leader even as Beijing raises military pressure NBC News China's Xi invokes 'threat' of Taiwan independence in first cross-strait opposition talks in a decade CNBC Taiwanese Opposition Leader Makes \u201cJourney of Peace\u201d to Chinese Mainland, Meets with Xi Jinping Democracy Now! Cheng Li-wun: Taiwan opposition leader meets Xi Jinping in Beijing BBC Xi Hosts Taiwan Opposition Leader to Draw Island Closer to China WSJ","title":"China's Xi talks peace with Taiwan's opposition leader even as Beijing raises military pressure - NBC 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_858fc682685f in signals