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-12T00:13:13.282906+00:00","dedupe_key":"signal_enriched:news_delta:9b1eee9767cbdf0f","evidence_event_ids":["evt_3d38f5c7f295"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNMVNPS1dQYk4yZThvTGtMYjJJOVc5RUpnQW9PdUgzRTNwWVJxUHY1MnFsRldvdGZVTFR2UUdOUFR4WG1jaGdSNTBiX0VNeGFyTEJqcVM3cTRQYUNKU0VuT3pzR3M5UTFfb3VHV1NBM05jc0MzWTN1bkkxUVRlWGdMQWVpVTh1aXk4?oc=5","as_of":"2026-04-12T00:13:13.282906+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/CBMiiAFBVV95cUxNMVNPS1dQYk4yZThvTGtMYjJJOVc5RUpnQW9PdUgzRTNwWVJxUHY1MnFsRldvdGZVTFR2UUdOUFR4WG1jaGdSNTBiX0VNeGFyTEJqcVM3cTRQYUNKU0VuT3pzR3M5UTFfb3VHV1NBM05jc0MzWTN1bkkxUVRlWGdMQWVpVTh1aXk4?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1cdd983ae4e12123","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-12T00:13:47.498726+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNMVNPS1dQYk4yZThvTGtMYjJJOVc5RUpnQW9PdUgzRTNwWVJxUHY1MnFsRldvdGZVTFR2UUdOUFR4WG1jaGdSNTBiX0VNeGFyTEJqcVM3cTRQYUNKU0VuT3pzR3M5UTFfb3VHV1NBM05jc0MzWTN1bkkxUVRlWGdMQWVpVTh1aXk4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sg.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNMVNPS1dQYk4yZThvTGtMYjJJOVc5RUpnQW9PdUgzRTNwWVJxUHY1MnFsRldvdGZVTFR2UUdOUFR4WG1jaGdSNTBiX0VNeGFyTEJqcVM3cTRQYUNKU0VuT3pzR3M5UTFfb3VHV1NBM05jc0MzWTN1bkkxUVRlWGdMQWVpVTh1aXk4?oc=5","source_event_id":"evt_3d38f5c7f295","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"3b1c9f81ae5a15ac","published_at":"2026-04-11T23:30:00+00:00","publisher_domain":"sg.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Yahoo Finance Singapore","relevance":"primary source of the headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No article text is available beyond the headline and repeated source summary.","No specific dividend stocks, REITs, tickers, or countries are named.","No concrete market action, earnings, policy change, or catalyst timing is provided.","No performance metrics, yields, or inflation figures are included."],"key_facts":["Headline mentions \u201cDividend Stocks,\u201d \u201cREIT Opportunities,\u201d and \u201cInflation-Proof Investing.\u201d","The content is labeled \u201cSmart Reads of the Week.\u201d","No article body text or specific tickers/companies are provided."],"numeric_claims":[],"primary_claim":"Yahoo Finance Singapore published a weekly roundup focused on dividend stocks, REIT opportunities, and inflation-proof investing.","relevance_score":0.25,"sentiment":"neutral","source_quality":"unknown","summary":"The provided signal is a Yahoo Finance Singapore headline referencing an article about dividend stocks, REIT opportunities, and inflation-proof investing. No specific company, market move, or timing details are included in the provided text.","topics":["dividend stocks","REIT opportunities","inflation-proof investing","weekly roundup"]},"source":"Yahoo Finance Singapore","source_domain":"sg.finance.yahoo.com","source_url":"https://sg.finance.yahoo.com","summary":"Smart Reads of the Week: Dividend Stocks, REIT Opportunities, and Inflation-Proof Investing Yahoo Finance Singapore","title":"Smart Reads of the Week: Dividend Stocks, REIT Opportunities, and Inflation-Proof Investing - Yahoo Finance Singapore","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 26541 in events