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/1046179/0001046179-26-000134.txt","as_of":"2026-04-08T02:28:02.401723+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","company":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","article_chars":1607,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_27716c21a0c2fabc","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","content_type":"text/plain","enriched_at":"2026-04-08T03:17:18.077807+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","source_event_id":"evt_00c52211f7d5","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"a1466ad4fcfffbf3","kind":"sec_filing","published_at":"20260407","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-07","2026-04-04"],"entities":[{"asset_class":"equity","name":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","relevance":"high","symbol":"2330.TW","type":"issuer"},{"asset_class":"person","name":"Ho Li-Mei","relevance":"high","symbol":"","type":"reporting_person"},{"asset_class":"person","name":"Jen-Chau Huang","relevance":"medium","symbol":"","type":"attorney_in_fact"}],"event_type":"listing","information_gaps":["The provided text does not include the specific transaction details (e.g., number of shares, transaction type, price) typically found in Form 4 tables.","The text does not show whether any securities were acquired/disposed beyond the retirement/Section 16 status statement.","No prior known state is included in the prompt, so the exact delta versus prior filings cannot be determined from the provided excerpt."],"key_facts":["SEC filing is Form 4 (CONFORMED SUBMISSION TYPE: 4).","Issuer: TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD (SEC CIK/Central Index Key shown as 0001046179).","Reporting person: Ho Li-Mei (CIK shown as 0002113691).","Conformed period of report: 20260404; filed as of date: 20260407.","The filing includes the statement: \"The Reporting Person retired on April 4, 2026, and is no longer subject to Section 16.\"","Signature line shows: \"/s/ Jen-Chau Huang, as attorney-in-fact\" dated 2026-04-07."],"numeric_claims":[{"label":"Form 4 filed as of date","value":"2026-04-07"},{"label":"Conformed period of report","value":"2026-04-04"},{"label":"Retirement date (Section 16 status change)","value":"2026-04-04"}],"primary_claim":"The Form 4 states that reporting person Ho Li-Mei retired on April 4, 2026 and is no longer subject to Section 16.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"Taiwan Semiconductor Manufacturing Co. Ltd. (TSM) filed a Form 4 on April 7, 2026 covering transactions/ownership reporting for reporting person Ho Li-Mei, with a note that the reporting person retired on April 4, 2026 and is no longer subject to Section 16.","topics":["SEC Form 4","Section 16 retirement","insider reporting","TSM"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD \u00b7 Filed 20260407","ticker":"TSMWF","tickers":["TSMWF"],"title":"TSMWF filed 4","url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.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_51248720e800 in signals