Artist Compilation

This is the 2008 WTMD listener voting results for the 897 greatest albums.

WTMD's Radio For Music People Blog: WTMD's 897 Greatest Albums of All Time Countdown


My counts of artists votes and number of albums

Artist Count and Ratings on WTMD Top 897 Albums

My favorite radio station in the Baltimore area is WTMD. Recently they held a contest that spanned over 2 months between the voting and the actual countdown in which they played, on average, three songs from each album. They updated their online list every hour they played music from the albums in the countdown. I would manually scrape the list, copying and pasting into a text file, then import the text file into a database. I parsed out the Artist and Album title in separate, indexable columns, sorted the table, standardized both the spelling and format of artist names, etc... I ran little queries to count the number of albums and, because they did not publish the number of votes each album received, I arbitrarily assigned the reverse of the album's position in the table as it's individual weight (album #897 had a weight of 1 and album #1 a weight of 897.) I then added all the weights for each album an artist had on the list to come up with a list of Artists represented on the list sorted by their combined album weight. This list viewable via the link on my blog page list section - WTMD Artist Counts List. If you like such things please enjoy yourself.