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_gJBVV95cUxNdm5pWlI0OU5IZllfWnNtcHZVaEVyWDVFajhYbGtwc2NqVFF2N19Sa3hLbU9adkxtZS0wNEpxNjJONEhIUXB3Sm1DajhDcHY5Q3VvdjU5a2NJT3llSkpqVWxjQ0kxZjNqenZoVXpxcXZ5aWpUR3k4U0VHaDhOQWRkSVpETlQ5QkVaZ1JnX0M4d2d2SGoyaFV3VHJPRGd5Q2ZEVjBLV2NacURoakFVZl8xNndENFF1OFI4YVNnRDRwUzNCOGpQYURwaU5jNmo2a29ua1BYWjQwdGE3TEQtTHMxUkJ1RFJmR1czWDF2VFJwY3lMOWlveEtwRXk4b3piRFZWVmZoVGdZYTBsd1A3U0pzY1BxWUwwQ3BFbGdjY0Zkb2I5eGI4ZUFxMHNfZko1QkxDWHJpdUhfUENtS2lGbHc5eXV3MnIxMXVlTy1odl9ySUR4ejRBWnExX0ZXQWVOc0VCTmM3OS03czdJSjNfc3prUFUxLWsyS2JsUDB6TWVn?oc=5","as_of":"2026-04-06T16:28:37.219892+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi_gJBVV95cUxNdm5pWlI0OU5IZllfWnNtcHZVaEVyWDVFajhYbGtwc2NqVFF2N19Sa3hLbU9adkxtZS0wNEpxNjJONEhIUXB3Sm1DajhDcHY5Q3VvdjU5a2NJT3llSkpqVWxjQ0kxZjNqenZoVXpxcXZ5aWpUR3k4U0VHaDhOQWRkSVpETlQ5QkVaZ1JnX0M4d2d2SGoyaFV3VHJPRGd5Q2ZEVjBLV2NacURoakFVZl8xNndENFF1OFI4YVNnRDRwUzNCOGpQYURwaU5jNmo2a29ua1BYWjQwdGE3TEQtTHMxUkJ1RFJmR1czWDF2VFJwY3lMOWlveEtwRXk4b3piRFZWVmZoVGdZYTBsd1A3U0pzY1BxWUwwQ3BFbGdjY0Zkb2I5eGI4ZUFxMHNfZko1QkxDWHJpdUhfUENtS2lGbHc5eXV3MnIxMXVlTy1odl9ySUR4ejRBWnExX0ZXQWVOc0VCTmM3OS03czdJSjNfc3prUFUxLWsyS2JsUDB6TWVn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bd02b79702251a3c","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T17:09:41.115236+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_gJBVV95cUxNdm5pWlI0OU5IZllfWnNtcHZVaEVyWDVFajhYbGtwc2NqVFF2N19Sa3hLbU9adkxtZS0wNEpxNjJONEhIUXB3Sm1DajhDcHY5Q3VvdjU5a2NJT3llSkpqVWxjQ0kxZjNqenZoVXpxcXZ5aWpUR3k4U0VHaDhOQWRkSVpETlQ5QkVaZ1JnX0M4d2d2SGoyaFV3VHJPRGd5Q2ZEVjBLV2NacURoakFVZl8xNndENFF1OFI4YVNnRDRwUzNCOGpQYURwaU5jNmo2a29ua1BYWjQwdGE3TEQtTHMxUkJ1RFJmR1czWDF2VFJwY3lMOWlveEtwRXk4b3piRFZWVmZoVGdZYTBsd1A3U0pzY1BxWUwwQ3BFbGdjY0Zkb2I5eGI4ZUFxMHNfZko1QkxDWHJpdUhfUENtS2lGbHc5eXV3MnIxMXVlTy1odl9ySUR4ejRBWnExX0ZXQWVOc0VCTmM3OS03czdJSjNfc3prUFUxLWsyS2JsUDB6TWVn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_gJBVV95cUxNdm5pWlI0OU5IZllfWnNtcHZVaEVyWDVFajhYbGtwc2NqVFF2N19Sa3hLbU9adkxtZS0wNEpxNjJONEhIUXB3Sm1DajhDcHY5Q3VvdjU5a2NJT3llSkpqVWxjQ0kxZjNqenZoVXpxcXZ5aWpUR3k4U0VHaDhOQWRkSVpETlQ5QkVaZ1JnX0M4d2d2SGoyaFV3VHJPRGd5Q2ZEVjBLV2NacURoakFVZl8xNndENFF1OFI4YVNnRDRwUzNCOGpQYURwaU5jNmo2a29ua1BYWjQwdGE3TEQtTHMxUkJ1RFJmR1czWDF2VFJwY3lMOWlveEtwRXk4b3piRFZWVmZoVGdZYTBsd1A3U0pzY1BxWUwwQ3BFbGdjY0Zkb2I5eGI4ZUFxMHNfZko1QkxDWHJpdUhfUENtS2lGbHc5eXV3MnIxMXVlTy1odl9ySUR4ejRBWnExX0ZXQWVOc0VCTmM3OS03czdJSjNfc3prUFUxLWsyS2JsUDB6TWVn?oc=5","source_event_id":"evt_03aceb0e27f4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c2b2783b30f5dabc","published_at":"2026-04-06T09:37:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"U.S. Stocks","relevance":"high","symbol":"^GSPC","type":"market"}],"event_type":"macro_policy","information_gaps":["Specific stock performance metrics are not provided.","Details on market reactions to Trump's rhetoric are not included."],"key_facts":["Trump threatens severe consequences for Iran.","Stocks are performing well despite geopolitical tensions."],"numeric_claims":[],"primary_claim":"Stocks are resilient in the face of Trump's threats against Iran.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Stocks are maintaining strength despite President Trump's aggressive rhetoric towards Iran, which includes threats of severe consequences.","topics":["stocks","Trump","Iran","market resilience"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"Stocks Power Through Trump\u2019s Rhetoric Even as He Threatens \u2018Hell\u2019 for Iran Barron's","title":"Stocks Power Through Trump\u2019s Rhetoric Even as He Threatens \u2018Hell\u2019 for Iran - Barron's","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_73f10a5e160f in signals