Map pins pop songs that mention cities

map

Map maker Javier Arce created a world map locating 212 cities referenced in 7,681 pop songs. Click on a city and you can instantly play the related songs through Spotify.

To create this map Javier extracted a list of the cities with their respective countries and created a table. Then he geocoded that table to get the position of each city on the map.

Next, he extracted all the song information in the main article using regular expressions and infinite amounts of patience. It generated a CSV file that he imported into his CartoDB account. Javier ended up having a table that contained the name of the song, the author, and the city.

Music Map Mashup [CartoDB Blog]