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-08T11:43:27.582006+00:00","dedupe_key":"signal_enriched:news_delta:dfce3fa2d9efceb9","evidence_event_ids":["evt_503633a6e798"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxQUWxFWDktWHd0UGwtZmFGRzE2dXg0Z095MG0zTWlvZ3AwYzcwb0F0VVpzZGNzNWthbW1CNkxvTTlqVlRNakJ5M2RUMk1rTDcwbVBKTUxJeERUWjZCUWtVTWI1eWxhREZDUkhHOThsaktRbFNHaDBMMUs4LTlNREFUdk5MWHhMUTNHYXg2TGoxdWkwN3pUUTYtZm1pNUNYcDg?oc=5","as_of":"2026-04-08T11:43:27.582006+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/CBMinwFBVV95cUxQUWxFWDktWHd0UGwtZmFGRzE2dXg0Z095MG0zTWlvZ3AwYzcwb0F0VVpzZGNzNWthbW1CNkxvTTlqVlRNakJ5M2RUMk1rTDcwbVBKTUxJeERUWjZCUWtVTWI1eWxhREZDUkhHOThsaktRbFNHaDBMMUs4LTlNREFUdk5MWHhMUTNHYXg2TGoxdWkwN3pUUTYtZm1pNUNYcDg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b1d4b0afec23f772","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-08T11:44:18.322913+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxQUWxFWDktWHd0UGwtZmFGRzE2dXg0Z095MG0zTWlvZ3AwYzcwb0F0VVpzZGNzNWthbW1CNkxvTTlqVlRNakJ5M2RUMk1rTDcwbVBKTUxJeERUWjZCUWtVTWI1eWxhREZDUkhHOThsaktRbFNHaDBMMUs4LTlNREFUdk5MWHhMUTNHYXg2TGoxdWkwN3pUUTYtZm1pNUNYcDg?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/CBMinwFBVV95cUxQUWxFWDktWHd0UGwtZmFGRzE2dXg0Z095MG0zTWlvZ3AwYzcwb0F0VVpzZGNzNWthbW1CNkxvTTlqVlRNakJ5M2RUMk1rTDcwbVBKTUxJeERUWjZCUWtVTWI1eWxhREZDUkhHOThsaktRbFNHaDBMMUs4LTlNREFUdk5MWHhMUTNHYXg2TGoxdWkwN3pUUTYtZm1pNUNYcDg?oc=5","source_event_id":"evt_503633a6e798","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0c39dd55f89eeaf8","published_at":"2026-04-08T08:15:55+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"directly involved in ceasefire agreement","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"directly involved in ceasefire agreement","symbol":"","type":"country"},{"asset_class":"media","name":"Bloomberg","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNBC","relevance":"referenced in source summary for live updates","symbol":"","type":"publisher"},{"asset_class":"media","name":"Reuters","relevance":"referenced in source summary","symbol":"","type":"publisher"},{"asset_class":"media","name":"New York Times","relevance":"referenced in source summary","symbol":"","type":"publisher"},{"asset_class":"equity_index_futures","name":"Dow futures","relevance":"mentioned as soaring after ceasefire","symbol":"DJIA (futures)","type":"index futures"},{"asset_class":"commodity","name":"Oil (WTI referenced)","relevance":"prices plunged; oil tumbles below $100","symbol":"WTI (implied)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["Exact magnitude of the oil and gas price declines (percent/absolute) is not provided in the supplied text.","Which specific oil benchmark is meant by \u201coil\u201d (e.g., WTI vs Brent) is not explicitly stated in the provided excerpt.","The exact timing (timestamp) of the price moves relative to the ceasefire announcement is not provided.","Whether the ceasefire is fully implemented or conditional is not specified in the provided text."],"key_facts":["US and Iran agreed to a ceasefire (described as a two-week ceasefire in the provided source summary).","After the ceasefire announcement, oil and gas prices plunged.","Oil reportedly fell below $100 (currency/contract not fully specified in the provided text; implied WTI).","Dow futures reportedly rose by about 1,300 points following the ceasefire.","Stocks surged/risk sentiment improved immediately after the ceasefire announcement (as described in the source summary)."],"numeric_claims":[{"label":"Dow futures move","value":"+1,300 points (approx.)"},{"label":"Oil price level","value":"below $100"}],"primary_claim":"Oil and gas prices plunged after the US and Iran agreed to a ceasefire.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Oil and gas prices fell sharply after the US and Iran agreed to a ceasefire, with the market also showing a risk-on reaction in equities. The ceasefire is described as lasting two weeks, acting as the near-term catalyst.","topics":["oil prices","gas prices","ceasefire","US-Iran tensions","risk sentiment","equity futures","market volatility"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Oil and Gas Prices Plunge After US and Iran Agree to a Ceasefire Bloomberg.com Dow futures soar 1,300 points as traders rush to buy stocks after U.S. and Iran reach two-week ceasefire: Live updates CNBC Oil tumbles below $100 after Trump announces two-week ceasefire Reuters Oil Prices Plunge and Stocks Surge After Cease-Fire Deal The New York Times Stock Trading Intensity Soars to Record on Rapid Shifts in War Bloomberg.com","title":"Oil and Gas Prices Plunge After US and Iran Agree to a Ceasefire - Bloomberg.com","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 6289 in events