musiccaps_details (view)
2 rows where musiccaps_aspects contains "epic", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "reverberant"
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 | |
Ennio Morricone Vienna 12.12.2007 (part 4) | The low quality recording features a live performance of an orchestra and it consists of loud brass melody, mellow woodwinds melody, suspenseful violin melody and muffled percussion. It sounds epic, powerful and passionate. The recording is in mono, a bit noisy and it is reverberant as it was performed in a large concert hall. | 2008-08-12T15:10:07Z | Tomáš Vlček | Ennio Morricone conducts his own music at Vienna Stadthalle - Ecstasy of gold (reprise). | ["String section", "Orchestra"] | ["low quality", "live performance", "noisy", "mono", "reverberant", "orchestra", "muffled", "epic", "powerful", "passionate", "suspenseful violin melody", "muffled percussion", "loud brass section melody", "mellow woodwinds melody"] | 4 | cJ80eZY03Yg | 3697 |
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;