Announcement

Collapse
No announcement yet.

Some Billboard Chart Collections

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Some Billboard Chart Collections

    Have not really been that involved in creating new chart spreadsheets of late. Guess you could say semi-retired from this activity but I'll share with the group because I'm guessing many would like these.

    Here's the mother of all SS Billboard Pop ME (1890-2020) 20200125 - which was not created by me.

    https://ufile.io/fy1j795c

  • #2
    Here are the Bubbling Under charts:

    Bubbling Under Charts 1959-1985.xlsx
    https://ufile.io/qjixqjay

    Bubbling Under Charts 1992-2020.xlsx
    https://ufile.io/trrni7qh

    Comment


    • #3
      Here are some genre charts:

      Adult Charts 1961-2020.xlsx
      https://ufile.io/xi1cum8n

      Billboard C&W Annual 1944-2019.xlsx
      https://ufile.io/258321zu

      Billboard R&B Annual 1942-2019.xlsx
      https://ufile.io/g05wkp2l

      Billboard R&B Bubbling Under 1992-2020.xlsx
      https://ufile.io/1xipe8r4

      Comment


      • #4
        Here's my cup of tea, the rock charts:

        Mainstream Rock Charts 1981-2020.xls
        https://ufile.io/1clp0s9f

        Modern Rock Charts 1988-2020.xlsx
        https://ufile.io/8npgolaq

        Comment


        • #5
          So here are the Billboard Pop charts 1940-1958 when there were Best Sellers, Juke Box, and Disc Jockey charts:

          Billboard Pop ME (1940-1954).xlsx
          https://ufile.io/iouwalbv

          Billboard Pop ME (1955-1958).xls
          https://ufile.io/b8jjf9fy

          Comment


          • #6
            Here is a listing of the Airplay and Sales only data Whitburn use to include in his Pop Singles book

            Billboard Pop ME A-S-X tab.xls
            https://ufile.io/xertsgex

            Comment


            • #7
              So that's "all" the Billboard spreadsheets I have. The links will expire in 30 days so grab them soon because I will not post them again.

              Do not say "thanks for your posts, any chance you have this chart or this chart" because I generally ignore those requests.

              I did provide charts from Cash Box (Pop, R&B, C&W, Bubbling) and Music Vendor/Record World (Pop, Bubbling) and posted them on completion. They have not been updated since I last posted them because, well the magazines folded. So if you need them, I'm sure other forum members can help you out.

              The Cash Box charts are available on-line at https://www.cashboxmagazine.com/archives.htm.

              I MIGHT get th MusicVendor/Record World charts on-line in the next year or so.

              Comment


              • #8
                Although I compiled all the above spreadsheets except for the "mother" I owe thanks to many who helped - they all know who they are. Providing and calling in favors is the name of the game!

                Comment


                • #9
                  DrTravel. Thank you so much for this.

                  Comment


                  • #10
                    Providing and calling in favours is not an uncommon chart game. What make your projects unique is the combination of structure and magnitude attached to the game and the determination to go all the way till the intended ends of the projects without pausing. This side of the Atlantic I guess only kingofskiffle has the possibility to achieve something that may be compared to your achievements. Thanks for the monumental work you’ve shared with us.

                    Comment


                    • #11
                      Thank you DrTravel

                      Comment


                      • #12
                        Originally posted by DrTravel View Post
                        S

                        I did provide charts from Cash Box (Pop, R&B, C&W, Bubbling) and Music Vendor/Record World (Pop, Bubbling) and posted them on completion. They have not been updated since I last posted them because, well the magazines folded. So if you need them, I'm sure other forum members can help you out..
                        Can anyone share the Cash Box Pop charts DR.T references above.

                        Much appreciated

                        Comment


                        • #13
                          Many Thankx, Dr. Travel!!

                          Comment


                          • #14
                            Ultimate thanks again, Dr Travel !!! You R-O-C-K !!!

                            Comment


                            • #15
                              Long live our Doctor

                              Comment


                              • #16
                                Chart Track List

                                I have posted a file called "ChartTrackList20200309.zip" to the following URL:

                                http://ge.tt/7WcPOm13 (corrected)

                                The zip contains a large-ish Tab-Delimited data file with a smaller Info text file. I have copied most of the Info file below. If you are reading this, I think you might find it interesting and useful. The download will expire in 30 days.

                                =======

                                Chart Track List

                                The Chart Track List file is a tab-delimited listing of all tracks that appeared through the end of 1999 on the charts listed below. I believe that charts after that are readily available and so did not need me to replicate them. Plus, I'm more interested in chart history than the more recent past.

                                The tab-delimited format is readily input to whatever database or spreadsheet or other application you choose to use. I tend to use Access because I'm familiar with it and have a copy, not because it is best. The data is not really suitable for browsing as is, but if you import it to Word, set adequate page size and proper tab stops, then you can try...

                                Note that the file has one record (or line) per track per label no., approximately 65,000 tracks. The same song/artist combination might appear multiple times if it charted with different Label Numbers at different times (may be same of different recordings). That is, the combination of TrkArtist, TrackName, and Label is unique in this file. The file is ordered by artist "sort name" (not included as a field) and then Entry Date, giving you a chronology of hits by artist. See the field definitions below.

                                I'm sure this file will lead to requests by some for the expanded listing of actual chart positions, week by week for each track - the ultimate raw chart data. This is a file of over 850,000 records, so be careful what you ask for. It would also require a lot of context and explanation, error listings and caveats, and more. That additional material just isn't complete yet.

                                This track listing is the basis - you need to know which tracks exist, which song is actually being performed, which artist is this really. To create the file I had to make some decisions, which you may or may not agree with. For example, do you list a common name for an artist as "Glenn Miller", as "Glenn Miller And His Orchestra", or "Glenn Miller With Ray Eberle" (or other vocalist)? The first two group all of Glenn Miller's tracks together more easily, but slights the vocalists. Oh, and what about Glenn Miller's post war orchestra (after his death)? There is not enough room here or time to list all my decisions and the reasoning for them. I hope they work for you. In the end, it would be so much easier to merge and compare datasets if we all called artists, songs, and tracks by the same names and even had common IDs for them.

                                I strive for accuracy in this data. There are a number of chart listings available to you, but most are informally created and, but without exception, they all contain a high number of errors. The data you find here is also not without error, but I believe that you will find it significantly more accurate than almost any of the listings you find online and even a bit better than most books. This listing is also more extensive than any that I have found.

                                My approach to creating accurate listings is based on the following:

                                o Entering data direct from the original sources is an excellent approach, but any human data entry introduces errors. I have entered a significant amount of chart data myself, but this is not my first choice.

                                o The best way to find human error is to programmatically compare multiple listings of the same charts independently entered. Then, any disagreements found can be resolved by looking back at the original source (magazine) if available.

                                o Comparing existing listings with the original chart can also help find errors, but this can be mind-numbing and prone to missing errors. It has to be done in many cases, but far from perfect

                                o Even the original chart listings in Billboard/Cash Box/Record World/etc. contain errors. A consistent approach to resolving these errors is important. Such errors may include a song listed twice at different positions, no song listed at a position, mismatch in artist/title/label at a position, numbered chart positions listed out of order, or even that the listed song does not seem to exist. Once you have a chart in a database, you can detect many of these errors programmatically. A listing of all the errors found in each chart is a worthy project by itself.

                                o It is critical to build up separate, accurate lists of artists, songs (with authors), and tracks and confirming their existence using various resources. You will need to detect different names used for the same artist or the same song. You can detect different artists with the same name (see Bang, Jimmy Barnes, Barons, Buster Brown, etc.).

                                o I consider the record label to be the source for track name/artist/etc.

                                o Finally, perfection is something to strive for, but in a dataset this large, I have come to realize that it is not possible to reach it. On the other hand, with a lot of work, you can get pretty close.

                                Here are the fields in the tab-delimited chart listings provided with this file. This also outlines the charts addressed.

                                For any charts that had associated "bubbling under" type extensions, those chart entries are included with the base chart. Thus, an "Entry Date" for a Billboard Hot 100 track might refer to an issue where the track was at position 110 (or #10 on Bubbling Under).

                                A common name was used for each chart. Some charts changed names over time. The history of chart name changes is a separate subject.

                                o Entry Date - Billboard issue date for the first time the track appeared on any of the included charts. Cashbox and Record World, the Entry Date may be slightly different - a separate listing of issue date alignment for the three could be provided.
                                o Weeks - Number of weeks the track appeared on at least one of the included charts. These may not be consecutive weeks.
                                o TrkArtist - The "common name" of the artist for this track. Compare with Label Artist field.
                                o TrackName - The name of the song in this track as listed on the record label - see SongID if looking for same song by different artists.
                                o Label - This is the Label Number (e.g. MCA 54426) for the recording that charted. Note that these are not unique - some companies reused label numbers, often many years later.
                                o Label Artist - This is the name of the artist as shown on the label of the record that charted. This may vary from the TrkArtist as the name may change over time.
                                o Composer - The name(s) of the authors of the song on the track. This helps differentiate different songs with same or similar names. Please also see SongID to help with finding multiple recordings of the same song.
                                o WksBS - Number of weeks charted on the Billboard Best Sellers chart.
                                o WksJB - Number of weeks charted on the Billboard Juke Box chart.
                                o WksDJ - Number of weeks charted on the Billboard Disk Jockey chart.
                                o WksTop100 - Number of weeks charted on the Billboard Top 100 chart.
                                o WksHot100 - Number of weeks charted on the Billboard Hot 100 chart.
                                o WksHR - Number of weeks charted on the Billboard Honor Roll chart (top seller of the charted song).
                                o WksC&W - Number of weeks charted on the Billboard Country & Western chart.
                                o WksC&W-JB - Number of weeks charted on the Billboard Country & Western Juke Box chart.
                                o WksC&W-DJ - Number of weeks charted on the Billboard Country & Western Disk Jockey chart.
                                o WksR&B - Number of weeks charted on the Billboard R&B chart.
                                o WksR&B-JB - Number of weeks charted on the Billboard R&B Juke Box chart.
                                o WksR&B-DJ - Number of weeks charted on the Billboard R&B Disk Jockey chart.
                                o WksR&B-CB - Number of weeks charted on the Cash Box R&B charts during the time Billboard did not publish R&B charts. This data is often used as a filler for the missing BB-R&B years.
                                o WksCB - Number of weeks charted on the Cash Box pop charts (Disc-Hits Box Score/Top 100 charts/etc.)
                                o WksRW - Number of weeks charted on the Record World pop charts (100 Top Pops/The Singles Chart/etc.)
                                o TrackID - Unique identifier for each of the 64000+ tracks listed
                                o ArtistID - Unique identifier for each artist - allows you to group records by artist
                                o SongID - Unique identifier for each song - allows you to group recordings of a song by different artists

                                Here are some of the on-line listings I used for researching charts and record labels:

                                <<Download the zip for the rest of this and for the data file - didn't want to bore you further if you aren't interested>>
                                Last edited by Cottonwood; Fri March 13th, 2020, 18:07.
                                Cottonwood
                                Texas

                                Comment


                                • #17
                                  Originally posted by Cottonwood View Post
                                  Chart Track List

                                  I have posted a file called "ChartTrackList20200309.zip" to the following URL:

                                  http://ge.tt/7WcPOm13
                                  Unless I am doing something wrong the link goes to a xlsx file instead and then refuses to download the file. Can you check the link and make sure I'm not being silly.
                                  http://thechartbook.co.uk - for the latest are best chart book - By Decade!
                                  Now including NME, Record Mirror and Melody Maker from the UK and some Billboard charts

                                  Comment


                                  • #18
                                    ^ The same problem.

                                    Comment


                                    • #19
                                      Open!
                                      But another title file...

                                      Comment


                                      • #20
                                        Sorry folks. The link showing is correct, but the underlying URL points to a different place. I changed where I was posting it during the editing process and guess that messed it up.

                                        The link is this:

                                        http://ge.tt/7WcPOm13

                                        I hope it works this time. I'll check it once it is posted to be sure.
                                        Cottonwood
                                        Texas

                                        Comment


                                        • #21
                                          Thanks for the links DrTravel and Cottonwood.

                                          Comment


                                          • #22
                                            If anyone can repost DrTravel's Cash Box R&B file, I'd also be grateful. I've been offline for a little and missed it. I think I have the Cash Box C&W and could add both to the list I published.
                                            Cottonwood
                                            Texas

                                            Comment


                                            • #23
                                              Originally posted by Cottonwood View Post
                                              If anyone can repost DrTravel's Cash Box R&B file, I'd also be grateful. I've been offline for a little and missed it. I think I have the Cash Box C&W and could add both to the list I published.
                                              Here are all the final Cashbox charts:

                                              Cashbox National RnB (1953-1996).xlsx
                                              https://ufile.io/uhm0uoda
                                              Corrected link

                                              Cash Box Country (1947-1996).xlsx
                                              https://ufile.io/tuym2s0e

                                              Cash Box Country Looking Ahead (1990-1994).xls
                                              https://ufile.io/g4oxim1i

                                              Cash Box Country Looking Ahead (1973-1977).xls
                                              https://ufile.io/5x9e7wdp
                                              Last edited by DrTravel; Thu March 19th, 2020, 23:52.

                                              Comment


                                              • #24
                                                Two last ones

                                                Cash Box Pop Charts (1944-1996).xlsx
                                                https://ufile.io/3lownfni

                                                Cash Box Looking Ahead (1959-1993).xlsx
                                                https://ufile.io/rizw7ori

                                                Comment


                                                • #25
                                                  Thank you Dr. Travel
                                                  Last edited by croatia; Thu March 19th, 2020, 22:09.

                                                  Comment

                                                  Working...
                                                  X