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/CBMiqwFBVV95cUxNcW5YemE5bU5RMGlFMnpqcUF3ZHBSZWF5QUkzN2tlMk5Rb2k0TFdmcUg0VnFIUFV1MUNOWGV2ZVJoQTRqZlYza0xHTjU3RXowNlRQcUQzQ3EtRE9GcndQRlVvYi1tUmtkX2xnR1lCaGNJLVJ0RXREVGFHd2ROOXhDU0N5dkNZQzlTZHBTc2ZvSWtvMEhJT3pya1QxbXU5N3dlZ01ibzRGaDhBU2M?oc=5","as_of":"2026-04-10T16:36:00.984373+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/CBMiqwFBVV95cUxNcW5YemE5bU5RMGlFMnpqcUF3ZHBSZWF5QUkzN2tlMk5Rb2k0TFdmcUg0VnFIUFV1MUNOWGV2ZVJoQTRqZlYza0xHTjU3RXowNlRQcUQzQ3EtRE9GcndQRlVvYi1tUmtkX2xnR1lCaGNJLVJ0RXREVGFHd2ROOXhDU0N5dkNZQzlTZHBTc2ZvSWtvMEhJT3pya1QxbXU5N3dlZ01ibzRGaDhBU2M?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2720ddeaa3fcc8d2","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-10T17:00:23.302685+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNcW5YemE5bU5RMGlFMnpqcUF3ZHBSZWF5QUkzN2tlMk5Rb2k0TFdmcUg0VnFIUFV1MUNOWGV2ZVJoQTRqZlYza0xHTjU3RXowNlRQcUQzQ3EtRE9GcndQRlVvYi1tUmtkX2xnR1lCaGNJLVJ0RXREVGFHd2ROOXhDU0N5dkNZQzlTZHBTc2ZvSWtvMEhJT3pya1QxbXU5N3dlZ01ibzRGaDhBU2M?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"statesman.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNcW5YemE5bU5RMGlFMnpqcUF3ZHBSZWF5QUkzN2tlMk5Rb2k0TFdmcUg0VnFIUFV1MUNOWGV2ZVJoQTRqZlYza0xHTjU3RXowNlRQcUQzQ3EtRE9GcndQRlVvYi1tUmtkX2xnR1lCaGNJLVJ0RXREVGFHd2ROOXhDU0N5dkNZQzlTZHBTc2ZvSWtvMEhJT3pya1QxbXU5N3dlZ01ibzRGaDhBU2M?oc=5","source_event_id":"evt_402a0f2ddab9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a66953882a4e350","published_at":"2026-04-10T16:27:59+00:00","publisher_domain":"statesman.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"US","relevance":"context for planned talks","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"counterparty in planned talks","symbol":"","type":"country"},{"asset_class":"equities","name":"Stocks","relevance":"market reaction described","symbol":"","type":"asset_class"},{"asset_class":"commodity","name":"Oil prices","relevance":"market reaction described","symbol":"","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["No specific date/time for the planned US\u2013Iran talks is provided in the provided text.","No specific stock index(s) or oil benchmark(s) are named.","No magnitude of the stock wavering or oil price stability is provided.","No details on expected outcomes or policy actions from the talks are provided."],"key_facts":["The headline states that stocks are wavering.","The headline states that oil prices are holding steady.","The described market conditions are ahead of planned US\u2013Iran talks."],"numeric_claims":[],"primary_claim":"Stocks waver and oil prices hold steady ahead of planned US\u2013Iran talks.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"Stocks were described as wavering and oil prices as steady ahead of planned US\u2013Iran talks. The near-term catalyst timing is the scheduled talks themselves.","topics":["US\u2013Iran talks","market volatility","oil prices","risk sentiment"]},"source":"Austin American-Statesman","source_domain":"statesman.com","source_url":"https://www.statesman.com","summary":"Stocks waver and oil prices hold steady ahead of planned US-Iran talks Austin American-Statesman","title":"Stocks waver and oil prices hold steady ahead of planned US-Iran talks - Austin American-Statesman","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_4320c3261177 in signals