On investigating my own music

iTunes Rocks!You’re asking me, “What are the ten songs you played the most in iTunes this year, David?” Unfortunately I’m not going to tell you that. I’d love to do it, but I can’t. See, the thing is that iTunes doesn’t store meta data in a true RDBMS; it’s just a flat XML file. There’s no way to determine which songs you’ve listened to the most in the last X number of days. In order to do that you’d have to be able to cross-reference the time you heard each song as a separate data point. iTunes only stores the timestamp of the most-recent instance of listening to a song. Bummer.

But I can tell you which songs I added to iTunes in 2006 that I heard the most. And I know you want to know that. And — because I love flirting with disaster — I can also let you download an mp3 of each one. Shhh! Don’t tell the RIAA!

The Ten Songs I Added to iTunes in 2006
(That I Heard the Most This Year)

Tip: Right-click and choose “Save As…”

  1. Mi Fido Di TeJovanotti
  2. The Dirty GlassDropkick Murphys
  3. MapsThe Yeah Yeah Yeahs
  4. When You Were YoungThe Killers
  5. Bonnie BraeThe Twilight Singers
  6. Where’d You Go?Fort Minor
  7. what will they dobecky
  8. Everybody Wants YouBilly Squier
  9. Symphony No. 9 (Scherzo)Beethoven
  10. Read My Mind – The Killers


  • I posted this prior to seeing a very similar post at kottke’s site.
  • Like Kottke, I, too, use last.fm‘s audioscrobbler plugin to track my tracks. My problem is that I often listen to iTunes via my iPod and last.fm doesn’t keep track of those spins. Their database also seems to be wildly mistaken when it comes to which songs I’m hearing. I think it’s a nice service — I use it to display my “recently heard” songs in the sidebar on the front page — but I just know that a bunch of their statistics are incorrect for me.

There are 2 comments on this post

  1. […] While we’re at it, how about more playlists along the likes of this outstanding one created by the magnificent David Gagne […]

  2. FYI: This happens whenever I post an mp3, so I should have seen it coming. My site was slammed with bots grabbing each of those ten songs, so I removed the mp3s from my site and unlinked the titles to them.
    If you’re dying for one of these songs and can’t find it on Limewire or iTunes, let me know.

Add to the discussion:

I'll never share your email address and it won't be published.

What Is This?

davidgagne.net is the personal weblog of me, David Vincent Gagne. I've been publishing here since 1999, which makes this one of the oldest continuously-updated websites on the Internet.


A few years ago I was trying to determine what cocktails I could make with the alcohol I had at home. I searched the App Store but couldn't find an app that would let me do that, so I built one.


You can read dozens of essays and articles and find hundreds of links to other sites with stories and information about Ernest Hemingway in The Hemingway Collection.