musiccaps_details (view)
4 rows where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no percussion" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- instrumental 4
- no other instruments · 4 ✖
- no percussion · 4 ✖
- no voices 4
- moderate tempo 2
- slow tempo 2
- tuba 2
- battle song 1
- brass band 1
- brass section 1
- clarinet 1
- classical instrumental song 1
- french horn 1
- horn section 1
- instrumental song 1
- low quality recording 1
- orchestra music 1
- orchestral song 1
- piano 1
- relaxing music 1
- symphonic song 1
- trumpet 1
- victorious mood 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
R. Gliere four pieces for horn and piano Op.35 | This instrumental song features a run played on a piano followed by an ascending progression on the French horn. The horn plays descending notes and the piano repeats the same melody using arpeggiated chords. This is followed by two ascending notes on the horn. There are no other instruments in this song. This song has a relaxing feel. This song can be played in a bar. | 2014-03-02T12:47:13Z | Sergey Lee Akimov | Horn: Sergey Akimov Piano: Minjee Lee 1. Romance 2. Waltz 3. Nocturne 4. Intermezzo The second piece, Waltz is Gliere’s op. 45. From Sergey Akimov's horn recital that took place on 17 Feb 2014 at Seoul Arts Center Recital Hall. | ["Brass instrument", "French horn"] | ["classical instrumental song", "piano", "french horn", "instrumental", "no voices", "no percussion", "no other instruments", "slow tempo", "relaxing music"] | 0 | 2IpapScfsT4 | 350 | |
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 | |
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 | |
Aunque no sea conmigo (solo de clarinete) | This instrumental song features a tuba and a clarinet. The tuba plays the bass part of the song. The clarinet plays the high notes. This song does not have any voices. There is no percussion in this song. This song can be played in a comedy movie. | 2016-04-01T06:34:06Z | Edgar Vigil Castillo | Aunque no sea conmigo Edgar Clarinete, Eddy Tuba | ["Brass instrument", "Clarinet"] | ["instrumental song", "tuba", "clarinet", "no percussion", "no voices", "instrumental", "no other instruments", "moderate tempo"] | 0 | vG0FGgJlDGw | 5169 |
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;