SQLite Web: event

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/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

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')

event_store.db — signals

Update row sig_c18287c2c379 in signals