SQLite Web: event_store.db

Update row 1153 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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:a18d500734d44c7c","evidence_event_ids":["evt_9d195d86180d"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","company":"SPRUCE POWER HOLDING CORP","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","article_chars":1861,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_182670d6022dba7f","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","content_type":"text/plain","enriched_at":"2026-04-07T23:47:52.016056+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.txt","source_event_id":"evt_9d195d86180d","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"d32a5773350af10f","kind":"sec_filing","published_at":"20260406","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-01","2026-04-06","2025-03-21","2023-01-25","2020-12-23","2019-04-03"],"entities":[{"asset_class":"equity","name":"SPRUCE POWER HOLDING CORP","relevance":"high","symbol":"SPRU","type":"issuer"},{"asset_class":"","name":"Jonathan McWhinnie Norling","relevance":"high","symbol":"","type":"reporting_person"},{"asset_class":"equity","name":"Common Stock","relevance":"medium","symbol":"","type":"security"}],"event_type":"other","information_gaps":["The cleaned text does not include the specific number of shares withheld or any other transaction quantities/prices beyond the withholding-for-tax statement.","No explicit \u201cchange vs prior known state\u201d details are provided in the text beyond referencing that the RSUs were reported on a Form 4 filed March 21, 2025.","The filing\u2019s specific transaction table fields (e.g., shares, transaction code) are not shown in the provided excerpt."],"key_facts":["SEC filing is Form 4 for SPRUCE POWER HOLDING CORP (SPRU).","Reporting person: Jonathan McWhinnie Norling (listed as Chief Legal Officer).","Conformed period of report: 2026-04-01; filed as of date: 2026-04-06.","The filing states: \u201cThe securities were withheld to pay the reporting person's tax withholding obligations with respect to the vesting of restricted stock units (RSUs) on April 1, 2026.\u201d","The applicable RSUs were reported on a prior Form 4 filed March 21, 2025."],"numeric_claims":[{"label":"RSU vesting date","value":"2026-04-01"},{"label":"Form 4 filed date","value":"2026-04-06"},{"label":"Prior Form 4 filed date (RSUs reported)","value":"2025-03-21"},{"label":"SEC accession number","value":"0001213900-26-040187"},{"label":"SEC file number","value":"001-38971"}],"primary_claim":"The Form 4 (filed 2026-04-06) by Jonathan McWhinnie Norling for SPRUCE POWER HOLDING CORP indicates securities were withheld to pay tax withholding obligations for RSUs vesting on April 1, 2026.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"SPRUCE POWER HOLDING CORP (SPRU) reported a Form 4 filed on 2026-04-06 by reporting person Jonathan McWhinnie Norling. The filing states shares were withheld to cover tax withholding obligations related to RSU vesting on 2026-04-01.","topics":["SEC Form 4","insider transaction","RSU vesting","tax withholding","share withholding"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 SPRUCE POWER HOLDING CORP \u00b7 Filed 20260406","ticker":"SPRU","tickers":["SPRU"],"title":"SPRU filed 4","url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-040187.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