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-11T16:31:46.717827+00:00","dedupe_key":"signal_enriched:market_headline_delta:958ae3644e3335ae","evidence_event_ids":["evt_7f876a2e6603"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxPUFBJMFZSQmV2SUZOcXR5aDMwZFNIUzBJX3FSSm16VlVoVnJnS3IweThCT2E2eXFDM09KWGROR0NDZUFGby1YYWI5NTRreVVKYU1SRGlqa1hDOWdNQnlOLU5IcnRtQkZzckpQRFpvUm1BT3dLYWRzaDRtUkVyakUyazVaLXQzQ0FIUFFGRUItRFJlSzFXWDhVWTFaTQ?oc=5","as_of":"2026-04-11T16:31:46.717827+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/CBMimwFBVV95cUxPUFBJMFZSQmV2SUZOcXR5aDMwZFNIUzBJX3FSSm16VlVoVnJnS3IweThCT2E2eXFDM09KWGROR0NDZUFGby1YYWI5NTRreVVKYU1SRGlqa1hDOWdNQnlOLU5IcnRtQkZzckpQRFpvUm1BT3dLYWRzaDRtUkVyakUyazVaLXQzQ0FIUFFGRUItRFJlSzFXWDhVWTFaTQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_594c5b02663dbbc9","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-11T22:17:35.348254+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxPUFBJMFZSQmV2SUZOcXR5aDMwZFNIUzBJX3FSSm16VlVoVnJnS3IweThCT2E2eXFDM09KWGROR0NDZUFGby1YYWI5NTRreVVKYU1SRGlqa1hDOWdNQnlOLU5IcnRtQkZzckpQRFpvUm1BT3dLYWRzaDRtUkVyakUyazVaLXQzQ0FIUFFGRUItRFJlSzFXWDhVWTFaTQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxPUFBJMFZSQmV2SUZOcXR5aDMwZFNIUzBJX3FSSm16VlVoVnJnS3IweThCT2E2eXFDM09KWGROR0NDZUFGby1YYWI5NTRreVVKYU1SRGlqa1hDOWdNQnlOLU5IcnRtQkZzckpQRFpvUm1BT3dLYWRzaDRtUkVyakUyazVaLXQzQ0FIUFFGRUItRFJlSzFXWDhVWTFaTQ?oc=5","source_event_id":"evt_7f876a2e6603","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"850c87fe4944fa74","published_at":"2026-04-11T15:47:03+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Riot Platforms","relevance":"referenced in headline","symbol":"RIOT","type":"company"},{"asset_class":"crypto","name":"Bitcoin","relevance":"explicitly mentioned as the action to take","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["No article text or source summary was provided, so the context of what \u201cthat\u201d refers to is unknown.","No details are provided about any price movement, timeframe, or whether the comment implies continuation or reversal beyond the quoted instruction.","No additional tickers, figures, or market data are included in the provided text."],"key_facts":["Headline is from Yahoo Finance (finance.yahoo.com).","Jim Cramer is quoted saying: \u201cIf You Want That, You Just Go Buy Bitcoin.\u201d","The quote is presented in connection with Riot Platforms."],"numeric_claims":[],"primary_claim":"Jim Cramer stated: \u201cIf You Want That, You Just Go Buy Bitcoin,\u201d in a segment about Riot Platforms.","relevance_score":0.45,"sentiment":"neutral","source_quality":"unknown","summary":"The Yahoo Finance headline quotes Jim Cramer saying that if someone wants something, they should \u201cjust go buy Bitcoin,\u201d referencing Riot Platforms.","topics":["market commentary","Bitcoin","Riot Platforms","Jim Cramer"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"Jim Cramer on Riot Platforms: \u201cIf You Want That, You Just Go Buy Bitcoin\u201d - Yahoo Finance","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 25253 in events