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/813623/0001398344-26-006168.txt","as_of":"2026-04-07T03:18:43.308311+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.txt","company":"Total Return Securities Fund","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.txt","article_chars":2012,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_88e8954607511f3e","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.txt","content_type":"text/plain","enriched_at":"2026-04-07T08:52:58.876011+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.txt","source_event_id":"evt_649c49a9a9b1","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"9a12c99fadfe3e48","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-04-02"],"entities":[{"asset_class":"equity","name":"Total Return Securities Fund","relevance":"high","symbol":"SWZ","type":"issuer"}],"event_type":"listing","information_gaps":["No prior state of ownership or transactions disclosed for comparison."],"key_facts":["Form 4 filed on April 6, 2026.","Reporting owner: Andrew Dakos, President and CEO.","Transactions involve common stock held by a limited partnership."],"numeric_claims":[{"label":"Number of shares reported","value":"100"},{"label":"Weighted average price","value":"5.95"}],"primary_claim":"Andrew Dakos reported transactions involving common stock of Total Return Securities Fund (SWZ) on April 6, 2026.","relevance_score":0.7,"sentiment":"neutral","source_quality":"medium","summary":"SWZ filed a Form 4 disclosing transactions by Andrew Dakos, President and CEO of Total Return Securities Fund, on April 6, 2026.","topics":["SEC filing","insider trading"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Total Return Securities Fund \u00b7 Filed 20260406","ticker":"SWZ","tickers":["SWZ"],"title":"SWZ filed 4","url":"https://www.sec.gov/Archives/edgar/data/813623/0001398344-26-006168.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_fd39fb8a4595 in signals