Billboard R&B Charts (from the beginning)

Moderator: kingofskiffle

 

Postby Chartaholic » Fri Mar 31, 2017 8:05 pm

DrTravel wrote:This spreadsheet now contains all the R&B charts up to March 18, 2017 - the three weeks after are available on ukmix. Complete chart runs are shown for all songs the PEAKED in the years 1942 to 2016 but not those that peaked in 2017 - I have those in another working spreadsheet. There are three songs that peaked in 2016 but are still on the April 8, 2017 chart ("24K Magic", "Redbone" and "Deja Vu") - I will update their chart runs on a weekly basis.

http://www76.zippyshare.com/v/IgAI8eO6/file.html

It took four months to put this together with the assistance of half a dozen individuals (I am eternally grateful for their help).

On to the 1959 Music Vendor charts
Thanks to you and the team for their efforts in preserving music chert history.

Now I just need Apple to cooperate and make a powerful enough iPad to display more than the first few thousands lines lol.
Chartaholic
Groupie
 
Posts: 51
Joined: Tue Mar 14, 2017

Postby kingofskiffle » Sat Apr 01, 2017 6:25 am

Chartaholic wrote:Thanks to you and the team for their efforts in preserving music chert history.

Now I just need Apple to cooperate and make a powerful enough iPad to display more than the first few thousands lines lol.
I think the built in viewer only shows those but their are apps that show more. Excel and Numbers do I think. Excel is free with a subscription to save the file and do more while numbers should be free if you bought the device in the last few years
http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5573
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby Chartaholic » Sat Apr 01, 2017 4:52 pm

kingofskiffle wrote:
Chartaholic wrote:Thanks to you and the team for their efforts in preserving music chert history.

Now I just need Apple to cooperate and make a powerful enough iPad to display more than the first few thousands lines lol.
I think the built in viewer only shows those but their are apps that show more. Excel and Numbers do I think. Excel is free with a subscription to save the file and do more while numbers should be free if you bought the device in the last few years
Thanks.

It won't load in numbers. Too big. It crashes out. I've tried some other smaller xls viewer apps and it only shows a limited number of lines,

That's using the latest standard iPad Air 2 and the first iPad Pro.

I've never understood the fascinations iin doing these projects in a spreadsheet. Too big and cumbersome. Even my win7 machine bought in 2010 is slow scrolling this file. Yes that's old, but still.

Database people, database! Heh.
Chartaholic
Groupie
 
Posts: 51
Joined: Tue Mar 14, 2017

Postby DrTravel » Thu Jun 08, 2017 2:13 pm

Here are the chart runs for those songs that PEAKED on the Billboard Bubbling Under R&B chart 1992-2016:

http://www36.zippyshare.com/v/G8LER8hG/file.html

This chart started in December 1992 and was 25 positions. Since October 2012 the chart is only 10 positions. SS does not include the charts as they all are available on billboard.biz.

That's a rap for the Billboard R&B charts
DrTravel
Roadie
 
Posts: 265
Joined: Thu Dec 25, 2014

Postby VelaLuka » Sun Jun 18, 2017 8:58 pm

Hello,
does somebody have the Billboard RnB-Chart-file up to 2017 please?
The download-link of DrTravel expired :-(
VelaLuka
Groupie
 
Posts: 59
Joined: Fri Jun 17, 2016

Postby VelaLuka » Tue Jun 20, 2017 7:03 pm

Still became the file from a friend. Big thanks
VelaLuka
Groupie
 
Posts: 59
Joined: Fri Jun 17, 2016

Postby freeme » Fri Jun 23, 2017 12:04 pm

Any plans to have an archive for others charts like rhythmic, pop or adult?
Thanks for your work guys!
don't disturb this groove!
freeme
Manager
 
Posts: 1603
Joined: Sun Mar 07, 2004
Location: Haywards Heat, UK

Postby kingofskiffle » Fri Jun 23, 2017 12:50 pm

freeme wrote:Any plans to have an archive for others charts like rhythmic, pop or adult?
Thanks for your work guys!
I suppose this depends on demand. I, for example, have the adult contemporary in my database but unchecked. I'm going to do something with those but when time allows. Currently working on the UK and early USA (1940-1955).
http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5573
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby freeme » Sat Jun 24, 2017 10:03 pm

kingofskiffle wrote:
freeme wrote:Any plans to have an archive for others charts like rhythmic, pop or adult?
Thanks for your work guys!
I suppose this depends on demand. I, for example, have the adult contemporary in my database but unchecked. I'm going to do something with those but when time allows. Currently working on the UK and early USA (1940-1955).
I hope for the future to have adult charts.... Find the time please hehehehe!
Anyway thanks
don't disturb this groove!
freeme
Manager
 
Posts: 1603
Joined: Sun Mar 07, 2004
Location: Haywards Heat, UK

Postby DrTravel » Tue Oct 31, 2017 6:24 pm

Made a few corrections plus I added charts up to September, 2017

http://www63.zippyshare.com/v/p2OW4K6X/file.html
DrTravel
Roadie
 
Posts: 265
Joined: Thu Dec 25, 2014

Postby AntLop » Tue Nov 07, 2017 5:43 pm

@DrTravel, Post Mainstream Top 40 (Pop) Please!
AntLop
Roadie
 
Posts: 224
Joined: Thu Nov 28, 2013

Postby freeme » Tue Nov 07, 2017 10:02 pm

Also... What about canadian charts?
Do you have archives?
don't disturb this groove!
freeme
Manager
 
Posts: 1603
Joined: Sun Mar 07, 2004
Location: Haywards Heat, UK

Postby Swampy61 » Wed Nov 08, 2017 9:46 am

freeme wrote:Also... What about canadian charts?
Do you have archives?
Canadian RPM charts are available here - http://www.bac-lac.gc.ca/eng/discover/f ... earch.aspx

CHUM charts - http://www.las-solanas.com/arsa/station ... 1&rsid=148
Swampy61
Groupie
 
Posts: 29
Joined: Fri Sep 18, 2015

Postby RokinRobinOfLocksley » Wed Nov 08, 2017 11:32 am

Swampy61 wrote:
freeme wrote:Also... What about canadian charts?
Do you have archives?
Canadian RPM charts are available here - http://www.bac-lac.gc.ca/eng/discover/f ... earch.aspx

CHUM charts - http://www.las-solanas.com/arsa/station ... 1&rsid=148
Many thanks for these links, Swampy!!

I've been trying for a long while to get copies of the Canadian record chart books by author Ted Kennedy, but it's impossible unless you go visit a Canadian library, ugh. I do have a CHUM 'by artist' chart book.

Ted's books covered both the RPM and The Record charts. RPM's ran from 1964 to 2000, The Record ran from 1981 to 2001. One could say they were worthy competitors. Ted later published a searchable computer database program of this data, which I obtained, but it only runs on Windows XP and earlier versions.

My research notes (gotten off the internet) say that the RPM chart was modelled on Billboard, sales + airplay. In 1989, they switched to airplay only, and later transformed into Hot Tracks that featured 'tracks' not just singles.

The Record singles chart was based on sales only.

If anyone knows where The Record singles charts can be found, please lettuce snow!
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 88
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby Chartaholic » Thu Nov 09, 2017 6:13 am

RokinRobinOfLocksley wrote:
Swampy61 wrote:
freeme wrote:Also... What about canadian charts?
Do you have archives?
Canadian RPM charts are available here - http://www.bac-lac.gc.ca/eng/discover/f ... earch.aspx

CHUM charts - http://www.las-solanas.com/arsa/station ... 1&rsid=148
Many thanks for these links, Swampy!!

I've been trying for a long while to get copies of the Canadian record chart books by author Ted Kennedy, but it's impossible unless you go visit a Canadian library, ugh. I do have a CHUM 'by artist' chart book.

Ted's books covered both the RPM and The Record charts. RPM's ran from 1964 to 2000, The Record ran from 1981 to 2001. One could say they were worthy competitors. Ted later published a searchable computer database program of this data, which I obtained, but it only runs on Windows XP and earlier versions.

My research notes (gotten off the internet) say that the RPM chart was modelled on Billboard, sales + airplay. In 1989, they switched to airplay only, and later transformed into Hot Tracks that featured 'tracks' not just singles.

The Record singles chart was based on sales only.

If anyone knows where The Record singles charts can be found, please lettuce snow!
Be careful when using the RPM archives site. There's a few errors on chart dates and wrong charts with the wrong dates.

Nanda Lwin's The Canadian Singles Book will give you the usual peak, weeks etc by artist for The Record.
Chartaholic
Groupie
 
Posts: 51
Joined: Tue Mar 14, 2017

Postby RokinRobinOfLocksley » Thu Nov 09, 2017 12:37 pm

Chartaholic wrote:Be careful when using the RPM archives site. There's a few errors on chart dates and wrong charts with the wrong dates.

Nanda Lwin's The Canadian Singles Book will give you the usual peak, weeks etc by artist for The Record.
Thanks Chartaholic. Lwin's book would give The Record data from 1983 to 1996, missing the last 5 years, unless he published a revision.

Correction to my above post, The Record seems to have started in 1981 as a publication, but the charts didn't begin until Jan 1983.
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 88
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby Chartaholic » Thu Nov 09, 2017 6:13 pm

RokinRobinOfLocksley wrote:
Chartaholic wrote:Be careful when using the RPM archives site. There's a few errors on chart dates and wrong charts with the wrong dates.

Nanda Lwin's The Canadian Singles Book will give you the usual peak, weeks etc by artist for The Record.
Thanks Chartaholic. Lwin's book would give The Record data from 1983 to 1996, missing the last 5 years, unless he published a revision.

Correction to my above post, The Record seems to have started in 1981 as a publication, but the charts didn't begin until Jan 1983.
I've never seen it, but there's a book called Top 40 Hits: The Essential Charts. It supposedly updates through 1999.

His books, like Teds' are extremely hard to find, even here in Canada. Especially once out of Toronto or Vancouver,
Chartaholic
Groupie
 
Posts: 51
Joined: Tue Mar 14, 2017

Postby DrTravel » Fri Nov 10, 2017 7:35 pm

Chartaholic wrote:
RokinRobinOfLocksley wrote:
Chartaholic wrote:Be careful when using the RPM archives site. There's a few errors on chart dates and wrong charts with the wrong dates.

Nanda Lwin's The Canadian Singles Book will give you the usual peak, weeks etc by artist for The Record.
Thanks Chartaholic. Lwin's book would give The Record data from 1983 to 1996, missing the last 5 years, unless he published a revision.

Correction to my above post, The Record seems to have started in 1981 as a publication, but the charts didn't begin until Jan 1983.
I've never seen it, but there's a book called Top 40 Hits: The Essential Charts. It supposedly updates through 1999.

His books, like Teds' are extremely hard to find, even here in Canada. Especially once out of Toronto or Vancouver,
10 used and one brand new copy available on amazon - shipping to Canada shouldn't be a big deal
"Top 40 Hits: The Essential Chart Guide Paperback – September 1, 1999"
https://www.amazon.com/Top-40-Hits-Esse ... nanda+lwin
DrTravel
Roadie
 
Posts: 265
Joined: Thu Dec 25, 2014

Postby Chartaholic » Sat Nov 11, 2017 7:34 am

DrTravel wrote:
Chartaholic wrote:
RokinRobinOfLocksley wrote:
Chartaholic wrote:Be careful when using the RPM archives site. There's a few errors on chart dates and wrong charts with the wrong dates.

Nanda Lwin's The Canadian Singles Book will give you the usual peak, weeks etc by artist for The Record.
Thanks Chartaholic. Lwin's book would give The Record data from 1983 to 1996, missing the last 5 years, unless he published a revision.

Correction to my above post, The Record seems to have started in 1981 as a publication, but the charts didn't begin until Jan 1983.
I've never seen it, but there's a book called Top 40 Hits: The Essential Charts. It supposedly updates through 1999.

His books, like Teds' are extremely hard to find, even here in Canada. Especially once out of Toronto or Vancouver,
10 used and one brand new copy available on amazon - shipping to Canada shouldn't be a big deal
"Top 40 Hits: The Essential Chart Guide Paperback – September 1, 1999"
https://www.amazon.com/Top-40-Hits-Esse ... nanda+lwin
Thanks I'll take a look.
Chartaholic
Groupie
 
Posts: 51
Joined: Tue Mar 14, 2017

Return to Chart Analysis