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/CBMi_wFBVV95cUxOemFKNmlMdmhVZmNIRnFJQkFzUDFLSF9vZFlXNFNNM0NZdi1Fd3ZFRVVjUmxtWl9VUWNBWldBUzJyV3ViSHg5eXlMMm1aM25QNTQ2emN6N1FZQlFGWjNidGk2VWdGWkMyOTVJSlVfczR0WHkzTzl4cE9vRmpRajYyX21yMTBRUU12TGJya1FjanlTZWtEUnphUno5NDRkMEFEaU9rQTNWMkw3QzFnVjUxdXZ1VGhaZEo5bkVDODB4azlBQzdaM1c3UGo0TUx4eF9WZXpWa2lhaERUYVFpMTB0WmlGdG9tSG1jSENoSWVyX0NUbm9XU1JEMkpDb3RlYTA?oc=5","as_of":"2026-04-09T20:18:40.891572+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/CBMi_wFBVV95cUxOemFKNmlMdmhVZmNIRnFJQkFzUDFLSF9vZFlXNFNNM0NZdi1Fd3ZFRVVjUmxtWl9VUWNBWldBUzJyV3ViSHg5eXlMMm1aM25QNTQ2emN6N1FZQlFGWjNidGk2VWdGWkMyOTVJSlVfczR0WHkzTzl4cE9vRmpRajYyX21yMTBRUU12TGJya1FjanlTZWtEUnphUno5NDRkMEFEaU9rQTNWMkw3QzFnVjUxdXZ1VGhaZEo5bkVDODB4azlBQzdaM1c3UGo0TUx4eF9WZXpWa2lhaERUYVFpMTB0WmlGdG9tSG1jSENoSWVyX0NUbm9XU1JEMkpDb3RlYTA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0d244e61e9188972","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:26:15.884105+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_wFBVV95cUxOemFKNmlMdmhVZmNIRnFJQkFzUDFLSF9vZFlXNFNNM0NZdi1Fd3ZFRVVjUmxtWl9VUWNBWldBUzJyV3ViSHg5eXlMMm1aM25QNTQ2emN6N1FZQlFGWjNidGk2VWdGWkMyOTVJSlVfczR0WHkzTzl4cE9vRmpRajYyX21yMTBRUU12TGJya1FjanlTZWtEUnphUno5NDRkMEFEaU9rQTNWMkw3QzFnVjUxdXZ1VGhaZEo5bkVDODB4azlBQzdaM1c3UGo0TUx4eF9WZXpWa2lhaERUYVFpMTB0WmlGdG9tSG1jSENoSWVyX0NUbm9XU1JEMkpDb3RlYTA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"journal-news.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_wFBVV95cUxOemFKNmlMdmhVZmNIRnFJQkFzUDFLSF9vZFlXNFNNM0NZdi1Fd3ZFRVVjUmxtWl9VUWNBWldBUzJyV3ViSHg5eXlMMm1aM25QNTQ2emN6N1FZQlFGWjNidGk2VWdGWkMyOTVJSlVfczR0WHkzTzl4cE9vRmpRajYyX21yMTBRUU12TGJya1FjanlTZWtEUnphUno5NDRkMEFEaU9rQTNWMkw3QzFnVjUxdXZ1VGhaZEo5bkVDODB4azlBQzdaM1c3UGo0TUx4eF9WZXpWa2lhaERUYVFpMTB0WmlGdG9tSG1jSENoSWVyX0NUbm9XU1JEMkpDb3RlYTA?oc=5","source_event_id":"evt_67604c15248a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6132741318604915","published_at":"2026-04-09T19:10:39+00:00","publisher_domain":"journal-news.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity_index","name":"US stocks","relevance":"affected","symbol":"^GSPC (not specified)","type":"market"},{"asset_class":"commodity","name":"Oil prices","relevance":"affected","symbol":"WTI/Brent (not specified)","type":"commodity"},{"asset_class":"sovereign","name":"Iran","relevance":"related_to_ceasefire","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Which specific US stock index(es) are referenced is not stated.","Which oil benchmark (WTI, Brent, or another) is referenced is not stated.","The magnitude of the stock and oil moves is not provided.","Timing/catalyst window for the ceasefire is not specified beyond \u201chopes.\u201d","No additional details from the article body are available in the provided text (only page code/boilerplate)."],"key_facts":["US stocks are rising.","Oil prices are trimming their gains.","The move is attributed to hopes for a ceasefire with Iran."],"numeric_claims":[],"primary_claim":"US stocks rise and oil prices trim their gains on hopes for the ceasefire with Iran.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"US stocks are rising while oil prices are giving back some gains, driven by hopes for a ceasefire with Iran.","topics":["ceasefire hopes","Iran","US equities","oil prices","market reaction"]},"source":"Journal-News.com","source_domain":"journal-news.com","source_url":"https://www.journal-news.com","summary":"US stocks rise and oil prices trim their gains on hopes for the ceasefire with Iran Journal-News.com","title":"US stocks rise and oil prices trim their gains on hopes for the ceasefire with Iran - Journal-News.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_d155b8e077df in signals