SQLite Web: event_store.db

Update row 46822 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-15T02:18:53.247056+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:71cc1f16908758a1","evidence_event_ids":["evt_835e84739192"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.txt","as_of":"2026-04-15T02:18:53.247056+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.txt","company":"SPRUCE POWER HOLDING CORP","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9f733c388bd17105","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.txt","content_type":"text/plain","enriched_at":"2026-04-15T06:47:06.163751+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.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-000987.txt","source_event_id":"evt_835e84739192","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"42446b47450d0672","kind":"sec_filing","published_at":"20260414","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-10","2026-04-14","2010-06-24","2018-02-28","2008-09-29","1999-01-08","1992-07-03","2008-12-29","2026-04-15T02:18:53.247056+00:00"],"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 text provided does not include the Form 4 transaction table(s) (e.g., number of shares, price, security title, transaction type, or ownership after transaction).","No prior known state is included in the prompt, so the specific 'delta' versus prior filings cannot be determined from the provided text alone.","The signal headline says 'SPRU filed 4', but the provided text only confirms the issuer name and Form type; it does not explicitly state the ticker symbol 'SPRU' within the filing text excerpt."],"key_facts":["SEC accession number: 0000921895-26-000987.","Conformed submission type: Form 4.","Conformed period of report: 20260410.","Filed as of date: 20260414 (date of change: 20260414).","Issuer: Spruce Power Holding Corp (Central Index Key: 0001772720; EIN: 834109918).","Public document count: 1."],"numeric_claims":[{"label":"conformed_period_of_report","value":"20260410"},{"label":"filed_as_of_date","value":"20260414"},{"label":"accession_number","value":"0000921895-26-000987"}],"primary_claim":"A Form 4 was filed for Spruce Power Holding Corp with a conformed period of report of 2026-04-10 and filed as of 2026-04-14 (accession 0000921895-26-000987).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Spruce Power Holding Corp (SPRU) filed a Form 4 on 2026-04-14 covering the reporting period ending 2026-04-10. The provided text contains filing metadata and reporting-owner identities but does not include the specific insider transaction details.","topics":["SEC filing","Form 4","insider/reporting owner disclosure","Spruce Power Holding Corp"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 SPRUCE POWER HOLDING CORP \u00b7 Filed 20260414","ticker":"SPRU","tickers":["SPRU"],"title":"SPRU filed 4","url":"https://www.sec.gov/Archives/edgar/data/1772720/0000921895-26-000987.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