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-12T04:23:29.563537+00:00","dedupe_key":"signal_enriched:market_headline_delta:43bc708ddc1469ba","evidence_event_ids":["evt_67e2dfbdc664"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE0ybDFvMnNqU3BaM2VJTzdIYkwyb3k3WTNkNHNzQTF0YkpTZ1NESGlDRjdWV3MyR2IyWWtfeUFFV19jT3FNcTUwOTRwbUhOd2lFZ1VfX2JMTFJVeHRQVjRiSm5lZ0UxTVhKbHFFS1Rrdzh6TjVvQnNSNGhiZW9aM1k?oc=5","as_of":"2026-04-12T04:23:29.563537+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/CBMif0FVX3lxTE0ybDFvMnNqU3BaM2VJTzdIYkwyb3k3WTNkNHNzQTF0YkpTZ1NESGlDRjdWV3MyR2IyWWtfeUFFV19jT3FNcTUwOTRwbUhOd2lFZ1VfX2JMTFJVeHRQVjRiSm5lZ0UxTVhKbHFFS1Rrdzh6TjVvQnNSNGhiZW9aM1k?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b125339ca1919388","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-12T04:24:10.143821+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE0ybDFvMnNqU3BaM2VJTzdIYkwyb3k3WTNkNHNzQTF0YkpTZ1NESGlDRjdWV3MyR2IyWWtfeUFFV19jT3FNcTUwOTRwbUhOd2lFZ1VfX2JMTFJVeHRQVjRiSm5lZ0UxTVhKbHFFS1Rrdzh6TjVvQnNSNGhiZW9aM1k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE0ybDFvMnNqU3BaM2VJTzdIYkwyb3k3WTNkNHNzQTF0YkpTZ1NESGlDRjdWV3MyR2IyWWtfeUFFV19jT3FNcTUwOTRwbUhOd2lFZ1VfX2JMTFJVeHRQVjRiSm5lZ0UxTVhKbHFFS1Rrdzh6TjVvQnNSNGhiZW9aM1k?oc=5","source_event_id":"evt_67e2dfbdc664","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"51ae647c2483ce4a","published_at":"2026-04-12T04:17:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"geopolitical_risk","information_gaps":["No article text is provided, so details such as timing, magnitude of Bitcoin\u2019s move, and specific stock market preview context are missing.","No additional information is provided about the nature of the US-Iran talks or any follow-up actions."],"key_facts":["Barron's headline states US-Iran talks ended with no deal.","Barron's headline states Bitcoin slumped.","The headline frames the move as a potential stock market preview."],"numeric_claims":[],"primary_claim":"US-Iran talks ended with no deal and Bitcoin slumped, as reported by Barron's.","relevance_score":0.62,"sentiment":"mixed","source_quality":"unknown","summary":"The headline says US-Iran talks ended without a deal and that Bitcoin fell, potentially ahead of a stock market preview.","topics":["US-Iran talks","no deal outcome","Bitcoin price decline","stock market preview"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"","tickers":[],"title":"US-Iran Talks End With No Deal, Bitcoin Slumps in Potential Stock Market Preview - Barron's","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 27493 in events