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/1537435/0001827663-26-000004.txt","as_of":"2026-04-15T02:18:53.247056+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.txt","company":"TECOGEN INC.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.txt","article_chars":1433,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_93258255139e1168","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.txt","content_type":"text/plain","enriched_at":"2026-04-15T05:48:54.276242+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.txt","source_event_id":"evt_90020c7189b2","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"923c49375f430931","kind":"sec_filing","published_at":"20260414","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026-04-14","2026-04-13","2026-04-15T02:18:53.247056+00:00"],"entities":[{"asset_class":"equity","name":"TECOGEN INC.","relevance":"high","symbol":"TGEN","type":"issuer"},{"asset_class":"person","name":"Susan B. Hirsch","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"person","name":"Hirsch Susan B","relevance":"medium","symbol":"","type":"reporting_owner_name_variant"}],"event_type":"other","information_gaps":["The provided text does not explicitly state the transaction type (e.g., purchase/sale), whether the numeric fields (5000, 3.73, 265416) correspond to shares, price, or total consideration, or whether there were multiple transactions.","No prior known state is included in the prompt, so the \"delta\" versus earlier disclosures cannot be determined from the provided text alone.","No table of holdings before/after is shown in the cleaned excerpt, so changes in ownership cannot be quantified beyond the presence of numeric fields."],"key_facts":["SEC accession number: 0001827663-26-000004.","Form type: 4.","Issuer: TECOGEN INC. (TGEN).","Filed as of date: 2026-04-14.","Conformed period of report: 2026-04-13.","Reporting owner: Hirsch Susan B (Susan B. Hirsch).","Filing document count: 1.","The cleaned text includes a line indicating: \"Common Stock\" with additional fields (e.g., \"2026-04-13\", \"4\", and values such as \"5000\", \"3.73\", and \"265416\"), but the specific transaction type and whether these are shares/price/consideration are not explicitly labeled in the provided text."],"numeric_claims":[{"label":"Document count","value":"1"},{"label":"Conformed period of report","value":"20260413"},{"label":"Filed as of date","value":"20260414"},{"label":"Common stock quantity/value field shown","value":"5000"},{"label":"Price/amount field shown","value":"3.73"},{"label":"Another numeric field shown","value":"265416"}],"primary_claim":"A Form 4 (SEC filing type 4) for TECOGEN INC. was filed on 2026-04-14 for a reporting period of 2026-04-13 by reporting owner Susan B. Hirsch.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"TECOGEN INC. (TGEN) filed a Form 4 on 2026-04-14 covering a transaction dated 2026-04-13 by reporting owner Susan B. Hirsch.","topics":["SEC Form 4","insider transaction disclosure","reporting owner"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 TECOGEN INC. \u00b7 Filed 20260414","ticker":"TGEN","tickers":["TGEN"],"title":"TGEN filed 4","url":"https://www.sec.gov/Archives/edgar/data/1537435/0001827663-26-000004.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_1acc76cb245a in signals