How to unnest a list-column as new rows in pre-existing columns?
Unnest list columns
SteadyWhy this scored 6
every term, weightedEngagement per hour, normalized against the fastest item on its own source
Whether that velocity is itself speeding up, as a per-hour rate
How many independent communities are talking about the same entity
Decays to zero over 14 days
Subtracted once something is big and old — we rank what's next, not what's peaked
Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On a topic's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement. Full methodology
Outlook
medium confidence · estimate, not a guarantee7-day
~0
range 0–0
14-day
~0
range 0–0
30-day
~0
range 0–0
Signal history
7-day window (free)— — projected trajectory (estimate, not a guarantee)
Entities
Embed a live signal badge
[](https://www.signalcrest.app/topic/so%3A79983560)
Drop this in a README or blog post — it updates automatically as the score moves.