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.452726+00:00","dedupe_key":"signal_enriched:news_delta:f87c5201794093f6","evidence_event_ids":["evt_eb124b7cacbf"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxQYjd0a0dXYlUzMElSNFZ5amhvQ3VXY2YxMlNyMXNFUDFpUFlqM1NlLVFuVWRQX1lIZGFzQnVhOUVacDlvRG5QM3V2R1F1eE4tNXMzdld1LXZPWXlxei02VHRKOGVGbm5nUXVNTjc5aENLLTNVMWJsd1ZRRDlBa2FfNGFVamlzaVhIMXo0cHBFcw?oc=5","as_of":"2026-04-08T23:28:56.452726+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/CBMijwFBVV95cUxQYjd0a0dXYlUzMElSNFZ5amhvQ3VXY2YxMlNyMXNFUDFpUFlqM1NlLVFuVWRQX1lIZGFzQnVhOUVacDlvRG5QM3V2R1F1eE4tNXMzdld1LXZPWXlxei02VHRKOGVGbm5nUXVNTjc5aENLLTNVMWJsd1ZRRDlBa2FfNGFVamlzaVhIMXo0cHBFcw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_37d34a71e48d6e2b","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:18:56.493209+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxQYjd0a0dXYlUzMElSNFZ5amhvQ3VXY2YxMlNyMXNFUDFpUFlqM1NlLVFuVWRQX1lIZGFzQnVhOUVacDlvRG5QM3V2R1F1eE4tNXMzdld1LXZPWXlxei02VHRKOGVGbm5nUXVNTjc5aENLLTNVMWJsd1ZRRDlBa2FfNGFVamlzaVhIMXo0cHBFcw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fortune.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxQYjd0a0dXYlUzMElSNFZ5amhvQ3VXY2YxMlNyMXNFUDFpUFlqM1NlLVFuVWRQX1lIZGFzQnVhOUVacDlvRG5QM3V2R1F1eE4tNXMzdld1LXZPWXlxei02VHRKOGVGbm5nUXVNTjc5aENLLTNVMWJsd1ZRRDlBa2FfNGFVamlzaVhIMXo0cHBFcw?oc=5","source_event_id":"evt_eb124b7cacbf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"56616c770fdaf18c","published_at":"2026-04-08T20:12:00+00:00","publisher_domain":"fortune.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Iran","relevance":"directly involved in ceasefire","symbol":"","type":"country"},{"asset_class":"","name":"United States","relevance":"directly involved in ceasefire","symbol":"","type":"country"},{"asset_class":"equities/FX/commodities (unspecified)","name":"Markets","relevance":"described as reacting minimally","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No specific details are provided on what actions or incidents caused the ceasefire to break down.","No information is given on which markets (equities, FX, rates, commodities) or which instruments reacted.","No timing details beyond \u201cwithin a day\u201d are provided (exact dates/times not stated).","No quantitative market-move data is included in the provided text."],"key_facts":["Fortune headline states that the Iran-U.S. ceasefire began breaking down within a day.","Fortune headline states that markets \u201cshrugged.\u201d"],"numeric_claims":[],"primary_claim":"Within a day, the Iran-U.S. ceasefire began breaking down, and markets shrugged.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The Iran-U.S. ceasefire reportedly began breaking down within a day, but markets did not react strongly, according to Fortune.","topics":["Iran-U.S. ceasefire","ceasefire breakdown","market reaction","geopolitical risk"]},"source":"Fortune","source_domain":"fortune.com","source_url":"https://fortune.com","summary":"Within a day, the Iran-U.S. ceasefire began breaking down. Markets shrugged Fortune","title":"Within a day, the Iran-U.S. ceasefire began breaking down. Markets shrugged - Fortune","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 8582 in events