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-10T15:03:21.800033+00:00","dedupe_key":"signal_enriched:market_headline_delta:7cd31183ce916bbb","evidence_event_ids":["evt_b1aacff0e98e"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxObE5DUnpmTUwyTmJYSGc5LWlMS3J5WTVEV1NEMUY4a09Tdm82TFRfSGdtRVhQVjQ3djNHQ21NSElEZGhsS0FtOTh1OU1pQVYzTjlxNlFid0NWaks4UGp1YUVPLWVGYldQUXloQkh2cFpfLXFYcHM2WnFtbHpQc1pRaQ?oc=5","as_of":"2026-04-10T15:03:21.800033+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/CBMigAFBVV95cUxObE5DUnpmTUwyTmJYSGc5LWlMS3J5WTVEV1NEMUY4a09Tdm82TFRfSGdtRVhQVjQ3djNHQ21NSElEZGhsS0FtOTh1OU1pQVYzTjlxNlFid0NWaks4UGp1YUVPLWVGYldQUXloQkh2cFpfLXFYcHM2WnFtbHpQc1pRaQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4b2768ad173a33f9","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-10T15:04:16.788389+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxObE5DUnpmTUwyTmJYSGc5LWlMS3J5WTVEV1NEMUY4a09Tdm82TFRfSGdtRVhQVjQ3djNHQ21NSElEZGhsS0FtOTh1OU1pQVYzTjlxNlFid0NWaks4UGp1YUVPLWVGYldQUXloQkh2cFpfLXFYcHM2WnFtbHpQc1pRaQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxObE5DUnpmTUwyTmJYSGc5LWlMS3J5WTVEV1NEMUY4a09Tdm82TFRfSGdtRVhQVjQ3djNHQ21NSElEZGhsS0FtOTh1OU1pQVYzTjlxNlFid0NWaks4UGp1YUVPLWVGYldQUXloQkh2cFpfLXFYcHM2WnFtbHpQc1pRaQ?oc=5","source_event_id":"evt_b1aacff0e98e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"30a6c8bee3ed41e0","published_at":"2026-04-10T13:54:14+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical_risk","name":"Hormuz","relevance":"high","symbol":"","type":"geopolitical_location"},{"asset_class":"geopolitical_risk","name":"Ceasefire","relevance":"medium","symbol":"","type":"conflict_status"},{"asset_class":"macro","name":"Inflation (3.3% reading)","relevance":"high","symbol":"","type":"macro_indicator"}],"event_type":"geopolitical_risk","information_gaps":["No specific inflation measure (e.g., CPI/PPI, YoY/MoM) is identified in the provided text.","\u201cHormuz tolls\u201d is not defined (no magnitude, mechanism, or affected markets are specified).","No tickers, asset classes, or market index moves are included in the provided headline text.","The headline does not specify which ceasefire or conflict is referenced."],"key_facts":["The headline states the ceasefire is holding.","The headline states there are \u201cHormuz tolls.\u201d","The headline states there is a \u201c3.3% inflation reading.\u201d","The headline claims these factors give investors fresh reasons for caution."],"numeric_claims":[{"label":"Inflation reading","value":"3.3%"}],"primary_claim":"Even with the ceasefire holding, Hormuz-related tolls and a 3.3% inflation reading are giving investors fresh reasons for caution.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The headline says market caution is increasing despite a ceasefire holding, due to Hormuz-related \u201ctolls\u201d and a reported 3.3% inflation reading.","topics":["ceasefire","Hormuz","inflation","investor caution","market conditions"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today (LIVE): Ceasefire Holds but Hormuz Tolls and a 3.3% Inflation Reading Give Investors Fresh Reasons for Caution - The Motley Fool","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 17309 in events