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-03T19:18:05.772943+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:a4234d9b6333e053","evidence_event_ids":["evt_ef9519e25f02"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://gov.idaho.gov/pressrelease/","as_of":"2026-04-03T19:18:05.772943+00:00","canonical_url":"https://gov.idaho.gov/pressrelease/","enrichment":{"aggregator_url":"https://gov.idaho.gov/pressrelease/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_229cb421db4ab08a","canonical_host":"gov.idaho.gov","canonical_is_aggregator":false,"canonical_url":"https://gov.idaho.gov/pressrelease/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T01:16:50.037645+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"Gov. Little\u2019s \u201cEnduring Idaho\u201d plan clears Legislature | Office of the Governor","final_url":"https://gov.idaho.gov/pressrelease/","html_truncated":true,"paywall_likely":false,"publisher_domain":"gov.idaho.gov","publisher_resolution":"canonical_url","requested_url":"https://gov.idaho.gov/pressrelease/","source_event_id":"evt_ef9519e25f02","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ac94c0aab42dcb7f","published_at":"","publisher_domain":"gov.idaho.gov","query":"KISB earnings are conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 2, 2026"],"entities":[{"asset_class":"government","name":"Idaho","relevance":"high","symbol":"ID","type":"location"},{"asset_class":"political","name":"Governor Brad Little","relevance":"high","symbol":"N/A","type":"person"}],"event_type":"regulation","information_gaps":["Details on how the $253 million will be distributed to residents are not provided."],"key_facts":["House Bill 40 signed by Governor Brad Little","$253 million allocated back to Idaho residents"],"numeric_claims":[{"label":"amount allocated","value":"$253 million"}],"primary_claim":"House Bill 40 will return $253 million to Idahoans.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Governor Brad Little signed House Bill 40, which allocates $253 million back to Idaho residents as part of his 'Enduring Idaho' plan, aimed at balancing the budget and prioritizing public education.","topics":["budget","education","public policy"]},"snippet":"Boise, Idaho \u2013 Governor Brad Little joined members of House and Senate leadership today in signing House Bill 40, sending another $253 million back to Idahoans' ...","source":"web_search","source_domain":"gov.idaho.gov","summary":"Boise, Idaho \u2013 Governor Brad Little joined members of House and Senate leadership today in signing House Bill 40, sending another $253 million back to Idahoans' ...","title":"Press Releases - Idaho Governor","url":"https://gov.idaho.gov/pressrelease/"}}

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 9525 in events