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/1898766/0001493152-26-015915.txt","as_of":"2026-04-10T03:04:31.796915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.txt","company":"Trio Petroleum Corp","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.txt","article_chars":1734,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_589bbc3804a85217","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.txt","content_type":"text/plain","enriched_at":"2026-04-10T03:23:14.197875+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.txt","source_event_id":"evt_c927b6bc34ab","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"8b887cfa5d2bdeb2","kind":"sec_filing","published_at":"20260409","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-08","2026-04-09","2026-04-10T03:04:31.796915+00:00","20211213"],"entities":[{"asset_class":"equity","name":"Trio Petroleum Corp","relevance":"high","symbol":"TPET","type":"issuer"},{"asset_class":"equity","name":"Ross Robin A.","relevance":"high","symbol":"","type":"reporting_owner"}],"event_type":"listing","information_gaps":["No explicit number of shares sold is clearly captured in the provided cleaned text (only fragments like '25000' and '662500' appear without clear mapping).","No prior known state is included in the prompt, so the 'delta vs prior' change cannot be determined from the provided information.","No details are provided on whether the transaction was a sale of common stock specifically beyond the line 'Common Stock' and the transaction purpose/average price."],"key_facts":["SEC accession number: 0001493152-26-015915.","Conformed submission type: Form 4.","Conformed period of report: 20260408; filed as of date: 20260409.","Issuer company name: Trio Petroleum Corp; issuer ticker indicated as TPET in the cleaned text.","Reporting owner: Ross Robin A.; title shown as Chief Executive Officer.","The purpose of the sale is stated as: to cover taxes with respect to the issuance of restricted stock to Mr. Ross in 2025.","The filing states shares were sold at an average price of $0.5424.","The filing notes: a full breakdown of prices for all shares sold will be provided at the request of the SEC."],"numeric_claims":[{"label":"Average sale price (USD)","value":"0.5424"},{"label":"Conformed period of report","value":"20260408"},{"label":"Filed as of date","value":"20260409"}],"primary_claim":"A Form 4 was filed by Trio Petroleum Corp on 2026-04-09 (covering period 2026-04-08) reporting that Ross Robin A. sold shares to cover taxes for restricted stock issued in 2025.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Trio Petroleum Corp (TPET) filed a Form 4 on 2026-04-09 covering a transaction by reporting owner Ross Robin A. The filing states the sale was to cover taxes related to restricted stock issued to Mr. Ross in 2025.","topics":["SEC Form 4","insider transaction","restricted stock","tax withholding"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Trio Petroleum Corp \u00b7 Filed 20260409","ticker":"TPET","tickers":["TPET"],"title":"TPET filed 4","url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-015915.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_dde50ef72b07 in signals