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/CBMiggFBVV95cUxNYW1GWC1ZWWRxcW50MmNYb0F3bVV5N2MyNnFpa0Vhb2Z2cVJ5RFhUMVlVZW94TmdwUi02V2xlRzFacThWYjBWUTJKVW9pdUJuM1lEaWkxMURfWmNYNHpKNTA1dWRiVmJVOGlMaEZvMFdKYW01ejdRZ3JtTnVMazQxLWln0gGHAUFVX3lxTE43blE0ekVabkpUNGsyQXRMSkJ5WmNncjZJaG4yVzhKcHVxd3lRT0UtSkpnbWhFMmlYT01ad1NWdWVXOGZ6cFNTVUVpaTA5V2NoUVdodmlETUp4Nzd1TzVvTjVZSTVpOUh5bDRaUnRURUlWRGp5X09LT3ViSVNRT2hTNVZTOVF3QQ?oc=5","as_of":"2026-04-10T16:36:01.284043+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/CBMiggFBVV95cUxNYW1GWC1ZWWRxcW50MmNYb0F3bVV5N2MyNnFpa0Vhb2Z2cVJ5RFhUMVlVZW94TmdwUi02V2xlRzFacThWYjBWUTJKVW9pdUJuM1lEaWkxMURfWmNYNHpKNTA1dWRiVmJVOGlMaEZvMFdKYW01ejdRZ3JtTnVMazQxLWln0gGHAUFVX3lxTE43blE0ekVabkpUNGsyQXRMSkJ5WmNncjZJaG4yVzhKcHVxd3lRT0UtSkpnbWhFMmlYT01ad1NWdWVXOGZ6cFNTVUVpaTA5V2NoUVdodmlETUp4Nzd1TzVvTjVZSTVpOUh5bDRaUnRURUlWRGp5X09LT3ViSVNRT2hTNVZTOVF3QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d5f89401fab16da5","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:15:33.475287+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNYW1GWC1ZWWRxcW50MmNYb0F3bVV5N2MyNnFpa0Vhb2Z2cVJ5RFhUMVlVZW94TmdwUi02V2xlRzFacThWYjBWUTJKVW9pdUJuM1lEaWkxMURfWmNYNHpKNTA1dWRiVmJVOGlMaEZvMFdKYW01ejdRZ3JtTnVMazQxLWln0gGHAUFVX3lxTE43blE0ekVabkpUNGsyQXRMSkJ5WmNncjZJaG4yVzhKcHVxd3lRT0UtSkpnbWhFMmlYT01ad1NWdWVXOGZ6cFNTVUVpaTA5V2NoUVdodmlETUp4Nzd1TzVvTjVZSTVpOUh5bDRaUnRURUlWRGp5X09LT3ViSVNRT2hTNVZTOVF3QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNYW1GWC1ZWWRxcW50MmNYb0F3bVV5N2MyNnFpa0Vhb2Z2cVJ5RFhUMVlVZW94TmdwUi02V2xlRzFacThWYjBWUTJKVW9pdUJuM1lEaWkxMURfWmNYNHpKNTA1dWRiVmJVOGlMaEZvMFdKYW01ejdRZ3JtTnVMazQxLWln0gGHAUFVX3lxTE43blE0ekVabkpUNGsyQXRMSkJ5WmNncjZJaG4yVzhKcHVxd3lRT0UtSkpnbWhFMmlYT01ad1NWdWVXOGZ6cFNTVUVpaTA5V2NoUVdodmlETUp4Nzd1TzVvTjVZSTVpOUh5bDRaUnRURUlWRGp5X09LT3ViSVNRT2hTNVZTOVF3QQ?oc=5","source_event_id":"evt_8df4586d1340","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"93531885d9cf1c1c","published_at":"2026-04-10T15:13:55+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"White House","relevance":"primary source of the warning","symbol":"","type":"government_body"},{"asset_class":"","name":"Iran","relevance":"subject of the warned-about prediction market bets","symbol":"","type":"country"},{"asset_class":"","name":"Prediction markets","relevance":"the mechanism staff were warned not to use for Iran war bets","symbol":"","type":"financial_market_structure"},{"asset_class":"","name":"CNBC","relevance":"publisher reporting the warning","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided on when the warning occurred.","No details are provided on the specific staff roles, internal policy wording, or enforcement/penalties.","No details are provided on which prediction markets or contracts were involved.","No details are provided on the rationale beyond what is implied by the existence of the warning (not explicitly stated in the provided text)."],"key_facts":["CNBC headline states the White House warned staff against making Iran war bets on prediction markets.","The warning is specifically about \u201cIran war\u201d bets and the use of prediction markets."],"numeric_claims":[],"primary_claim":"The White House warned staff against making Iran war bets on prediction markets.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"CNBC reports that the White House warned staff not to place \u201cIran war\u201d bets on prediction markets. The warning suggests concern about how staff might use or influence market-based forecasts regarding potential conflict with Iran.","topics":["White House guidance","Iran","prediction markets","risk management","geopolitical uncertainty"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"White House warned staff against making Iran war bets on prediction markets CNBC","title":"White House warned staff against making Iran war bets on prediction markets - CNBC","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_95b8845d639e in signals