SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-14T11:35:08.345142+00:00","dedupe_key":"signal_enriched:news_delta:f87a3da75f7bb6a9","evidence_event_ids":["evt_1a9de94c6b86"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 42018 in events