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-20T17:15:12.787981+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:e89374684b561497","evidence_event_ids":["evt_55200891856c"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","as_of":"2026-04-20T17:15:12.787981+00:00","canonical_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","article_chars":389,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_199d1febee77935b","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:45:04.105620+00:00","extraction_method":"trafilatura","fetched_description":"The latest tally of analyst opinions from the major brokerage houses shows that among the components of the S&P 500 index, Idexx Laboratories is now the #84 analyst pick, moving up by 1 spot. This rank is formed by averaging the analyst opinions for each component f","fetched_title":"S&P 500 Analyst Moves: IDXX | Nasdaq","final_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx","source_event_id":"evt_55200891856c","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"0d46167c9ab29a37","kind":"new_listings","published_at":"2026-04-20T16:06:04+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.52,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Idexx Laboratories","relevance":"high","symbol":"IDXX","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"listing","information_gaps":["The article does not provide the number of brokers included, the distribution of analyst ratings, or the specific average opinion value behind the #113 rank.","No date is given for when the ranking and the 5.8% year-to-date figure were measured.","The article does not specify whether the ranking is based on consensus rating, price target, or another metric beyond 'analyst opinions.'","No comparison to prior period beyond 'moving up by 1 spot' is provided."],"key_facts":["The ranking is formed by averaging analyst opinions for each S&P 500 component across brokers, then ranking 500 components by those average opinion values.","Idexx Laboratories is ranked #113 in the analyst pick tally.","Idexx Laboratories moved up by 1 spot.","Idexx Laboratories shows a 5.8% gain year-to-date based on stock price movement."],"numeric_claims":[{"label":"Analyst pick rank","value":"113"},{"label":"Rank change","value":"+1 spot"},{"label":"Year-to-date gain","value":"5.8%"}],"primary_claim":"Idexx Laboratories is now the #113 analyst pick among S&P 500 components, up by 1 spot.","relevance_score":0.45,"sentiment":"neutral","source_quality":"low","summary":"IDEXX Laboratories moved up one spot in an S&P 500 analyst-pick ranking, now ranked #113. The article also notes the stock is up 5.8% year-to-date.","topics":["analyst ratings","S&P 500 components","ranking methodology","year-to-date price performance"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"The latest tally of analyst opinions from the major brokerage houses shows that among the components of the S&P 500 index, Idexx Laboratories is now the #113 analyst pick, moving up by 1 spot. This rank is formed by averaging the analyst opinions for each component","tickers":[],"title":"S&P 500 Analyst Moves: IDXX","url":"https://www.nasdaq.com/articles/sp-500-analyst-moves-idxx"}}

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