SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T03:18:43.308311+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:c5d3b03cd631b307","evidence_event_ids":["evt_8ec4f19d8512"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","as_of":"2026-04-07T03:18:43.308311+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","company":"SOPHiA GENETICS SA","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","article_chars":3070,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_98d52b2e1ce0bd02","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","content_type":"text/plain","enriched_at":"2026-04-07T09:32:42.245950+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt","source_event_id":"evt_8ec4f19d8512","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"144","fp":"ea606f0ab4cbd13f","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":"SOPHiA GENETICS SA","relevance":"issuer","symbol":"SOPH","type":"company"}],"event_type":"listing","information_gaps":["No prior known state of filings for comparison."],"key_facts":["Filing date: April 6, 2026","Form type: 144","Issuer: SOPHiA GENETICS SA","Securities acquired from restricted stock units on April 2, 2026."],"numeric_claims":[],"primary_claim":"SOPHiA GENETICS SA filed Form 144 on April 6, 2026.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"SOPHiA GENETICS SA filed Form 144 on April 6, 2026, indicating the intention to sell securities acquired from restricted stock units.","topics":["SEC filing","Form 144","stock sales"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 144 \u00b7 SOPHiA GENETICS SA \u00b7 Filed 20260406","ticker":"SOPH","tickers":["SOPH"],"title":"SOPH filed 144","url":"https://www.sec.gov/Archives/edgar/data/1840706/0001950047-26-003266.txt"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 36538 in events