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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_earnings_calendar_delta:befb42f6a6df11bc","evidence_event_ids":["evt_3f980d8fc5b7"],"signal_type":"discovery_earnings_calendar_delta","source":"discovery_earnings_calendar","value":{"as_of":"2026-04-07T23:23:54.391414+00:00","earnings_date":"2026-04-09","earnings_time_hint":"bmo","enrichment":{"aggregator_url":null,"article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5bbb9041bf5979b7","canonical_host":null,"canonical_is_aggregator":false,"canonical_url":null,"content_type":"","enriched_at":"2026-04-08T00:11:51.855289+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"","html_truncated":false,"paywall_likely":false,"publisher_domain":null,"publisher_resolution":"unresolved","requested_url":"","source_event_id":"evt_3f980d8fc5b7","source_quality":"empty","status_code":null,"version":"signal_enrichment_v2"},"eps_estimate":"0.0204","fp":"69f138cc441e2f4c","kind":"earnings_calendar","published_at":"2026-04-09T00:00:00Z","revenue_estimate":"21522000","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":["2026-04-09"],"entities":[{"asset_class":"equity","name":"NTIC","relevance":"high","symbol":"NTIC","type":"company"}],"event_type":"earnings","information_gaps":["No actual reported results are provided (only calendar/estimates).","No currency/units for revenue are specified.","No guidance, consensus range, or number of analysts is provided.","No validation/invalidation criteria tied to a specific thesis is included in the provided text."],"key_facts":["Earnings date: 2026-04-09","Time/session: BMO (before market open)","EPS estimate: 0.0204","Revenue estimate: 21,522,000"],"numeric_claims":[{"label":"EPS_est","value":"0.0204"},{"label":"Revenue_est","value":"21522000"}],"primary_claim":"NTIC earnings are scheduled for 2026-04-09 (BMO) with EPS estimate 0.0204 and revenue estimate 21,522,000.","relevance_score":0.62,"sentiment":"neutral","source_quality":"unknown","summary":"NTIC is scheduled to report earnings on 2026-04-09 before market open (BMO). The provided estimates are EPS 0.0204 and revenue 21,522,000.","topics":["earnings calendar","earnings date/time","consensus estimates"]},"source":"earnings_calendar","summary":"Earnings date 2026-04-09 \u00b7 Time bmo \u00b7 EPS est 0.0204 \u00b7 Revenue est 21522000","ticker":"NTIC","tickers":["NTIC"],"title":"NTIC earnings on 2026-04-09 (bmo)","url":""}}

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