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/1561680/0001731562-26-000009.txt","as_of":"2026-04-16T02:08:52.472606+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001731562-26-000009.txt","company":"Tri Pointe Homes, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001731562-26-000009.txt","article_chars":1710,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_40280bbd29724716","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001731562-26-000009.txt","content_type":"text/plain","enriched_at":"2026-04-16T02:29:54.406611+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1561680/0001731562-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/0001731562-26-000009.txt","source_event_id":"evt_8a8c65074a41","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"3a93b1b6c46e3991","kind":"sec_filing","published_at":"20260415","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-15","2026-04-16T02:08:52.472606+00:00","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":"","name":"Lee David Ch","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"","name":"Tri Pointe Group, Inc.","relevance":"low","symbol":"","type":"address_reference"}],"event_type":"other","information_gaps":["No disclosed insider transaction details are present in the provided text (missing: transaction type, number of shares, price per share, total value, and whether it was a purchase/sale/option exercise).","No prior known state is included in the prompt, so the \u201cdelta\u201d vs prior filings cannot be determined from the provided text alone."],"key_facts":["SEC accession number: 0001731562-26-000009.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-15.","Filed as of date: 2026-04-15.","Issuer: Tri Pointe Homes, Inc. (TPH).","Reporting owner: Lee David Ch.","The filing values shown include: \u201cGeneral Counsel & Secretary\u201d and \u201cCommon Stock\u201d for the reporting owner.","The provided cleaned text does not show the transaction specifics (e.g., number of shares, transaction type, or price)."],"numeric_claims":[{"label":"Form 4 filing date (conformed period of report)","value":"2026-04-15"},{"label":"Form 4 filed as of date","value":"2026-04-15"}],"primary_claim":"Tri Pointe Homes, Inc. filed Form 4 (SEC accession 0001731562-26-000009) on 2026-04-15 reporting transactions by Lee David Ch.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"Tri Pointe Homes, Inc. (TPH) filed a Form 4 on 2026-04-15 for reporting-owner David Ch Lee. The provided text does not include the specific transaction details (e.g., shares, price, or nature of the transaction).","topics":["SEC Form 4","insider transaction filing","reporting owner disclosure"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Tri Pointe Homes, Inc. \u00b7 Filed 20260415","ticker":"TPH","tickers":["TPH"],"title":"TPH filed 4","url":"https://www.sec.gov/Archives/edgar/data/1561680/0001731562-26-000009.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_83dd3fabf889 in signals