SQLite Web: event_store.db

Update row 3047 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-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:3fc058325b7b8843","evidence_event_ids":["evt_4f13733478ab"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000134.txt","as_of":"2026-04-08T19:57:42.365437+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-09T01:37:59.726053+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_4f13733478ab","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 Form 4 transaction details (e.g., number of shares, security title, transaction type, or price).","No prior known state is included in the prompt, so the exact delta versus prior filings cannot be determined beyond the retirement/Section 16 status statement.","The filing\u2019s XML/transaction table contents are not present in the cleaned text excerpt, limiting extraction of financial implications."],"key_facts":["SEC filing type: Form 4.","Issuer: TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD.","Filed as of date: 2026-04-07; conformed period of report: 20260404.","Reporting person: Ho Li-Mei (central index key 0002113691).","The filing includes the statement: \u201cThe Reporting Person retired on April 4, 2026, and is no longer subject to Section 16.\u201d","Signature line shows \u201c/s/ Jen-Chau Huang, as attorney-in-fact\u201d 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 filed on 2026-04-07 reports that 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 2026-04-07 covering transactions/ownership reporting for reporting person Ho Li-Mei. The filing states that the reporting person retired on April 4, 2026 and is no longer subject to Section 16.","topics":["SEC Form 4","Section 16 status","reporting person retirement","insider reporting"]},"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

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