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-08T03:48:37.023140+00:00","dedupe_key":"signal_enriched:news_delta:38638fd3edd3d8da","evidence_event_ids":["evt_ee3bdc6bb581"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPU1NIRXQtZWNSQWNITzl2S2JDTzl1YTA4ano1dHB5RGZJRlMwSTJ3Vkg1UFdWNnVZTFZPNXVMYWpnVzF6QzhDdnFCVi16SkZWQnk4WVF3aE81bC1WZnc4SU1ObC1jZDEtN29wT1NlRHNsb1R6dFpnbjRiSm1QVnJMbTlRVzlTaEI1YXlqSklrcnVoZ056ZVVNLXhtVklUYnNNazhfVzBiQ2l1c2tjemhQeFYySk5YbnZOSmN5cGt3?oc=5","as_of":"2026-04-08T03:48:37.023140+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPU1NIRXQtZWNSQWNITzl2S2JDTzl1YTA4ano1dHB5RGZJRlMwSTJ3Vkg1UFdWNnVZTFZPNXVMYWpnVzF6QzhDdnFCVi16SkZWQnk4WVF3aE81bC1WZnc4SU1ObC1jZDEtN29wT1NlRHNsb1R6dFpnbjRiSm1QVnJMbTlRVzlTaEI1YXlqSklrcnVoZ056ZVVNLXhtVklUYnNNazhfVzBiQ2l1c2tjemhQeFYySk5YbnZOSmN5cGt3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_061be1e6f637b925","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:50:07.800817+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPU1NIRXQtZWNSQWNITzl2S2JDTzl1YTA4ano1dHB5RGZJRlMwSTJ3Vkg1UFdWNnVZTFZPNXVMYWpnVzF6QzhDdnFCVi16SkZWQnk4WVF3aE81bC1WZnc4SU1ObC1jZDEtN29wT1NlRHNsb1R6dFpnbjRiSm1QVnJMbTlRVzlTaEI1YXlqSklrcnVoZ056ZVVNLXhtVklUYnNNazhfVzBiQ2l1c2tjemhQeFYySk5YbnZOSmN5cGt3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"latimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPU1NIRXQtZWNSQWNITzl2S2JDTzl1YTA4ano1dHB5RGZJRlMwSTJ3Vkg1UFdWNnVZTFZPNXVMYWpnVzF6QzhDdnFCVi16SkZWQnk4WVF3aE81bC1WZnc4SU1ObC1jZDEtN29wT1NlRHNsb1R6dFpnbjRiSm1QVnJMbTlRVzlTaEI1YXlqSklrcnVoZ056ZVVNLXhtVklUYnNNazhfVzBiQ2l1c2tjemhQeFYySk5YbnZOSmN5cGt3?oc=5","source_event_id":"evt_ee3bdc6bb581","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9cee41d052773d49","published_at":"2026-04-07T20:28:23+00:00","publisher_domain":"latimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equities","name":"Stocks (market)","relevance":"high","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["Which specific index(s) or stocks moved is not stated in the provided text.","What the \u201ctiny gain\u201d magnitude was (percent/points) is not provided.","The exact date/time of \u201cTrump\u2019s deadline for Iran\u201d is not included.","No details are provided on the mechanism (e.g., negotiations, policy change) beyond the deadline framing."],"key_facts":["The Los Angeles Times headline states that stocks swung from losses to a tiny gain.","The timing of the swing is described as being ahead of Trump\u2019s deadline for Iran."],"numeric_claims":[],"primary_claim":"Stocks moved from losses to a tiny gain ahead of Trump\u2019s deadline for Iran.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Stocks swung from losses to a small gain as markets approached Trump\u2019s deadline for Iran. The headline indicates the move was tied to timing around that deadline.","topics":["stocks","market swing","geopolitical deadline","Iran","Trump"]},"source":"Los Angeles Times","source_domain":"latimes.com","source_url":"https://www.latimes.com","summary":"Stocks swing from losses to a tiny gain ahead of Trump\u2019s deadline for Iran Los Angeles Times","title":"Stocks swing from losses to a tiny gain ahead of Trump\u2019s deadline for Iran - Los Angeles Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 4334 in events