viewof list = aq.from(raw)
.derive({
Population: d => +d.Population
})
.orderby(aq.desc('Population'))
.filter(d => op.rank() <= 250)
.derive({
row_number: d => op.row_number()
})
.join_left(abb, ['State', 'State'])
.derive({
location: d => `${d.City}, ${d.Abbreviation}`
})
.orderby(aq.desc('Population'))
.dedupe('Abbreviation')
.view()