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/CBMitwFBVV95cUxPbldpd2lPakVwU0NZSWJSbHRiTEN3eEQ1d0xTRUFUdVFZOTBOVjVFOTd2YlNnakVvWUZwb3AtU1drLVZXTjloczdaNVJYQ1REOTFVcElVTVZmRWZxUlg2U05MNktnVU1NWVAzbFZnY0Rnd0xVVF9BTUp0aEtTQko0eXREbHZuYV94ZmxrdnBtcFhhaFN4dHNuTlhOckw4ZGNVSFZJRUlFaDc4bV9Hdk11WGFmVTFZems?oc=5","as_of":"2026-04-07T04:04:22.316826+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/CBMitwFBVV95cUxPbldpd2lPakVwU0NZSWJSbHRiTEN3eEQ1d0xTRUFUdVFZOTBOVjVFOTd2YlNnakVvWUZwb3AtU1drLVZXTjloczdaNVJYQ1REOTFVcElVTVZmRWZxUlg2U05MNktnVU1NWVAzbFZnY0Rnd0xVVF9BTUp0aEtTQko0eXREbHZuYV94ZmxrdnBtcFhhaFN4dHNuTlhOckw4ZGNVSFZJRUlFaDc4bV9Hdk11WGFmVTFZems?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_648988c98d6ce14d","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-07T17:21:48.124360+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxPbldpd2lPakVwU0NZSWJSbHRiTEN3eEQ1d0xTRUFUdVFZOTBOVjVFOTd2YlNnakVvWUZwb3AtU1drLVZXTjloczdaNVJYQ1REOTFVcElVTVZmRWZxUlg2U05MNktnVU1NWVAzbFZnY0Rnd0xVVF9BTUp0aEtTQko0eXREbHZuYV94ZmxrdnBtcFhhaFN4dHNuTlhOckw4ZGNVSFZJRUlFaDc4bV9Hdk11WGFmVTFZems?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxPbldpd2lPakVwU0NZSWJSbHRiTEN3eEQ1d0xTRUFUdVFZOTBOVjVFOTd2YlNnakVvWUZwb3AtU1drLVZXTjloczdaNVJYQ1REOTFVcElVTVZmRWZxUlg2U05MNktnVU1NWVAzbFZnY0Rnd0xVVF9BTUp0aEtTQko0eXREbHZuYV94ZmxrdnBtcFhhaFN4dHNuTlhOckw4ZGNVSFZJRUlFaDc4bV9Hdk11WGFmVTFZems?oc=5","source_event_id":"evt_fb156bd5cc03","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5162f8b2b44e9356","published_at":"2026-04-06T17:40:42+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"N/A","name":"Steve Bannon","relevance":"directly affected","symbol":"N/A","type":"individual"},{"asset_class":"N/A","name":"US Supreme Court","relevance":"decision maker","symbol":"N/A","type":"institution"},{"asset_class":"N/A","name":"Donald Trump","relevance":"indirectly affected","symbol":"N/A","type":"individual"}],"event_type":"regulation","information_gaps":["Details on the implications of the dismissal for ongoing investigations or cases against Trump and his associates are not provided."],"key_facts":["The Supreme Court's decision facilitates the dismissal of Bannon's contempt case related to the January 6 events.","This ruling may influence other legal challenges faced by Trump and his allies."],"numeric_claims":[],"primary_claim":"The US Supreme Court has cleared the way for the dismissal of the case against Steve Bannon.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"The US Supreme Court has allowed the dismissal of a case against Steve Bannon, a close ally of former President Trump, which may impact ongoing legal proceedings involving Trump and his associates.","topics":["legal","politics","Supreme Court","Trump administration"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"US Supreme Court clears way for dismissal of case against Trump ally Steve Bannon Reuters Supreme Court Clears the Way for Dismissal of Steve Bannon\u2019s Conviction The New York Times Supreme Court clears path for Trump\u2019s DOJ to dismiss criminal case against Steve Bannon CNN Supreme Court sides with Steve Bannon in bid to dismiss Jan. 6 conviction The Washington Post Supreme Court agrees to help Trump DOJ move to dismiss Steve Bannon\u2019s contempt case MS NOW","title":"US Supreme Court clears way for dismissal of case against Trump ally Steve Bannon - Reuters","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_a88a87635e8b in signals