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-08T22:21:15.751639+00:00","dedupe_key":"signal_enriched:news_delta:3c9842871ce9e64d","evidence_event_ids":["evt_03173e3a3cb7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPcEdLbk9ZUEVfMHVxT1BuRl8zNnFEWC1OU0VLUS1EcmRKVjZvTUVkbEx3VnFWYllwNnJQWGFCNldDM0JUMUZ0dlI5eXdxaXdEUWZCZTZycmxSVlJuUmFlLVlVT0R6LUtvb0hNYUFIeS0tQ0l5S2ticWVZZlpkZU5VUFlB?oc=5","as_of":"2026-04-08T22:21:15.751639+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/CBMiggFBVV95cUxPcEdLbk9ZUEVfMHVxT1BuRl8zNnFEWC1OU0VLUS1EcmRKVjZvTUVkbEx3VnFWYllwNnJQWGFCNldDM0JUMUZ0dlI5eXdxaXdEUWZCZTZycmxSVlJuUmFlLVlVT0R6LUtvb0hNYUFIeS0tQ0l5S2ticWVZZlpkZU5VUFlB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9503d587ea499a00","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:16:43.955343+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPcEdLbk9ZUEVfMHVxT1BuRl8zNnFEWC1OU0VLUS1EcmRKVjZvTUVkbEx3VnFWYllwNnJQWGFCNldDM0JUMUZ0dlI5eXdxaXdEUWZCZTZycmxSVlJuUmFlLVlVT0R6LUtvb0hNYUFIeS0tQ0l5S2ticWVZZlpkZU5VUFlB?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/CBMiggFBVV95cUxPcEdLbk9ZUEVfMHVxT1BuRl8zNnFEWC1OU0VLUS1EcmRKVjZvTUVkbEx3VnFWYllwNnJQWGFCNldDM0JUMUZ0dlI5eXdxaXdEUWZCZTZycmxSVlJuUmFlLVlVT0R6LUtvb0hNYUFIeS0tQ0l5S2ticWVZZlpkZU5VUFlB?oc=5","source_event_id":"evt_03173e3a3cb7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a87f898700604e5","published_at":"2026-04-08T20:24:23+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"The Washington Post","relevance":"primary source of the headline signal","symbol":"","type":"publisher"},{"asset_class":"media","name":"CBS News","relevance":"referenced for expert views on Iran ceasefire and gas prices","symbol":"","type":"publisher"},{"asset_class":"media","name":"ClickOnDetroit | WDIV Local 4","relevance":"referenced for local impact of higher gas prices on Metro Detroit","symbol":"","type":"publisher"},{"asset_class":"media","name":"The Arizona Republic","relevance":"referenced for Arizona gas-price implications of Trump\u2019s Iran threat","symbol":"","type":"publisher"},{"asset_class":"media","name":"USA Today","relevance":"referenced for what is known about gas prices if an Iran ceasefire holds","symbol":"","type":"publisher"},{"asset_class":"geopolitical","name":"Iran","relevance":"geopolitical factor potentially affecting gas prices via Strait of Hormuz reopening/ceasefire","symbol":"","type":"country"},{"asset_class":"country","name":"United States","relevance":"market referenced for U.S. gas prices","symbol":"","type":"country"},{"asset_class":"political","name":"Trump","relevance":"referenced as pressuring Iran on Strait of Hormuz reopening","symbol":"Donald Trump","type":"person"}],"event_type":"macro_policy","information_gaps":["No specific price levels, dates, or quantified forecasts are included in the provided text; only questions and references to other coverage are present.","The actual Washington Post article content is not provided beyond the headline; therefore, the exact mechanism and timing claims (if any) cannot be verified.","The signal does not specify whether the Iran ceasefire is already in effect or the exact timeline for any ceasefire/Strait of Hormuz reopening."],"key_facts":["The Washington Post headline asks when prices will come down for gas, air travel, and strawberries.","The provided source summary states that CBS News discusses whether an Iran ceasefire would quickly ease U.S. gas prices and includes expert views.","The provided source summary states that ClickOnDetroit | WDIV Local 4 reports higher gas prices affecting Metro Detroiters as Trump pressures Iran on Strait of Hormuz reopening.","The provided source summary states that The Arizona Republic discusses what Trump\u2019s threat on Iran means for Arizona\u2019s high gas prices.","The provided source summary states that USA Today discusses whether gas prices will fall if an Iran ceasefire holds and what is known."],"numeric_claims":[],"primary_claim":"The Washington Post asks when prices will come down for gas, air travel, and strawberries, in the context of experts discussing whether an Iran ceasefire could ease U.S. gas prices.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post headline frames a question about when consumer prices will fall for gas, air travel, and strawberries, tying the gas-price outlook to potential easing of U.S.-Iran tensions. The provided source summary also references multiple outlets discussing whether an Iran ceasefire would lower U.S. gas prices and how Trump\u2019s Iran-related pressure affects local gas prices.","topics":["gas prices","air travel prices","food prices","strawberries","Iran ceasefire","Strait of Hormuz","U.S.-Iran tensions","consumer inflation","energy market risk"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"When will prices come down for gas, air travel and strawberries? The Washington Post Will the Iran ceasefire quickly ease U.S. gas prices? Here's what experts think. CBS News Higher gas prices squeeze Metro Detroiters as Trump pressures Iran on Strait of Hormuz reopening ClickOnDetroit | WDIV Local 4 Here's what Trump's threat on Iran means for Arizona's high gas prices The Arizona Republic Will gas prices fall if Iran ceasefire holds? What we know USA Today","title":"When will prices come down for gas, air travel and strawberries? - 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 8531 in events