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/CBMi5AFBVV95cUxPLW9DMGtRVEhDT2xENmVIU3dKZVpXa1R6TE15VHdIdEhzVGZfTUNLZkxhbm9NeEpGWl9COGgyWHB6NUtWajRSd19ybm9ZZHRQenBYc0VjeVNiXzk4YVY0V3dKWmg1SHNhLU5zWXZCU3RzVURXU3hOeTdxQ0liMXFOc0M4Z3RNNGFjb3lGRzlmN3hHTlpHTFlDdzhtTERpemxScFFSakhFUG85Y2JONno2MExxU3JWTURnSWY0ZDhrS0tpblptcnlHb2pFdFViX3Mya1o4bnFmMnhIUWlFUVIyTVMwVGY?oc=5","as_of":"2026-04-14T11:35:08.345142+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxPLW9DMGtRVEhDT2xENmVIU3dKZVpXa1R6TE15VHdIdEhzVGZfTUNLZkxhbm9NeEpGWl9COGgyWHB6NUtWajRSd19ybm9ZZHRQenBYc0VjeVNiXzk4YVY0V3dKWmg1SHNhLU5zWXZCU3RzVURXU3hOeTdxQ0liMXFOc0M4Z3RNNGFjb3lGRzlmN3hHTlpHTFlDdzhtTERpemxScFFSakhFUG85Y2JONno2MExxU3JWTURnSWY0ZDhrS0tpblptcnlHb2pFdFViX3Mya1o4bnFmMnhIUWlFUVIyTVMwVGY?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_26219deb63ca0309","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T11:36:06.938449+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxPLW9DMGtRVEhDT2xENmVIU3dKZVpXa1R6TE15VHdIdEhzVGZfTUNLZkxhbm9NeEpGWl9COGgyWHB6NUtWajRSd19ybm9ZZHRQenBYc0VjeVNiXzk4YVY0V3dKWmg1SHNhLU5zWXZCU3RzVURXU3hOeTdxQ0liMXFOc0M4Z3RNNGFjb3lGRzlmN3hHTlpHTFlDdzhtTERpemxScFFSakhFUG85Y2JONno2MExxU3JWTURnSWY0ZDhrS0tpblptcnlHb2pFdFViX3Mya1o4bnFmMnhIUWlFUVIyTVMwVGY?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/CBMi5AFBVV95cUxPLW9DMGtRVEhDT2xENmVIU3dKZVpXa1R6TE15VHdIdEhzVGZfTUNLZkxhbm9NeEpGWl9COGgyWHB6NUtWajRSd19ybm9ZZHRQenBYc0VjeVNiXzk4YVY0V3dKWmg1SHNhLU5zWXZCU3RzVURXU3hOeTdxQ0liMXFOc0M4Z3RNNGFjb3lGRzlmN3hHTlpHTFlDdzhtTERpemxScFFSakhFUG85Y2JONno2MExxU3JWTURnSWY0ZDhrS0tpblptcnlHb2pFdFViX3Mya1o4bnFmMnhIUWlFUVIyTVMwVGY?oc=5","source_event_id":"evt_1a9de94c6b86","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"2a76a61ac5b254c1","published_at":"2026-04-14T04:18:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"China Evergrande founder","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Shenzhen court","relevance":"medium","symbol":"","type":"court"},{"asset_class":"equity","name":"Evergrande","relevance":"high","symbol":"","type":"company"}],"event_type":"conflict","information_gaps":["Founder\u2019s name is not provided in the provided text.","Specific fraud charges, case details, and sentencing information are not provided.","No timing/date of the court appearance is included.","No direct market/asset impact details are provided in the provided text.","No standardized ticker/symbol for Evergrande is provided in the provided text."],"key_facts":["Headline states the Evergrande founder pleaded guilty to fraud.","The plea is reported to have occurred in Shenzhen court.","Source cited is Reuters."],"numeric_claims":[],"primary_claim":"China Evergrande founder pleaded guilty to fraud in Shenzhen court, according to Reuters.","relevance_score":0.72,"sentiment":"negative","source_quality":"unknown","summary":"Reuters reports that the founder of China Evergrande has pleaded guilty to fraud in a Shenzhen court. The headline indicates a legal/corporate governance development tied to Evergrande\u2019s founder amid the company\u2019s downfall.","topics":["fraud plea","Shenzhen court","Evergrande founder","legal proceedings"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"China Evergrande founder pleads guilty to fraud in Shenzhen court Reuters Founder of China's Evergrande pleads guilty to fraud BBC China Evergrande Founder Pleads Guilty to Fraud in Downfall Bloomberg.com Founder of Fallen Chinese Property Giant Evergrande Pleads Guilty to Fraud WSJ China Evergrande's billionaire boss falls from circles of power to fraud plea Reuters","title":"China Evergrande founder pleads guilty to fraud in Shenzhen court - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_4a94fe855b5f in signals