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/96869/0001193125-26-145921.txt","as_of":"2026-04-08T02:28:02.401723+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.txt","company":"TEJON RANCH CO","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.txt","article_chars":1353,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_415e607d02fc4127","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.txt","content_type":"text/plain","enriched_at":"2026-04-08T03:17:43.444415+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.txt","source_event_id":"evt_5c90101954fd","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"83f452c84d2b8bbe","kind":"sec_filing","published_at":"20260407","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-07"],"entities":[{"asset_class":"equity","name":"Tejon Ranch Co","relevance":"high","symbol":"TRC","type":"issuer"},{"asset_class":"equity","name":"Kenneth Yee","relevance":"high","symbol":"","type":"reporting_owner"}],"event_type":"listing","information_gaps":["The excerpt does not clearly state the transaction type (e.g., buy/sell), whether shares were acquired or disposed, or the exact number of shares and price in a labeled manner.","No prior known state is provided in the prompt, so 'what changed vs prior' cannot be determined from the given text alone.","The excerpt does not include the full Form 4 table/footnotes needed to interpret fields like 'A', '5205 D', and '913' unambiguously.","No guidance or financial implication is explicitly disclosed in the provided text beyond the existence of the Form 4 filing."],"key_facts":["SEC accession number: 0001193125-26-145921.","Form type: 4 (Form 4).","Issuer: Tejon Ranch Co (TRC).","Conformed period of report and filed as of date: 2026-04-07.","Reporting owner: Kenneth Yee (CIK 0001704070).","The filing includes a line referencing Tejon Ranch Co. Common Stock and a date of 2026-04-07.","The filing text includes numeric fields (e.g., '913', '18.84', 'A', '5205 D') but the provided excerpt does not clearly label them as shares, price, or transaction type in plain language."],"numeric_claims":[{"label":"Accession number (numeric portion)","value":"0001193125-26-145921"},{"label":"Conformed period of report / filed as of date","value":"2026-04-07"},{"label":"Reporting owner CIK","value":"0001704070"},{"label":"Common stock-related numeric field (unlabeled in excerpt)","value":"913"},{"label":"Unlabeled numeric field (unlabeled in excerpt)","value":"18.84"},{"label":"Unlabeled numeric field (unlabeled in excerpt)","value":"5205"}],"primary_claim":"A Form 4 was filed by Tejon Ranch Co on 2026-04-07 for reporting owner Kenneth Yee (CIK 0001704070).","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"Tejon Ranch Co (TRC) filed a Form 4 on 2026-04-07 disclosing an ownership transaction by reporting owner Kenneth Yee. The provided text includes the filing metadata and some transaction-related fields, but does not clearly state the specific number of shares or transaction type in a human-readable way.","topics":["SEC filing","Form 4","insider ownership","reporting owner disclosure"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TEJON RANCH CO \u00b7 Filed 20260407","ticker":"TRC","tickers":["TRC"],"title":"TRC filed 4","url":"https://www.sec.gov/Archives/edgar/data/96869/0001193125-26-145921.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_38a36d99e513 in signals