SQLite Web: event_store.db

Update row 54719 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-16T02:08:52.472606+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:b2b67ab4cad8f849","evidence_event_ids":["evt_e4b37b74687c"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","as_of":"2026-04-16T02:08:52.472606+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","company":"SPINDLETOP OIL & GAS CO","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4b903ebf5ae6d77e","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","content_type":"text/plain","enriched_at":"2026-04-16T02:43:11.700346+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"Spindletop Oil and Gas","final_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","html_truncated":true,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.txt","source_event_id":"evt_e4b37b74687c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"10-K","fp":"de2ffda5f15b3e77","kind":"sec_filing","published_at":"20260415","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-16"],"entities":[{"asset_class":"equity","name":"Spindletop Oil & Gas Co.","relevance":"high","symbol":"SPND","type":"issuer"},{"asset_class":"other","name":"Spindletop Drilling Company (SDC)","relevance":"medium","symbol":"","type":"subsidiary"},{"asset_class":"other","name":"Prairie Pipeline Co. (PPC)","relevance":"medium","symbol":"","type":"subsidiary"},{"asset_class":"other","name":"U.S. Securities and Exchange Commission","relevance":"high","symbol":"","type":"regulator"}],"event_type":"listing","information_gaps":["The fiscal year ended date is not present in the provided text excerpt (the cover-page placeholder text is incomplete).","No financial statements, results, risk factors, or management discussion content is included in the provided excerpt, so no guidance/financial implications can be extracted.","No prior-known state or delta details are provided, so \u201cwhat changed vs prior\u201d cannot be determined from the supplied text alone.","The filing\u2019s checkmark selections (e.g., large accelerated filer/smaller reporting company, electronic filing, internal control attestation) are not fully interpretable because the excerpt contains placeholders and partial lines without the corresponding selected categories."],"key_facts":["The document is a Form 10-K filed by Spindletop Oil & Gas Co. (SPINDLETOP OIL & GAS CO).","The provided metadata indicates a filing_date of 2026-04-16T02:08:52.472606+00:00.","The cover page lists common stock with $0.01 par value as a security registered under Section 12(g) (as shown in the text).","The filing states Spindletop is an independent oil and gas company engaged in exploration, development, production, and acquisition of oil and natural gas.","The filing states that through a subsidiary it also rents oilfield equipment and gathers/markets natural gas.","The filing states its oil and gas operations are principally focused in Texas and also operate properties in five states: Texas, Oklahoma, New Mexico, Louisiana, and Alabama.","The filing states it operates the majority of projects through drilling and production phases."],"numeric_claims":[],"primary_claim":"SPINDLETOP OIL & GAS CO filed a Form 10-K with the SEC (filed 2026-04-16 per the provided filing_date metadata).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Spindletop Oil & Gas Co. filed a Form 10-K with the SEC for the fiscal year ended (not shown in the provided text). The filing includes standard 10-K cover-page items and begins the \u201cDescription of Business\u201d section describing its oil and gas operations and related subsidiaries.","topics":["SEC filing","Form 10-K","business description","oil and gas operations","subsidiaries","cover page disclosures"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 10-K \u00b7 SPINDLETOP OIL & GAS CO \u00b7 Filed 20260415","ticker":"SPND","tickers":["SPND"],"title":"SPND filed 10-K","url":"https://www.sec.gov/Archives/edgar/data/867038/0001017386-26-000048.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