SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_f50da969735c in signals