SQLite Web: event_store.db

Update row 46540 in events

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:3c76cd9a7729950c","evidence_event_ids":["evt_f85f07315d1c"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001429711-26-000004.txt","as_of":"2026-04-15T02:18:53.247056+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001429711-26-000004.txt","company":"Tri Pointe Homes, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001429711-26-000004.txt","article_chars":1800,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3f07ff4d7ff9f06a","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001429711-26-000004.txt","content_type":"text/plain","enriched_at":"2026-04-15T05:16:51.167102+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001429711-26-000004.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/0001429711-26-000004.txt","source_event_id":"evt_f85f07315d1c","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"54f1aabd88d0d3fb","kind":"sec_filing","published_at":"20260414","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-14","2026-04-15","2008-03-13","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":"Lawrence B. Burrows","relevance":"high","symbol":"","type":"reporting-owner"},{"asset_class":"person","name":"Glenn J. Keeler","relevance":"medium","symbol":"","type":"signatory"}],"event_type":"other","information_gaps":["No disclosed insider transaction details are present in the provided text (e.g., whether shares were bought/sold, number of shares, price per share, or total value).","No explicit description of what changed versus a prior known state is included in the provided text (the signal is labeled as a delta, but the prior state content is not provided).","No material items or specific Form 4 sections (e.g., Table 1/footnotes) are included in the cleaned excerpt."],"key_facts":["SEC accession number: 0001429711-26-000004.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-14.","Filed as of date: 2026-04-14.","Issuer company name: Tri Pointe Homes, Inc.","Issuer ticker shown in text: TPH.","Reporting-owner: Lawrence B. Burrows.","Signatory shown: /s/ Glenn J. Keeler, attorney-in-fact.","The cleaned text provided does not include the transaction table/details (e.g., shares, transaction type, or consideration)."],"numeric_claims":[{"label":"Form 4 filing date (period of report)","value":"2026-04-14"},{"label":"Filed as of date","value":"2026-04-14"}],"primary_claim":"Tri Pointe Homes, Inc. filed Form 4 on 2026-04-14 (accession 0001429711-26-000004) reporting-owner Lawrence B. Burrows.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Tri Pointe Homes, Inc. (TPH) filed a Form 4 on 2026-04-14 for reporting-owner Lawrence B. Burrows. The provided text includes filing metadata but does not include the underlying transaction details (e.g., number of shares, price, or nature of the transaction).","topics":["SEC filing","Form 4","insider transaction reporting","Tri Pointe Homes"]},"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/0001429711-26-000004.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')

Cancel