Book Database Stats

Moving my shelves around in my room finally gave me a reason to add the last of my books to my database, since all the books needed to be pulled off and resorted anyways.  So here are a few random (and likely uninteresting) stats pulled from it.  (You have been warned.  No complaining afterwards if you actually read this.)

There are a total of 357 books entered in the database, with 260 distinct authors and 128 distinct publishers, for a total of 123 729 pages.  (Actually, the page count is higher.  There are 3 books with no page numbers, and therefore are represented by a page count of 0 in the database.)  Of these books, 273 are categorised as fiction, and 84 are listed as non-fiction.  The average printing date is 1991 (for those books with a discernible printing date), and the average page count (excluding those three previously mentioned books) is 349.5 pages.

Now for some random "top 3" lists:

The three authors with the most books that I own:

1. Terry Pratchett (33 books.)
2. Lord Dunsany (11 books.)
3. Philip K. Dick and Harlan Ellison (10 books each, although at least one book [Dangerous Visions] with Ellison marked as the author also has the edited flag set — meaning that it was largely the work of other authors, and primarily edited by him.)

The three publishers with the most books that I own:

1. Penguin Books (29 books, not counting those published by its subsidiaries such as Puffin and Pelican.)
2. Corgi (25 books.)
3. DC Comics (11 books.  Yeah, my trade paperback collections of comics are in the database.  You got a problem with that?)

The three books with the oldest printing date that I own:

1. Lord Dunsany - Far Off Unhappy Things (Elkin Matthews, 1919.)
2. Lord Dunsany - Five Plays (Little, Brown, and Company, 1925.)
3. Ambrose Bierce - The Collected Writings of Ambrose Bierce (The Citadel Press, 1946.)

The three longest non-fiction books that I own:

1. Concise Oxford English Dictionary, Tenth Edition, Revised (Oxford University Press, 2002.  1708 pages.)
2. All Music Guide to Rock, 2nd Edition (Miller Freeman Books, 1997.  1232 pages.)
3. Fundamentals of Physics Extended, Fifth Edition (Wiley, 1997.  1142 pages.)  (Yes, the database includes dictionaries and textbooks.  It also includes all my cookbooks.  About the only printed matter it doesn't contain is magazines.)

The three longest fiction books that I own:

1. William Shakespeare - The Complete Works of William Shakespeare (Collins.  1433 pages.)
2. Miguel de Cervantes - Don Quixote (Modern Library, 2001.  1132 pages.)
3. Masterpieces of the Drama, Sixth Edition (Prentice Hall.  1036 pages.)

The three shortest books that I own:

1. Neil Gaiman - Shoggoth's Old Peculiar (Dreamhaven Books, 2004.  37 pages.)
2. Edgar Allen Poe - The Raven and Other Favorite Poems (Dover.  50 pages.)
3. Henrik Ibsen - Ghosts (Dover.  60 pages.)