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/CBMifEFVX3lxTFByaml5VzJzQzR4QzZzSVBfUVVkejRKOWVveDlnaVdsYmJUaFdnZjgtZUxEbHZRem96YmZ3bi13RWFVUXk0MXdEUE95R1NzbUkzRnJwYXB1T1ljRzQ3VDV1LVJ3UVJmU09hV2lscDhrYlhZeXlDTnF6LXd1WV8?oc=5","as_of":"2026-04-08T23:28:56.719831+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/CBMifEFVX3lxTFByaml5VzJzQzR4QzZzSVBfUVVkejRKOWVveDlnaVdsYmJUaFdnZjgtZUxEbHZRem96YmZ3bi13RWFVUXk0MXdEUE95R1NzbUkzRnJwYXB1T1ljRzQ3VDV1LVJ3UVJmU09hV2lscDhrYlhZeXlDTnF6LXd1WV8?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a09a104f059889e4","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:19:14.920674+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifEFVX3lxTFByaml5VzJzQzR4QzZzSVBfUVVkejRKOWVveDlnaVdsYmJUaFdnZjgtZUxEbHZRem96YmZ3bi13RWFVUXk0MXdEUE95R1NzbUkzRnJwYXB1T1ljRzQ3VDV1LVJ3UVJmU09hV2lscDhrYlhZeXlDTnF6LXd1WV8?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifEFVX3lxTFByaml5VzJzQzR4QzZzSVBfUVVkejRKOWVveDlnaVdsYmJUaFdnZjgtZUxEbHZRem96YmZ3bi13RWFVUXk0MXdEUE95R1NzbUkzRnJwYXB1T1ljRzQ3VDV1LVJ3UVJmU09hV2lscDhrYlhZeXlDTnF6LXd1WV8?oc=5","source_event_id":"evt_e85b90ab2b3c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b6c1cc3933f08ffa","published_at":"2026-04-08T14:27:38+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Friday"],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"media","name":"Axios","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"consumer","name":"South Florida drivers","relevance":"medium","symbol":"","type":"local_consumers"},{"asset_class":"other","name":"Analysts","relevance":"high","symbol":"","type":"group"}],"event_type":"macro_policy","information_gaps":["The specific analyst name(s) and their methodology are not provided in the provided text.","No quantitative gasoline price figures (e.g., cents/gallon change) are included in the provided content.","The duration/terms of the ceasefire (beyond being described as a ceasefire) are not specified in the provided excerpt.","Whether the ceasefire is already in effect at the time of the report is not explicitly stated in the provided text."],"key_facts":["Axios headline states that Iran ceasefire may bring gasoline relief by Friday, according to an analyst.","The relief is conditional on the ceasefire holding (i.e., continuation of the agreement).","The signal implies a near-term timing window of \u201cby Friday\u201d for gasoline price easing."],"numeric_claims":[{"label":"Timing","value":"by Friday"}],"primary_claim":"Analysts say an Iran ceasefire may bring gasoline relief by Friday if it holds.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Axios reports that an Iran ceasefire could lead to gasoline price relief in the U.S. by Friday, assuming the ceasefire holds. The expected catalyst is near-term and tied to the continuation of the U.S.-Iran ceasefire.","topics":["Iran ceasefire","gasoline prices","oil market expectations","U.S.-Iran tensions","near-term commodity relief"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Iran ceasefire may bring gasoline relief by Friday, analyst says Axios South Florida drivers and experts are hopeful as gas prices drop due to 2 week ceasefire between the U.S. and Iran CBS News When will prices come down for gas, air travel and strawberries? The Washington Post Higher gas prices squeeze Metro Detroiters as Trump pressures Iran on Strait of Hormuz reopening ClickOnDetroit | WDIV Local 4 Gas prices should soon start slowly easing if ceasefire holds, analysts say CNBC","title":"Iran ceasefire may bring gasoline relief by Friday, analyst says - Axios","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_05826dbefdc6 in signals