![]() For example, Tony Orlando and Dawn were not originally billed as “Dawn Featuring Tony Orlando,” but that is how the Singles Chronology webpage presents them. Note that, in a few instances, the source database seems to have introduced its own errors. Users always have the option of reverting to the source artist and title columns in the spreadsheet. Even my limited tinkering may have introduced a few errors. I did not engage in a comprehensive attempt to make all artist names and song titles clean and consistent with each other. But the spreadsheet’s formulas are mostly intact, allowing users to shape the data in other directions as desired. So, for example, the original database entry for the song “Let Me” by “Paul Revere and the Raiders Featuring Mark Lindsay” is modified into this suggested filename: “Paul Revere & The Raiders–Let Me (1969).” In that example, the artist name is shortened to its essential form, “and” is replaced with an ampersand, “the” is capitalized, and the year is added. The spreadsheet also offers a column presenting a suggested filename, using the modified names. The spreadsheet offers original as well as modified names of artists and song titles. I don’t expect to maintain the spreadsheet I did it once, for my own purposes, and have decided to share it, as a proof of concept, for anyone who wishes to update and improve upon it. I put all that information into a spreadsheet, and added some innovations. Michaelson’s lists indicate the name of each song, who sang it, how high it went on the chart, and other facts. John Michaelson’s Singles Chronology provides lists of all songs that appeared on the Billboard Hot 100 Singles chart at any time between 19.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |