musiccaps_details (view)
3 rows where musiccaps_aspects contains "no voices" and musiccaps_aspects contains "trumpet" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- instrumental 3
- no voices · 3 ✖
- trumpet · 3 ✖
- tuba 3
- moderate tempo 2
- no percussion 2
- symphonic song 2
- accordion 1
- brass band 1
- brass quintet 1
- clarinet 1
- epic mood 1
- folk song 1
- french horn 1
- guitar 1
- low quality audio 1
- low quality recording 1
- no other instruments 1
- no string instruments 1
- orchestra song 1
- orchestral song 1
- slow tempo 1
- trombone 1
- victorious mood 1
musiccaps_names (array) 5 ✖
- Brass instrument 2
- Trombone 2
- Accordion 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Victor Ewald - Brass Quintet No. 1 - Mvt. 1 | This song features a brass quintet. The bass notes are played on a tuba. The main melody is played on the trumpets. This is backed by the trombone and French horn. There are no other instruments in this song. There are no voices in this song. This song is an instrumental song with an epic feel. This song can be played when a victorious protagonist enters the city after a battle in a movie. | 2009-03-04T06:47:17Z | Beth McDonald | Thoroughbred Brass Quintet Julian Kaplan, Andrew McGrannahan, trumpets John-Morgan Bush, horn Phil Steinmetz, trombone Beth McDonald, tuba Recorded at the University of Kentucky Fine Arts Building on 25 February 2009. UNEDITED | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["brass quintet", "symphonic song", "orchestra song", "tuba", "trumpet", "french horn", "trombone", "no string instruments", "no percussion", "no voices", "instrumental", "epic mood", "moderate tempo"] | 0 | tr2iVjsu4xs | 5071 | |
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 |
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;