musiccaps_details (view)
1 row where musiccaps_aspects contains "epic", musiccaps_aspects contains "reverberant" and musiccaps_names contains "Trombone"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
STS 2015 Faculty Orchestral Excerpts masterclass | The recording features a brass quartet playing in a reverberant space. It consists of synchronized trombone melody and it sounds passionate, epic and powerful. | 2015-08-19T18:58:12Z | Southeast Trombone Symposium | The faculty of the 2015 Southeast Trombone Symposium present a low brass orchestral excerpts masterclass at STS 2015. For a listing of the excerpts and start times look a little further down in the description. Featured in this video are STS 2015 Faculty Colin Williams and George Curran (New York Philharmonic), Nathan Zgonc and Brian Hecht (Atlanta Symphony Orchestra), James Nova (Pittsburgh Symphony), Bradley Palmer (Columbus State University faculty). They are joined on tuba by Andrew Miller (Alabama Symphony, Columbus State University faculty). All of the STS faculty are S.E. Shires artists. The STS is held annually at the Schwob School of Music at Columbus State University in Columbus, Georgia. It is home to an orchestral excerpts competition, and the S.E. Shires Solo Competition. The winner of each competition received a new S.E. Shires custom trombone. www.columbusstate.edu/sts Excerpts performed in this video: 0:15 Berlioz - Hungarian March 0:54 Bruckner - Symphony #7 2:48 Brahms - Symphony #1 4:04 Respighi - Fountains of Rome 5:08 Shostakovich - Symphony #7 9:25 Strauss - Alpine Symphony 12:07 Brahms - Symphony #2 13:26 Tchaikovsky - Symphony #6 14:12 Wagner - Ring Cycle 16:26 Holst - The Planets 19:18 Nielsen - Symphony #4 20:30 Bruckner - Symphony #8 | ["Brass instrument", "Trombone"] | ["brass quartet", "synchronized trombone melody", "reverberant", "passionate", "epic", "powerful"] | 4 | IizUHzmcPGA | 1932 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;