musiccaps_details (view)
2 rows where musiccaps_aspects contains "trombones", musiccaps_author = 6 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- trombones · 2 ✖
- acoustic drums 1
- acoustic piano 1
- baritone saxophone 1
- brass ensemble 1
- e-bass 1
- jazz 1
- saxophones 1
- slow 1
- trumpets 1
- very fast tempo 1
- warm sounding 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Buddy Rich / Channel One Suite Part 2 | This song contains acoustic drums playing a complex rhythm along with a e-bass playing a walking bassline and a piano playing jazz chords in the mid range. A baritone saxophone is playing the main melody accompanied by other brass instruments. This song may be playing during a live concert. | 2009-08-04T16:41:44Z | Bob Bowlby | Berlin Jazz Festival. November 3, 1984. | ["Brass instrument", "Saxophone"] | ["jazz", "baritone saxophone", "acoustic piano", "saxophones", "trombones", "trumpets", "acoustic drums", "e-bass", "very fast tempo"] | 6 | 3dzR3ZWOe8Y | 490 | |
岩工 トロンボーン四重奏 ♪.ゴスペル・タイム | This audio contains two trombone players playing a warm melody. One in a higher key the other in a lower register. This song may be playing live listening to a performance in a theater. | 2012-08-15T23:16:58Z | itosikihibi | 第35回全日本アンサンブルコンテスト 中国大会 トロンボーン四重奏 金賞受賞 ♪,ゴスペル・タイム | ["Brass instrument", "Trombone"] | ["brass ensemble", "trombones", "slow", "warm sounding"] | 6 | 9dx9IhSqwC4 | 1031 |
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;