musiccaps_details (view)
3 rows where musiccaps_aspects contains "no percussion", musiccaps_aspects contains "trombone" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- no percussion · 3 ✖
- trombone · 3 ✖
- instrumental 2
- moderate tempo 2
- no voice 2
- brass instruments 1
- brass quintet 1
- epic mood 1
- french horn 1
- horn 1
- instrumental music 1
- jazz song 1
- minimal instruments 1
- no string instruments 1
- no voices 1
- orchestra song 1
- orchestral music 1
- piano 1
- relaxing song 1
- repetitive melody 1
- slow tempo 1
- symphonic feel 1
- symphonic song 1
- trumpet 1
- tuba 1
- uplifting mood 1
musiccaps_names (array) 4 ✖
- Brass instrument · 3 ✖
- Trombone 3
- Trumpet 2
- French horn 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
WMB-14-002 ルパン三世のテーマ'78(トロンボーン・ソロ) | This jazz song is an instrumental song featuring a trombone playing the main melody. The trombone is accompanied by a piano playing chords using jazz rhythms. The tone changes at the end to an uplifting mood. There is no percussion in this song. This song can be used in a highway driving scene in a movie. | 2014-02-28T03:40:24Z | めちゃモテ・シリーズ | ★管楽器プレイヤーのための新しいソロ楽譜"めちゃモテ"シリーズ ~トロンボーン~ 演奏:前田大輔 編曲:前田大輔、小林真人 大野雄二によって作曲された、モンキー・パンチ原作のテレビアニメ「ルパン三世」の主題歌。数多くのテーマがある中で最も親しまれている「ルパン三世TV第2シリーズ」で使用されたヴァージョンとなっています。 原曲の雰囲気を生かしたアレンジになっており、誰でもカッコ良く演奏できる一曲です。 演奏に使われている楽譜の購入はコチラから ↓伴奏CD付楽譜 http://brass.winds-score.com/?pid=71753227 | ["Brass instrument", "Trombone"] | ["jazz song", "trombone", "piano", "no percussion", "no voice", "instrumental", "minimal instruments", "moderate tempo", "repetitive melody", "uplifting mood"] | 0 | AlVr7-ntuqw | 1166 | |
Giovanni Gabrieli Sacra Symphonia Sonata Pian'e Forte | This song features the brass section of a symphonic orchestra. The melody is played on trumpets. It is accompanied by a trombone and a brass horn playing individual parts. This song is at a slow tempo and has a relaxing feel. There are no voices in this song. There is no percussion in this song. This song can be played when a hero is returning victorious from a battle. | 2010-06-23T21:36:58Z | Maurizio De Marco | Zubin Metha conducts The Brass Section of the Bayerische Staatsoper | ["Brass instrument", "Trombone", "Trumpet"] | ["brass instruments", "orchestral music", "trombone", "symphonic feel", "horn", "no percussion", "instrumental music", "no voice", "slow tempo", "relaxing song"] | 0 | rQeikHMQGOM | 4876 | |
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 |
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;