SQLite Web: event_store.db

Update row 22022 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-11T03:10:51.104915+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:fac57628c31cf4af","evidence_event_ids":["evt_7cc44263c77a"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.txt","as_of":"2026-04-11T03:10:51.104915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.txt","company":"SPRUCE POWER HOLDING CORP","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.txt","article_chars":1859,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d82e41f438345e14","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.txt","content_type":"text/plain","enriched_at":"2026-04-11T07:34:18.851773+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.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-042455.txt","source_event_id":"evt_7cc44263c77a","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"e37841e8163d655a","kind":"sec_filing","published_at":"20260410","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-03","2026-04-10","2023-04-05","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":"person","name":"Jonathan McWhinnie Norling","relevance":"high","symbol":"","type":"reporting_person"},{"asset_class":"equity","name":"Common Stock","relevance":"medium","symbol":"","type":"security"}],"event_type":"listing","information_gaps":["The cleaned text does not include the specific number of shares withheld or any remaining holdings change details beyond the tax-withholding/RSU vesting explanation.","No explicit \u201cchange vs prior known state\u201d quantities are provided in the provided text (e.g., prior Form 4 amounts are not included here).","The filing\u2019s table fields (e.g., transaction code, shares before/after) are not fully captured in the provided excerpt, so the exact transaction mechanics cannot be quantified."],"key_facts":["SEC filing type is Form 4.","Issuer: Spruce Power Holding Corp (SPRU).","Reporting person: Jonathan McWhinnie Norling.","Reporting person role shown as Chief Legal Officer.","Conformed period of report: 2026-04-03.","Filed as of date: 2026-04-10.","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 3, 2026.\u201d","The applicable RSUs were reported on a Form 4 filed April 5, 2023."],"numeric_claims":[{"label":"RSU vesting date","value":"2026-04-03"},{"label":"Form 4 filed date","value":"2026-04-10"},{"label":"Prior Form 4 date (RSUs reported)","value":"2023-04-05"}],"primary_claim":"The Form 4 (filed 2026-04-10) discloses that securities were withheld to pay tax withholding obligations tied to RSU vesting on 2026-04-03 by Jonathan McWhinnie Norling, an officer of SPRUCE POWER HOLDING CORP.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"Spruce Power Holding Corp (SPRU) filed a Form 4 on April 10, 2026 reporting an April 3, 2026 transaction by reporting person Jonathan McWhinnie Norling (Chief Legal Officer). The filing states that shares were withheld to cover the reporting person\u2019s tax withholding obligations related to the vesting of RSUs on April 3, 2026.","topics":["SEC Form 4","insider transaction","RSU vesting","tax withholding","officer reporting"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 SPRUCE POWER HOLDING CORP \u00b7 Filed 20260410","ticker":"SPRU","tickers":["SPRU"],"title":"SPRU filed 4","url":"https://www.sec.gov/Archives/edgar/data/1772720/0001213900-26-042455.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