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-08T06:04:59.097702+00:00","dedupe_key":"signal_enriched:news_delta:6c9f828159ac54c2","evidence_event_ids":["evt_fb10e2534d16"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5","as_of":"2026-04-08T06:04:59.097702+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c8d7c8b27db9216f","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T06:05:42.416292+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5","source_event_id":"evt_fb10e2534d16","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5e3d5beafad026cd","published_at":"2026-04-08T05:35:00+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil","relevance":"high","symbol":"","type":"commodity"},{"asset_class":"equity","name":"Stocks","relevance":"high","symbol":"","type":"equities (broad market)"}],"event_type":"geopolitical_risk","information_gaps":["No specific oil benchmark or ticker is provided (e.g., Brent/WTI).","No specific stock index or tickers are provided (e.g., S&P 500, Nasdaq).","No timing details (exact date/time of the move, session) are included in the provided text.","No details on the terms, parties, or effective date of the Iran ceasefire are included beyond \u201cagreed.\u201d","No magnitude of the moves (percent/points) is provided in the provided text."],"key_facts":["Bloomberg headline states: \u201cOil Plunges, Stocks Jump as Iran Ceasefire Agreed: Markets Wrap.\u201d","The signal indicates simultaneous directional moves: oil down (\u201cplunges\u201d) and stocks up (\u201cjump\u201d).","The catalyst mentioned in the headline is that an Iran ceasefire was agreed."],"numeric_claims":[],"primary_claim":"Oil prices plunged and stocks jumped following an agreed Iran ceasefire, according to Bloomberg\u2019s markets wrap.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports that oil prices fell sharply while stocks rose after an Iran ceasefire was agreed. The market reaction is described as oil plunging and equities jumping in the same wrap-up.","topics":["Iran ceasefire","oil prices","equity market reaction","markets wrap"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Oil Plunges, Stocks Jump as Iran Ceasefire Agreed: Markets Wrap Bloomberg.com","title":"Oil Plunges, Stocks Jump as Iran Ceasefire Agreed: Markets Wrap - Bloomberg.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 4889 in events