SQLite Web: event_store.db

Update row sig_4fa3c46bf80b in signals

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/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

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')

Cancel