SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","article_chars":3843,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cb0737290dd1e632","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:47:20.372832+00:00","extraction_method":"heuristic","fetched_description":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, Republic Services Inc (Symbol: RSG) has taken over the #225 spot from Becton, Dickinson & Co (Symbol: BDX), according to The Online Investor. Market capitalizatio","fetched_title":"Republic Services Takes Over #225 Spot From Becton, Dickinson | Nasdaq","final_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","source_event_id":"evt_8bd0c31febe6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7efba1223f8ab4d7","kind":"new_listings","published_at":"2026-04-09T20:40:23+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 09, 2026","Thursday"],"entities":[{"asset_class":"equity","name":"Republic Services Inc","relevance":"primary","symbol":"RSG","type":"company"},{"asset_class":"equity","name":"Becton, Dickinson & Co","relevance":"secondary","symbol":"BDX","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"context","symbol":"","type":"index"}],"event_type":"listing","information_gaps":["The article does not specify the exact methodology or date/time window used for the #225 rank determination beyond referencing the \u201clatest look.\u201d","It does not provide the prior rank position of RSG or the exact rank change magnitude (e.g., how many spots moved).","The article does not include the chart values or the underlying data source for the market-cap history beyond referencing The Online Investor."],"key_facts":["The article states that Republic Services Inc (RSG) has taken over the #225 spot from Becton, Dickinson & Co (BDX) in the S&P 500 ordered by largest market capitalization.","The article gives market capitalization values: RSG at $66.89 billion and BDX at $44.73 billion.","The article states that at the closing bell on Thursday, RSG is up about 0.2% and BDX is off about 0.9% on the day.","The article is dated April 09, 2026 \u2014 04:40 pm EDT."],"numeric_claims":[{"label":"RSG market cap (billion USD)","value":"66.89"},{"label":"BDX market cap (billion USD)","value":"44.73"},{"label":"RSG daily move at closing bell","value":"up about 0.2%"},{"label":"BDX daily move at closing bell","value":"off about 0.9%"}],"primary_claim":"Republic Services Inc (RSG) took over the #225 market-cap rank in the S&P 500 from Becton, Dickinson & Co (BDX).","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Republic Services (RSG) moved into the #225 spot in the S&P 500 by largest market capitalization, taking the position from Becton, Dickinson & Co (BDX). The article also cites market-cap figures and same-day performance at the closing bell.","topics":["S&P 500 constituents/rank by market capitalization","market capitalization","stock performance","BNK Invest/The Online Investor"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, Republic Services Inc (Symbol: RSG) has taken over the #225 spot from Becton, Dickinson & Co (Symbol: BDX), according to The Online Investor. Market capitalizatio","tickers":[],"title":"Republic Services Takes Over #225 Spot From Becton, Dickinson","url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_e64c7dc5d6ee in signals