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-016793.txt","as_of":"2026-04-16T02:08:52.472606+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-016793.txt","company":"Trio Petroleum Corp","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-016793.txt","article_chars":1682,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b3a714d51f1334c3","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-016793.txt","content_type":"text/plain","enriched_at":"2026-04-16T02:29:59.884679+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-016793.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-016793.txt","source_event_id":"evt_ce155b080a07","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"6b220a20b547a280","kind":"sec_filing","published_at":"20260415","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-14","2026-04-15","2026-04-16T02:08:52.472606+00:00","2025 (restricted stock issuance year referenced)","2021-12-13 (name change referenced)"],"entities":[{"asset_class":"equity","name":"Trio Petroleum Corp","relevance":"high","symbol":"TPET","type":"issuer"},{"asset_class":"person","name":"Thomas J. Pernice","relevance":"high","symbol":"","type":"reporting-owner"}],"event_type":"listing","information_gaps":["The cleaned text does not explicitly state the number of shares sold (only partial numeric fields appear, but not clearly labeled as share quantity).","No prior known state is provided in the signal, so the 'what changed vs prior' component cannot be determined from the provided text alone.","The filing excerpt does not include whether the transaction was a sale under Rule 10b5-1 or other plan details.","No post-transaction holdings figures are shown in the provided text excerpt."],"key_facts":["SEC filing: Form 4 (conformed submission type: 4).","Issuer: Trio Petroleum Corp (TPET).","Reporting owner: Thomas J. Pernice (central index key 0001193534).","Conformed period of report / transaction date shown: 2026-04-14.","Filed as of date: 2026-04-15 (accession number 0001493152-26-016793).","The purpose of the sale is stated as: to cover taxes with respect to the issuance of restricted stock to Mr. Pernice in 2025.","The filing states shares were sold at an average of $0.4952.","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 ($)","value":"0.4952"},{"label":"Transaction date (YYYY-MM-DD)","value":"2026-04-14"},{"label":"Filing date (YYYY-MM-DD)","value":"2026-04-15"}],"primary_claim":"A Form 4 was filed for Trio Petroleum Corp on 2026-04-15 showing reporting-owner Thomas J. Pernice sold shares on 2026-04-14 to cover taxes for restricted stock issued in 2025.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Trio Petroleum Corp (TPET) reported a Form 4 filed on 2026-04-15 for reporting-owner Thomas J. Pernice, covering a sale of shares on 2026-04-14. The filing states the purpose of the sale was to cover taxes related to restricted stock issued in 2025.","topics":["SEC Form 4","insider transaction","restricted stock","tax withholding","share sale"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Trio Petroleum Corp \u00b7 Filed 20260415","ticker":"TPET","tickers":["TPET"],"title":"TPET filed 4","url":"https://www.sec.gov/Archives/edgar/data/1898766/0001493152-26-016793.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_f160b7f24cea in signals