SQLite Web: event_store.db

Update row 39557 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-14T02:04:49.876253+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:dacb27f5749feff0","evidence_event_ids":["evt_1b967d5f816f"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.txt","as_of":"2026-04-14T02:04:49.876253+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.txt","company":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.txt","article_chars":2279,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_56f65798d33bbc34","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.txt","content_type":"text/plain","enriched_at":"2026-04-14T02:19:48.345401+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.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-000142.txt","source_event_id":"evt_1b967d5f816f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"a8e16a45865d731d","kind":"sec_filing","published_at":"20260413","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-13","2026-04-09"],"entities":[{"asset_class":"equity","name":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","relevance":"high","symbol":"2330.TW","type":"issuer"},{"asset_class":"person","name":"Cao Min","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"other","name":"Employee Stock Purchase Plan (ESPP) Trust","relevance":"medium","symbol":"","type":"plan_trust"},{"asset_class":"other","name":"Long-Term Incentive (LTI) Bonus Plan","relevance":"medium","symbol":"","type":"plan"}],"event_type":"listing","information_gaps":["What changed vs prior known state is not provided in the signal; no prior filing details are included to compare deltas.","The excerpt does not clearly label each quantity (e.g., 507879, 10581, 34470) with the corresponding transaction row/footnote in a fully parseable way.","The excerpt does not provide the full Form 4 table fields (e.g., exact transaction dates per row, transaction codes, and whether shares were acquired/sold) beyond the narrative snippets shown.","No explicit statement of whether this is a net purchase/sale or the transaction code(s) is included in the provided text beyond the narrative descriptions."],"key_facts":["SEC filing type: Form 4 (CONFORMED SUBMISSION TYPE: 4).","Issuer: TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD (SEC CIK/Central Index Key shown in text).","Filing date (filed as of date): 2026-04-13; conform ed period of report: 2026-04-09.","Reporting owner: Cao Min.","Security: Common Shares (2330.TW) is explicitly shown in the filing text.","The filing includes a line stating: \u201cCommon Shares purchased and held under the issuer's Employee Stock Purchase Plan (\"ESPP\").\u201d","The filing includes a line stating: \u201cRepresents Common Shares purchased by a trust with cash received under the issuer's Long-Term Incentive (\"LTI\") Bonus Plan, over which the filer has obtained investment control.\u201d","The filing text includes a purchase price translation statement: \u201cThe price was translated from the average purchase price of NT$1,837.2789 in New Taiwan dollars, at the rate of NT$31.748 to US$1.\u201d","The filing text includes quantities associated with common shares (as shown): 507879, 10581, 34470, and \u201cBy Spouse\u201d language is present, but the exact mapping of each quantity to each transaction type is not fully structured in the provided excerpt."],"numeric_claims":[{"label":"ESPP/LTI-related common shares quantity (as shown)","value":"507879"},{"label":"Additional common shares quantity (as shown)","value":"10581"},{"label":"Additional common shares quantity (as shown)","value":"34470"},{"label":"Average purchase price (NT$)","value":"1,837.2789"},{"label":"FX rate (NT$ per US$1)","value":"31.748"}],"primary_claim":"Form 4 for TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD was filed on 2026-04-13 (covering period 2026-04-09) by reporting person Cao Min, reporting common share transactions including ESPP and LTI trust-related purchases.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Taiwan Semiconductor Manufacturing Co. Ltd. (TSM) filed a Form 4 on 2026-04-13 reporting common share transactions for reporting person Cao Min, including purchases under the issuer\u2019s ESPP and LTI-related trust arrangements. The filing covers transactions with a reported purchase date of 2026-04-09 and includes a stated price translation from NT$ to US$.","topics":["SEC Form 4","insider transactions","ESPP","LTI trust","common shares","TSM 2330.TW"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD \u00b7 Filed 20260413","ticker":"TSMWF","tickers":["TSMWF"],"title":"TSMWF filed 4","url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000142.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