Since January 1st, 2014, there's been a renewed interest in energy-efficient lighting thanks to a law that requires a minimum level of efficiency from lightbulbs, making the century-old incandescents a thing of the past for most uses (there are exceptions, but the most popular models, the 60W and 100W, are goners). While some will complain at first, I think it's a great thing for the long-term. So much wasted energy will go to better use. There's still about 70% of light sockets in the US that contain energy-inefficient lightbulbs, so the potential gains are huge. And with long-lived and very efficient LEDs dropping in price quickly, there's no excuses to stick with antiquated technology.
The map above was compiled based on sales data from Home Depot, the biggest lightbulb seller in the US, so a good proxy for sales in general. They combined U.S. store sales numbers from markets with at least 100,000 people with 2010 Census data for a per capita look at which areas of the country are the top adopters of LED and compact fluorescent (CFL) bulbs.
Unfortunately, the data on the map is not ranked (I've asked for it, and will update this post if I get it), but it's still possible to see the top 10 markets clearly in orange, and the top 5 markets for total consumption with the stars. The data is per capita, so higher population density doesn't affect the ranking.
See also: Lighting facts: Did you know that 70% of lightbulbs in the U.S. are still inefficient models?