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-10T13:59:12.087056+00:00","dedupe_key":"signal_enriched:market_headline_delta:f6b1737bad47c97e","evidence_event_ids":["evt_7b6c1507c6cc"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQSFJhMHU1NkxPcnR0THZ0VVBjUVctR1cyc0R1WktPZG5WLXYxZDViaFpYMGw0MEdiWTRRYVFJZFRyNVZETml3MVVZbEQyOG9hTUt3dmZ4MllTZTdkNno1WllsWGY4Y2E5LUtsRkFXUG9zTzBRR3JUamRrZm9heVlNVXpxWWY5SDNpT1llNUhfN05SRERFTVVqVFpJckVPOGF6X2NHVWVFWlBMQ3VZa2laZmdpeWc?oc=5","as_of":"2026-04-10T13:59:12.087056+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/CBMitAFBVV95cUxQSFJhMHU1NkxPcnR0THZ0VVBjUVctR1cyc0R1WktPZG5WLXYxZDViaFpYMGw0MEdiWTRRYVFJZFRyNVZETml3MVVZbEQyOG9hTUt3dmZ4MllTZTdkNno1WllsWGY4Y2E5LUtsRkFXUG9zTzBRR3JUamRrZm9heVlNVXpxWWY5SDNpT1llNUhfN05SRERFTVVqVFpJckVPOGF6X2NHVWVFWlBMQ3VZa2laZmdpeWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2e752f096bfe969c","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-10T14:04:38.418077+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQSFJhMHU1NkxPcnR0THZ0VVBjUVctR1cyc0R1WktPZG5WLXYxZDViaFpYMGw0MEdiWTRRYVFJZFRyNVZETml3MVVZbEQyOG9hTUt3dmZ4MllTZTdkNno1WllsWGY4Y2E5LUtsRkFXUG9zTzBRR3JUamRrZm9heVlNVXpxWWY5SDNpT1llNUhfN05SRERFTVVqVFpJckVPOGF6X2NHVWVFWlBMQ3VZa2laZmdpeWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"meyka.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQSFJhMHU1NkxPcnR0THZ0VVBjUVctR1cyc0R1WktPZG5WLXYxZDViaFpYMGw0MEdiWTRRYVFJZFRyNVZETml3MVVZbEQyOG9hTUt3dmZ4MllTZTdkNno1WllsWGY4Y2E5LUtsRkFXUG9zTzBRR3JUamRrZm9heVlNVXpxWWY5SDNpT1llNUhfN05SRERFTVVqVFpJckVPOGF6X2NHVWVFWlBMQ3VZa2laZmdpeWc?oc=5","source_event_id":"evt_7b6c1507c6cc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1ab7f8eaba8cf61d","published_at":"2026-04-10T13:34:16+00:00","publisher_domain":"meyka.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.86,"dates_mentioned":["10 Apr 2026"],"entities":[{"asset_class":"equity","name":"Natural Cool","relevance":"high","symbol":"5IF.SI","type":"company"},{"asset_class":"unknown","name":"Meyka","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond the headline; the meaning/definition of 'SES' is not explained.","No context is given for why the drop occurred (e.g., earnings, guidance, news catalyst).","No prior price or intraday range is provided to confirm the move beyond the headline."],"key_facts":["Headline states Natural Cool (5IF.SI) dropped 10.20%.","Headline states the price is S$0.044.","Headline states the date is 10 Apr 2026.","Headline includes '(SES): 0.12 S$ yearly forecast noted - Meyka'."],"numeric_claims":[{"label":"price_drop_percent","value":"10.20%"},{"label":"price","value":"S$0.044"},{"label":"yearly_forecast","value":"S$0.12"}],"primary_claim":"Natural Cool (5IF.SI) dropped 10.20% to S$0.044 on 10 Apr 2026, and a S$0.12 yearly forecast was noted (SES) by Meyka.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"5IF.SI (Natural Cool) fell 10.20% to S$0.044 on 10 Apr 2026, with a SES note of S$0.12 yearly forecast mentioned by Meyka.","topics":["stock price drop","Singapore market","equity forecast","SES yearly forecast"]},"source":"Meyka","source_domain":"meyka.com","source_url":"https://meyka.com","summary":"","tickers":[],"title":"5IF.SI Natural Cool drops 10.20% to S$0.044 on 10 Apr 2026 (SES): 0.12 S$ yearly forecast noted - Meyka","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 16677 in events