I made a information map of MSA (Metropolitan statistical areas) and then linked it to common names for those areas and sites such as reddit.com/r/cincinnati an

I made a information map of MSA (Metropolitan statistical areas) and then linked it to common names for those areas and sites such as reddit.com/r/cincinnati and then scraped the online users over time. There was a bit more to it though around sentiment analysis because some cities higher on the MSA are really in decline, but have increasing populations of very low wage workers with decreasing high wage workers. The cities on the top of the list were not surprising given my very limited scope (San Francisco, New York, Denver, Seattle, Boston etc). The one that ranked highest that was most surprising was Minneapolis, they are fairly strong in almost all the metrics I was looking at.