This is an analysis of the music in my iTunes library, mostly involving ratings. Feel free to take the provided code and modify/use it. The scripts are done in Python, and they use the PostgreSQL database. I run Debian Linux.
iTunes Music Library.xml
and puts it in the database. (uses the short Debug.py library)Date of analysis: Wed Apr 11 18:45:56 2007 Average rating of all tracks averagerating | stddev | numratedtracks | totaltracks | trackstorate --------------------+------------------------------------+----------------+-------------+-------------- 2.7740112994350282 | 0.91201401374759079766365068148428 | 4602 | 5052 | 449 (1 row) Number of rated tracks rating | numtracks --------+----------- 0 | 449 1 | 1 2 | 2294 3 | 1311 4 | 740 5 | 257 (6 rows) Total time listened to music days | hours | minutes | seconds ------+-------+---------+--------- 18 | 6 | 19 | 9 (1 row) Total time of music in library days | hours | minutes | seconds ------+-------+---------+--------- 13 | 16 | 37 | 27 (1 row) Total time of unrated music days | hours | minutes | seconds ------+-------+---------+--------- 1 | 13 | 8 | 43 (1 row) Highest average rated artists with more than four tracks rated artist | numtracks | averagerating | stddev | totaltracks -----------------------------------------------------------------------------------------------+-----------+---------------+---------+------------- Webber, Andrew Lloyd | 13 | 4.46154 | 0.87706 | 13 Alcoa Singers | 19 | 4.26316 | 0.73349 | 19 They Might Be Giants | 19 | 4.26316 | 0.73349 | 19 Nintendo | 82 | 4.21951 | 0.81687 | 82 Evanescence | 11 | 4.00000 | 0.89443 | 11 Lager Rhythms | 19 | 3.94737 | 0.77986 | 19 Apotheosis | 12 | 3.83333 | 0.93744 | 12 You're A Good Man, Charlie Brown | 6 | 3.83333 | 0.98319 | 6 Annie | 15 | 3.80000 | 0.41404 | 15 Beaches | 10 | 3.80000 | 0.91894 | 10 Simple Plan | 13 | 3.76923 | 0.59914 | 13 Rudy Davenport | 20 | 3.75000 | 0.71635 | 20 Stephen Schwartz | 19 | 3.73684 | 1.09758 | 19 A*Teens | 11 | 3.72727 | 0.46710 | 11 Alain Boubil & Claude-Michel Shonberg | 14 | 3.71429 | 0.61125 | 14 Scooby Doo | 19 | 3.68421 | 1.49267 | 19 The Rice Philharmonics | 52 | 3.67308 | 0.92294 | 52 The Lion King | 12 | 3.66667 | 1.15470 | 12 Train | 11 | 3.63636 | 0.67420 | 11 1995 Broadway Cast | 20 | 3.60000 | 0.88258 | 20 The New Broadway Cast Recording | 9 | 3.55556 | 0.52705 | 9 Dexter Freebish | 11 | 3.54545 | 0.93420 | 11 Savage Garden | 11 | 3.54545 | 0.93420 | 11 Barnes & Noble | 28 | 3.50000 | 0.96225 | 28 Phil Collins & Mark Mancina | 14 | 3.50000 | 1.16024 | 14 Pink | 14 | 3.50000 | 1.09193 | 14 Sean Wood | 10 | 3.50000 | 0.52705 | 10 ACTS | 8 | 3.50000 | 0.53452 | 8 John Du Prez & Eric Idle | 25 | 3.48000 | 1.04563 | 25 Homestar Runner | 7 | 3.42857 | 1.13389 | 7 Barenaked Ladies | 40 | 3.42500 | 1.05945 | 40 Vertical Horizon | 22 | 3.40909 | 0.66613 | 22 Josie and the Pussycats | 13 | 3.38462 | 0.96077 | 13 Animaniacs | 32 | 3.37500 | 0.97551 | 32 Cats | 15 | 3.33333 | 0.81650 | 15 Disney | 20 | 3.30000 | 1.03110 | 20 Loreena McKennitt | 8 | 3.25000 | 0.70711 | 8 Enya | 29 | 3.24138 | 0.78627 | 41 Third Eye Blind | 13 | 3.23077 | 0.43853 | 13 Guster | 10 | 3.20000 | 0.91894 | 10 Menken, Alan, Howard Ashman & Tim Rice | 21 | 3.19048 | 0.67964 | 21 Jimmy Eat World | 35 | 3.17143 | 0.92309 | 35 Cirque du Soleil | 24 | 3.16667 | 0.86811 | 24 Saliva | 12 | 3.16667 | 0.93744 | 12 University of Rochester Yellowjackets | 19 | 3.15789 | 1.01451 | 19 Bleu | 13 | 3.15385 | 0.80064 | 13 Dana Lyons | 13 | 3.15385 | 0.98710 | 13 Beauty and the Beast | 15 | 3.13333 | 1.06010 | 15 Titanic Soundtrack (James Horner) | 15 | 3.13333 | 0.74322 | 15 Various artists | 15 | 3.13333 | 0.83381 | 15 Menken, Alan & David Zippel | 24 | 3.12500 | 1.03472 | 24 The Simpsons | 92 | 3.11957 | 0.89985 | 92 Tom Lehrer | 17 | 3.11765 | 0.78121 | 29 Avalon | 18 | 3.11111 | 0.96338 | 18 ABBA | 19 | 3.10526 | 0.87526 | 19 Various Artists | 19 | 3.10526 | 1.19697 | 19 Revels | 31 | 3.09677 | 0.78972 | 31 The Killers | 11 | 3.09091 | 1.13618 | 11 Big Idea | 36 | 3.08333 | 0.99642 | 36 Hilary Duff | 13 | 3.07692 | 0.95407 | 13 Video Game Pianist | 45 | 3.06667 | 0.93905 | 45 Various | 22 | 3.04545 | 0.99892 | 34 Weird Al Yankovic | 36 | 3.00000 | 1.06904 | 36 Colin Hay | 28 | 3.00000 | 1.24722 | 28 Goo Goo Dolls | 13 | 3.00000 | 1.08012 | 13 Hoobastank | 12 | 3.00000 | 0.95346 | 12 3 Doors Down | 11 | 3.00000 | 0.63246 | 11 Frou Frou | 11 | 3.00000 | 1.09545 | 11 Michael W. Smith | 11 | 3.00000 | 1.00000 | 11 Michelle Branch | 11 | 3.00000 | 1.00000 | 11 Tori Amos | 60 | 2.95000 | 0.85222 | 60 Rodgers & Hammerstein | 16 | 2.93750 | 0.77190 | 16 NSync | 26 | 2.92308 | 0.84489 | 26 Everclear | 13 | 2.92308 | 1.03775 | 13 Brian Jacobs | 22 | 2.90909 | 0.75018 | 22 The Calling | 11 | 2.90909 | 0.70065 | 11 U2 | 32 | 2.90625 | 0.81752 | 32 Cher | 10 | 2.90000 | 1.10050 | 10 Sting | 34 | 2.88235 | 0.59108 | 34 Sarah McLachlan | 15 | 2.86667 | 0.74322 | 15 Clandestine | 12 | 2.83333 | 0.57735 | 12 Northwestern University Purple Haze | 12 | 2.83333 | 0.93744 | 12 Boyz II Men | 23 | 2.82609 | 0.83406 | 23 Vanessa Carlton | 22 | 2.81818 | 0.90692 | 22 "Weird Al" Yankovic | 11 | 2.81818 | 0.98165 | 11 Austin Lounge Lizards | 47 | 2.78723 | 0.83239 | 47 University of Rochester Midnight Ramblers | 14 | 2.78571 | 0.69929 | 25 Matchbox 20 | 13 | 2.76923 | 0.83205 | 13 Coldplay | 34 | 2.76471 | 0.74096 | 34 The Beatles | 27 | 2.74074 | 0.76423 | 27 Kathy Troccoli | 10 | 2.70000 | 0.82327 | 10 Mark Douthit, Jeff Kirk, Dann Huff, Craig Nelson, David Huntsinger, John Darnall, Eric Darken | 10 | 2.70000 | 0.67495 | 10 The American Film Orchestra | 10 | 2.70000 | 0.82327 | 10 Maroon 5 | 12 | 2.66667 | 0.88763 | 12 Natalie Imbruglia | 12 | 2.66667 | 0.65134 | 12 UGA Accidentals | 6 | 2.66667 | 0.51640 | 6 Dido | 23 | 2.65217 | 0.93462 | 23 John Tesh | 17 | 2.64706 | 0.78591 | 17 Original Soundtrack | 19 | 2.63158 | 0.76089 | 19 Rockapella | 35 | 2.62857 | 0.68966 | 35 All-Region Choir | 16 | 2.62500 | 0.50000 | 16 The Blues Brothers Band | 8 | 2.62500 | 0.74402 | 8 Fountains Of Wayne | 18 | 2.61111 | 0.69780 | 46 David Arnold | 15 | 2.60000 | 0.82808 | 15 Creed | 10 | 2.60000 | 0.84327 | 10 Sensuous Sax | 10 | 2.60000 | 0.51640 | 10 TV Themes | 65 | 2.58462 | 0.89952 | 65 Christina Aguilera | 21 | 2.57143 | 0.97834 | 21 The Christmas Revels | 21 | 2.57143 | 0.59761 | 21 Celine Dion | 14 | 2.57143 | 0.93761 | 14 E.J. Jones | 9 | 2.55556 | 0.52705 | 9 John Mayer | 13 | 2.53846 | 0.51887 | 14 Mannheim Steamroller | 13 | 2.53846 | 0.51887 | 29 Mighty Mighty Bosstones | 13 | 2.53846 | 0.77625 | 13 Queen | 28 | 2.53571 | 0.57620 | 28 Badelt, Klaus | 15 | 2.53333 | 0.63994 | 15 Jackson Browne | 19 | 2.52632 | 0.51299 | 19 Linkin Park | 25 | 2.52000 | 0.77028 | 25 Danny Elfman | 26 | 2.50000 | 0.64807 | 26 Michael Jackson | 22 | 2.50000 | 0.67259 | 22 George Winston | 16 | 2.50000 | 0.89443 | 16 Dirty Vegas | 12 | 2.50000 | 0.67420 | 12 Mark Knopfler (Princess Bride) | 12 | 2.50000 | 0.52223 | 12 Toni Braxton | 12 | 2.50000 | 0.52223 | 12 Sha-Na-Na | 6 | 2.50000 | 0.54772 | 6 Dave Matthews Band | 80 | 2.48750 | 0.50300 | 80 Metallica | 21 | 2.47619 | 0.81358 | 21 Backstreet Boys | 13 | 2.46154 | 0.51887 | 13 Eminem | 23 | 2.43478 | 0.72777 | 23 Jewel | 27 | 2.40741 | 0.50071 | 27 Journey | 32 | 2.40625 | 0.55992 | 32 Depeche Mode | 20 | 2.40000 | 0.59824 | 20 Blue Oyster Cult | 10 | 2.40000 | 0.51640 | 10 Don Henley | 10 | 2.40000 | 0.69921 | 10 Puddle of Mudd | 23 | 2.39130 | 0.49901 | 23 Kenny G | 26 | 2.38462 | 0.49614 | 26 The Brian Setzer Orchestra | 13 | 2.38462 | 0.65044 | 13 Wynton Marsalis and Ellis Marsalis | 13 | 2.38462 | 0.65044 | 13 Much Ado About Nothing | 24 | 2.37500 | 0.49454 | 24 Zero 7 | 14 | 2.35714 | 0.49725 | 14 John Williams | 36 | 2.33333 | 0.58554 | 36 Bernstein The Songbook | 21 | 2.33333 | 0.48305 | 21 Fuel | 12 | 2.33333 | 0.49237 | 12 The Wallflowers | 12 | 2.33333 | 0.49237 | 12 Asia | 9 | 2.33333 | 0.50000 | 9 Gorillaz | 9 | 2.33333 | 0.70711 | 9 Howard Shore | 16 | 2.31250 | 0.47871 | 16 Phil Collins | 16 | 2.31250 | 0.47871 | 16 Pet Shop Boys | 10 | 2.30000 | 0.48305 | 10 Aerosmith | 24 | 2.29167 | 0.46431 | 24 Kansas | 14 | 2.28571 | 0.46881 | 14 Enigma | 25 | 2.28000 | 0.67823 | 25 Rice Marching Owl Band | 25 | 2.28000 | 0.45826 | 25 George Michael | 11 | 2.27273 | 0.46710 | 11 Flying Fish Sailors | 15 | 2.26667 | 0.45774 | 15 Andrea Bocelli | 16 | 2.25000 | 0.68313 | 16 DJ Danger Mouse | 12 | 2.25000 | 0.45227 | 12 Jacques Loussier | 8 | 2.25000 | 0.46291 | 8 Lauridsen, Morten | 17 | 2.23529 | 0.43724 | 17 Verve Pipe | 13 | 2.23077 | 0.43853 | 13 Outkast | 19 | 2.21053 | 0.41885 | 19 Nimoy & Shatner, William Shatner | 24 | 2.20833 | 0.41485 | 24 Don McLean | 20 | 2.20000 | 0.52315 | 20 Ely Guerra | 11 | 2.18182 | 0.40452 | 11 John Barry | 17 | 2.17647 | 0.39295 | 17 Pink Floyd | 35 | 2.14286 | 0.35504 | 35 Buena Vista Social Club | 14 | 2.14286 | 0.36314 | 14 Men At Work | 14 | 2.14286 | 0.36314 | 14 The Cambridge Singers | 22 | 2.13636 | 0.46756 | 22 Michael Kamen | 30 | 2.13333 | 0.34575 | 30 Barry White | 20 | 2.10000 | 0.30779 | 20 Bellaire High School | 10 | 2.10000 | 0.31623 | 10 OutKast | 21 | 2.09524 | 0.30079 | 21 Herbert Blomstedt, San Francisco Symphony | 25 | 2.08000 | 0.27689 | 25 James Horner | 15 | 2.06667 | 0.25820 | 15 Jerry Goldsmith | 15 | 2.06667 | 0.25820 | 15 Car Talk | 24 | 2.00000 | 0.00000 | 24 Sviatoslav Richter | 22 | 2.00000 | 0.00000 | 22 Moffo/Tucker/Costa/Merrill | 18 | 2.00000 | 0.00000 | 18 Atlanta Symphony & Chorus | 16 | 2.00000 | 0.00000 | 16 Pinnock, The English Concert & Choir | 16 | 2.00000 | 0.00000 | 16 Wolfgang Amadeus Mozart | 14 | 2.00000 | 0.00000 | 14 Jennifer Molholt | 13 | 2.00000 | 0.00000 | 13 B.B.C. | 12 | 2.00000 | 0.00000 | 12 Sandra Boynton | 12 | 2.00000 | 0.00000 | 12 mc chris | 10 | 2.00000 | 0.00000 | 10 Chick Corea | 7 | 2.00000 | 0.00000 | 7 David Newman | 6 | 2.00000 | 0.00000 | 6 Leonard Bernstein | 6 | 2.00000 | 0.00000 | 6 Noteworthy | 5 | 2.00000 | 0.00000 | 5 (190 rows) Highest average rated artists with two to four tracks rated artist | numtracks | averagerating | stddev | totaltracks -------------------------------------------+-----------+---------------+---------+------------- Eels | 2 | 4.50000 | 0.70711 | 2 Jars Of Clay | 2 | 4.50000 | 0.70711 | 2 Letters to Cleo | 2 | 4.50000 | 0.70711 | 2 University of Southern California Sirens | 2 | 4.50000 | 0.70711 | 2 Antonio Banderas, Madonna | 3 | 4.00000 | 0.00000 | 3 Blink 182 | 2 | 4.00000 | 1.41421 | 2 Copeland | 2 | 4.00000 | 1.41421 | 2 Edmonson, Greg | 2 | 4.00000 | 1.41421 | 25 Liz Callaway | 2 | 4.00000 | 0.00000 | 2 Sister Hazel | 2 | 4.00000 | 0.00000 | 2 Stanford University Mixed Company | 2 | 4.00000 | 0.00000 | 2 Bostonians of Boston College | 2 | 3.50000 | 0.70711 | 2 Grover | 2 | 3.50000 | 2.12132 | 2 John Travolta and Olivia Newton-John | 2 | 3.50000 | 0.70711 | 2 Norman Blake | 2 | 3.50000 | 0.70711 | 2 R. Kelly | 2 | 3.50000 | 0.70711 | 2 Tar Heel Voices | 2 | 3.50000 | 0.70711 | 2 Tufts University Amalgamates | 2 | 3.50000 | 0.70711 | 2 University of North Carolina Clef Hangers | 2 | 3.50000 | 2.12132 | 2 Smash Mouth | 3 | 3.33333 | 1.15470 | 3 Madonna, Antonio Banderas | 3 | 3.00000 | 0.00000 | 3 Aural Pleasure | 2 | 3.00000 | 1.41421 | 2 Duke Ellington | 2 | 3.00000 | 0.00000 | 2 Gershwin | 2 | 3.00000 | 0.00000 | 2 Sympathetic Vibrations | 2 | 3.00000 | 0.00000 | 2 Virginia Tech Juxtaposition | 2 | 3.00000 | 0.00000 | 2 Commercial | 4 | 2.50000 | 0.57735 | 4 a-ha | 4 | 2.50000 | 0.57735 | 10 Count Basie | 2 | 2.50000 | 0.70711 | 2 Fletcher Henderson | 2 | 2.50000 | 0.70711 | 2 Grease | 2 | 2.50000 | 0.70711 | 2 Indiana University Straight No Chaser | 2 | 2.50000 | 0.70711 | 2 Leroy | 2 | 2.50000 | 0.70711 | 2 Macy Gray | 2 | 2.50000 | 0.70711 | 2 Olivia Newton-John | 2 | 2.50000 | 0.70711 | 2 Arvo P#rt | 3 | 2.33333 | 0.57735 | 3 Local Vocals | 3 | 2.33333 | 0.57735 | 3 Radio Sponsor | 4 | 2.25000 | 0.50000 | 4 The Kids | 4 | 2.25000 | 0.50000 | 4 Mozart, Wolfgang Amadeus/ Requiem | 4 | 2.00000 | 0.00000 | 4 Richard M. Nixon | 4 | 2.00000 | 0.00000 | 4 Ronald Reagan | 4 | 2.00000 | 0.00000 | 4 Evolution Control Committee | 3 | 2.00000 | 0.00000 | 3 Stanford Fleet Street Singers | 3 | 2.00000 | 0.00000 | 3 50 Cent | 2 | 2.00000 | 0.00000 | 2 Barbara Jordan | 2 | 2.00000 | 0.00000 | 2 Beastie Boys | 2 | 2.00000 | 0.00000 | 2 Bjork | 2 | 2.00000 | 0.00000 | 2 Cindy Bullens | 2 | 2.00000 | 0.00000 | 2 DJ Zebra | 2 | 2.00000 | 0.00000 | 2 Deodato | 2 | 2.00000 | 0.00000 | 2 Frankie Valli | 2 | 2.00000 | 0.00000 | 2 Franklin Delano Roosevelt | 2 | 2.00000 | 0.00000 | 2 Human League vs. Kylie Minogue | 2 | 2.00000 | 0.00000 | 2 John Hartford | 2 | 2.00000 | 0.00000 | 2 John Travolta | 2 | 2.00000 | 0.00000 | 2 Kenny Loggins | 2 | 2.00000 | 0.00000 | 2 Kermit the Frog | 2 | 2.00000 | 0.00000 | 2 Lazlow | 2 | 2.00000 | 0.00000 | 2 Lyndon Baines Johnson | 2 | 2.00000 | 0.00000 | 2 Madonna vs The Lovemakers | 2 | 2.00000 | 0.00000 | 2 Mark Ronson vs. Busta Rhymes | 2 | 2.00000 | 0.00000 | 2 Martin Luther King, Jr. | 2 | 2.00000 | 0.00000 | 2 Mongo Santamaria | 2 | 2.00000 | 0.00000 | 2 Penn Six-5000 | 2 | 2.00000 | 0.00000 | 2 Soggy Bottom Boys | 2 | 2.00000 | 0.00000 | 2 Stevie Wonder | 2 | 2.00000 | 0.00000 | 2 Stockard Channing | 2 | 2.00000 | 0.00000 | 2 Teena Marie | 2 | 2.00000 | 0.00000 | 2 The Cardigans | 2 | 2.00000 | 0.00000 | 2 The Pointer Sisters | 2 | 2.00000 | 0.00000 | 2 Vocal Tonic | 2 | 2.00000 | 0.00000 | 2 (72 rows) Highest average rated albums with at least one tracks rated album | numtracks | averagerating | stddev | totaltracks | mainartist ----------------------------------------------------------------------+-----------+---------------+---------+-------------+----------------------------------------------------------------------------------------------- Flood (CD Single) | 2 | 4.50000 | 0.70711 | 2 | Jars Of Clay Highlights From The Phantom Of The Opera | 13 | 4.46154 | 0.87706 | 13 | Webber, Andrew Lloyd Irish & Celtic Celebration | 12 | 4.33333 | 0.49237 | 12 | Barnes & Noble Stunt | 13 | 4.30769 | 0.63043 | 13 | Barenaked Ladies An old-fashioned Christmas | 19 | 4.26316 | 0.73349 | 19 | Alcoa Singers Flood | 19 | 4.26316 | 0.73349 | 19 | They Might Be Giants The Legend of Zelda : Original Sound Track | 82 | 4.21951 | 0.81687 | 82 | Nintendo Rent | 5 | 4.20000 | 1.09545 | 17 | Various No Timidity | 14 | 4.07143 | 0.73005 | 14 | The Rice Philharmonics Shrek | 13 | 4.00000 | 0.91287 | 13 | Fallen | 11 | 4.00000 | 0.89443 | 11 | Evanescence Firefly | 2 | 4.00000 | 1.41421 | 25 | Edmonson, Greg That Was The Year That Was | 2 | 4.00000 | 1.41421 | 14 | Tom Lehrer Strange Charm | 19 | 3.94737 | 0.77986 | 19 | Lager Rhythms All That Chaz | 12 | 3.91667 | 0.90034 | 12 | The Rice Philharmonics BOCA 2001 | 17 | 3.88235 | 0.99262 | 17 | Five Seconds To Spare | 12 | 3.83333 | 0.93744 | 12 | Apotheosis Running With Scissors | 12 | 3.83333 | 1.02986 | 12 | Weird Al Yankovic Steven Speilberg Presents Animaniacs | 16 | 3.81250 | 0.83417 | 16 | Animaniacs Annie | 15 | 3.80000 | 0.41404 | 15 | Annie Beaches | 10 | 3.80000 | 0.91894 | 10 | Beaches No Pads, No Helmets...Just Balls | 13 | 3.76923 | 0.59914 | 13 | Simple Plan Christmas Wonder | 20 | 3.75000 | 0.71635 | 20 | Rudy Davenport Little Earthquakes | 12 | 3.75000 | 0.96531 | 12 | Tori Amos Wicked | 19 | 3.73684 | 1.09758 | 19 | Stephen Schwartz The Abba Generation | 11 | 3.72727 | 0.46710 | 11 | A*Teens Miss Saigon (Highlights) | 14 | 3.71429 | 0.61125 | 14 | Alain Boubil & Claude-Michel Shonberg Scooby-Doo's Snack Tracks | 19 | 3.68421 | 1.49267 | 19 | Scooby Doo You're A Good Man, Charlie Brown | 15 | 3.66667 | 0.72375 | 15 | The New Broadway Cast Recording La Nouba | 12 | 3.66667 | 0.88763 | 12 | Cirque du Soleil The Lion King Soundtrack | 12 | 3.66667 | 1.15470 | 12 | The Lion King Calling All Angels | 11 | 3.63636 | 0.67420 | 11 | Train Company | 20 | 3.60000 | 0.88258 | 20 | 1995 Broadway Cast BOCA 2003 | 18 | 3.55556 | 0.70479 | 18 | A Life Of Saturdays | 11 | 3.54545 | 0.93420 | 11 | Dexter Freebish Savage Garden | 11 | 3.54545 | 0.93420 | 11 | Savage Garden Bleed American | 11 | 3.54545 | 1.12815 | 11 | Jimmy Eat World Go | 11 | 3.54545 | 0.68755 | 11 | Vertical Horizon [Scrubs] Soundtrack | 15 | 3.53333 | 0.91548 | 15 | Tarzan Soundtrack | 14 | 3.50000 | 1.16024 | 14 | Phil Collins & Mark Mancina Missundaztood | 14 | 3.50000 | 1.09193 | 14 | Pink Lifemiles | 10 | 3.50000 | 0.52705 | 10 | Sean Wood ACTS | 8 | 3.50000 | 0.53452 | 8 | ACTS Gotham City (Single) | 2 | 3.50000 | 0.70711 | 2 | R. Kelly Spamalot | 25 | 3.48000 | 1.04563 | 25 | John Du Prez & Eric Idle Employee Of The Month | 13 | 3.46154 | 0.87706 | 13 | Austin Lounge Lizards Go Simpsonic With The Simpsons | 53 | 3.45283 | 0.86749 | 53 | The Simpsons Clueless Soundtrack | 14 | 3.42857 | 0.75593 | 14 | Mulan | 12 | 3.41667 | 1.24011 | 12 | Josie and the Pussycats Movie Soundtrack | 13 | 3.38462 | 0.96077 | 13 | Josie and the Pussycats Paint The Sky With Stars, The Best Of Enya | 16 | 3.37500 | 0.61914 | 16 | Enya VeggieTunes | 16 | 3.37500 | 1.08781 | 16 | Big Idea A Rush Of Blood To The Head | 11 | 3.36364 | 0.67420 | 11 | Coldplay A Scorching Day of Abstention | 14 | 3.35714 | 1.00821 | 14 | The Rice Philharmonics Cats | 15 | 3.33333 | 0.81650 | 15 | Cats Bridges and Breakdowns | 12 | 3.33333 | 0.88763 | 12 | The Rice Philharmonics BOCA 2002 | 19 | 3.31579 | 1.10818 | 19 | The Little Mermaid | 20 | 3.30000 | 1.03110 | 20 | Disney Songs From the Street - 35 Years of Music - Disc 3 | 21 | 3.28571 | 1.00712 | 21 | Everything You Want | 11 | 3.27273 | 0.64667 | 11 | Vertical Horizon Futures | 11 | 3.27273 | 0.90453 | 11 | Jimmy Eat World All That You Can't Leave Behind | 11 | 3.27273 | 0.78625 | 11 | U2 The Book Of Secrets | 8 | 3.25000 | 0.70711 | 8 | Loreena McKennitt Out Of The Vein | 13 | 3.23077 | 0.43853 | 13 | Third Eye Blind Darwin's Gambit | 10 | 3.20000 | 0.91894 | 10 | University of Rochester Yellowjackets Lost and Gone Forever | 10 | 3.20000 | 0.91894 | 10 | Guster Aladdin | 21 | 3.19048 | 0.67964 | 21 | Menken, Alan, Howard Ashman & Tim Rice Mario Fantasy | 21 | 3.19048 | 0.87287 | 21 | Video Game Pianist A Day Without Rain | 11 | 3.18182 | 0.98165 | 11 | Enya Back Into Your System | 12 | 3.16667 | 0.93744 | 12 | Saliva Evita | 19 | 3.15789 | 0.76472 | 19 | Cows With Guns: The Cow Pie Nation Cowpilation | 13 | 3.15385 | 0.98710 | 13 | Dana Lyons My Best Friend's Wedding | 13 | 3.15385 | 0.89872 | 13 | 10 Things I Hate About You | 14 | 3.14286 | 1.09945 | 14 | Titanic Soundtrack | 15 | 3.13333 | 0.74322 | 15 | Titanic Soundtrack (James Horner) The Hunchback Of Notre Dame | 15 | 3.13333 | 0.83381 | 15 | Various artists Beauty and the Beast | 15 | 3.13333 | 1.06010 | 15 | Beauty and the Beast Hercules | 24 | 3.12500 | 1.03472 | 24 | Menken, Alan & David Zippel Scarlet's Walk | 18 | 3.11111 | 0.75840 | 18 | Tori Amos Nature's Call | 9 | 3.11111 | 1.16667 | 9 | University of Rochester Yellowjackets The Prince of Egypt | 19 | 3.10526 | 1.19697 | 19 | Various Artists ABBA Gold: Greatest Hits | 19 | 3.10526 | 0.87526 | 19 | ABBA Fast Trax | 10 | 3.10000 | 1.19722 | 10 | Cooleyhighharmony | 10 | 3.10000 | 0.87560 | 10 | Boyz II Men Christmas in an Irish Castle | 31 | 3.09677 | 0.78972 | 31 | Revels Harmonium | 11 | 3.09091 | 0.94388 | 11 | Vanessa Carlton Hot Fuss | 11 | 3.09091 | 1.13618 | 11 | The Killers Mr. Holland's Opus - Original Motion Picture Soundtrack | 12 | 3.08333 | 0.79296 | 12 | Untie Me | 12 | 3.08333 | 0.79296 | 12 | Brian Jacobs Redhead | 12 | 3.08333 | 0.79296 | 12 | Bleu Metamorphosis | 13 | 3.07692 | 0.95407 | 13 | Hilary Duff Man @ Work | 13 | 3.07692 | 1.25576 | 13 | Colin Hay Fields Of Gold - The Best Of Sting 1984-1994 | 14 | 3.07143 | 0.61573 | 14 | Sting Gordon | 15 | 3.06667 | 1.03280 | 15 | Barenaked Ladies Testify To Love (The Very Best of Avalon) | 16 | 3.06250 | 0.99791 | 16 | Avalon Tom Lehrer Revisited | 15 | 3.00000 | 0.65465 | 15 | Tom Lehrer Dizzy Up The Girl | 13 | 3.00000 | 1.08012 | 13 | Goo Goo Dolls Free Willy | 12 | 3.00000 | 0.95346 | 12 | The Reason | 12 | 3.00000 | 0.95346 | 12 | Hoobastank Bad Hair Day | 12 | 3.00000 | 0.95346 | 12 | Weird Al Yankovic No Strings Attached | 12 | 3.00000 | 0.85280 | 12 | NSync The Spirit Room | 11 | 3.00000 | 1.00000 | 11 | Michelle Branch Details | 11 | 3.00000 | 1.09545 | 11 | Frou Frou The Joshua Tree | 11 | 3.00000 | 0.77460 | 11 | U2 The Better Life | 11 | 3.00000 | 0.63246 | 11 | 3 Doors Down Out-Of-State Plates | 2 | 3.00000 | 1.41421 | 30 | Fountains Of Wayne The Video Game Pianist Piano Collections | 24 | 2.95833 | 0.99909 | 24 | Video Game Pianist Variety Pack | 16 | 2.93750 | 0.92871 | 16 | Animaniacs The Sound Of Music | 16 | 2.93750 | 0.77190 | 16 | Rodgers & Hammerstein So Much For The Afterglow | 13 | 2.92308 | 1.03775 | 13 | Everclear Maroon | 12 | 2.91667 | 0.90034 | 12 | Barenaked Ladies Camino Palmero | 11 | 2.90909 | 0.70065 | 11 | The Calling Life For Rent | 11 | 2.90909 | 1.13618 | 11 | Dido Go West Young Man | 10 | 2.90000 | 0.99443 | 10 | Michael W. Smith Believe | 10 | 2.90000 | 1.10050 | 10 | Cher Christmas Chorale | 16 | 2.87500 | 0.71880 | 16 | Barnes & Noble Mirrorball | 14 | 2.85714 | 0.77033 | 14 | Sarah McLachlan Veggie Tunes 2 | 20 | 2.85000 | 0.87509 | 20 | Big Idea NSync | 13 | 2.84615 | 0.89872 | 13 | NSync To Anybody At All | 12 | 2.83333 | 0.57735 | 12 | Clandestine Hooray for Everything | 12 | 2.83333 | 0.93744 | 12 | Northwestern University Purple Haze Even Worse | 11 | 2.81818 | 0.98165 | 11 | "Weird Al" Yankovic Brand New Day | 10 | 2.80000 | 0.63246 | 10 | Sting The Blue Album | 14 | 2.78571 | 0.69929 | 14 | University of Rochester Midnight Ramblers Mad Season | 13 | 2.76923 | 0.83205 | 13 | Matchbox 20 Clarity | 13 | 2.76923 | 0.59914 | 13 | Jimmy Eat World Anastasia | 17 | 2.76471 | 0.83137 | 17 | Hybrid Theory | 12 | 2.75000 | 0.96531 | 12 | Linkin Park Lizard Vision | 12 | 2.75000 | 0.86603 | 12 | Austin Lounge Lizards 1 | 27 | 2.74074 | 0.76423 | 27 | The Beatles Rockapella: Live In Japan | 23 | 2.73913 | 0.75181 | 23 | Rockapella Now That's What I Call Music 15 | 20 | 2.70000 | 0.86450 | 20 | Two Faces | 10 | 2.70000 | 0.67495 | 10 | Brian Jacobs The Heart of Me | 10 | 2.70000 | 0.82327 | 10 | Kathy Troccoli Mercury Falling | 10 | 2.70000 | 0.48305 | 10 | Sting Sleepless in Seattle & Other Great Movie Hits | 10 | 2.70000 | 0.82327 | 10 | The American Film Orchestra Light Jazz Christmas | 10 | 2.70000 | 0.67495 | 10 | Mark Douthit, Jeff Kirk, Dann Huff, Craig Nelson, David Huntsinger, John Darnall, Eric Darken Bernstein Favorites: The Twentieth Century | 10 | 2.70000 | 0.94868 | 10 | Run Lola Run Soundtrack | 16 | 2.68750 | 0.70415 | 16 | Various Songs In The Key Of Springfield | 39 | 2.66667 | 0.73747 | 39 | The Simpsons GTA VC Disc 3 - Emotion 98.3 | 15 | 2.66667 | 0.61721 | 15 | Quidam | 12 | 2.66667 | 0.49237 | 12 | Cirque du Soleil Left Of The MIddle | 12 | 2.66667 | 0.65134 | 12 | Natalie Imbruglia Songs About Jane | 12 | 2.66667 | 0.88763 | 12 | Maroon 5 Under The Table And Dreaming | 12 | 2.66667 | 0.49237 | 12 | Dave Matthews Band From The Choirgirl Hotel | 12 | 2.66667 | 0.65134 | 12 | Tori Amos A Deeper Faith | 17 | 2.64706 | 0.78591 | 17 | John Tesh Greatest Hits | 17 | 2.64706 | 0.60634 | 17 | Queen S&M Disc 1 | 11 | 2.63636 | 1.02691 | 11 | Metallica Fiddler on the Roof (30th Anniv. Ed.) | 19 | 2.63158 | 0.76089 | 19 | Original Soundtrack 1998-1999 concert | 16 | 2.62500 | 0.50000 | 16 | All-Region Choir Going Somewhere | 13 | 2.61538 | 1.04391 | 13 | Colin Hay II | 13 | 2.61538 | 0.76795 | 13 | Boyz II Men Spirit | 13 | 2.61538 | 0.50637 | 13 | Jewel X&Y | 13 | 2.61538 | 0.65044 | 13 | Coldplay Tomorrow Never Dies | 15 | 2.60000 | 0.82808 | 15 | David Arnold Mission Impossible Soundtrack | 15 | 2.60000 | 0.82808 | 15 | The Movies | 10 | 2.60000 | 0.51640 | 10 | Sensuous Sax My Own Prison | 10 | 2.60000 | 0.84327 | 10 | Creed Television's Greatest Hits Volume 3 (70's & 80's) | 65 | 2.58462 | 0.89952 | 65 | TV Themes Everyday | 12 | 2.58333 | 0.51493 | 12 | Dave Matthews Band Spider-Man | 19 | 2.57895 | 0.69248 | 19 | Wassail! Wassail! Early American Christmas Music | 21 | 2.57143 | 0.59761 | 21 | The Christmas Revels Charlie and the Chocolate Factory Original Motion Picture Soundtrack | 21 | 2.57143 | 0.67612 | 21 | Danny Elfman Wasting Our Parents' Money | 21 | 2.57143 | 0.67612 | 21 | Falling Into You | 14 | 2.57143 | 0.93761 | 14 | Celine Dion UGApalooza | 23 | 2.56522 | 0.66237 | 23 | Welcome Interstate Managers | 16 | 2.56250 | 0.62915 | 16 | Fountains Of Wayne Wow 2001 - Silver 1 | 16 | 2.56250 | 0.89209 | 16 | Blues Brothers 2000 | 18 | 2.55556 | 0.61570 | 18 | The Willow | 9 | 2.55556 | 0.52705 | 9 | E.J. Jones Be Not Nobody | 11 | 2.54545 | 0.82020 | 11 | Vanessa Carlton A Little South Of Sanity, CD1 | 11 | 2.54545 | 0.52223 | 11 | Aerosmith Room For Squares | 13 | 2.53846 | 0.51887 | 14 | John Mayer Classical Gas | 13 | 2.53846 | 0.51887 | 13 | Mannheim Steamroller Pirates of the Carribbean: The Curse of the Black Pearl | 15 | 2.53333 | 0.63994 | 15 | Badelt, Klaus Songs From the Street - 35 Years of Music Disc 2 | 21 | 2.52381 | 0.51177 | 21 | Linus & Lucy The Music Of Vince Guaraldi | 16 | 2.50000 | 0.89443 | 16 | George Winston The Essential Journey (Disc 1) | 16 | 2.50000 | 0.63246 | 16 | Journey Breathless | 14 | 2.50000 | 0.51887 | 14 | Kenny G The Princess Bride | 12 | 2.50000 | 0.52223 | 12 | Mark Knopfler (Princess Bride) Secrets | 12 | 2.50000 | 0.52223 | 12 | Toni Braxton Dirty Vegas | 12 | 2.50000 | 0.67420 | 12 | Dirty Vegas I'm Alive | 10 | 2.50000 | 0.52705 | 10 | Jackson Browne The Pretender | 8 | 2.50000 | 0.53452 | 8 | Jackson Browne Hunting High and Low | 4 | 2.50000 | 0.57735 | 10 | a-ha Black & Blue | 13 | 2.46154 | 0.51887 | 13 | Backstreet Boys Before These Crowded Streets | 11 | 2.45455 | 0.52223 | 11 | Dave Matthews Band Busted Stuff | 11 | 2.45455 | 0.52223 | 11 | Dave Matthews Band Paint Me On Velvet | 11 | 2.45455 | 0.52223 | 11 | Austin Lounge Lizards Stripped | 20 | 2.45000 | 0.82558 | 20 | Christina Aguilera Boys For Pele | 18 | 2.44444 | 0.51131 | 18 | Tori Amos Number Ones | 18 | 2.44444 | 0.61570 | 18 | Michael Jackson Stand Up | 14 | 2.42857 | 0.51355 | 14 | Dave Matthews Band Grease | 24 | 2.41667 | 0.65386 | 24 | No Angel | 12 | 2.41667 | 0.66856 | 12 | Dido Let's Face It | 12 | 2.41667 | 0.66856 | 12 | Mighty Mighty Bosstones Smilin' | 12 | 2.41667 | 0.51493 | 12 | Rockapella Life on Display | 12 | 2.41667 | 0.51493 | 12 | Puddle of Mudd Star Wars Episode 1: The Phantom Menace | 17 | 2.41176 | 0.61835 | 17 | John Williams GTA VC Disc 4 - Flash FM | 17 | 2.41176 | 0.50730 | 17 | 101 | 20 | 2.40000 | 0.59824 | 20 | Depeche Mode Encore | 20 | 2.40000 | 0.75394 | 20 | Eminem GTA VC Disc 2 - Wave 103 | 15 | 2.40000 | 0.63246 | 15 | Listener Supported (Disc 2) | 10 | 2.40000 | 0.51640 | 10 | Dave Matthews Band Super Hits | 10 | 2.40000 | 0.51640 | 18 | Blue Oyster Cult The End Of The Innocence | 10 | 2.40000 | 0.69921 | 10 | Don Henley Top Gun | 10 | 2.40000 | 0.51640 | 10 | Listener Supported (Disc 1) | 10 | 2.40000 | 0.51640 | 10 | Dave Matthews Band War | 10 | 2.40000 | 0.69921 | 10 | U2 O Brother, Where Art Thou? - Soundtrack | 18 | 2.38889 | 0.60768 | 18 | Joe Cool's Blues | 13 | 2.38462 | 0.65044 | 13 | Wynton Marsalis and Ellis Marsalis The Dirty Boogie | 13 | 2.38462 | 0.65044 | 13 | The Brian Setzer Orchestra Much Ado About Nothing | 24 | 2.37500 | 0.49454 | 24 | Much Ado About Nothing Rip Sample Mash Share | 16 | 2.37500 | 0.50000 | 16 | Small Minds | 11 | 2.36364 | 0.50452 | 11 | Austin Lounge Lizards The Game | 11 | 2.36364 | 0.50452 | 11 | Queen Come Clean | 11 | 2.36364 | 0.50452 | 11 | Puddle of Mudd Simple Things | 14 | 2.35714 | 0.49725 | 14 | Zero 7 The X-Files: The Album - Fight The Future | 14 | 2.35714 | 0.49725 | 14 | Wow 2001 - Blue Disc | 17 | 2.35294 | 0.49259 | 17 | An Anthology Of Big Band Swing (1930-1955) (Disc 1) | 20 | 2.35000 | 0.48936 | 20 | Bernstein The Songbook | 21 | 2.33333 | 0.48305 | 21 | Bernstein The Songbook The Lord of the Rings - The Fellowship of the Ring [OST] | 18 | 2.33333 | 0.48507 | 18 | Howard Shore The Wallflowers | 12 | 2.33333 | 0.49237 | 12 | The Wallflowers G Sides | 9 | 2.33333 | 0.70711 | 9 | Gorillaz Asia | 9 | 2.33333 | 0.50000 | 9 | Asia Litany | 3 | 2.33333 | 0.57735 | 3 | Arvo P#rt Phil Collins...Hits | 16 | 2.31250 | 0.47871 | 16 | Phil Collins The Essential Journey (Disc 2) | 16 | 2.31250 | 0.47871 | 16 | Journey Meteora | 13 | 2.30769 | 0.48038 | 13 | Linkin Park An Anthology Of Big Band Swing (1930-1955) (Disc 2) | 20 | 2.30000 | 0.47016 | 20 | Actually | 10 | 2.30000 | 0.48305 | 10 | Pet Shop Boys S&M Disc 2 | 10 | 2.30000 | 0.48305 | 10 | Metallica Parachutes | 10 | 2.30000 | 0.48305 | 10 | Coldplay Live at the Whisky | 14 | 2.28571 | 0.46881 | 14 | Kansas MCMXC a.D. | 7 | 2.28571 | 0.48795 | 7 | Enigma MOB Reborn | 25 | 2.28000 | 0.45826 | 25 | Rice Marching Owl Band Love Sensuality Devotion - The Greatest Hits | 18 | 2.27778 | 0.75190 | 18 | Enigma Faith | 11 | 2.27273 | 0.46710 | 11 | George Michael Sunburn | 11 | 2.27273 | 0.46710 | 11 | Fuel GTA VC Disc 7 - Espantoso | 15 | 2.26667 | 0.45774 | 15 | Loch Ness Monster | 15 | 2.26667 | 0.45774 | 15 | Flying Fish Sailors Harry Potter And The Sorcerer's Stone | 19 | 2.26316 | 0.56195 | 19 | John Williams Sacred Arias | 16 | 2.25000 | 0.68313 | 16 | Andrea Bocelli 8 Mile (Soundtrack) | 16 | 2.25000 | 0.44721 | 16 | The Gray Album | 12 | 2.25000 | 0.45227 | 12 | DJ Danger Mouse The Moment | 12 | 2.25000 | 0.45227 | 12 | Kenny G Play Bach | 8 | 2.25000 | 0.46291 | 8 | Jacques Loussier Songs from the Street - 35 Years of Music | 21 | 2.23810 | 0.43644 | 21 | Lux Aeterna | 17 | 2.23529 | 0.43724 | 17 | Lauridsen, Morten Free Music / Mash-Up | 300 | 2.23333 | 0.54148 | 300 | Villains | 13 | 2.23077 | 0.43853 | 13 | Verve Pipe The Dark Side Of The Moon | 9 | 2.22222 | 0.44096 | 9 | Pink Floyd Pieces of You | 14 | 2.21429 | 0.42582 | 14 | Jewel Speakerboxxx | 19 | 2.21053 | 0.41885 | 19 | Outkast Spaced Out - The Very Best of Leonard Nimoy, William Shatner | 24 | 2.20833 | 0.41485 | 24 | Nimoy & Shatner, William Shatner Band Of Brothers | 20 | 2.20000 | 0.41039 | 20 | Michael Kamen American Pie - The Greatest Hits | 20 | 2.20000 | 0.52315 | 20 | Don McLean Lotofire | 11 | 2.18182 | 0.40452 | 11 | Ely Guerra Dances with Wolves | 17 | 2.17647 | 0.39295 | 17 | John Barry Weird Al Yankovic | 12 | 2.16667 | 0.38925 | 12 | Weird Al Yankovic The Wall - Disc 2 | 13 | 2.15385 | 0.37553 | 13 | Pink Floyd Business As Usual | 14 | 2.14286 | 0.36314 | 14 | Men At Work Buena Vista Social Club | 14 | 2.14286 | 0.36314 | 14 | Buena Vista Social Club The John Rutter Collection | 22 | 2.13636 | 0.46756 | 22 | The Cambridge Singers GTA VC Disc 1 - V-Rock | 15 | 2.13333 | 0.35187 | 15 | Apollo 13 | 23 | 2.13043 | 0.34435 | 23 | James Horner All Time Greatest Hits | 20 | 2.10000 | 0.30779 | 20 | Barry White Avodath Hakodesh | 10 | 2.10000 | 0.31623 | 10 | Bellaire High School The Love Below | 21 | 2.09524 | 0.30079 | 21 | OutKast Orff: Carmina Burana | 25 | 2.08000 | 0.27689 | 25 | Herbert Blomstedt, San Francisco Symphony The Wall - Disc 1 | 13 | 2.07692 | 0.27735 | 13 | Pink Floyd GTA VC Disc 6 - Fever 105 | 15 | 2.06667 | 0.25820 | 15 | Sum of All Fears, The | 15 | 2.06667 | 0.25820 | 15 | Jerry Goldsmith GTA VC Disc 5 - Wildstyle Pirate Radio | 21 | 2.04762 | 0.21822 | 21 | Sviatoslav Richter - Vol. 7 - Rachmaninov | 22 | 2.00000 | 0.00000 | 22 | Sviatoslav Richter La Boheme - Highlights | 18 | 2.00000 | 0.00000 | 18 | Moffo/Tucker/Costa/Merrill Mozart - Coronation Mass | 16 | 2.00000 | 0.00000 | 16 | Pinnock, The English Concert & Choir Faur# and Durufl# Requiems | 16 | 2.00000 | 0.00000 | 16 | Atlanta Symphony & Chorus Karajan - Berliner | 14 | 2.00000 | 0.00000 | 14 | Wolfgang Amadeus Mozart Senior Recital | 13 | 2.00000 | 0.00000 | 13 | Jennifer Molholt Pigorian Chant | 12 | 2.00000 | 0.00000 | 12 | Sandra Boynton Hitchhikers Guide to the Galaxy | 12 | 2.00000 | 0.00000 | 12 | B.B.C. Best of Car Talk | 12 | 2.00000 | 0.00000 | 12 | Car Talk Second Best of Car Talk | 12 | 2.00000 | 0.00000 | 12 | Car Talk A Little South Of Sanity, CD2 | 11 | 2.00000 | 0.00000 | 11 | Aerosmith The Three Musketeers | 10 | 2.00000 | 0.00000 | 10 | Michael Kamen Life's A Bitch And I'm Her Pimp | 8 | 2.00000 | 0.00000 | 8 | mc chris The Gold Collection | 7 | 2.00000 | 0.00000 | 7 | Chick Corea Kaddish/Chichester Psalms | 6 | 2.00000 | 0.00000 | 6 | Leonard Bernstein Mozart, Wolfgang Amadeus/ Requiem | 4 | 2.00000 | 0.00000 | 4 | Mozart, Wolfgang Amadeus/ Requiem (292 rows) Genres in rating order genre | averagerating | stddev | numratedtracks | totaltracks ----------------+---------------+---------+----------------+------------- Podcast | | | | 10 Christmas | 3.34109 | 0.93955 | 129 | 145 A Capella | 3.20741 | 0.98007 | 270 | 281 Instrumental | 3.06667 | 0.93905 | 45 | 45 Electronic | 3.00000 | | 1 | 1 | 2.81429 | 0.91154 | 3597 | 3865 Rock | 2.25000 | 0.50000 | 4 | 4 Modern Rock | 2.25000 | 0.50000 | 4 | 4 Techno | 2.23214 | 0.54841 | 280 | 280 Easy Listening | 2.17647 | 0.39295 | 17 | 17 Classical | 2.07937 | 0.30778 | 189 | 334 Books & Spoken | 2.00000 | 0.00000 | 65 | 65 Hip-Hop | 2.00000 | | 1 | 1 (13 rows) Artists with most 5 star tracks artist | num5startracks | totaltracks ----------------------------------------------------+----------------+------------- Nintendo | 38 | 82 Scooby Doo | 10 | 19 The Rice Philharmonics | 10 | 52 Webber, Andrew Lloyd | 9 | 13 They Might Be Giants | 8 | 19 Alcoa Singers | 8 | 19 Stephen Schwartz | 6 | 19 Barenaked Ladies | 6 | 40 The Simpsons | 6 | 92 Lager Rhythms | 5 | 19 John Du Prez & Eric Idle | 5 | 25 Colin Hay | 5 | 28 Weird Al Yankovic | 5 | 36 TV Themes | 5 | 65 The Lion King | 4 | 12 Barnes & Noble | 4 | 28 Animaniacs | 4 | 32 Evanescence | 3 | 11 Pink | 3 | 14 Phil Collins & Mark Mancina | 3 | 14 Various Artists | 3 | 19 Disney | 3 | 20 Various | 3 | 34 Jimmy Eat World | 3 | 35 Tori Amos | 3 | 60 You're A Good Man, Charlie Brown | 2 | 6 Beaches | 2 | 10 Savage Garden | 2 | 11 Apotheosis | 2 | 12 Everclear | 2 | 13 Beauty and the Beast | 2 | 15 Avalon | 2 | 18 University of Rochester Yellowjackets | 2 | 19 Rudy Davenport | 2 | 20 1995 Broadway Cast | 2 | 20 Christina Aguilera | 2 | 21 Menken, Alan & David Zippel | 2 | 24 Big Idea | 2 | 36 Video Game Pianist | 2 | 45 University of Wisconsin Madison Tangled Up In Blue | 1 | 1 Baha Men | 1 | 1 Good Charlotte | 1 | 1 Jessica Riddle | 1 | 1 Rufus Wainwright | 1 | 1 Northwestern Univ. Purple Haze | 1 | 1 Hootie & The Blowfish with Elmo and The Kids | 1 | 1 Self | 1 | 1 Utah State That One | 1 | 1 Busted vs. Destiny's Child | 1 | 1 The Cast Of "My Best Friend's Wedding" | 1 | 1 Univ. of Rochester Midnight Ramblers | 1 | 1 Hoku | 1 | 1 Univ. of Southern Cal. SoCal Vocals | 1 | 1 Lea Salonga | 1 | 1 Univ. of Illinois Xtension Chords | 1 | 1 Beth Fowler, Marnie Nixon, Lea Salonga and Chorus | 1 | 1 Eddie Murphy | 1 | 1 Depeche Mode vs. Green Day | 1 | 1 Ursula 1000 | 1 | 1 Jars Of Clay | 1 | 2 University of Southern California Sirens | 1 | 2 Eels | 1 | 2 Blink 182 | 1 | 2 University of North Carolina Clef Hangers | 1 | 2 Copeland | 1 | 2 Grover | 1 | 2 Letters to Cleo | 1 | 2 Homestar Runner | 1 | 7 Cher | 1 | 10 The Killers | 1 | 11 Frou Frou | 1 | 11 Train | 1 | 11 "Weird Al" Yankovic | 1 | 11 Michelle Branch | 1 | 11 Michael W. Smith | 1 | 11 Dexter Freebish | 1 | 11 Northwestern University Purple Haze | 1 | 12 Hoobastank | 1 | 12 Saliva | 1 | 12 Simple Plan | 1 | 13 Hilary Duff | 1 | 13 Dana Lyons | 1 | 13 Josie and the Pussycats | 1 | 13 Goo Goo Dolls | 1 | 13 Alain Boubil & Claude-Michel Shonberg | 1 | 14 George Winston | 1 | 16 Metallica | 1 | 21 Vanessa Carlton | 1 | 22 Dido | 1 | 23 Cirque du Soleil | 1 | 24 Edmonson, Greg | 1 | 25 Linkin Park | 1 | 25 Enigma | 1 | 25 NSync | 1 | 26 Tom Lehrer | 1 | 29 U2 | 1 | 32 Enya | 1 | 41 Austin Lounge Lizards | 1 | 47 (98 rows) Albums with most 5 star tracks album | num5startracks | totaltracks | mainartist ----------------------------------------------------+----------------+-------------+--------------------------------------- The Legend of Zelda : Original Sound Track | 38 | 82 | Nintendo Scooby-Doo's Snack Tracks | 10 | 19 | Scooby Doo Highlights From The Phantom Of The Opera | 9 | 13 | Webber, Andrew Lloyd An old-fashioned Christmas | 8 | 19 | Alcoa Singers Flood | 8 | 19 | They Might Be Giants Wicked | 6 | 19 | Stephen Schwartz Go Simpsonic With The Simpsons | 6 | 53 | The Simpsons Stunt | 5 | 13 | Barenaked Ladies BOCA 2001 | 5 | 17 | Strange Charm | 5 | 19 | Lager Rhythms Spamalot | 5 | 25 | John Du Prez & Eric Idle Television's Greatest Hits Volume 3 (70's & 80's) | 5 | 65 | TV Themes Irish & Celtic Celebration | 4 | 12 | Barnes & Noble The Lion King Soundtrack | 4 | 12 | The Lion King Running With Scissors | 4 | 12 | Weird Al Yankovic Shrek | 4 | 13 | No Timidity | 4 | 14 | The Rice Philharmonics Fallen | 3 | 11 | Evanescence Bleed American | 3 | 11 | Jimmy Eat World All That Chaz | 3 | 12 | The Rice Philharmonics Little Earthquakes | 3 | 12 | Tori Amos Mulan | 3 | 12 | Tarzan Soundtrack | 3 | 14 | Phil Collins & Mark Mancina Missundaztood | 3 | 14 | Pink [Scrubs] Soundtrack | 3 | 15 | Steven Speilberg Presents Animaniacs | 3 | 16 | Animaniacs Rent | 3 | 17 | Various The Prince of Egypt | 3 | 19 | Various Artists The Little Mermaid | 3 | 20 | Disney Songs From the Street - 35 Years of Music - Disc 3 | 3 | 21 | Fast Trax | 2 | 10 | Beaches | 2 | 10 | Beaches Savage Garden | 2 | 11 | Savage Garden Five Seconds To Spare | 2 | 12 | Apotheosis So Much For The Afterglow | 2 | 13 | Everclear Man @ Work | 2 | 13 | Colin Hay 10 Things I Hate About You | 2 | 14 | A Scorching Day of Abstention | 2 | 14 | The Rice Philharmonics You're A Good Man, Charlie Brown | 2 | 15 | The New Broadway Cast Recording Beauty and the Beast | 2 | 15 | Beauty and the Beast VeggieTunes | 2 | 16 | Big Idea Testify To Love (The Very Best of Avalon) | 2 | 16 | Avalon BOCA 2002 | 2 | 19 | Christmas Wonder | 2 | 20 | Rudy Davenport Company | 2 | 20 | 1995 Broadway Cast Hercules | 2 | 24 | Menken, Alan & David Zippel The Video Game Pianist Piano Collections | 2 | 24 | Video Game Pianist Free Music / Mash-Up | 2 | 300 | Flood (CD Single) | 1 | 2 | Jars Of Clay Nature's Call | 1 | 9 | University of Rochester Yellowjackets Go West Young Man | 1 | 10 | Michael W. Smith Darwin's Gambit | 1 | 10 | University of Rochester Yellowjackets Bernstein Favorites: The Twentieth Century | 1 | 10 | Believe | 1 | 10 | Cher The Spirit Room | 1 | 11 | Michelle Branch Calling All Angels | 1 | 11 | Train Details | 1 | 11 | Frou Frou S&M Disc 1 | 1 | 11 | Metallica A Day Without Rain | 1 | 11 | Enya Harmonium | 1 | 11 | Vanessa Carlton Hot Fuss | 1 | 11 | The Killers A Life Of Saturdays | 1 | 11 | Dexter Freebish Even Worse | 1 | 11 | "Weird Al" Yankovic All That You Can't Leave Behind | 1 | 11 | U2 Life For Rent | 1 | 11 | Dido La Nouba | 1 | 12 | Cirque du Soleil Bridges and Breakdowns | 1 | 12 | The Rice Philharmonics The Reason | 1 | 12 | Hoobastank Hybrid Theory | 1 | 12 | Linkin Park Back Into Your System | 1 | 12 | Saliva Hooray for Everything | 1 | 12 | Northwestern University Purple Haze Bad Hair Day | 1 | 12 | Weird Al Yankovic Going Somewhere | 1 | 13 | Colin Hay No Pads, No Helmets...Just Balls | 1 | 13 | Simple Plan Josie and the Pussycats Movie Soundtrack | 1 | 13 | Josie and the Pussycats Dizzy Up The Girl | 1 | 13 | Goo Goo Dolls NSync | 1 | 13 | NSync Cows With Guns: The Cow Pie Nation Cowpilation | 1 | 13 | Dana Lyons Employee Of The Month | 1 | 13 | Austin Lounge Lizards My Best Friend's Wedding | 1 | 13 | Metamorphosis | 1 | 13 | Hilary Duff That Was The Year That Was | 1 | 14 | Tom Lehrer Miss Saigon (Highlights) | 1 | 14 | Alain Boubil & Claude-Michel Shonberg Gordon | 1 | 15 | Barenaked Ladies Variety Pack | 1 | 16 | Animaniacs Linus & Lucy The Music Of Vince Guaraldi | 1 | 16 | George Winston BOCA 2003 | 1 | 18 | Love Sensuality Devotion - The Greatest Hits | 1 | 18 | Enigma Stripped | 1 | 20 | Christina Aguilera Now That's What I Call Music 15 | 1 | 20 | Firefly | 1 | 25 | Edmonson, Greg (91 rows) Comments in rating order comments | averagerating | stddev | numratedtracks | totaltracks ---------------------------------------------------+---------------+---------+----------------+------------- [Christmas] | 4.33333 | 0.57735 | 3 | 19 [workout] | 3.00000 | | 1 | 1 [explicit] | 3.00000 | 1.41421 | 2 | 2 | 2.78483 | 0.91919 | 4285 | 4719 [wordless] | 2.67260 | 0.79255 | 281 | 281 VIX RIP | 2.00000 | | 1 | 1 visit www.mcchris.com and make $$ (this is a lie) | 2.00000 | | 1 | 1 [spoken] | 2.00000 | 0.00000 | 28 | 28 (8 rows) Artists with more than one song in order of number of songs artist | numtracks -----------------------------------------------------------------------------------------------+----------- The Simpsons | 92 Nintendo | 82 Dave Matthews Band | 80 TV Themes | 65 Tori Amos | 60 The Rice Philharmonics | 52 Austin Lounge Lizards | 47 Fountains Of Wayne | 46 Video Game Pianist | 45 Enya | 41 Barenaked Ladies | 40 Stephen Flaherty | 38 Weird Al Yankovic | 36 Big Idea | 36 John Williams | 36 Rockapella | 35 Pink Floyd | 35 Jimmy Eat World | 35 Various | 34 Coldplay | 34 Sting | 34 Animaniacs | 32 U2 | 32 Journey | 32 Revels | 31 Michael Kamen | 30 Mannheim Steamroller | 29 Tom Lehrer | 29 Barnes & Noble | 28 Queen | 28 Colin Hay | 28 Jewel | 27 The Beatles | 27 NSync | 26 Giuseppe Verdi | 26 Kenny G | 26 Danny Elfman | 26 John Du Prez & Eric Idle | 25 Herbert Blomstedt, San Francisco Symphony | 25 Edmonson, Greg | 25 University of Rochester Midnight Ramblers | 25 Rice Marching Owl Band | 25 Linkin Park | 25 Enigma | 25 Car Talk | 24 Aerosmith | 24 Nimoy & Shatner, William Shatner | 24 Much Ado About Nothing | 24 Menken, Alan & David Zippel | 24 Cirque du Soleil | 24 Eminem | 23 Puddle of Mudd | 23 Boyz II Men | 23 Dido | 23 | 22 Brian Jacobs | 22 Sviatoslav Richter | 22 Vanessa Carlton | 22 Vertical Horizon | 22 Michael Jackson | 22 The Cambridge Singers | 22 The Christmas Revels | 21 Christina Aguilera | 21 Metallica | 21 OutKast | 21 Menken, Alan, Howard Ashman & Tim Rice | 21 Bernstein The Songbook | 21 Rudy Davenport | 20 Barry White | 20 1995 Broadway Cast | 20 Don McLean | 20 Depeche Mode | 20 Disney | 20 Scooby Doo | 19 Lager Rhythms | 19 They Might Be Giants | 19 Original Soundtrack | 19 ABBA | 19 Stephen Schwartz | 19 Bowling For Soup | 19 Jackson Browne | 19 University of Rochester Yellowjackets | 19 Outkast | 19 Various Artists | 19 Alcoa Singers | 19 Tchaikovsky | 18 Avalon | 18 Moffo/Tucker/Costa/Merrill | 18 John Tesh | 17 John Barry | 17 Lauridsen, Morten | 17 Andrea Bocelli | 16 Beethoven | 16 Atlanta Symphony & Chorus | 16 Rodgers & Hammerstein | 16 Indigo Girls | 16 All-Region Choir | 16 Phil Collins | 16 George Winston | 16 Dmitri Shostakovich | 16 Pinnock, The English Concert & Choir | 16 Howard Shore | 16 Sarah McLachlan | 15 Cats | 15 David Arnold | 15 Badelt, Klaus | 15 Beauty and the Beast | 15 Jerry Goldsmith | 15 Annie | 15 Various artists | 15 James Horner | 15 Titanic Soundtrack (James Horner) | 15 Flying Fish Sailors | 15 John Mayer | 14 Wolfgang Amadeus Mozart | 14 Men At Work | 14 Pink | 14 Kansas | 14 Constantinople | 14 Buena Vista Social Club | 14 Celine Dion | 14 Zero 7 | 14 Phil Collins & Mark Mancina | 14 Alain Boubil & Claude-Michel Shonberg | 14 Simple Plan | 13 Mighty Mighty Bosstones | 13 Hilary Duff | 13 Dana Lyons | 13 Webber, Andrew Lloyd | 13 Matchbox 20 | 13 Josie and the Pussycats | 13 Backstreet Boys | 13 Verve Pipe | 13 Goo Goo Dolls | 13 Wynton Marsalis and Ellis Marsalis | 13 Third Eye Blind | 13 The Brian Setzer Orchestra | 13 Jennifer Molholt | 13 Everclear | 13 Madonna | 13 Bleu | 13 Mark Knopfler (Princess Bride) | 12 B.B.C. | 12 Clandestine | 12 Sonya Kitchell | 12 Natalie Imbruglia | 12 The Lion King | 12 Northwestern University Purple Haze | 12 Fuel | 12 Sandra Boynton | 12 Entourloupe | 12 Toni Braxton | 12 DJ Danger Mouse | 12 Apotheosis | 12 Hoobastank | 12 Maroon 5 | 12 Saliva | 12 Dirty Vegas | 12 The Wallflowers | 12 A*Teens | 11 George Michael | 11 The Killers | 11 Frou Frou | 11 3 Doors Down | 11 Train | 11 "Weird Al" Yankovic | 11 Savage Garden | 11 Evanescence | 11 Ely Guerra | 11 Michelle Branch | 11 Michael W. Smith | 11 Anna Nalick | 11 The Calling | 11 Dexter Freebish | 11 Guster | 10 mc chris | 10 Creed | 10 a-ha | 10 Kathy Troccoli | 10 Blue Oyster Cult | 10 Pet Shop Boys | 10 The American Film Orchestra | 10 Sean Wood | 10 Don Henley | 10 Cher | 10 Bellaire High School | 10 Mark Douthit, Jeff Kirk, Dann Huff, Craig Nelson, David Huntsinger, John Darnall, Eric Darken | 10 Sensuous Sax | 10 Beaches | 10 Asia | 9 The New Broadway Cast Recording | 9 E.J. Jones | 9 Gorillaz | 9 Aaron Copland | 8 Loreena McKennitt | 8 The Blues Brothers Band | 8 E. Power Biggs | 8 Dvorak - Mendelssohn | 8 Jacques Loussier | 8 ACTS | 8 Homestar Runner | 7 Chick Corea | 7 Evan & Paulie | 6 UGA Accidentals | 6 Sha-Na-Na | 6 You're A Good Man, Charlie Brown | 6 David Newman | 6 Leonard Bernstein | 6 Mozart | 6 Noteworthy | 5 Richard M. Nixon | 4 The Kids | 4 Johannes Brahms | 4 Commercial | 4 Ronald Reagan | 4 Radio Sponsor | 4 Mozart, Wolfgang Amadeus/ Requiem | 4 Arvo P#rt | 3 Local Vocals | 3 Vivaldi | 3 Bach | 3 Smash Mouth | 3 Greig | 3 Antonio Banderas, Madonna | 3 Strauss | 3 Madonna, Antonio Banderas | 3 Evolution Control Committee | 3 Schubert | 3 Stanford Fleet Street Singers | 3 Gershwin | 2 Sympathetic Vibrations | 2 Jars Of Clay | 2 Madonna vs The Lovemakers | 2 University of Southern California Sirens | 2 Cindy Bullens | 2 The Cardigans | 2 Vocal Tonic | 2 Tar Heel Voices | 2 Virginia Tech Juxtaposition | 2 Kristine W | 2 Stevie Wonder | 2 Lazlow | 2 Stanford University Mixed Company | 2 Bostonians of Boston College | 2 Chopin | 2 Gay Talk - With Gay Paulie and Gay Evan who are both so Gay Gay Gay | 2 Norman Blake | 2 Franklin Delano Roosevelt | 2 Mongo Santamaria | 2 Martin Luther King, Jr. | 2 Human League vs. Kylie Minogue | 2 Mark Ronson vs. Busta Rhymes | 2 The Pointer Sisters | 2 Fletcher Henderson | 2 John Hartford | 2 Bizet | 2 Teena Marie | 2 Eels | 2 Blink 182 | 2 DJ Zebra | 2 Leroy | 2 Count Basie | 2 Deodato | 2 Bjork | 2 Duke Ellington | 2 Frankie Valli | 2 University of North Carolina Clef Hangers | 2 John Travolta | 2 Rossini | 2 Copeland | 2 Brahms | 2 Macy Gray | 2 50 Cent | 2 Stockard Channing | 2 John Travolta and Olivia Newton-John | 2 Kermit the Frog | 2 Mendelssohn | 2 Penn Six-5000 | 2 Kenny Loggins | 2 Grease | 2 Barbara Jordan | 2 Aural Pleasure | 2 Grover | 2 Indiana University Straight No Chaser | 2 Letters to Cleo | 2 R. Kelly | 2 Soggy Bottom Boys | 2 Beastie Boys | 2 Lyndon Baines Johnson | 2 Tufts University Amalgamates | 2 Sister Hazel | 2 Liz Callaway | 2 Olivia Newton-John | 2 (293 rows) Total number of tracks played sum ------ 7980 (1 row) Total time listened to music days | hours | minutes | seconds ------+-------+---------+--------- 18 | 6 | 19 | 9 (1 row)