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-09T15:01:33.556414+00:00","dedupe_key":"signal_enriched:news_delta:25a05844e9091515","evidence_event_ids":["evt_ac86c122ece6"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPNTd2ZGtJRmRMS0ZXaTBzRG9NeklqTzV3TXBxeWFiT3d5UEU4cjd6dFdRM0RTdnB1WkVhSEdxdW5hX1B6R1R1MEhBR3FrVlp1MHFWemtoVGw3VUE2eTBQOXhodFI4bncyMk5qczRYRkJvdll5V2F6OFdKQnY4dVJVbHdfRDJkc1RTQXMyYlNyWQ?oc=5","as_of":"2026-04-09T15:01:33.556414+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/CBMijwFBVV95cUxPNTd2ZGtJRmRMS0ZXaTBzRG9NeklqTzV3TXBxeWFiT3d5UEU4cjd6dFdRM0RTdnB1WkVhSEdxdW5hX1B6R1R1MEhBR3FrVlp1MHFWemtoVGw3VUE2eTBQOXhodFI4bncyMk5qczRYRkJvdll5V2F6OFdKQnY4dVJVbHdfRDJkc1RTQXMyYlNyWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1d4893c19e2af660","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-09T23:38:38.078366+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPNTd2ZGtJRmRMS0ZXaTBzRG9NeklqTzV3TXBxeWFiT3d5UEU4cjd6dFdRM0RTdnB1WkVhSEdxdW5hX1B6R1R1MEhBR3FrVlp1MHFWemtoVGw3VUE2eTBQOXhodFI4bncyMk5qczRYRkJvdll5V2F6OFdKQnY4dVJVbHdfRDJkc1RTQXMyYlNyWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPNTd2ZGtJRmRMS0ZXaTBzRG9NeklqTzV3TXBxeWFiT3d5UEU4cjd6dFdRM0RTdnB1WkVhSEdxdW5hX1B6R1R1MEhBR3FrVlp1MHFWemtoVGw3VUE2eTBQOXhodFI4bncyMk5qczRYRkJvdll5V2F6OFdKQnY4dVJVbHdfRDJkc1RTQXMyYlNyWQ?oc=5","source_event_id":"evt_ac86c122ece6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f39bb209ca28b0d2","published_at":"2026-04-09T13:32:05+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign/policy","name":"Donald Trump","relevance":"primary decision-maker","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"affected party; public reaction described","symbol":"","type":"country"},{"asset_class":"population","name":"Iranians (public)","relevance":"observable behavior cited (flags)","symbol":"","type":"group"},{"asset_class":"media","name":"The Washington Post","relevance":"source of the headline claim","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual Washington Post narrative details; only the headline and the multi-outlet source summary are available.","No specific timing (date/time) of the \u201cpause\u201d or the flag display is included in the provided text.","No details are provided on what the pause/cease-fire concretely changed (e.g., scope, duration, terms).","The claim about flags is based on the headline; without the article body, the exact context (where/when, who displayed them, what the flags depicted) is uncertain."],"key_facts":["The Washington Post headline states that after Trump paused the war, Iranians flew flags of victory rather than surrender.","The provided source summary includes additional characterizations from other outlets: a cease-fire for now in Iran, a blow to American credibility, and claims that Trump is the war\u2019s biggest loser.","Reuters is referenced in the source summary as saying Trump\u2019s abrupt Iran reversal exposes limits of his leverage."],"numeric_claims":[],"primary_claim":"After Trump paused the war with Iran, Iranians flew flags of victory rather than surrender, according to The Washington Post.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that after President Trump paused the Iran war, Iranians publicly displayed \u201cvictory\u201d flags rather than \u201csurrender\u201d imagery. Other referenced outlets frame the pause as a cease-fire/temporary de-escalation that may damage U.S. credibility and highlight limits of Trump\u2019s leverage.","topics":["Iran-U.S. conflict","cease-fire/pause in hostilities","public messaging/symbolism","U.S. credibility","diplomatic leverage"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"After Trump pauses war, Iranians fly flags of victory, not surrender The Washington Post A Cease-Fire for Now in Iran, but a Blow to American Credibility The New York Times Donald Trump is the war\u2019s biggest loser The Economist MORNING GLORY: President Trump leads the West to a big win against Iran Fox News Trump's abrupt Iran reversal exposes limits of his leverage Reuters","title":"After Trump pauses war, Iranians fly flags of victory, not surrender - The Washington Post","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 10300 in events