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-08T14:43:46.027630+00:00","dedupe_key":"signal_enriched:news_delta:ca2d96864a8e3a53","evidence_event_ids":["evt_f8acbd92fbf1"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPZ1pNQkxDQl9WWVFwVGJQNjNNeWVSWXU1a3N6TkFwN2RDNGYxWkQtZGJiR1NSWGUwckVLWVUzd1BvblVKaEtPTS00ZkdZcEtRRnFTOHM5dHlxQXVXSG5fTEVNNVFWSjdVeHNuWFgtbmdGUmg3R3BYSURaTjRLWWxfNlVYYnZVNHVyOHd5SjNuVnh3SkNzUURTajFhNHl0V0pEMlVUYmVn?oc=5","as_of":"2026-04-08T14:43:46.027630+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/CBMipgFBVV95cUxPZ1pNQkxDQl9WWVFwVGJQNjNNeWVSWXU1a3N6TkFwN2RDNGYxWkQtZGJiR1NSWGUwckVLWVUzd1BvblVKaEtPTS00ZkdZcEtRRnFTOHM5dHlxQXVXSG5fTEVNNVFWSjdVeHNuWFgtbmdGUmg3R3BYSURaTjRLWWxfNlVYYnZVNHVyOHd5SjNuVnh3SkNzUURTajFhNHl0V0pEMlVUYmVn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_15b23dafafa9a9b9","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-08T17:19:44.046457+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPZ1pNQkxDQl9WWVFwVGJQNjNNeWVSWXU1a3N6TkFwN2RDNGYxWkQtZGJiR1NSWGUwckVLWVUzd1BvblVKaEtPTS00ZkdZcEtRRnFTOHM5dHlxQXVXSG5fTEVNNVFWSjdVeHNuWFgtbmdGUmg3R3BYSURaTjRLWWxfNlVYYnZVNHVyOHd5SjNuVnh3SkNzUURTajFhNHl0V0pEMlVUYmVn?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/CBMipgFBVV95cUxPZ1pNQkxDQl9WWVFwVGJQNjNNeWVSWXU1a3N6TkFwN2RDNGYxWkQtZGJiR1NSWGUwckVLWVUzd1BvblVKaEtPTS00ZkdZcEtRRnFTOHM5dHlxQXVXSG5fTEVNNVFWSjdVeHNuWFgtbmdGUmg3R3BYSURaTjRLWWxfNlVYYnZVNHVyOHd5SjNuVnh3SkNzUURTajFhNHl0V0pEMlVUYmVn?oc=5","source_event_id":"evt_f8acbd92fbf1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c699137c3cbb62c3","published_at":"2026-04-08T13:58:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical_risk","name":"Strait of Hormuz","relevance":"primary_catalyst","symbol":"","type":"geographic_location"},{"asset_class":"commodity","name":"Oil","relevance":"market_subject","symbol":"CL","type":"commodity"},{"asset_class":"equity_index","name":"S&P 500","relevance":"market_context","symbol":"^GSPC","type":"equity_index"},{"asset_class":"media","name":"Investor's Business Daily","relevance":"source","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The provided text includes only the headline and a generic cleaned HTML blob; it does not list which specific S&P 500 stocks are mentioned.","No magnitude (e.g., % move) or timing details for the oil price drop are provided in the supplied text.","The mechanism for \u201cHormuz opens\u201d (what was previously closed and by whom) is not described in the supplied text.","No confirmation is provided in the supplied text that the \u201cexhaling\u201d stocks are benefiting or merely described as such; the direction for those stocks is not explicit beyond the wording."],"key_facts":["The headline states oil prices are \u201cdiving.\u201d","The headline states the reason is that \u201cHormuz opens.\u201d","The headline references \u201cThese S&P 500 Stocks\u201d described as \u201cexhaling.\u201d"],"numeric_claims":[],"primary_claim":"Oil prices are diving as Hormuz opens, with knock-on effects referenced for specific S&P 500 stocks.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Investor's Business Daily reports that oil prices fell sharply as the Strait of Hormuz reopened, and it highlights certain S&P 500 stocks described as \u201cexhaling.\u201d","topics":["oil prices","Hormuz reopening","energy market","S&P 500 stocks","market sentiment"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Oil Prices Dive As Hormuz Opens; These S&P 500 Stocks Are 'Exhaling' Investor's Business Daily","title":"Oil Prices Dive As Hormuz Opens; These S&P 500 Stocks Are 'Exhaling' - 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 7384 in events