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/732026/0001247601-26-000008.txt","as_of":"2026-04-11T03:10:51.104915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000008.txt","company":"TRIO-TECH INTERNATIONAL","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000008.txt","article_chars":1529,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_30a76599ddfbf499","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000008.txt","content_type":"text/plain","enriched_at":"2026-04-11T06:07:42.836627+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000008.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-000008.txt","source_event_id":"evt_499a8f62733d","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"659b9ab5600f0467","kind":"sec_filing","published_at":"20260410","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-09","2026-04-10","2026-04-11T03:10:51.104915+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":"listing","information_gaps":["The provided text does not explicitly state the transaction type (e.g., buy/sell/option exercise) or whether the 4 shares represent a purchase, sale, or other action.","The currency for the 6.78 price is not specified.","No prior known state is included in the prompt, so the 'delta vs prior' change cannot be determined from the provided text alone.","No additional Form 4 table fields (e.g., remaining shares, ownership after transaction, nature of ownership) are shown in the excerpt."],"key_facts":["SEC accession number: 0001247601-26-000008.","Conformed submission type: 4 (Form 4).","Conformed period of report: 20260409; filed as of date: 20260410.","Reporting owner: Ting Hock Ming (CIK 0001247601).","Issuer: TRIO-TECH INTERNATIONAL (CIK 0000732026).","Security referenced: TRT Common Stock.","Transaction date shown: 2026-04-09.","Quantity shown: 4 shares.","Price shown: 6.78 (currency not specified in provided text).","Signature line: /s/ Ting Hock Ming; date: 2026-04-10."],"numeric_claims":[{"label":"shares","value":"4"},{"label":"price_per_share","value":"6.78"}],"primary_claim":"A Form 4 was filed by TRIO-TECH INTERNATIONAL on 2026-04-10 for a transaction dated 2026-04-09 involving TRT Common Stock at $6.78 per share for 4 shares.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"TRIO-TECH INTERNATIONAL (TRT) filed a Form 4 on 2026-04-10 covering a transaction dated 2026-04-09 by reporting owner Ting Hock Ming. The filing indicates 4 shares of TRT Common Stock were involved at a price of 6.78 (currency not specified).","topics":["SEC filing","Form 4","insider transaction","TRIO-TECH INTERNATIONAL","TRT Common Stock"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TRIO-TECH INTERNATIONAL \u00b7 Filed 20260410","ticker":"TRT","tickers":["TRT"],"title":"TRT filed 4","url":"https://www.sec.gov/Archives/edgar/data/732026/0001247601-26-000008.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_fba83f3a7784 in signals