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-03T18:42:30.759026+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:c9c3c56c8cdbbb84","evidence_event_ids":["evt_7095b9ed995c"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","as_of":"2026-04-03T18:42:30.759026+00:00","canonical_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cf5be6480c6ab84a","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T00:24:58.166349+00:00","extraction_method":"heuristic","fetched_description":"Northern Trust (NTRS) has an impressive earnings surprise history and currently possesses the right combination of the two key ingredients for a likely beat in its next quarterly report.","fetched_title":"Will Northern Trust (NTRS) Beat Estimates Again in Its Next Earnings Report? | Nasdaq","final_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1","source_event_id":"evt_7095b9ed995c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c130a5c2cd95daf5","kind":"new_listings","published_at":"2026-04-03T16:10:05+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 21, 2026"],"entities":[{"asset_class":"equity","name":"Northern Trust Corporation","relevance":"high","symbol":"NTRS","type":"company"}],"event_type":"earnings","information_gaps":["No specific details on market conditions or external factors influencing earnings estimates."],"key_facts":["Northern Trust's last reported earnings were $2.69 per share against an estimate of $2.37, a surprise of 13.50%.","In the previous quarter, earnings were $2.29 per share against an estimate of $2.26, a surprise of 1.33%.","Northern Trust has an Earnings ESP of +8.29%."],"numeric_claims":[{"label":"Average earnings surprise in last two quarters","value":"7.41%"},{"label":"Last quarter earnings surprise","value":"13.50%"},{"label":"Previous quarter earnings surprise","value":"1.33%"},{"label":"Earnings ESP","value":"+8.29%"}],"primary_claim":"Northern Trust has topped earnings estimates by an average of 7.41% in the last two quarters.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Northern Trust (NTRS) has a history of beating earnings estimates and is positioned for another potential earnings beat in its upcoming report on April 21, 2026, supported by a positive Earnings ESP of +8.29%.","topics":["earnings","financial performance","stock analysis"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Northern Trust (NTRS) has an impressive earnings surprise history and currently possesses the right combination of the two key ingredients for a likely beat in its next quarterly report.","tickers":["NTRS"],"title":"Will Northern Trust (NTRS) Beat Estimates Again in Its Next Earnings Report?","url":"https://www.nasdaq.com/articles/will-northern-trust-ntrs-beat-estimates-again-its-next-earnings-report-1"}}

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