
	Home Library Search News About the Project History Project Friends How To Help Resources Contact Read Me First Browse Collection Search Collection News & Announcements Project Overview Project Committee Associate Members How We Archive Sheet Music Project Beginnings Dana M. Bailey Collection Cooley-Selland Archives Vaclav Klimek Collection Chester Nettrower Collection Friends and Sponsors North Royalton Community Band Donate Public Domain Sheet Music Finding Missing Parts Transposing Parts Creating Scores Financial Support Essays, Guides & Papers Composer Info Library Field Key Part Shortforms Links Sitemap FAQ Public Domain & Copyright FAQ Contact Information

Library Field Descriptions

This page lists what each of the fields in the library database are used for. This information can be very helpful if you are searching the database for a specific type of piece.

List of fields:

pieceID
libraryNumber
acquisitionDate
collectionName
physicalSize
title
titleUnedited
subTitle
movements
composer
arranger
publisher
year
keywords
gradeLevel
gradeNotes
gradeGradedDate
gradeGradedBy
isListOfPartsKnown
isComplete
isPlayable
numberOfPartsWehave
partsDesc
partsMissingDesc
partsAddedDesc
partsNotes
includesFullScore
includesPartialScore
useCornetAsScore
isViewable
notes
libDateAdded
libAddedBy
libDateEdited
libEditedBy
libNotes

pieceID

number

This field is only used interally by the database.

libraryNumber

text

An identifier used by the music committee. This identifier is unique for each piece.

acquisitionDate

yyyy-mm-dd

Date the piece of music was acquired by the library.

collectionName

text

Name of the collection the piece is part of (if applicable).

If a this piece came from a specific collection, the name of the collection. If the piece is not part of a specific collection, this field is left blank.

Current collections are:

"VaclavKlimek"
"DanaMBailey"
"ChesterNettrower"

physicalSize

MarchCard / Octavo / Folio / 9x12 / Oversize

The original paper format of the individual parts.

Explanation of the physical formats:

MarchCard -
Octavo -
Folio -
9x12 - 9 inches x 12 inches, the usual size for parts
Oversize - larger than 9 inches by 12 inches

title

text

The title of the piece.

If the title is very long, it may be entered here in a shortened form.

If the title begins with "the" or "an" this is put at the end (i.e., "The Booster" becomes "Booster, The".)

titleUnedited

text

The unedited title of the piece.

Title without the "the" or " being moved to the end.

subTitle

text

If a piece has a secondary title and/or subtitle this is where it is listed.

movements

text

If a piece has separate movements, they will be listed here.

The suggested formats is (as in the case of Holst's 1st Suite in Eb):
1: Chaconne, 2: Intermezzo, 3: March

composer

text

Name of the composer, if known.

The composer name is listed in the format: LastName, FirstName

arranger

text

Name of the arranger, if there is one.

The arranger name is listed in the format: LastName, FirstName

publisher

text

Name of the publisher, if known.

year

yyyy

The year that the piece was published. If this is not known, this field is left blank.

keywords

text

This is a list of keywords separated by commas. The keywords themselves have no spaces in them.

The BandMusicPDF project's librarians try to stick to the following list of keywords:

animals, aviation, circus, college, nationalistic, dance, fillmore, foxtrot, indian,
march, military, oddity, onestep, patriotic, rag, slippery, smear, triumphal, trombone,
twostep, waltz, ethnic, expositions, fairs, flag, gallop, greatwar, inventions, military,
newspaper, polka, ragtime, religious, season, section, serviceclub, solo, song, states,
transportation, trombonesmear

Also if a piece is a solo feature for a particular instrument, that instrument name will be listed as a keyword as well:

clarinet, trumpet, flute, trombone, horn, tuba, oboe, cornet, euphonium, baritone, xylophone, marimba

To get a current list of the keywords that are in use: Run Get Keywords Query.

gradeLevel

text, usually a number of 1 to 6

This is left blank if the grade is not known.

We've consulted the Grade Level Chart published by American Band College to determine the difficulty level of each piece.

Observation:
For the most part, difficulty levels depend on Solo/First Clarinet and Solo/First Cornet parts, (occasionally Piccolo and Baritone parts as well.) During this time period, most of the remaining parts were less demanding. Consider that many town bands had their finest musicians on Solo/First Clarinet and Solo/First Cornet, Piccolo and Baritone, while other parts were covered by less experienced members, including the youngest performers. Also included in the evaluation is the complexity of the musical ideas, counterpoint, etc.

gradeNotes

text

Any notes about the grade assigned to the piece.

gradeGradedDate

yyyy-mm-dd

Note: This field is not publicly viewable.

When the piece was graded.

gradeGradedBy

text

Note: This field is not publicly viewable.

Who graded the piece.

isListOfPartsKnown

YES / NO

Do we know what parts the piece consists of?

Note: For pieces without a full score, this can be impossible to determine.

isComplete

YES / NO / UNKNOWN

Whether we have all the parts or not.

If the librarian doesn't know if it is complete or not, this field is set to UNKNOWN.

isPlayable

YES / NO / UNKNOWN

If the librarian knows if the piece is playable by a band (not missing too many parts) or not.

If the librarian doesn't know if it is playable or not, this field is set to UNKNOWN.

numberOfPartsWehave

number (count)

The number of parts we have.

This field is included to help users determine if a piece is for a large band or not.

If this field is different than the number of parts we have listed in the "partsDesc" field, use the number of parts listed in the "partDesc" field instead.

partsDesc

List of parts that exist.

The parts are listed as shortforms separated by commas.

The shortforms are as follows:

shortforms have no spaces in them and start with a capital letter
shortforms are usually ALL CAPS (some exceptions) with a number or letter on the end
the first part of the shortform says what instrument
the second part is the rank of the part
The rank of a part can be: 1, 2, 3, etc.
Special ranks are: "S" for solo, "R" for Repiano
Split parts are denoted with a slash, e.g., "CL2/3" for Bb Clarinets 2&3
Percussion parts are shown as "P1( )", "P2( )", "P3( )", etc.
Percussion parts list the instruments covered by the part in the brackets

List of Instruments:

FL     C  Flute
PIC    C  Piccolo
DbP    Db Piccolo
OB        Oboe
EHRN      English Horn
EbCL   Eb Clarinet
CL        Clarinet (in Bb)
ACL    Eb Alto Clarinet
BCL    Bb Bass Clarinet
BSN       Bassoon
CBSN      Contra Bassoon
SS        Soprano Sax
AS        Alto Sax
TS        Tenor Sax
BS        Bari Sax
BSS       Bass Sax

TP        Trumpet (in Bb)
EbTP   Eb Trumpet
FTP    F  Fanfare Trumpet
CT        Cornet (in Bb)
EbCT   Eb Cornet  
FLUG   Bb Flugel Horn  
FH        Horn in F (treble clef)
TB        Trombone (bass clef in C)
TBB       Bass Trombone (bass clef in C)
EU        Euphonium (bass clef in C)
EUTC      Euphonium, Treble Clef (in Bb)
TU        Tuba (bass clef in C)
P?(x, y)  Percussion (? = part number; x, y, etc. = instruments)
T         Timpani

=====

EbH    Eb Horn (treble clef in Eb)
TBTC      Trombone, Treble Clef (in Bb)
TH        Tenor Horn  (treble clef in Bb)
TUT       Tuba, Treble Clef (in Bb)
EbTU   Eb Tuba (bass clef in C)

=====

SD        Snare Drum
BD        Bass Drym
CYM       Cymbals
XYLO      Xylophone
BLS       Bells
CHMS      Chimes
DSET      Drum Set

Less Common Instruments:

FLEb     Eb Flute  (treble clef in Eb)
FLA      Alto Flute (treble clef in G)

CACL     Contra-Alto Clarinet (usually treble clef in Eb)
CBCL     Contrabass Clarinet (usually treble clef in Bb)
CLA      Clarinet in A
SNS      Sopranino Sax (treble clef in Eb)
CBS      Contrabass Sax (treble clef in Eb)
DG       Didgeridoo
KZ       Kazoo

Other Parts:

FS   Full Score
PS   Partial Score

Examples:

Using this system, gives the following shorthand.

CLS, CL1, CL2/3  -- Solo Bb Clarinet, Bb Clarinet 1, Bb Clarinet 2 and 3

P1(SD, BD), P2(XYLO)  -- two percussion parts
                          first percussion part: Snare Drum and Bass Drum
                          second percussion part: Xylophone

Very efficient... not easily mistaken...

partsMissingDesc

Listing of parts that are known to be missing.

This field uses the same format as the partsDesc field.

partsAddedDesc

Listing of parts that have been added. The two most usual parts to be added are C Piccolo (transposed from the Db Piccolo partss) or F Horn (transposed from the Eb Horn part).

This field uses the same format as the partsDesc field.

partsNotes

Place for notes to be left about the parts themselves.

includesFullScore

YES / NO / UNKNOWN

Whether a full score exists.

includesPartialScore

YES / NO / UNKNOWN

Whether a partial score exists.

useCornetAsScore

YES / NO / UNKNOWN / NOTAPPLICABLE

Is it recommended that the 1st/Solo Cornet Part be used to conduct the piece.

isViewable

YES / NO

If the piece is publicly viewable on the website or not.

notes

text

General comments/notes about the piece.

libDateAdded

yyyy-mm-dd

Date that the piece was added to the website.

libAddedBy

text

Note: This field is not publicly viewable.

Name of the librarian who added the piece to the website.

libDateEdited

yyyy-mm-dd

Date that the piece information was last edited.

libEditedBy

text

Note: This field is not publicly viewable.

Name of the librarian who last edited the piece information.

libNotes

text

Note: This field is not publicly viewable.

This is a place for the librarians to leave notes about the status of the piece.

Search the Collection

Browse the Collection