« previous next »
Pages: [1]

Author Topic: Top 40 database  (Read 8123 times)

mshray

  • The Core
  • Transcendent Typist
  • *****
  • Posts: 15129
    • View Profile
Top 40 database
« on: February 25, 2005, 04:23:17 PM »
Hi all,

In my never-ending quest to do anything but work at work, I have been  creating a spreadsheet of the Top 40.  My method was to copy from the Top 40 Lyrics website, which has Artist, Title & Chart Position all on one line & run a few customized functions to break up the data & format it cleanly (i.e. Beatles, not The Beatles, and changing (#16) into just 16).  After I got into the swing of it it became kind of fun, and it was a good exercise in refining my Excel skills.

I decided to start with Beatlemania & eschew the early 60's, then go by half decades as that seems a reasonable chunk of data to work with.  Thus the first two installments are ready: 1964-69 & 1970-74.  This is a two tab workbook, & only about 330kb (I'll leave it to you to copy them into a single page if you want to).  It includes approx 3000 song entries.

If you'd like a copy I can email you, (or maybe Geoff could set it up so that you could download it directly form this site?).  More to come in the future.
Logged
"Music is the Earth, People are the Flowers, and I am the Hose."

--Carlos Santana, 2010

RGMike

  • The Core
  • Eight Miles High
  • *****
  • Posts: 79493
    • View Profile
Top 40 database
« Reply #1 on: February 26, 2005, 11:46:19 AM »
Sounds great, but I would caution you to beware of the Top 40 db as they have their share of errors; they include some country songs that were country #1's and show them as "#1" when in fact they did not reach #1 pop.
Logged
You spin me right 'round, baby, right 'round

ggould

  • Administrator
  • Master Poster
  • *****
  • Posts: 9160
    • View Profile
    • http://www.ggould.com
Re: Top 40 database
« Reply #2 on: February 26, 2005, 07:36:18 PM »
Quote from: "mshray"
If you'd like a copy I can email you, (or maybe Geoff could set it up so that you could download it directly form this site?).  More to come in the future.
go ahead and send it to me, but JEEZ! How could you leave out 1961?  The year it all started!
Logged
Don't stand in the way of LOVE!

mshray

  • The Core
  • Transcendent Typist
  • *****
  • Posts: 15129
    • View Profile
Top 40 database
« Reply #3 on: February 28, 2005, 09:37:06 AM »
Quote from: "RGMike"
Sounds great, but I would caution you to beware of the Top 40 db as they have their share of errors; they include some country songs that were country #1's and show them as "#1" when in fact they did not reach #1 pop.


yeah i discovered already that they aren't perfect, there was not an entry for "Big Time" which was a top 10 for Peter Gabriel off of the So album.

My main reason to do this was to make it easy to work out my all-time personal Top 40, which if any of the rest of you are interested, is quite easy to do using this spreadsheet.

I already emailed it to Geoff, Mike & Gaz.

Geoff, I'm curious about the 1961 reference.  What started that year?  Most historians have it starting in the 54-56 era, and then being reborn with the Beatlemania/British Invasion of 64-65.
Logged
"Music is the Earth, People are the Flowers, and I am the Hose."

--Carlos Santana, 2010

ggould

  • Administrator
  • Master Poster
  • *****
  • Posts: 9160
    • View Profile
    • http://www.ggould.com
1961
« Reply #4 on: February 28, 2005, 04:51:07 PM »
Quote from: "mshray"
Geoff, I'm curious about the 1961 reference.  What started that year?  Most historians have it starting in the 54-56 era, and then being reborn with the Beatlemania/British Invasion of 64-65.
There's no real start date; it's spread out over a period of time.  When it reached critical mass is up to interpretation.  Looking at the iTunes 1961 charts, it seems to me a good year for the handoff from the old 'corny' Top 40, which still charts to this day, but has a lot of clearly cool shit too.  It just happens to be the year I got really hooked on radio, so it's also personal.



I Fall to Pieces (Single)   Patsy Cline
Crying   Roy Orbison
My True Story   The Jive Five
Running Scared   Roy Orbison
Exodus   Ferrante and Teicher
Where the Boys Are   Connie Francis
Travelin' Man   Rick Nelson
Shop Around   The Miracles
The Boll Weevil Song   Brook Benton
On the Rebound   Floyd Cramer
Calendar Girl   Neil Sedaka
Wings of a Dove   Dolly Parton
Little Sister   Elvis Presley
Blue Moon   The Marcels
Daddy's Home   Shep & The Limelites
(I Don't Know Why ) But I Do   Clarence "Frogman" Henry
Runaround Sue   Dion
Hurt   Timi Yuro
Hello Mary Lou, Goodbye Heart (Live)   Rick Nelson
Surrender   Elvis Presley
Walk Right Back   The Everly Brothers
The Way You Look Tonight   The Lettermen
Moody River (Single)   Pat Boone
One Mint Julep   Poncho Sanchez
Gee Whiz (Look at His Eyes)   The Emotions
Stand by Me   Ben E. King
Spanish Harlem   Ben E. King
It's Gonna Work Out Fine   Tina Turner
(Marie's the Name Of) His Latest Flame   Elvis Presley
Bless You   Tony Orlando
Breakin' In a Brand New Broken Heart   Connie Francis
My Kind of Girl   Matt Monro
Tonight My Love, Tonight   Paul Anka
San Antonio Rose   Floyd Cramer
Big Bad John   Jimmy Dean
Dum Dum (Single)   Brenda Lee
You Can Depend on Me (Single)   Brenda Lee
Take Five   Dave Brubeck
Are You Lonesome Tonight?   Elvis Presley
Sea of Heartbreak   Don Gibson
Please Stay   The Drifters
Logged
Don't stand in the way of LOVE!

ggould

  • Administrator
  • Master Poster
  • *****
  • Posts: 9160
    • View Profile
    • http://www.ggould.com
direct link
« Reply #5 on: February 28, 2005, 04:54:23 PM »
Quote from: "mshray"
My main reason to do this was to make it easy to work out my all-time personal Top 40, which if any of the rest of you are interested, is quite easy to do using this spreadsheet.

I already emailed it to Geoff, Mike & Gaz.
It's already uploaded, in Excel format, here:

http://10t10club.com/Top_40_database.xls
Logged
Don't stand in the way of LOVE!
Pages: [1]
« previous next »