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-15T02:18:53.247056+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:23c9311feb25b095","evidence_event_ids":["evt_f4252febf351"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","as_of":"2026-04-15T02:18:53.247056+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","company":"Tri Pointe Homes, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","article_chars":1783,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_32bb0e1f68ffbfad","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","content_type":"text/plain","enriched_at":"2026-04-15T05:16:55.499361+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.txt","source_event_id":"evt_f4252febf351","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"904388e13e93fe24","kind":"sec_filing","published_at":"20260414","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-13","2026-04-14","2014-06-30","2015-07-07","2013-01-30","2012-12-18"],"entities":[{"asset_class":"equity","name":"Tri Pointe Homes, Inc.","relevance":"high","symbol":"TPH","type":"issuer"},{"asset_class":"person","name":"Glenn J. Keeler","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"equity","name":"Common Stock","relevance":"medium","symbol":"","type":"security"}],"event_type":"other","information_gaps":["The cleaned text does not include the actual Form 4 transaction details (e.g., number of shares, price, transaction type such as buy/sell/option exercise).","No explicit description of what changed versus a prior known state is provided in the supplied text (no prior filing comparison data included).","The filing\u2019s specific table/footnotes content is not present in the provided excerpt, so the financial implication cannot be determined from this signal alone."],"key_facts":["SEC accession number: 0001612241-26-000009.","Conformed submission type: Form 4.","Issuer: Tri Pointe Homes, Inc. (TPH).","Reporting owner: Glenn J. Keeler.","Reporting owner role indicated as: CFO and CAO.","Security class indicated as: Common Stock.","Conformed period of report: 2026-04-13.","Filed as of date: 2026-04-14."],"numeric_claims":[{"label":"Conformed period of report","value":"20260413"},{"label":"Filed as of date","value":"20260414"},{"label":"SEC accession number","value":"0001612241-26-000009"}],"primary_claim":"Tri Pointe Homes, Inc. filed Form 4 (accession 0001612241-26-000009) on 2026-04-14 for reporting period 2026-04-13 by Glenn J. Keeler (CFO and CAO).","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Tri Pointe Homes, Inc. (TPH) filed a Form 4 on 2026-04-14 covering a reporting period of 2026-04-13 by reporting owner Glenn J. Keeler. The provided text does not include the specific transaction details, but it identifies the filer as CFO and CAO and the security as common stock.","topics":["SEC filing","Form 4","insider transaction disclosure","Tri Pointe Homes","Glenn J. Keeler"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Tri Pointe Homes, Inc. \u00b7 Filed 20260414","ticker":"TPH","tickers":["TPH"],"title":"TPH filed 4","url":"https://www.sec.gov/Archives/edgar/data/1561680/0001612241-26-000009.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 46542 in events