SQLite Web: event_store.db

Update row 39494 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-14T02:04:49.876253+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:3ec31d2367d18b88","evidence_event_ids":["evt_c457c789ff78"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.txt","as_of":"2026-04-14T02:04:49.876253+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.txt","company":"VIRCO MFG CORPORATION","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.txt","article_chars":1252,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_22813b6a1640008a","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.txt","content_type":"text/plain","enriched_at":"2026-04-14T02:15:04.056265+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.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-024904.txt","source_event_id":"evt_c457c789ff78","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"cb4abe9375e04500","kind":"sec_filing","published_at":"20260413","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-13","2026-04-10","2026-04-14T02:04:49.876253+00:00"],"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 ($.01 par value)","relevance":"medium","symbol":"","type":"security"}],"event_type":"listing","information_gaps":["The cleaned text does not clearly state the transaction type (e.g., buy/sell), number of shares, or transaction price in a human-readable way.","No explicit \u201cwhat changed vs prior known state\u201d is provided in the signal; only the new filing metadata is shown.","The \u201cmaterial_items\u201d field is empty, and the extracted text does not enumerate specific Form 4 table entries beyond fragmented XML-like fields."],"key_facts":["SEC accession number: 0001628280-26-024904.","Conformed submission type: Form 4.","Conformed period of report: 20260410.","Filed as of date: 20260413.","Issuer: VIRCO MFG CORPORATION (CIK 0000751365).","Reporting owner: Robert A. Virtue (CIK 0001238433).","Reporting owner role shown as: CEO.","Security shown as: Common Stock, $.01 par value.","Business address listed for issuer: 2027 Harpers Way, Torrance, CA 90501."],"numeric_claims":[{"label":"Form 4 filed as of date","value":"2026-04-13"},{"label":"Conformed period of report","value":"2026-04-10"},{"label":"Issuer CIK","value":"0000751365"},{"label":"Reporting owner CIK","value":"0001238433"}],"primary_claim":"VIRCO MFG CORPORATION filed Form 4 (accession 0001628280-26-024904) on 2026-04-13 for a period ending 2026-04-10, with Robert A. Virtue as the reporting owner (CEO) and common stock as the security.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"VIRCO MFG CORPORATION (VIRC) filed a Form 4 on 2026-04-13 covering a transaction with a reporting owner (Robert A. Virtue) dated 2026-04-10. The provided text includes the filing metadata and some fields (e.g., CEO role and common stock details) but does not clearly show the transaction type or share/price amounts in a readable way.","topics":["SEC filing","Form 4","insider transaction","corporate insider","VIRCO MFG CORPORATION"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 VIRCO MFG CORPORATION \u00b7 Filed 20260413","ticker":"VIRC","tickers":["VIRC"],"title":"VIRC filed 4","url":"https://www.sec.gov/Archives/edgar/data/751365/0001628280-26-024904.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