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-08T04:49:08.294827+00:00","dedupe_key":"signal_enriched:news_delta:37b80de6dd01d6bd","evidence_event_ids":["evt_12d6ada0cff1"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQTXJjSWVmMi1mYVVSakE0YmJhRUctTHdDb29wSk5wUlNNZXphTjI2N29TXzVYb2xEam9jTUNscl84OTg5ZHVuQlhWUGtBU3VzS3Rxa2tuRFlLdFNWNlNwbzEwd3dVaTVuckVlX01fTVNSMy12bTFOSHhIRkhRVWh5M2NVSU5NeWc?oc=5","as_of":"2026-04-08T04:49:08.294827+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/CBMihwFBVV95cUxQTXJjSWVmMi1mYVVSakE0YmJhRUctTHdDb29wSk5wUlNNZXphTjI2N29TXzVYb2xEam9jTUNscl84OTg5ZHVuQlhWUGtBU3VzS3Rxa2tuRFlLdFNWNlNwbzEwd3dVaTVuckVlX01fTVNSMy12bTFOSHhIRkhRVWh5M2NVSU5NeWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_556faa530314c0f3","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-08T04:49:22.099938+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQTXJjSWVmMi1mYVVSakE0YmJhRUctTHdDb29wSk5wUlNNZXphTjI2N29TXzVYb2xEam9jTUNscl84OTg5ZHVuQlhWUGtBU3VzS3Rxa2tuRFlLdFNWNlNwbzEwd3dVaTVuckVlX01fTVNSMy12bTFOSHhIRkhRVWh5M2NVSU5NeWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQTXJjSWVmMi1mYVVSakE0YmJhRUctTHdDb29wSk5wUlNNZXphTjI2N29TXzVYb2xEam9jTUNscl84OTg5ZHVuQlhWUGtBU3VzS3Rxa2tuRFlLdFNWNlNwbzEwd3dVaTVuckVlX01fTVNSMy12bTFOSHhIRkhRVWh5M2NVSU5NeWc?oc=5","source_event_id":"evt_12d6ada0cff1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f7dac7edb536a2de","published_at":"2026-04-08T03:53:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-07","two-week (duration mentioned; exact start/end dates not provided)"],"entities":[{"asset_class":"other","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"U.S. crude oil","relevance":"high","symbol":"WTI (implied)","type":"commodity"},{"asset_class":"equity_index_future","name":"Dow futures","relevance":"medium","symbol":"DJIA futures (implied)","type":"index_future"},{"asset_class":"equity_index_future","name":"S&P 500 futures","relevance":"medium","symbol":"SPX futures (implied)","type":"index_future"},{"asset_class":"equity_index_future","name":"Nasdaq futures","relevance":"medium","symbol":"NDX/IXIC futures (implied)","type":"index_future"}],"event_type":"geopolitical_risk","information_gaps":["Exact wording of the ceasefire terms and whether it is fully confirmed/implemented (only described as an announcement in the summary).","Which specific crude benchmark is referenced by \u201cU.S. crude\u201d (likely WTI, but not explicitly stated in the provided text).","Whether the futures move is measured at a specific time and by how much for S&P 500 and Nasdaq (only \u201csurge\u201d is stated).","No sector/individual stock breakdown is provided in the supplied content."],"key_facts":["On April 7, 2026, stock futures surged (headline cites Dow futures jumping).","U.S. crude oil fell below $100 (headline).","The move was attributed to Trump\u2019s ceasefire announcement suspending Iran attacks for two weeks (per provided source summary).","Near-term catalyst timing: the market reaction occurred immediately on the ceasefire news (same-day headline framing)."],"numeric_claims":[{"label":"Dow futures move","value":"900 points (as stated in source summary)"}],"primary_claim":"Stock futures surged and U.S. crude dropped below $100 after Trump announced a two-week ceasefire/suspension of Iran attacks.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"U.S. stock index futures rose sharply on April 7, 2026 while U.S. crude oil fell below $100, following a Trump ceasefire announcement that suspended Iran attacks for two weeks. The headline implies a near-term risk-off to risk-on shift as oil declines and equities rally.","topics":["stock futures","oil prices","ceasefire announcement","Iran attacks suspension","risk sentiment"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Stock Market News, April 7, 2026: Stock Futures Surge, U.S. Crude Drops Below $100 WSJ Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement CNN Oil Prices Plunge and Stocks Surge After Cease-fire Deal The New York Times Dow futures jump 900 points, oil tumbles after Trump suspends Iran attacks for two weeks: Live updates CNBC Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance","title":"Stock Market News, April 7, 2026: Stock Futures Surge, U.S. Crude Drops Below $100 - WSJ","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 4630 in events