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)