Energy use for water provision in cities

•A profiling approach is used to illustrate the water-energy trajectory of cities.•Data for the direct energy use for water supply in 30 cities is compiled.•Cities generally reduced per capita energy use for water supply in the last decade.•Some cities provide insights into management of energy use for water provision.•Water use reduction is needed to offset the energy impacts of system augmentations.