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/CBMiiwFBVV95cUxNelNDX3g5aUlXR1JrOFk0Q0xLTS1MU2ttWTdXdS1CZFVuS0F6TkVBVEZLeW5qU0R0S1hTMVI3dFdMNmJNUEE0OUZhYjRtcEppZExsSTMyVjNXWW1BR3JEMGpyRk01Zy1fZ1lRNHA5SHZjbFRSOGxlQXlBTk9YRHFvb3BQdUxzdEx5YTY4?oc=5","as_of":"2026-04-09T18:49:37.279826+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/CBMiiwFBVV95cUxNelNDX3g5aUlXR1JrOFk0Q0xLTS1MU2ttWTdXdS1CZFVuS0F6TkVBVEZLeW5qU0R0S1hTMVI3dFdMNmJNUEE0OUZhYjRtcEppZExsSTMyVjNXWW1BR3JEMGpyRk01Zy1fZ1lRNHA5SHZjbFRSOGxlQXlBTk9YRHFvb3BQdUxzdEx5YTY4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d81bd4c50db2e7b2","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-10T00:20:32.676891+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNelNDX3g5aUlXR1JrOFk0Q0xLTS1MU2ttWTdXdS1CZFVuS0F6TkVBVEZLeW5qU0R0S1hTMVI3dFdMNmJNUEE0OUZhYjRtcEppZExsSTMyVjNXWW1BR3JEMGpyRk01Zy1fZ1lRNHA5SHZjbFRSOGxlQXlBTk9YRHFvb3BQdUxzdEx5YTY4?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/CBMiiwFBVV95cUxNelNDX3g5aUlXR1JrOFk0Q0xLTS1MU2ttWTdXdS1CZFVuS0F6TkVBVEZLeW5qU0R0S1hTMVI3dFdMNmJNUEE0OUZhYjRtcEppZExsSTMyVjNXWW1BR3JEMGpyRk01Zy1fZ1lRNHA5SHZjbFRSOGxlQXlBTk9YRHFvb3BQdUxzdEx5YTY4?oc=5","source_event_id":"evt_e13104164b54","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a4f0075e54bb9a79","published_at":"2026-04-09T12:20:00+00:00","publisher_domain":"fortune.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"United States (White House)","relevance":"high","symbol":"","type":"government"},{"asset_class":"other","name":"Iran war ceasefire (unspecified parties)","relevance":"medium","symbol":"","type":"agreement"}],"event_type":"geopolitical_risk","information_gaps":["The actual Fortune article content is not included; only the headline and a brief multi-outlet summary are provided.","Specific quotes for \u201cannihilation\u201d and \u201cPEACE\u201d and the exact timing (\u201cone day\u201d) are not provided.","No concrete details are given about the ceasefire terms, the \u201c10-point proposal\u201d contents, or the specific U.S. demands.","The signal does not specify whether the Strait of Hormuz framing is a policy shift, rhetoric, or an interpretation by Fortune.","No market/price-action implications are explicitly stated in the provided text."],"key_facts":["Fortune headline states Trump\u2019s \u201cjourney from \u2018annihilation\u2019 to \u2018PEACE\u2019 in one day\u201d was based on a realization of a long-term battle to control the Strait of Hormuz.","The provided source summary states the White House is struggling to prop up a truce and that there is confusion/contradictions.","The provided source summary indicates that CNN and The Washington Post coverage highlights disagreement about what is in the Iran war ceasefire and what the two sides can agree on.","The provided source summary references a \u201c10-point proposal\u201d by Iran and compares it to U.S. demands (details not included in the provided text)."],"numeric_claims":[],"primary_claim":"Trump\u2019s one-day shift from \u201cannihilation\u201d to \u201cPEACE\u201d was attributed to a realization of a long-term battle to control the Strait of Hormuz.","relevance_score":0.74,"sentiment":"mixed","source_quality":"high","summary":"The Fortune signal claims that Trump\u2019s messaging shifted from \u201cannihilation\u201d to \u201cPEACE\u201d within a day due to a realization that the U.S. faces a long-term struggle over control of the Strait of Hormuz. It also suggests that White House efforts to sustain an Iran ceasefire are marked by confusion and disagreements over what the ceasefire entails.","topics":["Iran war ceasefire","U.S.-Iran negotiations","Strait of Hormuz","Trump rhetoric shift","White House strategy/communication"]},"source":"Fortune","source_domain":"fortune.com","source_url":"https://fortune.com","summary":"Trump's journey from 'annihilation' to 'PEACE' in one day rested on realization of a long-term battle to control Strait of Hormuz Fortune White House struggles to prop up truce marked by confusion, contradictions The Washington Post What\u2019s in the Iran war ceasefire? The two sides can\u2019t seem to even agree on that. CNN What Is In Iran\u2019s 10-Point Proposal, and How Does It Compare to U.S. Demands? The New York Times After five weeks of the Iran war, is the U.S. better off? NBC News","title":"Trump's journey from 'annihilation' to 'PEACE' in one day rested on realization of a long-term battle to control Strait of Hormuz - 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

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_d97e43f28b60 in signals