COMPLETED: Creating a searchable database of all my thousands of LP recordings.

Gentle reader,

After many, many hours over several days, I have at last completed the task of entering every LP record (plus the few ten and seven inch records) into a searchable database. It was a daunting task, but one I vowed I would complete once I was retired.

I started this 3-Part post here: Creating a searchable database of all my thousands of LP recordings.

Then continued it here: PART TWO: Creating a searchable database of all my thousands of LP recordings.   

Rather than have you have to go back to the first one, here are photos of the LP collection:

Above is the Classical records. Housed in the only commercially made shelf.

 Above is Jazz, Herb Alpert, Baja Marimba Band, Al Hirt, Big Band, and others.

Above is the Classic Rock/Pop on the top shelves and film/TV scores/soundtracks on the bottom shelves.

The shelf I made in 1976 or so, with the help of my then-girlfriend's father. He was a wonderful man and shaped my life in several positive ways. He sold me the white walnut board that were from a tree he felled and had a sawmill cut into rough boards.

I'd started with the Classical records because they are the largest group and I had to start somewhere. Then the Jazz, etc. shelf both of which are in the listening room. I finished with the horizontal shelf (directly above) is next to me in the other room that comprises my double-man-caves.  Below are the results. There are many more fields that they could be broken down to, but frankly, I'm kind of tired!

While all my numbers were perfectly lined up in Word Perfect, here in Blog land, that doesn't happen. My partially-COD brain is SO OK with that.

CLASSICAL RECORD COLLECTION
860 INDIVIDUAL RECORD ALBUMS CONSISTING OF:

BOX SETS                                                    66
DOUBLE ALBUMS                                    14
TOTAL                                                         80

TOTAL ALBUMS                                     860
1+EXTRA DISCS                                     256
TOTAL DISCS                      1116   
PROMOTIONAL                                         8
AUDIOPHILE                                            22
DIRECT METAL MASTER                       2   
COLORED/CLEAR VINYL                       2
NOT RIAA CURVE (NAB)                         1
1812 OVER. W/CANNONS                      18
MONO                                                       136
QUADRAPHONIC                                    26
FOREIGN                                                 344
JAZZ RECORD COLLECTION   

ALBUMS                                                 384
DOUBLE ALBUMS                                 19
TOTAL DISCS                      403
PROMOTIONAL                                     11
AUDIOPHILE                                            1
DIRECT METAL MASTER                     1   
COLORED/CLEAR VINYL                     1
MONO                                                       68
QUADRAPHONIC                                    1
FOREIGN                                                 30
HERB ALPERT RECORD COLLECTION

ALBUMS                                                 55
DOUBLE ALBUM                                   1
FIVE LP BOX SET                                  1
TOTAL DISCS                      60
MONO                                                       8
FOREIGN                                               15


BAJA MARIMBA BAND COLLECTION

ALBUMS                                                12

TIJUANA BAND SPIN-OFFS/TRIBUTES COLLECTION
ALBUMS                                                 6
FOREIGN                                               3

AL HIRT RECORD COLLECTION

ALBUMS                                              24
DOUBLE ALBUM                                1
TOTAL                                25
FOREIGN                                             4
BIG BAND RECORD COLLECTION

ALBUMS                                           182
DOUBLE ALBUMS                           12 TOTAL                              220

5 LP BOX SETS                                   2
TRIPLE ALBUMS                              1
6 LP BOX SET                                     1
10 LP BOX SET                                   1

COMEDY RECORD COLLECTION

ALBUMS                                           48
DOUBLE ALBUMS                           2TOTAL                               50

INTERNATIONAL + BLUEGRASS RECORD COLLECTION
ALBUMS                                         18
FOREIGN                                       15
BLUEGRASS                                   3

MISCELLANEOUS/TEST RECORD COLLECTION
ALBUMS                                       18
DOUBLE ALBUM                         1TOTAL                                          19

CLASSIC ROCK/POP RECORD COLLECTION
ALBUMS                                    257   
DOUBLE ALBUMS                   15
TOTAL                        270
FOREIGN                                   81
MONO                                          7
QUADRAPHONIC                     1
AUDIOPHILE                             1       
CLEAR/COLORED VINYL      1

MOVIE/TV SCORE/SOUNDTRACK COLLECTION

ALBUMS                                 328
DOUBLE ALBUMS                 15
TOTAL                       343
PROMOTIONAL                     11
MONO                                       50
PICTURE DISC                         2

GRAND TOTAL                                      2,199
TOTAL DISCS                                         2,554
                   I decided that I might as well at least COUNT the CD collection. 

I did not count the INDIVIDUAL discs, nor any other parameters such as I have with the LPs.

COMPACT DISCS

BIG BAND                                11
CLASSICAL                           280
COMEDY                                   3
COUNTRY*                              2
HERB ALPERT                       27
JAZZ                                       260
POP                                           35
ROCK                                       59
SOUNDTRACK/SCORE      195
TEST                                         12
WESTERN                                 5
TOTAL                      890
SACD                                        22
HDCD                                       18
GRAND TOTAL                                       3089 

That number is total CONTAINERS holding one or more LP or CD, regardless of the sub categories such as STEREO, MONO, QUADRAPHONIC, FOREIGN,SACD or HDCD, etcetera. 

I decided to stop actively collecting LP records when I looked around and gauged how many I already had. I have bought some CDs but I never cataloged them.

I DID buy a replacement for a Doobie Brothers LP because the one I had was in bad shape. Plus, I plan to buy a replacement for another Classic Rock LP for the same reason. Finally, I plan to buy two Steely Dan LPs to complete the collection. That will bring the LP collection to 2,101.  

I'm almost 61, now retired and even if I played TEN LPs a day, which would be hard to do, it would take me more than 200 days to do so. I DID decide to start playing ALL of the SOUNDTRACK/SCORE LPs starting with the first 007 soundtrack/score. Once I have listened to all 343 LPs and 195 CDs, THEN I will decide what to listen to next.

Thanks once again, for your kindness and patience with my humble blog. SOON another milestone will be passed: Page Views are rapidly approaching 100,000! ALL THANKS TO YOU, MY GENTLE READERS!

Scott

June 30, 2017