SQLite Web: event_store.db

Update row 54055 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:aac388c06ff52033","evidence_event_ids":["evt_5ab659247d03"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","as_of":"2026-04-16T02:08:52.472606+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","company":"urban-gro, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_afa7495741888007","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","content_type":"text/plain","enriched_at":"2026-04-16T02:25:20.412547+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","html_truncated":true,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.txt","source_event_id":"evt_5ab659247d03","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"10-K","fp":"115ea5c32d090784","kind":"sec_filing","published_at":"20260415","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["2025-06-30","2026-04-15","2026-04-16"],"entities":[{"asset_class":"equity","name":"urban-gro, Inc.","relevance":"high","symbol":"UGRO","type":"issuer"},{"asset_class":"regulator","name":"U.S. Securities and Exchange Commission","relevance":"medium","symbol":"","type":"regulator"}],"event_type":"earnings","information_gaps":["Fiscal year ended date is not shown in the provided text.","No specific financial statements, revenue/earnings figures, segment data, or risk disclosures are included in the excerpt.","No explicit \u201cwhat changed vs prior known state\u201d is provided in the text; only that a 10-K was filed is evidenced.","The SEC filing date/time is provided in the structured context, but the excerpt itself does not show the filing timestamp.","The aggregate market value figure and the \u201cAs of April 15, 2026, the registrant had \u2026\u201d continuation are missing."],"key_facts":["The document is an Annual Report on Form 10-K.","It includes forward-looking statements language referencing Sections 27A of the Securities Act and 21E of the Exchange Act.","The excerpt contains multiple cover-page checkboxes (e.g., not a well-known seasoned issuer; not required to file reports under Sections 13 or 15(d); submitted electronically every Interactive Data File required under Rule 405 of Regulation S-T).","The excerpt states: \u201cThe aggregate market value of the voting and non-voting common equity held by non-affiliates\u2026 as of\u2026 June 30, 2025 was approximately $\u201d (value not provided in the text).","The excerpt states: \u201cAs of April 15, 2026, the registrant had\u201d (the remainder is not provided)."],"numeric_claims":[{"label":"aggregate market value of common equity held by non-affiliates (as of June 30, 2025)","value":"approximately $ (not provided in excerpt)"}],"primary_claim":"UGRO (urban-gro, Inc.) filed a Form 10-K with the SEC.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Urban-gro, Inc. filed an annual report on Form 10-K for the fiscal year ended (date not shown in the provided text). The excerpt includes standard 10-K cover-page checkboxes and forward-looking statements language, but no specific financial results or business metrics.","topics":["SEC filing","Form 10-K","forward-looking statements","cover page disclosures"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 10-K \u00b7 urban-gro, Inc. \u00b7 Filed 20260415","ticker":"UGRO","tickers":["UGRO"],"title":"UGRO filed 10-K","url":"https://www.sec.gov/Archives/edgar/data/1706524/0001213900-26-044091.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