Example of metadata spreadsheet - jhu-library-applications/levy-api GitHub Wiki
| fileIdentifier | title | field_publish_date_text | field_publisher | field_subjects | field_dedicatee | field_item_author | field_box | field_item_id | field_full_title | lyricist | composer | field_instrumentation | boxitem | field_advertisement | field_plate_number | field_instrumentation_metadata | field_first_line_of_chorus | field_first_line | field_publish_date_year | arranger | no_role | pseudonym |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Levy-194-010 | King Of Swing. | 1936 | Gershwin Publishing Corporation; Chappell & Co., Inc., Rko Building., Rockefeller Center, New York, N.Y. | Dancing | Albert Stillman (Lyricist)|George Gershwin (Composer) | 194 | 010 | 194.010 - King Of Swing. | Albert Stillman | George Gershwin | Symbols for banjo, guitar, and ukulele. Piano and voice. | Johns Hopkins University, Levy Sheet Music Collection, Box 194, Item 010 | ads on back cover for selections from George Gershwin's "Porgy and Bess" | G-15-4 | banjo|guitar|piano|ukulele|voice | They're dancing at the Coronation | Before what's known as the Jazz Age | 1936 | ||||
| Levy-194-065 | Embraceable You. | 1930 | T.B. Harms Inc., New York | Love | Girl Crazy. | George Gershwin (Composer)|Ira Gershwin (Lyricist) | 194 | 065 | 194.065 - Embraceable You. | Ira Gershwin | George Gershwin | Names of chords for banjo and guitar. Symbols for ukulele. Duet. Piano and voice. | Johns Hopkins University, Levy Sheet Music Collection, Box 194, Item 065 | ad on back cover for George Gershwin's "Strike Up The Band" | S-353-4 | banjo|duet|guitar|piano|ukulele|voice | Embrace me | Dozens of girls would storm up | 1930 | |||
| Levy-194-066 | I Got Rhythm. | 1930 | T.B. Harms Inc., New York | Love | Girl Crazy. Signed by Ira Gershwin. | George Gershwin (Composer)|Ira Gershwin (Lyricist) | 194 | 066 | 194.066 - I Got Rhythm. | Ira Gershwin | George Gershwin | Piano and voice. Names of chords for banjo and guitar. Symbols for ukulele. | Johns Hopkins University, Levy Sheet Music Collection, Box 194, Item 066 | ad on back cover for George Gershwin's "Strike Up The Band" | S-354-4 | banjo|guitar|piano|ukulele|voice | I got rhythm | Days can be sunny | 1930 |
Notes:
- Names that will go into the field "people" are separated and listed in columns by relator term (for instance: lyricist, composer, arranger).
- Multiple entries in the same field should be separated by a pipe "|".
- Columns are named after the field's "machine name." More information about each field and its machine name can be found here.