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-08T21:48:34.542411+00:00","dedupe_key":"signal_enriched:news_delta:1769e4361af288c8","evidence_event_ids":["evt_837732b654ee"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQOEx5eGVpb0ViRGhwOFdUMnhSVHF0S2F4RUNwRTVucGYxck5xLVpfeE1nSmtaOXk2dlMwakFRQ1ZTTHh6WGgwOVBxUFg3UUNNQWpJVXJnWHlmZW5LdGVkVlNBakxEWnJ3TXY3YVpFWnZhWlF2VDA4cHdoTTFRT1QtbzRiNDA0NTdLNVlubUhCdl9qam9jaTB1dHZQc1dneGlPSlhZRHVyNWhfNmxETDFvN1BIMUtqWXpLU2c?oc=5","as_of":"2026-04-08T21:48:34.542411+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/CBMiugFBVV95cUxQOEx5eGVpb0ViRGhwOFdUMnhSVHF0S2F4RUNwRTVucGYxck5xLVpfeE1nSmtaOXk2dlMwakFRQ1ZTTHh6WGgwOVBxUFg3UUNNQWpJVXJnWHlmZW5LdGVkVlNBakxEWnJ3TXY3YVpFWnZhWlF2VDA4cHdoTTFRT1QtbzRiNDA0NTdLNVlubUhCdl9qam9jaTB1dHZQc1dneGlPSlhZRHVyNWhfNmxETDFvN1BIMUtqWXpLU2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dfeff16966a38227","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:14:59.182842+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQOEx5eGVpb0ViRGhwOFdUMnhSVHF0S2F4RUNwRTVucGYxck5xLVpfeE1nSmtaOXk2dlMwakFRQ1ZTTHh6WGgwOVBxUFg3UUNNQWpJVXJnWHlmZW5LdGVkVlNBakxEWnJ3TXY3YVpFWnZhWlF2VDA4cHdoTTFRT1QtbzRiNDA0NTdLNVlubUhCdl9qam9jaTB1dHZQc1dneGlPSlhZRHVyNWhfNmxETDFvN1BIMUtqWXpLU2c?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/CBMiugFBVV95cUxQOEx5eGVpb0ViRGhwOFdUMnhSVHF0S2F4RUNwRTVucGYxck5xLVpfeE1nSmtaOXk2dlMwakFRQ1ZTTHh6WGgwOVBxUFg3UUNNQWpJVXJnWHlmZW5LdGVkVlNBakxEWnJ3TXY3YVpFWnZhWlF2VDA4cHdoTTFRT1QtbzRiNDA0NTdLNVlubUhCdl9qam9jaTB1dHZQc1dneGlPSlhZRHVyNWhfNmxETDFvN1BIMUtqWXpLU2c?oc=5","source_event_id":"evt_837732b654ee","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"93ac5f9f15e76b17","published_at":"2026-04-08T18:35:00+00:00","publisher_domain":"fortune.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"cause of ceasefire referenced","symbol":"","type":"country"},{"asset_class":"market_index","name":"Markets","relevance":"where losses were wiped out","symbol":"","type":"market"},{"asset_class":"trading_strategy","name":"TACO trade","relevance":"subject of analysts\u2019 warning","symbol":"","type":"trading strategy"},{"asset_class":"media","name":"Fortune","relevance":"source of the headline and summary","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["What \u201cTACO trade\u201d specifically refers to is not defined in the provided text.","No details are given on which markets/assets were affected or the magnitude/timing of the \u201cweeks of losses\u201d reversal.","The specific analysts\u2019 rationale for why the trade \u201cwon\u2019t last forever\u201d is not included in the provided text.","No information is provided on the exact timing/date of the Iran ceasefire or how quickly markets reversed."],"key_facts":["Fortune headline states analysts warn the TACO trade won\u2019t last forever.","Fortune summary states an Iran ceasefire wiped out weeks of losses in markets.","The article framing implies a rebound occurred following the ceasefire, but analysts caution it may not be sustained."],"numeric_claims":[],"primary_claim":"Analysts warn the TACO trade won\u2019t last forever after an Iran ceasefire wiped out weeks of losses in markets.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Fortune reports that analysts say the \u201cTACO trade\u201d may not persist after an Iran ceasefire reversed weeks of market losses. The ceasefire is presented as a near-term catalyst for the market rebound, but analysts caution the rally may fade.","topics":["Iran ceasefire","TACO trade","market losses","analyst commentary","risk sentiment"]},"source":"Fortune","source_domain":"fortune.com","source_url":"https://fortune.com","summary":"Analysts warn the TACO trade won\u2019t last forever after an Iran ceasefire wipes out weeks of losses in markets Fortune","title":"Analysts warn the TACO trade won\u2019t last forever after an Iran ceasefire wipes out weeks of losses in markets - 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 8467 in events