[Logo]   Some statistics on my print collection

...or at least the part that's been entered into the database so far.

This is a long page divided into sections, here are links to go directly to each section:

Several of the following sections have not yet been updated to limit to the print collection, they report totals of all items. But, since the print section is much better cataloged at this point, it's still a good guide...

Genre

Most of my print collection is Science Fiction, with a smattering of other genres. This table lists all the genres I've cataloged by the type of item and a total number of items. [Querying the DB right now, there are 11 things with no genre listed (last I checked, these were all articles, I haven't really decided, yet, how to do a genre classification for articles), these are not counted in the table below. Just in case you got inspired to add up numbers and see that the totals don't match the table on the general stats page.]

One difficulty that I had when marking genres is that I set the database up to have a single genre for each item. That made it difficult when I came to, for example, Science Fiction Mysteries (of which I have a whole book of stories as well as many others). I could have set up a special genre for each combination, but what I did was just mark them as the main genre (usually SF). I've been thinking about making the DB more generalized to support some items with multiple genres, but these are a small subset, and doing that is a lot of work. So, it gets put off...

Genre  Book  Periodical  Issue  Story  Article  Total   
Science Fiction  317005206843   
Mystery  01558064   
Spy  11000011   
Humor  11000011   
Autobiography  300003   
Suspense  100001   
Reference  100001   
Historical(Science) Fiction  100001   
Adventure  100001   
Book Genres non-SF Book Genres

These two pie charts show what fraction of the books are each genre (i.e. the first column of the preceding table, because that's the most interesting). The first pie chart shows the total graphically. But, the non-SF categories are hard to see in that, so there's another that just shows the non-SF Genres...

People

There are a total of 310 people (authors, editors, etc.) recorded for 937 items. There are 195 people with only one credit. There are 24 items with multiple authors and 6 items with multiple editors.

The person with the most credits is Isaac Asimov with 64 credits listed (60 as Author, 4 as Editor). Anyone surprised at who came out in that query? That wasn't precoded, the server just now did a query on the database to get that result. But I always knew who was going to be there. You can see more in the page that shows credits, which can be shown ordered by total credits with larger counts first.

Credits come in the following types:

Type Number of credits
Author 901
Editor 59
Illustrator 8
Psuedonym 8
Introduction 7
Adaptation 6
Story by 3
Maps by 1
Series Editor 1
Translator 1
Writing as 1

Books

I have a total of 346 books cataloged. They are broken down into the following types:

Type Number 
Science Fiction Book Club printing  249
Paperback  89
Hardcover  4
Paperback, Large format  4

The reason SFBC books are listed as a separate type is that while they are technically hardcover, the bindings are somewhere in between hardcover and paperback. I suspect they won't stand up quite as well as most hardcover books, even though they would qualify as hardcover if I didn't have a special category.

You can get a list of all books (separated into pages), or search for a particular book. You can look up a particular author/editor to get a list of their credits (both books and other items (stories, introductions, etc.))

Universes

Each item in the database may be labelled as being part of a related grouping by belonging to a particular, consistent, alternate "Universe". However, not all such related groups are labeled, yet. The table below shows the tags I've used for the various universes I've cataloged so far in the print media and how many related items of each type that are marked as in that universe. You can click on the universe name to do a search for all the items (not just print) tagged with that universe. There is also a page that lists universes in all item types.

Universe Name Book Story Total  
Star Trek  11011   
Doc Savage  808   
Myth  448   
Asimov (Foundation)  707   
Star Wars  707   
Xanth  707   
Asimov (Robot)  505   
Darcy  145   
Known Space  505   
Riverworld  505   
Clancy (Jack Ryan)  404   
HHGG  404   
Asimov (Galactic Empire)  303   
Heechee  303   
Titan  303   
Stainless Steel Rat  303   
Polesotechnic League  202   
The State  202   
Barsoom  101   
Universes of Books

The pie chart shows relative sizes of the universes (by count of books within my collection, universes are actually all the same size...I think). I only count books here. As you can see from the chart stories haven't really been tagged, yet. When they are that might be a separate chart or combined, I'm not sure at this point. So the pie is what universe books — that are marked (a total of 85) — are part of. There are other books in some of these same universes, but that haven't been tagged, yet.

Attributes

To allow more general info to be kept efficiently, each item can have a set of arbitrary attributes attached to it. These are identified by a tag (such as "subtitle") and a value (the actual subtitle in this case). These are used to keep track of any information that applies to only a small subset of items.

There are a total of 231 attributes assigned to print media.

Some general counts of the tagged attributes that are given to print items:

Attribute Tag Count of items Description (if the tag is not enough) 
Synopsis  80  A summary of what the item is about (i.e. the storyline, setting or background).  
ISBN  66    
SFBC#  47    
Subtitle  14    
Keys  5  Words or phrases that characterize or identify the content. These are usually things that appear in the content that might stand out enough to be worth searching on, or that appear in multiple items.  
Characters  4  Names of Characters that appear.  
Based  4    
Award  2  An award the item has been given.  
Note  2  A textual note about the item itself (in contrast to Synopsis which is about the content).  
Source  1    
Contains  1    
Refs  1    
Factoids  1    
Eval  1  A textual evaluation of the item. This is, of course, my opinion (contrast synopsis which is supposed to be more objective).  
Indexes  1    
Original-Title  1    


Web site designed, developed and hosted by MAP Network Engineering
MAP Network Engineering uses, supports and recommends Open Source software and open standards.
[Powered by NetBSD] Powered by Roxen [Powered by MySQL] [Open Source Iniative] [Self professed Hacker] [Best viewed with ANY browser] [Valid HTML 4.01!]
Use of the logos above does not imply endorsement by the respective organizations of MAP Network Engineering sites or services.
On the contrary it implies endorsement by MAP Network Engineering of those organizations or software.


Page generated 2021-03-04 at 20:54 GMT
Copyright © MMXXI Michael A. Patton


And finally, a random note:
Life is a Sexually Transmitted Disease, which is invariably fatal.