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-10T01:23:24.002720+00:00","dedupe_key":"signal_enriched:market_headline_delta:cb20eb851c4d0b8e","evidence_event_ids":["evt_1d0c83f9afa5"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQcGNUMjh0aUI2QWF1UWVfbVA2SzJYTmFQOGlWaEswcVFZblZnd010N2d6VXlsXzM4d0NMNUNURGRIS1NCdHQ5SG4wMTJkS1F3YWIxWkJ1ZFR5a0NydEhNWkZnSjBzWWk3ZFItYVNWSzZhbkFqY1VsVHdXV19MeWNHOGtERUxfMmlDOEttMnkxa2ticlFBd213VEVWb0pCNjU3MmJhT1M5S296Zng2MUN3SGQtbFRJRFRtdHNr?oc=5","as_of":"2026-04-10T01:23:24.002720+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/CBMiuwFBVV95cUxQcGNUMjh0aUI2QWF1UWVfbVA2SzJYTmFQOGlWaEswcVFZblZnd010N2d6VXlsXzM4d0NMNUNURGRIS1NCdHQ5SG4wMTJkS1F3YWIxWkJ1ZFR5a0NydEhNWkZnSjBzWWk3ZFItYVNWSzZhbkFqY1VsVHdXV19MeWNHOGtERUxfMmlDOEttMnkxa2ticlFBd213VEVWb0pCNjU3MmJhT1M5S296Zng2MUN3SGQtbFRJRFRtdHNr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d1a510efc60d573c","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-10T01:25:34.104540+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQcGNUMjh0aUI2QWF1UWVfbVA2SzJYTmFQOGlWaEswcVFZblZnd010N2d6VXlsXzM4d0NMNUNURGRIS1NCdHQ5SG4wMTJkS1F3YWIxWkJ1ZFR5a0NydEhNWkZnSjBzWWk3ZFItYVNWSzZhbkFqY1VsVHdXV19MeWNHOGtERUxfMmlDOEttMnkxa2ticlFBd213VEVWb0pCNjU3MmJhT1M5S296Zng2MUN3SGQtbFRJRFRtdHNr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"coindesk.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQcGNUMjh0aUI2QWF1UWVfbVA2SzJYTmFQOGlWaEswcVFZblZnd010N2d6VXlsXzM4d0NMNUNURGRIS1NCdHQ5SG4wMTJkS1F3YWIxWkJ1ZFR5a0NydEhNWkZnSjBzWWk3ZFItYVNWSzZhbkFqY1VsVHdXV19MeWNHOGtERUxfMmlDOEttMnkxa2ticlFBd213VEVWb0pCNjU3MmJhT1M5S296Zng2MUN3SGQtbFRJRFRtdHNr?oc=5","source_event_id":"evt_1d0c83f9afa5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c5d0d32c478c174f","published_at":"2026-04-09T21:11:04+00:00","publisher_domain":"coindesk.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["Thursday"],"entities":[{"asset_class":"equity","name":"Circle","relevance":"high","symbol":"CRCL","type":"company"},{"asset_class":"equity","name":"Bullish","relevance":"high","symbol":"BLSH","type":"company"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond the headline, so the magnitude of underperformance, percentage moves, and broader market context are unknown.","The specific market/rally being referenced (e.g., crypto index, sector, or broader market) is not stated in the provided text.","Whether CRCL and BLSH are traded as equities or other instruments is not confirmed beyond the ticker-like symbols in the headline."],"key_facts":["The headline states that Circle (CRCL) and Bullish (BLSH) failed to participate in Thursday\u2019s rally."],"numeric_claims":[],"primary_claim":"Circle (CRCL) and Bullish (BLSH) failed to participate in Thursday\u2019s rally.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"CoinDesk reports that Circle (CRCL) and Bullish (BLSH) did not participate in Thursday\u2019s market rally.","topics":["crypto markets","equities","market rally participation","asset underperformance"]},"source":"CoinDesk","source_domain":"coindesk.com","source_url":"https://www.coindesk.com","summary":"","tickers":[],"title":"Circle (CRCL) and Bullish (BLSH) fail to participate in Thursday rally - CoinDesk","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 12130 in events