musiccaps_details (view)
3 rows where musiccaps_aspects contains "no other instruments" and musiccaps_names contains "Trombone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- instrumental 3
- no other instruments · 3 ✖
- no voices 3
- no percussion 2
- battle song 1
- brass band 1
- brass section 1
- horn section 1
- low quality recording 1
- moderate tempo 1
- motivational music 1
- orchestra music 1
- orchestral song 1
- slow tempo 1
- symphonic song 1
- three part melody 1
- trio 1
- trombone song 1
- trumpet 1
- tuba 1
- victorious mood 1
musiccaps_names (array) 4 ✖
- Brass instrument 3
- Trombone · 3 ✖
- French horn 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Britten: War Requiem / Rattle · Rundfunkchor Berlin · Berliner Philharmoniker | This song features the main melody played on a french horn and on a trumpet. The first part of the song is played on a french horn and the melody is continued on the trumpet. There are no other instruments in this song. The trumpet plays a battle call pattern. This is an instrumental song. There are no voices in this song. This song can be played just before a battle scene in a movie. | 2013-07-30T09:00:13Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/3470/?a=youtube&c=true Benjamin Britten: War Requiem / Sir Simon Rattle, conductor · Simon Halsey, chorus master · Rundfunkchor Berlin · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 15 June 2013. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["orchestra music", "horn section", "brass section", "no other instruments", "no percussion", "no voices", "instrumental", "battle song", "slow tempo"] | 0 | IGAzIIZRczw | 1887 | |
スターライトハイウェイ本番 | This song features three trombones playing different parts. One trombone plays the bass part. A second trombone outlines the chords being played. The third trombone plays the main melody. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. The mood of this song is motivational. The song can be played in an adventure movie just before the adventure begins. | 2012-05-11T13:47:00Z | TROMLEGACY746 | トリオーズ本番です。 第35回神奈川県アンサンブルコンテスト 1st...伊藤 2nd...佐々木 3rd...寺尾 | ["Brass instrument", "Trombone"] | ["trombone song", "trio", "three part melody", "motivational music", "instrumental", "no voices", "no other instruments"] | 0 | JZyw6YUsGzo | 2020 | |
Philippine Graduation March (a.k.a. "Martsang Pandangal") | This orchestral song features a brass band. The main melody is played on the trumpet. The bass is played on a tuba. There are other brass instruments playing in harmony in the background. There is no percussion in this song. There is no voice in this song. The mood of this song is victorious. This song can be played when a champion takes the podium in a classic event such as fencing or an equestrian event. | 2015-03-28T12:08:02Z | Infinitri Creatives | This audio is commonly used in school year-end recognition and graduation events in the Philippines. It is based on the second act of grand opera of Giuseppe Verdi, "Aida". The piece also influenced the composition of the Philippine National Anthem, according to its composer, Julián Felipe. *source of info: http://malacanang.gov.ph/7815-the-national-anthems-predecessor-and-influences/ **Uploaded for educational/promotional purposes only. | ["Brass instrument", "Trombone"] | ["brass band", "symphonic song", "orchestral song", "low quality recording", "trumpet", "tuba", "no percussion", "moderate tempo", "no other instruments", "instrumental", "no voices", "victorious mood"] | 0 | rQcecqZtGvE | 4875 |
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;