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/CBMihAFBVV95cUxNTFVkalh6dTJVbTY3dV9EU1p4cFNSQVF3VGtlR3hZc2M3MUhPUURvMEY4azRIbTFsc19HbmoxYzRXd0ZsSU1SMHU1TXlRaHZBaFlkcUtuNU9ONzY0ZTlDQzEyUjFySVZPUjNYSVM2ZlQ2ZmhIZGdBLUR4ZWcxeENMTkZOb1U?oc=5","as_of":"2026-04-08T04:18:54.848161+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/CBMihAFBVV95cUxNTFVkalh6dTJVbTY3dV9EU1p4cFNSQVF3VGtlR3hZc2M3MUhPUURvMEY4azRIbTFsc19HbmoxYzRXd0ZsSU1SMHU1TXlRaHZBaFlkcUtuNU9ONzY0ZTlDQzEyUjFySVZPUjNYSVM2ZlQ2ZmhIZGdBLUR4ZWcxeENMTkZOb1U?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d1456c12279affdb","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-08T04:19:16.597291+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNTFVkalh6dTJVbTY3dV9EU1p4cFNSQVF3VGtlR3hZc2M3MUhPUURvMEY4azRIbTFsc19HbmoxYzRXd0ZsSU1SMHU1TXlRaHZBaFlkcUtuNU9ONzY0ZTlDQzEyUjFySVZPUjNYSVM2ZlQ2ZmhIZGdBLUR4ZWcxeENMTkZOb1U?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/CBMihAFBVV95cUxNTFVkalh6dTJVbTY3dV9EU1p4cFNSQVF3VGtlR3hZc2M3MUhPUURvMEY4azRIbTFsc19HbmoxYzRXd0ZsSU1SMHU1TXlRaHZBaFlkcUtuNU9ONzY0ZTlDQzEyUjFySVZPUjNYSVM2ZlQ2ZmhIZGdBLUR4ZWcxeENMTkZOb1U?oc=5","source_event_id":"evt_f5fc41f03caf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a0937126594ae2bb","published_at":"2026-04-08T02:42:18+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"ceasefire counterpart","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"ceasefire counterpart","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil prices","relevance":"primary market reaction","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equities","name":"U.S. stocks (Dow futures)","relevance":"reported secondary market reaction","symbol":"DJIA (futures)","type":"equity index (futures)"}],"event_type":"geopolitical_risk","information_gaps":["Exact magnitude of oil price drop (percent/price level) is not provided in the extracted text.","Whether the ceasefire is officially termed a 'ceasefire' vs 'suspension of attacks' is not fully specified beyond the summary wording.","Specific oil benchmark (WTI vs Brent) and the time window of the move are not provided.","No details on follow-on policy terms, compliance, or exceptions within the two-week period are included."],"key_facts":["Axios headline states oil prices plunged following a U.S.-Iran ceasefire.","Source summary indicates stocks rallied after the ceasefire announcement.","Source summary indicates the ceasefire involved suspending Iran attacks for two weeks (timing catalyst).","Source summary indicates Dow futures rose while oil fell (directional cross-asset reaction)."],"numeric_claims":[{"label":"Dow futures move","value":"+900 points (reported in source summary; exact timing/verification not provided in extracted text)"}],"primary_claim":"Oil prices plunged following a U.S.-Iran ceasefire announcement (Axios).","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Oil prices fell sharply after a U.S.-Iran ceasefire announcement, with risk assets (stocks) reportedly rallying on the reduced near-term conflict risk. The ceasefire is described as lasting about two weeks, implying a near-term catalyst for commodity and equity sentiment.","topics":["U.S.-Iran ceasefire","oil price reaction","market risk sentiment","Trump ceasefire announcement","two-week ceasefire window"]},"source":"axios.com","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Oil prices plunge following U.S.-Iran ceasefire axios.com Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement CNN Dow futures jump 900 points, oil tumbles after Trump suspends Iran attacks for two weeks: Live updates CNBC Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance Stock Market Today: Oil Jumps, Dow Dips After U.S. Raises the Temperature on Iran \u2014 Live Updates WSJ","title":"Oil prices plunge following U.S.-Iran ceasefire - axios.com","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_b247bb85631b in signals