SQLite Web: event_store.db

Update row 478498 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-22T03:03:32.063787+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:7abcf60449de30b0","evidence_event_ids":["evt_5d372e8c435f"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","as_of":"2026-04-22T03:03:32.063787+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","company":"TRIO-TECH INTERNATIONAL","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","article_chars":1584,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e24fe8cb19df9cae","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","content_type":"text/plain","enriched_at":"2026-04-22T03:18:13.312809+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.txt","source_event_id":"evt_5d372e8c435f","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"a41d6b5caabe83dd","kind":"sec_filing","published_at":"20260421","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-17","2026-04-20","2026-04-21","2026-04-22T03:03:32.063787+00:00","2003-06-25","1992-07-03"],"entities":[{"asset_class":"equity","name":"TRIO-TECH INTERNATIONAL","relevance":"high","symbol":"TRT","type":"issuer"},{"asset_class":"person","name":"Ting Hock Ming","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"equity","name":"TRT Common Stock","relevance":"high","symbol":"TRT","type":"security"}],"event_type":"other","information_gaps":["The cleaned text does not explicitly state whether the transactions were purchases, sales, or other transaction types (the 'D'/'S' markers are present but not fully interpretable from the provided excerpt).","No explicit total shares owned after the transactions are shown in the provided text.","No explicit Form 4 table headings (e.g., transaction code, nature of ownership, or whether shares were acquired/disposed) are included in the excerpt.","The signal mentions 'TRT filed 4' but the prior known state and what changed vs prior filings are not provided, so the delta cannot be determined from this input alone."],"key_facts":["SEC accession number: 0001247601-26-000014 (conformed submission type: 4).","Conformed period of report: 20260417; filed as of date: 20260421; date of change: 20260421.","Reporting owner: Ting Hock Ming (central index key: 0001247601).","Issuer: TRIO-TECH INTERNATIONAL (central index key: 0000732026; standard industrial classification: 3559).","Security referenced: TRT Common Stock.","Two transaction rows appear in the cleaned text for TRT Common Stock with dates 2026-04-17 and 2026-04-20, including quantities and prices (see numeric_claims)."],"numeric_claims":[{"label":"Transaction date (row 1)","value":"2026-04-17"},{"label":"Quantity (row 1)","value":"3800"},{"label":"Price (row 1)","value":"7.08"},{"label":"Transaction date (row 2)","value":"2026-04-20"},{"label":"Quantity (row 2)","value":"2000"},{"label":"Price (row 2)","value":"7.13"}],"primary_claim":"A Form 4 (SEC filing type 4) for TRIO-TECH INTERNATIONAL was filed on 2026-04-21 by reporting owner Ting Hock Ming, with transactions in TRT Common Stock dated 2026-04-17 and 2026-04-20.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"TRIO-TECH INTERNATIONAL (TRT) filed a Form 4 on 2026-04-21 covering transactions by reporting owner Ting Hock Ming for the period ended 2026-04-17.","topics":["SEC Form 4","insider transaction","TRT Common Stock"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TRIO-TECH INTERNATIONAL \u00b7 Filed 20260421","ticker":"TRT","tickers":["TRT"],"title":"TRT filed 4","url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000014.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