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-08T20:43:08.025900+00:00","dedupe_key":"signal_enriched:news_delta:12b8e3dbd408384f","evidence_event_ids":["evt_e437a7444e38"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxPSTIxeVBwclVkVHE3cW1LMVhzUVZqVUZOY0lMbmdEeFdiQzc4RkU5bWxHRG45VERpYXJRLW1Wa2ZyU1FWOHJFckJ0WngxWTZ5eVlGTjRWRWlUQXlvNDRXcE1zUFhTMlhDYUZNRUYzOG5oYUZBZ0N2MVEwU2VCQlhIYg?oc=5","as_of":"2026-04-08T20:43:08.025900+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/CBMigAFBVV95cUxPSTIxeVBwclVkVHE3cW1LMVhzUVZqVUZOY0lMbmdEeFdiQzc4RkU5bWxHRG45VERpYXJRLW1Wa2ZyU1FWOHJFckJ0WngxWTZ5eVlGTjRWRWlUQXlvNDRXcE1zUFhTMlhDYUZNRUYzOG5oYUZBZ0N2MVEwU2VCQlhIYg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a6ce5b3b60022541","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-09T22:10:37.677534+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxPSTIxeVBwclVkVHE3cW1LMVhzUVZqVUZOY0lMbmdEeFdiQzc4RkU5bWxHRG45VERpYXJRLW1Wa2ZyU1FWOHJFckJ0WngxWTZ5eVlGTjRWRWlUQXlvNDRXcE1zUFhTMlhDYUZNRUYzOG5oYUZBZ0N2MVEwU2VCQlhIYg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxPSTIxeVBwclVkVHE3cW1LMVhzUVZqVUZOY0lMbmdEeFdiQzc4RkU5bWxHRG45VERpYXJRLW1Wa2ZyU1FWOHJFckJ0WngxWTZ5eVlGTjRWRWlUQXlvNDRXcE1zUFhTMlhDYUZNRUYzOG5oYUZBZ0N2MVEwU2VCQlhIYg?oc=5","source_event_id":"evt_e437a7444e38","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8d1ba020ab4f5c38","published_at":"2026-04-08T20:18:18+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary driver of cease-fire context","symbol":"","type":"country"},{"asset_class":"equity_index","name":"U.S. stocks / Dow","relevance":"beneficiary of the risk-off-to-risk-on shift","symbol":"DJIA","type":"market index"},{"asset_class":"equity_index","name":"S&P 500","relevance":"broader U.S. equity benchmark referenced","symbol":"SPX","type":"market index"},{"asset_class":"commodity","name":"Oil","relevance":"price reaction to cease-fire expectations","symbol":"WTI/Brent (unspecified)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["The exact oil price level and which benchmark (WTI vs Brent) is referenced are not fully specified in the provided text.","The specific cease-fire deal details (parties, timing, and effective date) are not included in the provided excerpt.","The article\u2019s claim about 'months' to restore flows is not quantified (e.g., number of months).","The magnitude of the oil price plunge is not fully specified beyond 'plunging' and 'below $95' in the provided summary; the exact percentage/absolute change is unclear.","The list of 'stocks in the S&P 500 rising the most' is referenced but the specific tickers are not provided in the excerpt."],"key_facts":["Oil prices fell sharply after the cease-fire deal announcement (exact magnitude not fully specified in the provided text).","U.S. equities rose sharply after the cease-fire announcement; the Dow is described as surging by about 1,100 points (as stated in the provided source summary).","The article notes that oil and gas flow out of the Persian Gulf will take months to resume/normalize.","The article cautions that consumers should not expect very low gasoline prices (e.g., $3 gas) anytime soon (exact timeframe not specified beyond 'don\u2019t expect' framing)."],"numeric_claims":[{"label":"Dow surge","value":"~1,100 points"}],"primary_claim":"Oil prices plunged and U.S. stocks surged following an Iran cease-fire deal announcement, though oil/gas flow restoration is expected to take months.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"After an Iran cease-fire deal was announced, oil prices fell sharply while U.S. stocks rose strongly. The move is framed as a near-term relief rally, but the article cautions that restoring oil and gas flows from the Persian Gulf will take months.","topics":["cease-fire deal","Iran","oil prices","stock market rally","Persian Gulf oil flows","energy prices"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Oil Prices Plunge and Stocks Surge After Cease-Fire Deal The New York Times Oil is plunging, but don\u2019t expect $3 gas anytime soon. Here\u2019s why CNN Oil plunges below $95 as Dow surges 1,100 following Iran ceasefire deal PBS It Will Take Months to Get Oil and Gas Flowing out of the Persian Gulf The New York Times These stocks in the S&P 500 are rising the most after Trump\u2019s cease-fire announcement MarketWatch","title":"Oil Prices Plunge and Stocks Surge After Cease-Fire Deal - The New York Times","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 8355 in events