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.008104+00:00","dedupe_key":"signal_enriched:news_delta:3653f285c9573d65","evidence_event_ids":["evt_4dfb07e0ba97"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","as_of":"2026-04-08T20:43:08.008104+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/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_01e24f971b55036a","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:27.372200+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","source_event_id":"evt_4dfb07e0ba97","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a516b39181df492e","published_at":"2026-04-08T20:29:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"high","symbol":"^DJI","type":"index"},{"asset_class":"equity_index","name":"S&P 500","relevance":"medium","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq","relevance":"medium","symbol":"^IXIC","type":"index"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil (global crude)","relevance":"high","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equity","name":"Chip stock (unspecified)","relevance":"medium","symbol":"","type":"company"}],"event_type":"geopolitical_risk","information_gaps":["The specific chip stock name/ticker is not included in the provided headline/summaries.","The exact timing/date of the market move (which trading session) is not specified in the provided text.","The oil benchmark (WTI vs Brent) is not specified.","The ceasefire details (parties involved, start/end dates, verification status) are not provided beyond \u201ctwo-week ceasefire.\u201d","The magnitude of S&P 500/Nasdaq moves is not quantified in the provided text."],"key_facts":["Dow rallied about 1,300 points on the day (per headline).","The rally was attributed to news of an Iran ceasefire described as lasting two weeks (per provided source summary).","Oil surged past $100/barrel globally due to the Iran conflict (per provided source summary).","S&P 500 and Nasdaq ended closer to record territory on Middle East optimism (per provided source summary).","A chip stock was described as \u201cbreaking out\u201d (company name not present in the provided text)."],"numeric_claims":[{"label":"Dow rally magnitude","value":"~1,300 points"},{"label":"Ceasefire duration","value":"two weeks"},{"label":"Oil price level","value":"> $100/barrel"}],"primary_claim":"The Dow rallied about 1,300 points amid news of a two-week Iran ceasefire, alongside a breakout in a chip stock.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"U.S. equities rose sharply as markets reacted positively to an Iran ceasefire, with oil jumping above $100/barrel. The coverage also highlights a \u201cchip stock\u201d breaking out, suggesting near-term momentum in semiconductors tied to the broader risk-on move.","topics":["Iran ceasefire","Middle East optimism","U.S. stock market rally","Dow/S&P/Nasdaq performance","Oil price surge","Semiconductor breakout (unspecified)"]},"source":"investors.com","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Stock Market Today: Dow Rallies 1,300 Points Amid Iran Ceasefire; This Chip Stock Breaks Out (Live Coverage) investors.com Oil surges past $100/barrel globally due to Iran conflict WWLP Dow logs best day in a year, S&P 500 and Nasdaq end closer to record territory on Middle East optimism MarketWatch Analysts Are Slow to Recognize a Crisis WSJ Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance","title":"Stock Market Today: Dow Rallies 1,300 Points Amid Iran Ceasefire; This Chip Stock Breaks Out (Live Coverage) - investors.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 8351 in events