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-07T23:23:39.106091+00:00","dedupe_key":"signal_enriched:news_delta:27b0398e2ccece95","evidence_event_ids":["evt_399c7c2d9a31"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNOV9QOGk4LU5YUlFIcjYxMHlDWGFpbjZZTDBxSW9aVVRlM1JfaEdzWndOSjdEVHpmUzUwZU1Sb0d4c3oyYnRNbTQ2c2swUmM2eGZ2a0c0c3hKQ3R5Z3BlVnE4Z0JaM2dqbnBleUk1ZlZteUFjVjhzd19lXzk0RFpQZE50TDJEZWFRNGczaURxekhPcmpzcEdzbA?oc=5","as_of":"2026-04-07T23:23:39.106091+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/CBMimAFBVV95cUxNOV9QOGk4LU5YUlFIcjYxMHlDWGFpbjZZTDBxSW9aVVRlM1JfaEdzWndOSjdEVHpmUzUwZU1Sb0d4c3oyYnRNbTQ2c2swUmM2eGZ2a0c0c3hKQ3R5Z3BlVnE4Z0JaM2dqbnBleUk1ZlZteUFjVjhzd19lXzk0RFpQZE50TDJEZWFRNGczaURxekhPcmpzcEdzbA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_432a2198d576fe86","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-08T00:36:15.443596+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNOV9QOGk4LU5YUlFIcjYxMHlDWGFpbjZZTDBxSW9aVVRlM1JfaEdzWndOSjdEVHpmUzUwZU1Sb0d4c3oyYnRNbTQ2c2swUmM2eGZ2a0c0c3hKQ3R5Z3BlVnE4Z0JaM2dqbnBleUk1ZlZteUFjVjhzd19lXzk0RFpQZE50TDJEZWFRNGczaURxekhPcmpzcEdzbA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNOV9QOGk4LU5YUlFIcjYxMHlDWGFpbjZZTDBxSW9aVVRlM1JfaEdzWndOSjdEVHpmUzUwZU1Sb0d4c3oyYnRNbTQ2c2swUmM2eGZ2a0c0c3hKQ3R5Z3BlVnE4Z0JaM2dqbnBleUk1ZlZteUFjVjhzd19lXzk0RFpQZE50TDJEZWFRNGczaURxekhPcmpzcEdzbA?oc=5","source_event_id":"evt_399c7c2d9a31","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1e781aeee45a86e5","published_at":"2026-04-07T16:52:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Cathie Wood","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"The Motley Fool","relevance":"context","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The two stocks\u2019 names and any ticker symbols are not included in the provided text.","No details on when the purchases occurred (date/timeframe) are provided.","No rationale, valuation metrics, or portfolio weights are included in the provided text.","No evidence of whether the buys are from ARK Invest funds or another vehicle is included beyond the headline wording."],"key_facts":["Headline states Cathie Wood bought 2 stocks.","Headline characterizes the buys as \u201cbargain hunting\u201d / \u201cbought\u201d (wording from headline).","No stock tickers or company names are included in the provided text."],"numeric_claims":[],"primary_claim":"Cathie Wood \u201cjust bought\u201d two stocks that the article characterizes as bargains.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article headline says Cathie Wood bought two stocks that are described as \u201cbargains.\u201d The specific stock names and purchase timing/price are not present in the provided text.","topics":["stock purchases","bargain hunting","Ark Invest/Cathie Wood (implied by name only)"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"Cathie Wood Goes Bargain Hunting: 2 Stocks She Just Bought The Motley Fool","title":"Cathie Wood Goes Bargain Hunting: 2 Stocks She Just Bought - The Motley Fool","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 2301 in events