Posted January 19Jan 19 I've thought of an idea for a chart feat a while back and wanted to make a list of songs to do it too, but I'm not sure where to get the database to do so and how to do it so I'll just say it. I was thinking about some chart stuff, and one was songs that top the end of year list, without topping the weekly charts. Love the Way You Lie is the only song to do it here, US did it a few times with Dua Lipa's Levitating as the most recent example in 2022, and the same year Yuuri's Dry Flower did the same in Japan. I wondered what songs never reached #1 on the weekly charts, but could've been #1 of a different time period, longer period and odd starting points. While there's sales data to do this for any range of time and see what would make it on a longer timescale, I thought about if no raw numbers were possible, you can take it to the extreme and see if a song could've possibly been #1 [only over an integer number of chart weeks though]. If each week a single charted, all songs above and including it were basically tied for units, and all songs below it sold pretty much 0 copies, than the only way for the song not to have possibly be #1 was if there was another song that was higher than it during every week it charted! So I want to find out the songs that could have (even in the loosest sense possible) possibly been the #1 of a multiweek time period The idea is in order to reach #1, not a single... well single could have charted higher than it during every week it's whole chart run. I think of it like when a song charts, it has a set of songs charting above it, and each week it charts, if a song from the initial list falls below it, it's removed from the list, and if there's no songs in the list left, it possibly hit #1, with the first week of the list of songs being empty is dated as when it possibly reached #1. This would include: every weekly #1 #2's and #3's that are blocked by songs that fell or will fall below it at some point (or even if the weekly #1 wasn't released when it first charted) Songs that spend a long time on the chart Most songs that get multiple chart runs over years since it's unlikely that the same song has been charting higher than it during those periods, except Holiday music when the same holiday standards chart higher than the song each time I'm not sure how to go about this, I'm guessing I need -a database of the weekly UK Chart: I think the most feasible options are web scraping the OCC site, or if some website out there has like a year-by-year compilation of every chart that year with separators between each field, and I can do some horrific spreadsheet bullshit. -Writing the code: I think I need to make a list of vectors, where the entries are like [Position, Week, Song Identifier...] and then I could run if any song is in the intersection of songs constantly charting above it but not sure what the most efficient way of going about that is lol. If any1 has any resources or thoughts or anything else let me know.
Create an account or sign in to comment