SQLite Web: event_store.db

Update row sig_57da86b2c5f1 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/92108/0000092108-26-000009.txt","as_of":"2026-04-09T03:12:49.786272+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.txt","company":"SOUTHERN CALIFORNIA GAS CO","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_68e642addb3aeea8","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.txt","content_type":"text/plain","enriched_at":"2026-04-09T17:45:34.275467+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"socalgas-20260406","final_url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.txt","html_truncated":true,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.txt","source_event_id":"evt_da26afc06533","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"8-K","fp":"3c533b978c139f25","kind":"sec_filing","published_at":"20260408","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.86,"dates_mentioned":["2026-04-06","2026-04-08","2026-04-17","2026-04-18","2026-03-2025","2020-11","2026-10-01","2026-09-30"],"entities":[{"asset_class":"equity (issuer)","name":"Southern California Gas Company","relevance":"high","symbol":"","type":"issuer"},{"asset_class":"person","name":"Rodger R. Schwecke","relevance":"high","symbol":"","type":"person"},{"asset_class":"person","name":"Maryam S. Brown","relevance":"high","symbol":"","type":"person"},{"asset_class":"organization","name":"Sempra family of companies","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["The filing\u2019s SEC Item number is shown as Item 5.02, but no additional Item 5.02 exhibits or details beyond the provided text are included in the extracted content.","The signal indicates a \u201cfiled 20260408\u201d headline, but the provided text includes a cover-page \u201cDate of Report (Date of earliest event reported) April 6, 2026\u201d; the relationship between these dates is not further explained in the provided text.","No prior known state is included in the prompt, so the specific \u201cwhat changed vs prior known state\u201d cannot be determined from the provided information alone."],"key_facts":["Filing: Form 8-K (Current Report) filed for Southern California Gas Company.","Date of report / earliest event reported: April 6, 2026 (as stated on the cover page).","Board action: On April 8, 2026, the Board appointed Rodger R. Schwecke as president for SoCalGas on an interim basis, effective April 18, 2026.","Role retention: Mr. Schwecke will retain his current chief operating officer role alongside the president position until his previously reported retirement effective October 1, 2026.","Compensation: Mr. Schwecke will receive a cash lump sum payment of $150,000 payable on September 30, 2026, contingent on continued employment through that date.","Resignation notice: On April 6, 2026, Maryam S. Brown provided notice that she will resign as chief executive officer and president and as a member of the Board of Directors and all committees, effective April 17, 2026."],"numeric_claims":[{"label":"Interim president effective date","value":"2026-04-18"},{"label":"Brown resignation effective date","value":"2026-04-17"},{"label":"Schwecke retirement effective date","value":"2026-10-01"},{"label":"Schwecke lump sum payment","value":"150000"},{"label":"Payment payable date","value":"2026-09-30"},{"label":"Schwecke age","value":"65"}],"primary_claim":"SoCalGas appointed Rodger R. Schwecke as interim president effective April 18, 2026, while Maryam S. Brown resigned as CEO/president and board member effective April 17, 2026.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"Southern California Gas Company (SoCalGas) filed a Form 8-K reporting leadership changes. The board appointed Rodger R. Schwecke as interim president effective April 18, 2026, and disclosed Maryam S. Brown\u2019s resignation as CEO/president and board member effective April 17, 2026.","topics":["Form 8-K","leadership change","interim president appointment","CEO resignation","executive compensation","board of directors"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 8-K \u00b7 SOUTHERN CALIFORNIA GAS CO \u00b7 Filed 20260408","ticker":"SOCGP","tickers":["SOCGP"],"title":"SOCGP filed 8-K","url":"https://www.sec.gov/Archives/edgar/data/92108/0000092108-26-000009.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