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-08T13:34:56.787132+00:00","dedupe_key":"signal_enriched:news_delta:441f8ad711372ade","evidence_event_ids":["evt_33d0db4fff24"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQeXk1NDJ0LU1PalZ0TVFaRHRZVm94MzMzZEVNXzV5OXFZUkpEQnYwWnhmWWJaWEVlbkFYLXNjYk5xTW9wV3FZSnkzSmJ3aDN2MllxdUs2cXVuZi1uMkh1QnphVUFhN0tmeUtRcVFyU3l5dkNiUm1BZnVfV1ctNWk3MDVqNnRZNE1nZWxZR1dmd1h6V0pTd0FMbFZjbWFyeVJQSFhacHJ5VjVnVUdBTlVyNHM4amY?oc=5","as_of":"2026-04-08T13:34:56.787132+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/CBMitAFBVV95cUxQeXk1NDJ0LU1PalZ0TVFaRHRZVm94MzMzZEVNXzV5OXFZUkpEQnYwWnhmWWJaWEVlbkFYLXNjYk5xTW9wV3FZSnkzSmJ3aDN2MllxdUs2cXVuZi1uMkh1QnphVUFhN0tmeUtRcVFyU3l5dkNiUm1BZnVfV1ctNWk3MDVqNnRZNE1nZWxZR1dmd1h6V0pTd0FMbFZjbWFyeVJQSFhacHJ5VjVnVUdBTlVyNHM4amY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4e0a834f831446ab","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-08T14:29:17.333590+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQeXk1NDJ0LU1PalZ0TVFaRHRZVm94MzMzZEVNXzV5OXFZUkpEQnYwWnhmWWJaWEVlbkFYLXNjYk5xTW9wV3FZSnkzSmJ3aDN2MllxdUs2cXVuZi1uMkh1QnphVUFhN0tmeUtRcVFyU3l5dkNiUm1BZnVfV1ctNWk3MDVqNnRZNE1nZWxZR1dmd1h6V0pTd0FMbFZjbWFyeVJQSFhacHJ5VjVnVUdBTlVyNHM4amY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQeXk1NDJ0LU1PalZ0TVFaRHRZVm94MzMzZEVNXzV5OXFZUkpEQnYwWnhmWWJaWEVlbkFYLXNjYk5xTW9wV3FZSnkzSmJ3aDN2MllxdUs2cXVuZi1uMkh1QnphVUFhN0tmeUtRcVFyU3l5dkNiUm1BZnVfV1ctNWk3MDVqNnRZNE1nZWxZR1dmd1h6V0pTd0FMbFZjbWFyeVJQSFhacHJ5VjVnVUdBTlVyNHM4amY?oc=5","source_event_id":"evt_33d0db4fff24","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b254808e85167b8d","published_at":"2026-04-08T13:15:23+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"South Africa","relevance":"primary","symbol":"","type":"country"},{"asset_class":"market_index_group","name":"Emerging markets","relevance":"context","symbol":"","type":"market_group"},{"asset_class":"geopolitical_risk","name":"Iran conflict","relevance":"cause","symbol":"","type":"geopolitical_event"}],"event_type":"macro_policy","information_gaps":["No specific market index, asset class, or performance metric (e.g., % move, timeframe) is provided in the provided text.","No details are given on which other emerging markets are included in the rebound.","The nature of the 'rebound' (stocks, bonds, FX, or broader risk sentiment) is not specified in the provided text.","No timing/catalyst window (e.g., intraday vs. multi-week) is provided beyond the headline framing."],"key_facts":["The headline states South Africa is leading a rebound in emerging markets.","The rebound is described as occurring in emerging markets hit by the Iran conflict."],"numeric_claims":[],"primary_claim":"South Africa is leading a rebound in emerging markets affected by the Iran conflict (per Bloomberg).","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Bloomberg reports that South Africa is leading a rebound across emerging markets that were hit by the Iran conflict.","topics":["emerging markets","South Africa","rebound","Iran conflict","Bloomberg"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"South Africa Leads Rebound in Emerging Markets Hit By Iran Conflict Bloomberg.com","title":"South Africa Leads Rebound in Emerging Markets Hit By Iran Conflict - Bloomberg.com","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

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 6772 in events