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/CBMi9AFBVV95cUxNdlhEMXFQOFBPRnpQN0Z1ZjhqYmtKZk50R3BNWE1sNmEteTJNUlQ0cGpFNGJFSTlfRjBGS0dSN0VPNnJkNFdlNjdCZ3ZRXzljWENxR2VYVEJwaHFfbzRVZ04xQ05iTlF5eTdfTDItQmdXWm1PbXJlVFRmYmhCNTZDaGxCWF8ybWpXNUMwU3hWTlUxSUl5eldsTFlfV2VPeVJvRThmTmxXMXhxejl5REVYLW9QTy1YelBETHFIbHN4VEkzdjZ4bHd3cFFBSGlHblpSUXhQNHUwaGVaaGZ6d2xJbGVybGxvS2ltY1phLXp4UDZhbW9P?oc=5","as_of":"2026-04-07T23:23:37.692868+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/CBMi9AFBVV95cUxNdlhEMXFQOFBPRnpQN0Z1ZjhqYmtKZk50R3BNWE1sNmEteTJNUlQ0cGpFNGJFSTlfRjBGS0dSN0VPNnJkNFdlNjdCZ3ZRXzljWENxR2VYVEJwaHFfbzRVZ04xQ05iTlF5eTdfTDItQmdXWm1PbXJlVFRmYmhCNTZDaGxCWF8ybWpXNUMwU3hWTlUxSUl5eldsTFlfV2VPeVJvRThmTmxXMXhxejl5REVYLW9QTy1YelBETHFIbHN4VEkzdjZ4bHd3cFFBSGlHblpSUXhQNHUwaGVaaGZ6d2xJbGVybGxvS2ltY1phLXp4UDZhbW9P?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_78ef3ef390b112e4","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-08T00:32:12.671812+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi9AFBVV95cUxNdlhEMXFQOFBPRnpQN0Z1ZjhqYmtKZk50R3BNWE1sNmEteTJNUlQ0cGpFNGJFSTlfRjBGS0dSN0VPNnJkNFdlNjdCZ3ZRXzljWENxR2VYVEJwaHFfbzRVZ04xQ05iTlF5eTdfTDItQmdXWm1PbXJlVFRmYmhCNTZDaGxCWF8ybWpXNUMwU3hWTlUxSUl5eldsTFlfV2VPeVJvRThmTmxXMXhxejl5REVYLW9QTy1YelBETHFIbHN4VEkzdjZ4bHd3cFFBSGlHblpSUXhQNHUwaGVaaGZ6d2xJbGVybGxvS2ltY1phLXp4UDZhbW9P?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9news.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi9AFBVV95cUxNdlhEMXFQOFBPRnpQN0Z1ZjhqYmtKZk50R3BNWE1sNmEteTJNUlQ0cGpFNGJFSTlfRjBGS0dSN0VPNnJkNFdlNjdCZ3ZRXzljWENxR2VYVEJwaHFfbzRVZ04xQ05iTlF5eTdfTDItQmdXWm1PbXJlVFRmYmhCNTZDaGxCWF8ybWpXNUMwU3hWTlUxSUl5eldsTFlfV2VPeVJvRThmTmxXMXhxejl5REVYLW9QTy1YelBETHFIbHN4VEkzdjZ4bHd3cFFBSGlHblpSUXhQNHUwaGVaaGZ6d2xJbGVybGxvS2ltY1phLXp4UDZhbW9P?oc=5","source_event_id":"evt_08d93ca51f28","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f1d4e2a730c27fed","published_at":"2026-04-07T21:53:00+00:00","publisher_domain":"9news.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Democratic lawmakers","relevance":"high","symbol":"","type":"group"},{"asset_class":"","name":"prediction markets","relevance":"high","symbol":"","type":"market_category"},{"asset_class":"","name":"wagers on war","relevance":"high","symbol":"","type":"activity"},{"asset_class":"","name":"KUSA.com (9news.com)","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["Which specific lawmakers or committees are involved is not provided in the provided text.","What form of oversight or crackdown is being demanded (e.g., legislation, hearings, enforcement actions) is not specified.","No details are provided on which prediction market platforms or jurisdictions are targeted.","No timing (near-term vs. long-term) for the proposed oversight/crackdown is included in the provided text."],"key_facts":["The headline states that Democratic lawmakers are demanding oversight on prediction markets.","The headline states that Democratic lawmakers are demanding a crackdown on wagers on war."],"numeric_claims":[],"primary_claim":"Democratic lawmakers demand oversight on prediction markets and a crackdown on wagers on war.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Democratic lawmakers are calling for increased oversight of prediction markets and for a crackdown on wagers related to war, according to KUSA.com/9news.com.","topics":["prediction markets","war-related wagering","regulatory oversight","political response"]},"source":"KUSA.com","source_domain":"9news.com","source_url":"https://www.9news.com","summary":"Democratic lawmakers demand oversight on prediction markets and crackdown on wagers on war KUSA.com","title":"Democratic lawmakers demand oversight on prediction markets and crackdown on wagers on war - KUSA.com","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_de304a070179 in signals