Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_memory
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 39559 in events
seq
Primary key.
INTEGER
id
evt_1798224faef7
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-14T02:19:55.867861+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-14T02:04:49.876253+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:7ab85b3b255b32c6","evidence_event_ids":["evt_d2b5ee610ddb"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000143.txt","as_of":"2026-04-14T02:04:49.876253+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000143.txt","company":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000143.txt","article_chars":2258,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7634ec2882679d21","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000143.txt","content_type":"text/plain","enriched_at":"2026-04-14T02:19:55.867810+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1046179/0001046179-26-000143.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-000143.txt","source_event_id":"evt_d2b5ee610ddb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"06be174f2ef14384","kind":"sec_filing","published_at":"20260413","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2026-04-09","2026-04-13"],"entities":[{"asset_class":"equity","name":"TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD","relevance":"high","symbol":"2330.TW","type":"issuer"},{"asset_class":"person","name":"Chang Tzonz-Sheng","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":["The signal is labeled discovery_sec_filing_delta, but no prior known state or previous filing content is provided here, so the exact \u201cwhat changed vs prior\u201d cannot be determined from the supplied text.","The cleaned text does not clearly specify whether the 317638 figure is a purchase, sale, or other transaction type beyond the presence of \u201cD\u201d and \u201cI\u201d markers; the exact mapping of those markers to transaction types is not explicitly defined in the provided excerpt.","No explicit guidance/financial implication is stated in the provided text beyond the share transaction details."],"key_facts":["SEC filing: Form 4 (CONFORMED SUBMISSION TYPE: 4).","Issuer: TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD (TSM), ticker shown as 2330.TW in the text.","Reporting owner: Chang Tzonz-Sheng (CENTRAL INDEX KEY: 0002113710).","Conformed period of report: 20260409; filed as of date: 20260413.","Transaction disclosure includes: \u201cCommon Shares (2330.TW) 317638 D\u201d and \u201cCommon Shares (2330.TW) 10581 I By ESPP Trust\u201d.","Text states the price was translated from the average purchase price of NT$1,837.2789 at the rate of NT$31.748 to US$1.","Footnote language indicates shares purchased and held under the issuer\u2019s ESPP and that the filer has obtained investment control over shares held under an LTI trust arrangement."],"numeric_claims":[{"label":"Conformed period of report","value":"20260409"},{"label":"Filed as of date","value":"20260413"},{"label":"Common shares (ESPP trust)","value":"10581"},{"label":"Common shares (shown as 317638)","value":"317638"},{"label":"Average purchase price (NT$)","value":"1,837.2789"},{"label":"FX rate (NT$ per US$)","value":"31.748"}],"primary_claim":"Form 4 for TAIWAN SEMICONDUCTOR MANUFACTURING CO LTD was filed on 2026-04-13 (period of report 2026-04-09) by reporting owner Chang Tzonz-Sheng, disclosing common share transactions under the issuer\u2019s ESPP/LTI trust arrangements.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Taiwan Semiconductor Manufacturing Co. Ltd. (TSM) filed a Form 4 on 2026-04-13 covering purchases of common shares by reporting owner Chang Tzonz-Sheng under employee stock plans. The filing period is 2026-04-09.","topics":["SEC Form 4","insider/employee plan share purchases","ESPP","LTI trust","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-000143.txt"}}
TEXT NOT NULL
source_ref
candidate:sc_7634ec2882679d21
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_sec_filing_delta:7ab85b3b255b32c6
TEXT
episode_id
NULL
TEXT
created_at
2026-04-14T02:19:55.867935+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel