SQLite Web: event_store.db

Update row 13852 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-10T03:04:31.796915+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:78b5cc9a7ce50ff7","evidence_event_ids":["evt_ed061e8d73ec"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.txt","as_of":"2026-04-10T03:04:31.796915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.txt","company":"SPRUCE POWER HOLDING CORP","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e9cd07172dd89ccb","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.txt","content_type":"text/plain","enriched_at":"2026-04-10T03:32:26.393755+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.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/0000921895-26-000952.txt","source_event_id":"evt_ed061e8d73ec","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"a03e11bbcf10458d","kind":"sec_filing","published_at":"20260409","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-07","2026-04-09","2026-04-10"],"entities":[{"asset_class":"equity","name":"SPRUCE POWER HOLDING CORP","relevance":"high","symbol":"SPRU","type":"issuer"},{"asset_class":"unknown","name":"Steel Excel Inc.","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"Steel Connect LLC","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"STEEL PARTNERS HOLDINGS L.P.","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"Steel Connect Sub LLC","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"SPH Group LLC","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"Steel Partners Holdings GP Inc.","relevance":"medium","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"SPH Group Holdings LLC","relevance":"medium","symbol":"","type":"reporting_owner"}],"event_type":"listing","information_gaps":["The provided text does not include the Form 4 transaction table/details (e.g., number of shares, price, transaction type, or whether it is an acquisition/disposition).","No prior known state is included in the prompt, so the 'what changed vs prior' portion cannot be determined from the provided text alone.","The signal headline says 'SPRU filed 4', but the extracted text only confirms the issuer Form 4 metadata; it does not explicitly state the ticker 'SPRU' within the provided excerpt."],"key_facts":["SEC accession number: 0000921895-26-000952 (from provided text).","Conformed submission type: 4.","Conformed period of report: 20260407.","Filed as of date: 20260409.","Issuer: SPRUCE POWER HOLDING CORP (Central Index Key: 0001772720).","Issuer business address: 820 Gessner Road, Suite 500, Houston, TX 77024 (from provided text).","Multiple reporting owners are listed in the provided text (e.g., Steel Excel Inc., Steel Connect LLC, STEEL PARTNERS HOLDINGS L.P., Steel Connect Sub LLC, SPH Group LLC, Steel Partners Holdings GP Inc., SPH Group Holdings LLC)."],"numeric_claims":[{"label":"conformed_period_of_report","value":"20260407"},{"label":"filed_as_of_date","value":"20260409"},{"label":"accession_number_suffix","value":"000952"}],"primary_claim":"A Form 4 was filed for SPRUCE POWER HOLDING CORP with a filing date of 2026-04-09 and a conformed period of report of 2026-04-07.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"SPRUCE POWER HOLDING CORP (SPRU) filed a Form 4 on 2026-04-09 covering the reporting period 2026-04-07. The provided text contains filing/issuer metadata but does not include the actual insider transaction details.","topics":["SEC filing","Form 4","insider/reporting owners","issuer metadata"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 SPRUCE POWER HOLDING CORP \u00b7 Filed 20260409","ticker":"SPRU","tickers":["SPRU"],"title":"SPRU filed 4","url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000952.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