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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:de56a9129f14e9c2","evidence_event_ids":["evt_bb8ef8b50730"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","company":"TIPTREE INC.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","article_chars":1707,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_987e1c46483ebc25","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","content_type":"text/plain","enriched_at":"2026-04-07T23:43:51.170815+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.txt","source_event_id":"evt_bb8ef8b50730","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"f83fde23b6a0d68a","kind":"sec_filing","published_at":"20260406","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-02","2026-04-06","2026-04-07T23:23:54.391414+00:00","2013-07-01","2007-03-20"],"entities":[{"asset_class":"equity","name":"TIPTREE INC.","relevance":"high","symbol":"TIPT","type":"issuer"},{"asset_class":"person","name":"Lesley Goldwasser","relevance":"high","symbol":"","type":"reporting_owner"}],"event_type":"other","information_gaps":["The cleaned text does not clearly show the full Form 4 transaction details (e.g., whether shares were acquired or disposed, and the exact transaction code).","The numeric fields (e.g., 1144, 115554) are present but not fully contextualized in the provided excerpt, so their meaning (shares vs. price vs. post-transaction holdings) is uncertain.","No prior known state is included in the prompt, so the specific delta vs. prior filings cannot be determined from the provided text alone."],"key_facts":["SEC accession number: 0001465575-26-000003.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-02.","Filed as of date: 2026-04-06.","Reporting owner: Lesley Goldwasser.","Issuer: TIPTREE INC. (TIPT).","The filing includes a line item for Common Stock with a footnote stating: \"Represents the stock component of the director's annual retainer fee, which is paid quarterly in arrears.\"","Signature: /s/ Siew Kwok as Attorney-in-Fact for Lesley Goldwasser.","SEC Act: 1934 Act; SEC file number: 001-33549."],"numeric_claims":[{"label":"Common stock value/quantity field shown","value":"1144"},{"label":"Additional numeric field shown","value":"115554"}],"primary_claim":"A Form 4 was filed by TIPTREE INC. on 2026-04-06 for reporting period 2026-04-02, with Lesley Goldwasser listed as the reporting owner.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"TIPTREE INC. (TIPT) filed a Form 4 on 2026-04-06 covering a transaction reported for the period ending 2026-04-02 by reporting owner Lesley Goldwasser.","topics":["SEC filing","Form 4","insider transaction","director compensation","common stock"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TIPTREE INC. \u00b7 Filed 20260406","ticker":"TIPT","tickers":["TIPT"],"title":"TIPT filed 4","url":"https://www.sec.gov/Archives/edgar/data/1393726/0001465575-26-000003.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 1091 in events