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-09T05:26:02.306752+00:00","dedupe_key":"signal_enriched:news_delta:2ff3a78906aeee29","evidence_event_ids":["evt_742ab5fdf67d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxPbFh3UWpUN2pGTjhwUzNLamw0M1ZCbjZWV2U3dktlaWIzSW4xbTlvX1o1NFBKTDlZVUM2WkZqY2d1WmtfSWNuamtISlV6TkhNZkI3UzdkcTZFT0w2MjlNRmhwYmxta3VIVWJzU3k5SlFlRWNraUtManhGVDc0MTdJWVFYRk1XM294SWN2ZWJCeWhaYXRKYzBCM0VkWXJNRWUzWGw5c1J4N0VBcVkwZElVR05QaFpOajM0VU5waFp2S2x4YktIa29J?oc=5","as_of":"2026-04-09T05:26:02.306752+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/CBMixwFBVV95cUxPbFh3UWpUN2pGTjhwUzNLamw0M1ZCbjZWV2U3dktlaWIzSW4xbTlvX1o1NFBKTDlZVUM2WkZqY2d1WmtfSWNuamtISlV6TkhNZkI3UzdkcTZFT0w2MjlNRmhwYmxta3VIVWJzU3k5SlFlRWNraUtManhGVDc0MTdJWVFYRk1XM294SWN2ZWJCeWhaYXRKYzBCM0VkWXJNRWUzWGw5c1J4N0VBcVkwZElVR05QaFpOajM0VU5waFp2S2x4YktIa29J?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8e66236824a1e8cf","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-09T22:40:22.579249+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxPbFh3UWpUN2pGTjhwUzNLamw0M1ZCbjZWV2U3dktlaWIzSW4xbTlvX1o1NFBKTDlZVUM2WkZqY2d1WmtfSWNuamtISlV6TkhNZkI3UzdkcTZFT0w2MjlNRmhwYmxta3VIVWJzU3k5SlFlRWNraUtManhGVDc0MTdJWVFYRk1XM294SWN2ZWJCeWhaYXRKYzBCM0VkWXJNRWUzWGw5c1J4N0VBcVkwZElVR05QaFpOajM0VU5waFp2S2x4YktIa29J?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/CBMixwFBVV95cUxPbFh3UWpUN2pGTjhwUzNLamw0M1ZCbjZWV2U3dktlaWIzSW4xbTlvX1o1NFBKTDlZVUM2WkZqY2d1WmtfSWNuamtISlV6TkhNZkI3UzdkcTZFT0w2MjlNRmhwYmxta3VIVWJzU3k5SlFlRWNraUtManhGVDc0MTdJWVFYRk1XM294SWN2ZWJCeWhaYXRKYzBCM0VkWXJNRWUzWGw5c1J4N0VBcVkwZElVR05QaFpOajM0VU5waFp2S2x4YktIa29J?oc=5","source_event_id":"evt_742ab5fdf67d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ec3e5a2bd5c41a25","published_at":"2026-04-09T04:33:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Foreign investors","relevance":"primary","symbol":"","type":"investor_group"},{"asset_class":"equities_market","name":"Japan","relevance":"primary","symbol":"","type":"country"},{"asset_class":"equities","name":"Japanese stocks","relevance":"primary","symbol":"","type":"asset"}],"event_type":"price_action","information_gaps":["No specific date/time window for the $18.65 billion figure is provided in the provided text.","No index or ticker symbols (e.g., TOPIX/Nikkei) are specified for the \u201cJapanese stocks.\u201d","No breakdown of whether flows were net purchases vs gross purchases is provided.","No stated reason for the return after three weeks is included in the provided text."],"key_facts":["Reuters reports foreign investors bought $18.65 billion into Japanese stocks.","The inflow occurred on their return after three weeks."],"numeric_claims":[{"label":"Foreign investor inflow into Japanese stocks","value":"$18.65 billion"}],"primary_claim":"Foreign investors poured $18.65 billion into Japanese stocks on their return after three weeks.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Foreign investors returned to Japanese equities after a three-week absence, buying $18.65 billion worth of Japanese stocks, according to Reuters.","topics":["foreign flows","Japan equities","portfolio investment","market sentiment"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Foreign investors pour $18.65 billion into Japanese stocks on return after three weeks Reuters","title":"Foreign investors pour $18.65 billion into Japanese stocks on return after three weeks - Reuters","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 9001 in events