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/CBMic0FVX3lxTE9tU2dHMnp4VlpsM21jelJsQ1hKalJUX1NCNXpUa1BnS1BtNVR0OTVGaFo2ZXFuc2hyNERDVUNmU2g0MDM4TTdDN3N3WU9GVER4czFTM3h5VTdWdENoSWZwOXY2TThVQmMzUVRXTGc1cjNmemM?oc=5","as_of":"2026-04-06T15:38:20.126731+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/CBMic0FVX3lxTE9tU2dHMnp4VlpsM21jelJsQ1hKalJUX1NCNXpUa1BnS1BtNVR0OTVGaFo2ZXFuc2hyNERDVUNmU2g0MDM4TTdDN3N3WU9GVER4czFTM3h5VTdWdENoSWZwOXY2TThVQmMzUVRXTGc1cjNmemM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_965aa76718c79f06","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-06T15:43:19.837029+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9tU2dHMnp4VlpsM21jelJsQ1hKalJUX1NCNXpUa1BnS1BtNVR0OTVGaFo2ZXFuc2hyNERDVUNmU2g0MDM4TTdDN3N3WU9GVER4czFTM3h5VTdWdENoSWZwOXY2TThVQmMzUVRXTGc1cjNmemM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9tU2dHMnp4VlpsM21jelJsQ1hKalJUX1NCNXpUa1BnS1BtNVR0OTVGaFo2ZXFuc2hyNERDVUNmU2g0MDM4TTdDN3N3WU9GVER4czFTM3h5VTdWdENoSWZwOXY2TThVQmMzUVRXTGc1cjNmemM?oc=5","source_event_id":"evt_eb3150ccd0d0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"574a2b5d784665a4","published_at":"2026-04-06T13:53:48+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"legal","name":"Steve Bannon","relevance":"directly affected","symbol":"N/A","type":"individual"},{"asset_class":"legal","name":"Supreme Court","relevance":"decision maker","symbol":"N/A","type":"institution"},{"asset_class":"legal","name":"Trump's DOJ","relevance":"involved in the case","symbol":"N/A","type":"institution"}],"event_type":"regulation","information_gaps":["Details on the implications of the dismissal for Bannon's future legal challenges","Timing of the dismissal process","Potential reactions from political entities or the public"],"key_facts":["Supreme Court decision allows dismissal of contempt case","Bannon was convicted related to January 6 incident"],"numeric_claims":[],"primary_claim":"The Supreme Court clears the way for the dismissal of Steve Bannon's contempt case.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"The Supreme Court has allowed the dismissal of Steve Bannon's contempt case related to the January 6 incident, potentially impacting his legal standing.","topics":["Supreme Court","Steve Bannon","January 6","legal proceedings"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Supreme Court clears the way for Bannon contempt case to be dismissed NPR Supreme Court sides with Steve Bannon in bid to dismiss Jan. 6 conviction The Washington Post Trump Live Updates: Supreme Court Clears Way for Dismissal of Steve Bannon Conviction The New York Times Supreme Court clears path for Trump\u2019s DOJ to dismiss criminal case against Steve Bannon CNN Supreme Court clears way for Trump DOJ to wipe out Steve Bannon's conviction USA Today","title":"Supreme Court clears the way for Bannon contempt case to be dismissed - NPR","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_91f39ee69a03 in signals