10at10 Club
Main Discussion Area => Stream of Consciousness => Topic started by: mshray 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.
-
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.
-
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!
-
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.
-
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
-
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