SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","as_of":"2026-04-07T03:18:43.308311+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","company":"SMITH MICRO SOFTWARE, INC.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","article_chars":1656,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a695e92503821a4a","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","content_type":"text/plain","enriched_at":"2026-04-07T09:47:55.897303+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt","source_event_id":"evt_49747bb9270b","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"b0da3a96ba853fd3","kind":"sec_filing","published_at":"20260406","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-06","2026-03-31"],"entities":[{"asset_class":"equity","name":"Smith Micro Software, Inc.","relevance":"high","symbol":"SMSI","type":"company"}],"event_type":"listing","information_gaps":["No prior state of ownership disclosed for comparison."],"key_facts":["Form 4 filed on April 6, 2026","Reporting owner: Bethany M. Braund","Unrestricted stock award of 39,585 shares"],"numeric_claims":[{"label":"Unrestricted stock award shares","value":"39,585"}],"primary_claim":"Bethany M. Braund received an unrestricted stock award of 39,585 shares as part of the company's equity incentive plan.","relevance_score":0.7,"sentiment":"neutral","source_quality":"medium","summary":"Smith Micro Software, Inc. filed a Form 4 on April 6, 2026, disclosing a stock award for an executive.","topics":["SEC filing","stock award","executive compensation"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 SMITH MICRO SOFTWARE, INC. \u00b7 Filed 20260406","ticker":"SMSI","tickers":["SMSI"],"title":"SMSI filed 4","url":"https://www.sec.gov/Archives/edgar/data/948708/0001437749-26-011457.txt"}

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_86d89c2286ef in signals