Mechanical Music Digest  Archives
You Are Not Logged In Login/Get New Account
Please Log In. Accounts are free!
Logged In users are granted additional features including a more current version of the Archives and a simplified process for submitting articles.
Home Archives Calendar Gallery Store Links Info

End-of-Year Fundraising Drive In Progress. Please visit our home page to see this and other announcements: https://www.mmdigest.com     Thank you. --Jody

MMD > Archives > January 1997 > 1997.01.04 > 05Prev  Next


Data Base Rollography
By Robbie Rhodes

It believe it was collector Mike Montgomery who coined the name "Rollography", inspired by the "Discography" which lists all the trivia you need to know about jazz phonograph records!

This is an example of the fields I used in my data base of music rolls played by Fats Waller (or often J. Lawrence Cook):

date \number \title \composers \recuts \comments

8/23 QRS Haitian Blues by Lizzie Miles CC-244, BT-137046
2304 & Spencer Williams

(unk) Clark Haitian Blues (adapted from JC-86, MS-89.4
A-442 (A-roll) QRS 2304

6/24 QRS Clearing House Blues, by Webb CC-314
2661 The & Honesty

8/24 Stand A New Kind Of Man by Sidney Clare CC-245, BT-137219
0677 With a New Kind & Leon Flatow
Of Love For Me
The first entry for "Haitian Blues" might look like this in the text file version (.TXT or .TAB or .MRG) of the data base:

8/23\QRS 2304\Haitian Blues\L. Miles & Sp. Williams\CC-244, BT-137046\

In this example I used the backslash (\) as the field separator; another common separator for spreadsheets and data bases is the tab character. (But in e-mail its action is unpredictable.)

Other useful data fields not shown here are

   The condition of the roll in my collection
   The guy who owns the roll sitting in my collection
   The guy who owns an original copy (not a recut)
   The guy I think I loaned my roll to
   The guy I think I borrowed my roll from (!!)

I would like to trade this type of data with others. Anyone interested?

Robbie Rhodes

(Message sent Sun 5 Jan 1997, 00:55:40 GMT, from time zone GMT-0800.)

Key Words in Subject:  Base, Data, Rollography

Home    Archives    Calendar    Gallery    Store    Links    Info   


Enter text below to search the MMD Website with Google



CONTACT FORM: Click HERE to write to the editor, or to post a message about Mechanical Musical Instruments to the MMD

Unless otherwise noted, all opinions are those of the individual authors and may not represent those of the editors. Compilation copyright 1995-2024 by Jody Kravitz.

Please read our Republication Policy before copying information from or creating links to this web site.

Click HERE to contact the webmaster regarding problems with the website.

Please support publication of the MMD by donating online

Please Support Publication of the MMD with your Generous Donation

Pay via PayPal

No PayPal account required

                                     
Translate This Page