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-08T23:28:56.273530+00:00","dedupe_key":"signal_enriched:news_delta:4f5dc20462c53f6a","evidence_event_ids":["evt_5dabc5aac18b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNdWdJZFIyMWxxTEhObVV2SlZTRnpqWW1KY0hQbGlNb0labnQ4bXdyeGhsV3NpR3JEQ3ZobDdRcFVFQnF2OGFYcHJBcS0tOFYydXhYOEMyWUVxOTVoZkdWWXBMVU1Bb3BNT0tobUZMZkFMalRlYjh1dlJjQllvd18wLXlwY2MyQTdVSGdGeXhvQTJOcnRlNWVaXzNZNmFfZUdnSGhDNHpkQ1RIMmJ0U3Z5RURSRkJkaTM2eXJVRVJjc014NGNqLWc?oc=5","as_of":"2026-04-08T23:28:56.273530+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/CBMixgFBVV95cUxNdWdJZFIyMWxxTEhObVV2SlZTRnpqWW1KY0hQbGlNb0labnQ4bXdyeGhsV3NpR3JEQ3ZobDdRcFVFQnF2OGFYcHJBcS0tOFYydXhYOEMyWUVxOTVoZkdWWXBMVU1Bb3BNT0tobUZMZkFMalRlYjh1dlJjQllvd18wLXlwY2MyQTdVSGdGeXhvQTJOcnRlNWVaXzNZNmFfZUdnSGhDNHpkQ1RIMmJ0U3Z5RURSRkJkaTM2eXJVRVJjc014NGNqLWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0115b300cbeb3e77","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:17:49.455671+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxNdWdJZFIyMWxxTEhObVV2SlZTRnpqWW1KY0hQbGlNb0labnQ4bXdyeGhsV3NpR3JEQ3ZobDdRcFVFQnF2OGFYcHJBcS0tOFYydXhYOEMyWUVxOTVoZkdWWXBMVU1Bb3BNT0tobUZMZkFMalRlYjh1dlJjQllvd18wLXlwY2MyQTdVSGdGeXhvQTJOcnRlNWVaXzNZNmFfZUdnSGhDNHpkQ1RIMmJ0U3Z5RURSRkJkaTM2eXJVRVJjc014NGNqLWc?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/CBMixgFBVV95cUxNdWdJZFIyMWxxTEhObVV2SlZTRnpqWW1KY0hQbGlNb0labnQ4bXdyeGhsV3NpR3JEQ3ZobDdRcFVFQnF2OGFYcHJBcS0tOFYydXhYOEMyWUVxOTVoZkdWWXBMVU1Bb3BNT0tobUZMZkFMalRlYjh1dlJjQllvd18wLXlwY2MyQTdVSGdGeXhvQTJOcnRlNWVaXzNZNmFfZUdnSGhDNHpkQ1RIMmJ0U3Z5RURSRkJkaTM2eXJVRVJjc014NGNqLWc?oc=5","source_event_id":"evt_5dabc5aac18b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"12ce84c1398c51e2","published_at":"2026-04-08T22:22:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Tuesday night (relative; exact date not provided)"],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil","relevance":"high","symbol":"WTI/Brent (not specified)","type":"commodity"},{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"medium","symbol":"DJIA","type":"equity index"},{"asset_class":"political","name":"Trump","relevance":"medium","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not include the actual IBD article content beyond the headline and the provided source summary.","The specific oil benchmark (WTI vs Brent) is not stated in the provided text.","The exact timing/date of the \u201cTuesday night deadline\u201d is not specified.","The mechanism linking the Iran truce to the \u201cbull turn\u201d (which assets/sectors) is not detailed in the provided text.","Whether the ceasefire violation refers to a specific incident/date is not provided."],"key_facts":["The headline indicates an Iran truce is associated with a \u201cbull turn.\u201d","The provided source summary states oil prices surged past $100/barrel globally due to the Iran conflict.","The source summary states markets were choppy, with US futures wavering.","The source summary states the Dow closed up more than 1,300 points after a US-Iran ceasefire.","The source summary states oil and stocks were choppy ahead of a \u201cTrump\u2019s Tuesday night deadline for Iran.\u201d","The source summary states Iran said the ceasefire was violated."],"numeric_claims":[{"label":"Oil price level","value":"past $100/barrel"},{"label":"Dow move","value":"up more than 1,300 points"}],"primary_claim":"The Iran truce is being interpreted as a catalyst for a bullish market turn, but investors face uncertainty about risk-taking amid choppy trading and ceasefire-related developments.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Investor's Business Daily frames a market \u201cbull turn\u201d in response to an Iran truce, while highlighting uncertainty about how aggressively investors should position given ongoing volatility around the Iran ceasefire and related oil price moves.","topics":["Iran truce/ceasefire","oil prices above $100/barrel","equity market volatility","US-Iran tensions","investment positioning/aggressiveness"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Iran Truce Spurs Bull Turn; How Aggressive Should You Be? Investor's Business Daily Oil surges past $100/barrel globally due to Iran conflict WWLP US Futures Waver as Iran Says Ceasefire Violated: Markets Wrap Bloomberg Dow closes up more than 1,300 points after US-Iran ceasefire ABC News Oil prices, stocks see choppy trading ahead of Trump's Tuesday night deadline for Iran CBS News","title":"Iran Truce Spurs Bull Turn; How Aggressive Should You Be? - Investor's Business Daily","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 8562 in events