SQLite Web: event

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-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:484559a12873a925","evidence_event_ids":["evt_a2744b318141"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","company":"UNITED FIRE GROUP INC","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d51f769cdf1fafd9","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","content_type":"text/plain","enriched_at":"2026-04-09T00:43:57.665671+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"ufcs-20260407","final_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","html_truncated":true,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.txt","source_event_id":"evt_a2744b318141","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"DEF 14A","fp":"06f7d0ebdbd8b7fd","kind":"sec_filing","published_at":"20260407","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-07","2026-05-20","2012-02-02","1992-07-03","2025-01-01","2025-12-31","2024-01-01","2024-12-31","2023-01-01","2023-12-31","2022-01-01","2022-12-31","2021-01-01","2021-12-31"],"entities":[{"asset_class":"equity","name":"United Fire Group Inc","relevance":"high","symbol":"UFCS","type":"issuer"},{"asset_class":"other","name":"SEC","relevance":"medium","symbol":"","type":"regulator"}],"event_type":"listing","information_gaps":["No proxy content is provided (e.g., agenda items, director nominees, executive compensation, voting matters).","No explicit \u201cwhat changed vs prior known state\u201d is included in the provided text; only the existence of this DEF 14A filing and metadata are shown.","No financial guidance or financial implications are stated in the provided excerpt.","No comparison to a prior DEF 14A version or prior filing state is included in the provided text."],"key_facts":["Form type: DEF 14A.","Issuer (conformed name): UNITED FIRE GROUP INC.","SEC accession number: 0000101199-26-000020.","Filed as of date: 2026-04-07.","Conformed period of report: 2026-05-20.","Public document count: 42.","Fiscal year end: 12/31.","Standard Industrial Classification (SIC): FIRE, MARINE & CASUALTY INSURANCE [6331].","Business address: 118 Second Ave SE, Cedar Rapids, IA 52401 (as listed).","Mail address: P O Box 73909, Cedar Rapids, IA 52407 (as listed)."],"numeric_claims":[{"label":"Public document count","value":"42"},{"label":"Fiscal year end (month/day)","value":"12/31"},{"label":"Conformed period of report","value":"2026-05-20"}],"primary_claim":"UNITED FIRE GROUP INC filed Form DEF 14A (proxy statement) on 2026-04-07 (accession number 0000101199-26-000020).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"United Fire Group Inc. filed a DEF 14A proxy statement with the SEC on 2026-04-07. The provided text includes filing metadata but does not include the substantive proxy items or any financial figures.","topics":["SEC filing","proxy statement","DEF 14A","corporate governance"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form DEF 14A \u00b7 UNITED FIRE GROUP INC \u00b7 Filed 20260407","ticker":"UFCS","tickers":["UFCS"],"title":"UFCS filed DEF 14A","url":"https://www.sec.gov/Archives/edgar/data/101199/0000101199-26-000020.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')

event_store.db — events

Update row 2907 in events