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.
Quick link: What the part shortforms mean
pieceID
format: number (####) or number (####.#), leading zeros not used
A unique identifier for each entry in the database. Each entry has a single PDF file associated with it. This field is used internally by the database.
Once a number is assigned to an entry, that number never changes.
Each piece has an entry with a major number: e.g., 1 or 314
The major number entry (####) for a piece will have the main collection of parts:
If there are additional parts that were published separately such as
Conductor, F French Horn Parts, C Piccolo Parts, Parts people have written, or Contributed Parts,
these will be added as "Add-On Entries" (####.#):
Note: If a physical sheet of music has more than 1 piece of music on it, each
piece of must will have its own unique major number. If this occurs, a unique
major number is assigned for each piece, and a note is put in the libNotes field stating that there are multiple pieces on
the sheet. For example, pieces:
isViewableOnWebsite
format: YES/NO
If the piece is viewable on the website. Pieces are relased in batches of 10 or so at a time.
See also libDateReleased, libReleaseNotes, libDateReleaseEdited, and libReleaseEditedNotes.
isReadyForWebsite
format: YES/NO
If the piece is a candidate for release to the website.
Note: Even if a piece is ready for release, it may not be released yet - see isViewableOnWebsite field.
Only used by the BandMusicPDF.org librarians.
title
format: 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".)
See also titleUnedited.
filenameForWebsite
format: filename (no spaces, ends in ".pdf")
The filename of the PDF file containing the sheet music. Each piece in the
library has exactly one PDF file associated with it.
isPrintPlay
format: YES/NO
Original music for band from the 1880-1923 era generally has horn parts
written in Eb and piccolo parts in Db. A Print & Play piece has these parts
tranposed onto F horn and C Piccolo. Bass Clarinet parts may also be added. For
a modern band, you can essentially just "print" the piece and then
"play" it.
Default setting is NO, unless the piece has had the extra parts added.
collectionName
format: 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"
- "Cooley-Selland"
- "Ed Ballenger"
physicalSize
format: 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
titleUnedited
format: text
The unedited title of the piece.
Title without the "The" or "A" being moved to the end.
See also title.
subTitle
format: text
If a piece has a secondary title and/or subtitle this is where it is listed.
movements
format: 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
format: text
Name of the composer, if known.
The composer name is listed in the format: LastName, FirstName
arranger
format: text
Name of the arranger, if there is one.
The arranger name is listed in the format: LastName, FirstName
year
format: yyyy
The year that the piece was published. If this is not known, this field is left blank.
publisher
format: text
Name of the publisher, if known.
keywords
format: text
This is a list of keywords separated by commas. The keywords themselves have
no spaces in them. The first keyword listed indicates the type of piece (e.g., march).
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
Special Tool:
Get List of Keywords Currently In Use.
gradeLevel
format: 1 | 2 | 3 | 4 | 5 | 6 (grade level as per the American Band College)
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
format: text
Any notes about the grade assigned to the piece.
gradeGradedDate
format: yyyy-mm-dd
Note: This field is not publicly viewable.
When the piece was graded by one of our librarians.
gradeGradedBy
format: text
Note: This field is not publicly viewable.
Who graded the piece.
isListOfPartsKnown
format: YES / NO
Do we know what parts the piece consisted of when it was published?
Note: For pieces without a full score, this can often be impossible to determine.
isComplete
format: YES / NO / UNKNOWN
Whether we have all the parts or not, in terms of how the piece was originally published.
If the librarian doesn't know if it is complete or not, this field is set to UNKNOWN.
isPlayable
format: 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
format: 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
format: see below
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
format: see partsDec
Listing of parts that are known to be missing.
This field uses the same format as the partsDesc field.
partsAddedDesc
format: see partsDec
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
format: text
Place for notes to be left about the parts themselves.
includesFullScore
format: YES / NO / UNKNOWN
Whether the piece includes a full score.
includesPartialScore
format: YES / NO / UNKNOWN
Whether the piece includes a partial score.
useCornetAsScore
format: YES / NO / UNKNOWN / NOTAPPLICABLE
Is it recommended that the 1st/Solo Cornet Part be used to conduct the piece.
copyrightStatus
format: text
The current copyright status of the piece.
Only pieces that have entered the public domain in the USA are posted to the website.
Note: All pieces posted to the website will generally have "public domain,
published before 1923" in this field.
notes
format: text
General comments/notes about the piece.
libDateAdded
format: yyyy-mm-dd
Date that the piece was added to the BandMusicPDF library.
Note: This is different than the "libDateReleased". A piece usually exists for
quite some time in the library before it is released to the website. Releases
to the website are on a set schedule of about 10 releases per month.
libAddedBy
format: text
Note: This field is not publicly viewable.
Name of the librarian who added the piece to the website.
libDateEdited
format: yyyy-mm-dd
Date that the piece information was last edited.
libEditedBy
format: text
Note: This field is not publicly viewable.
Name of the librarian who last edited the piece information.
libNotes
format: text
This is a place for the librarians to leave notes about the status of the piece.
If a physical sheet of music has multiple pieces on it, a note listing what
pieces are on the sheet will be included here. See also pieceID.
libDateReleased
format: YYYY-MM-DD
Date the piece was first released on the website.
See also libDateAdded and libDateReleaseEdited.
libReleaseNotes
format: text
Any notes about the piece to accompany its release.
libDateReleaseEdited
format: YYYY-MM-DD
Date the piece was edited/modified, if it had been previously released. If a
piece is edited more than once after it has been released, the most recent edit
date is put in this field.
libReleaseEditedNotes
format: text
Notes to accompany the most recent edit to the piece that took place on the date of libDateReleaseEdited.
libReleaseHistory
format: text
If a piece has been edited more than once after it was release, additional
information about the edits made to the piece can be put in this field.
libReleaseNotesPrivate
format: text
Note: This field is not publicly viewable.
This is a place for the librarians to leave notes about the release status of the piece.
libNotesPrivate
format: text
Note: This field is not publicly viewable.
This is a place for the librarians to leave notes about the status of the piece.
|
