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-14T21:43:24.109835+00:00","dedupe_key":"signal_enriched:market_headline_delta:b0845b554cdf639e","evidence_event_ids":["evt_6923cac352d8"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPSlZraTdtcEtfLVVWSUVaZndJRHhiQ1pFck9JMjc2aFV4Nmt6anZCWFdxeFVraENwSWp2Uy1UT2JCeFEzX1lTOWlkdGh1V1hnV2hBNkZockU4SnNGRDlqelBNbXBrSndYRVJBWDM2MXhQSjJjb0lCTzNGckw5VG1jMW50M2piWmZBTEZfSEtnUE82X19kYjNrd1NrM2d6X0JEZjk4VHh5VWpLcTFrSGxONm1vT05kWDN2U3pGankySXNwajhnWE1KVlVhVEJwM2RX?oc=5","as_of":"2026-04-14T21:43:24.109835+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPSlZraTdtcEtfLVVWSUVaZndJRHhiQ1pFck9JMjc2aFV4Nmt6anZCWFdxeFVraENwSWp2Uy1UT2JCeFEzX1lTOWlkdGh1V1hnV2hBNkZockU4SnNGRDlqelBNbXBrSndYRVJBWDM2MXhQSjJjb0lCTzNGckw5VG1jMW50M2piWmZBTEZfSEtnUE82X19kYjNrd1NrM2d6X0JEZjk4VHh5VWpLcTFrSGxONm1vT05kWDN2U3pGankySXNwajhnWE1KVlVhVEJwM2RX?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c12e8d987909a356","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T23:15:21.639467+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPSlZraTdtcEtfLVVWSUVaZndJRHhiQ1pFck9JMjc2aFV4Nmt6anZCWFdxeFVraENwSWp2Uy1UT2JCeFEzX1lTOWlkdGh1V1hnV2hBNkZockU4SnNGRDlqelBNbXBrSndYRVJBWDM2MXhQSjJjb0lCTzNGckw5VG1jMW50M2piWmZBTEZfSEtnUE82X19kYjNrd1NrM2d6X0JEZjk4VHh5VWpLcTFrSGxONm1vT05kWDN2U3pGankySXNwajhnWE1KVlVhVEJwM2RX?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/CBMi0AFBVV95cUxPSlZraTdtcEtfLVVWSUVaZndJRHhiQ1pFck9JMjc2aFV4Nmt6anZCWFdxeFVraENwSWp2Uy1UT2JCeFEzX1lTOWlkdGh1V1hnV2hBNkZockU4SnNGRDlqelBNbXBrSndYRVJBWDM2MXhQSjJjb0lCTzNGckw5VG1jMW50M2piWmZBTEZfSEtnUE82X19kYjNrd1NrM2d6X0JEZjk4VHh5VWpLcTFrSGxONm1vT05kWDN2U3pGankySXNwajhnWE1KVlVhVEJwM2RX?oc=5","source_event_id":"evt_6923cac352d8","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"577dff8f4d14e747","published_at":"2026-04-14T21:35:31+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":["April 14"],"entities":[{"asset_class":"equities","name":"Stock market (unspecified)","relevance":"primary subject","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No article text provided, so no specific markets, indices, or tickers are identified.","No details on what \u201ctalk optimism\u201d refers to (who is speaking, what talks, or any concrete statements).","No magnitude of the move (percent/points) is provided.","No confirmation of whether the move is continuation or reversal beyond the phrase \u201cerase losses.\u201d"],"key_facts":["Headline date: April 14.","Claim: Markets erased Iran war losses.","Attribution: talk optimism."],"numeric_claims":[],"primary_claim":"On April 14, markets erased Iran war-related losses due to talk optimism.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The headline says that on April 14, stock markets erased losses related to the Iran war, attributing the move to talk optimism.","topics":["Iran war","market losses","optimism","risk sentiment"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today, April 14: Markets Erase Iran War Losses on Talk Optimism - The Motley Fool","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 45145 in events