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/1788882/0001977858-26-000002.txt","as_of":"2026-04-09T03:12:49.786272+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.txt","company":"Root, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.txt","article_chars":1558,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a8875d60ed0338db","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.txt","content_type":"text/plain","enriched_at":"2026-04-09T19:29:55.313641+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.txt","source_event_id":"evt_b1faeffc1cf9","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"6cb0fab965eab4b3","kind":"sec_filing","published_at":"20260408","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-08","2026-04-07","2026-04-08 16:58:42","2019-09-19"],"entities":[{"asset_class":"equity","name":"Root, Inc.","relevance":"high","symbol":"","type":"issuer"},{"asset_class":"equity","name":"Allison Jonathan","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"equity","name":"Class A Common Stock","relevance":"high","symbol":"","type":"security"}],"event_type":"listing","information_gaps":["The cleaned text does not clearly show the number of shares sold, sale price per share, total transaction value, or whether there were any purchases/other transactions beyond the statement that shares were sold.","The text snippet does not provide the prior known state (e.g., whether this Form 4 is new vs. previously disclosed transactions), so the specific delta versus prior filings cannot be determined from the provided content alone."],"key_facts":["SEC accession number: 0001977858-26-000002.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-07.","Filed as of date: 2026-04-08.","Reporting-owner: Allison Jonathan.","Reporting-owner title shown: Chief Administrative Officer.","Security class shown: Class A Common Stock.","The shares were sold pursuant to a 10b5-1 trading plan (as stated in the filing text)."],"numeric_claims":[{"label":"Filing date (as of)","value":"2026-04-08"},{"label":"Period of report","value":"2026-04-07"},{"label":"SEC file number","value":"001-39658"},{"label":"EIN","value":"842717903"},{"label":"Central index key (issuer)","value":"0001788882"},{"label":"Central index key (owner)","value":"0001977858"}],"primary_claim":"Root, Inc. submitted SEC Form 4 (accession 0001977858-26-000002) filed 2026-04-08 for reporting period 2026-04-07, showing a sale of Class A Common Stock by Allison Jonathan under a 10b5-1 trading plan.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"Root, Inc. filed a Form 4 on 2026-04-08 covering a transaction with reporting-owner Allison Jonathan (Chief Administrative Officer). The filing indicates shares of Class A Common Stock were sold under a 10b5-1 trading plan.","topics":["SEC filing","Form 4","insider transaction","10b5-1 trading plan","share sale"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Root, Inc. \u00b7 Filed 20260408","ticker":"ROOT","tickers":["ROOT"],"title":"ROOT filed 4","url":"https://www.sec.gov/Archives/edgar/data/1788882/0001977858-26-000002.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_2c750fbb06b7 in signals