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/751365/0001628280-26-025054.txt","as_of":"2026-04-15T02:18:53.247056+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.txt","company":"VIRCO MFG CORPORATION","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.txt","article_chars":1317,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_70fa37c1c1166d75","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.txt","content_type":"text/plain","enriched_at":"2026-04-15T04:19:02.008853+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.txt","source_event_id":"evt_05c8872d66ce","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"b39cd795adfc474e","kind":"sec_filing","published_at":"20260414","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-14"],"entities":[{"asset_class":"equity","name":"VIRCO MFG CORPORATION","relevance":"high","symbol":"VIRC","type":"issuer"},{"asset_class":"person","name":"Robert A. Virtue","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"equity","name":"Common Stock (issuer)","relevance":"medium","symbol":"","type":"security"}],"event_type":"other","information_gaps":["The provided text does not explicitly state whether the reported transaction was a purchase or sale (transaction type not clearly labeled in the excerpt).","The meaning of the numeric fields (e.g., 700, 2000, 499824, 501824) is not explicitly explained in the excerpt (e.g., whether they represent shares transacted vs. post-transaction holdings).","No prior known state is included in the prompt, so the 'delta vs prior' change cannot be determined from the provided information."],"key_facts":["SEC accession number: 0001628280-26-025054.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-14.","Issuer: VIRCO MFG CORPORATION (CIK 0000751365).","Reporting owner: Robert A. Virtue (CIK 0001238433).","Reporting owner role shown: CEO.","Security shown: Common Stock, $0.01 par value.","Price shown in filing text: $6.22.","Filing date shown: 2026-04-14 (filed as of date: 20260414)."],"numeric_claims":[{"label":"Price per share (shown)","value":"6.22"},{"label":"Numeric quantity field (shown)","value":"700"},{"label":"Numeric quantity field (shown)","value":"2000"},{"label":"Numeric quantity field (shown)","value":"499824"},{"label":"Numeric quantity field (shown)","value":"501824"}],"primary_claim":"A Form 4 was filed by VIRCO MFG CORPORATION on 2026-04-14, with reporting owner Robert A. Virtue listed as CEO and associated with Common Stock transactions at $6.22.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"VIRCO MFG CORPORATION (VIRC) filed a Form 4 on 2026-04-14 reporting a transaction by reporting owner Robert A. Virtue. The filing text provided does not clearly state the transaction type (e.g., buy/sell) or the number of shares beyond the numeric fields shown.","topics":["SEC filing","Form 4","insider transaction","corporate insider","ownership reporting"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 VIRCO MFG CORPORATION \u00b7 Filed 20260414","ticker":"VIRC","tickers":["VIRC"],"title":"VIRC filed 4","url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-025054.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_34828ee08030 in signals