Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 13903 in events
seq
Primary key.
INTEGER
id
evt_39fddd16d28d
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T03:35:58.774996+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-10T03:04:31.796915+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:ce499569580f5215","evidence_event_ids":["evt_09f26c48077e"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","as_of":"2026-04-10T03:04:31.796915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","company":"Virgin Galactic Holdings, Inc","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","article_chars":3749,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9ea7b591345a1e27","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","content_type":"text/plain","enriched_at":"2026-04-10T03:35:58.774962+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt","source_event_id":"evt_09f26c48077e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"1c50c6d9b3572c53","kind":"sec_filing","published_at":"20260409","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2026-04-09","2026-04-07","2026-03-20","2025-03-20","2024-03-16","2023-03-16","2024-06-16","2022-03-16","20191025","20170517"],"entities":[{"asset_class":"equity","name":"Virgin Galactic Holdings, Inc","relevance":"high","symbol":"SPCE","type":"issuer"},{"asset_class":"person","name":"Douglas T. Ahrens","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"person","name":"Ahrens Douglas T","relevance":"medium","symbol":"","type":"reporting_owner_name_variant"}],"event_type":"other","information_gaps":["The signal is labeled as a 'delta' but no prior known state is provided in the prompt, so the 'what changed vs prior' cannot be determined from the given text alone.","The cleaned text includes multiple line items with quantities/transaction codes, but the prompt does not provide a mapping of each numeric line item to specific transaction types (e.g., buy/sell/withhold) beyond the narrative explanations.","No explicit statement of net shares acquired/disposed is provided in the extracted text; only partial numeric fragments and narrative descriptions are present."],"key_facts":["SEC accession number: 0001589800-26-000006; Form type: 4; filed as of date: 2026-04-09; conform ed period of report: 2026-04-07.","Reporting owner: Douglas T. Ahrens; title shown as Chief Financial Officer.","Issuer: Virgin Galactic Holdings, Inc (SPCE).","The filing includes common stock and restricted stock units (RSUs) entries tied to dates including 2026-04-07 and grant/vesting references in the explanatory text.","The filing states RSUs convert into common stock on a one-for-one basis.","The filing states shares may be settled in shares or, at the issuer\u2019s discretion, in cash upon vesting.","The filing includes descriptions that shares were withheld to cover the reporting person\u2019s tax withholding obligation upon annual/quarterly vesting of RSUs granted on March 20, 2025; March 16, 2023; and March 16, 2022.","The filing states an RSU grant on March 20, 2025 vests 1/3 on March 20, 2026 and thereafter 1/3 on the second anniversary and 1/3 on the third anniversary, subject to continued service.","The filing states an RSU grant on March 16, 2023 vested 25% on March 16, 2024 and the remaining 75% vests in 12 quarterly installments beginning June 16, 2024, subject to continued service."],"numeric_claims":[{"label":"Conformed period of report","value":"2026-04-07"},{"label":"Filed as of date","value":"2026-04-09"},{"label":"RSU vesting (March 20, 2025 grant)","value":"1/3 on 2026-03-20; then 1/3 on 2nd anniversary; 1/3 on 3rd anniversary (per text)"}],"primary_claim":"On 2026-04-09, Virgin Galactic Holdings, Inc filed Form 4 reporting transactions/holdings by CFO Douglas T. Ahrens involving common stock and RSUs with vesting and tax-withholding share withholding described in the filing.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Virgin Galactic Holdings, Inc filed a Form 4 on 2026-04-09 for reporting-owner Douglas T. Ahrens (Chief Financial Officer). The filing relates to restricted stock units (RSUs) and shares withheld/transactions tied to RSU vesting and unvested RSU holdings as of 2026-04-07.","topics":["SEC Form 4","insider transactions","restricted stock units (RSUs)","common stock","tax withholding upon vesting","vesting schedules"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Virgin Galactic Holdings, Inc \u00b7 Filed 20260409","ticker":"SPCE","tickers":["SPCE"],"title":"SPCE filed 4","url":"https://www.sec.gov/Archives/edgar/data/1706946/0001589800-26-000006.txt"}}
TEXT NOT NULL
source_ref
candidate:sc_9ea7b591345a1e27
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_sec_filing_delta:ce499569580f5215
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T03:35:58.775046+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel