musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- jazz 3
- live performance · 3 ✖
- low quality 3
- passionate 3
- shimmering hi hats · 3 ✖
- emotional 2
- chill 1
- clarinet solo melody 1
- easygoing 1
- groovy bass 1
- groovy double bass 1
- groovy piano melody 1
- intimate 1
- mellow brass melody 1
- mellow kick hits 1
- mellow piano chords 1
- noisy 1
- punchy kick 1
- snappy rimshots 1
- soulful 1
- sustained strings 1
- tenor sax solo melody 1
- trombone solo 1
- warm 1
musiccaps_names (array) 9 ✖
- Brass instrument · 3 ✖
- Trombone 2
- Clarinet 1
- Jazz 1
- Music 1
- Musical instrument 1
- Saxophone 1
- Trumpet 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sleepy Time Down South | The low quality recording features a live performance of a jazz song that consists of a clarinet solo melody played over groovy piano, mellow brass melody, shimmering hi hats and mellow kick hits. It sounds emotional, easygoing and chill. | 2007-06-23T22:34:36Z | glengillo | Another clip from the Carling family at the Stockamollan Jazz Festival in June 2007, playing the old Louis Armstrong classic "When it's Sleepy Time Down South". With such tight ensemble playing it would be wrong to pick out any particular soloist -- they are all great! | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | ["low quality", "live performance", "jazz", "clarinet solo melody", "mellow brass melody", "groovy piano melody", "shimmering hi hats", "mellow kick hits", "passionate", "emotional", "easygoing", "chill"] | 4 | 588osm3C4bw | 635 | |
Jazz Cimbasso - Donna Lee, WDR Big Band featuring Mattis Cederberg | The low quality recording features a live performance of a jazz song and it consists of groovy double bass, trombone solo and shimmering hi-hats. The recording is a bit noisy and it sounds warm, intimate and passionate. | 2012-01-20T22:52:27Z | cimbassonista | Here's an arrangement of Donna Lee by Michael Philip Mossman. The WDR Big Band featuring me on cimbasso. As always, I play the HAAG cimbasso. | ["Brass instrument", "Trombone"] | ["low quality", "noisy", "intimate", "live performance", "jazz", "trombone solo", "groovy double bass", "shimmering hi hats", "passionate", "warm"] | 4 | p1DNl8BF49U | 4677 | |
Tony on Tenor Sax | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | 2008-01-24T22:22:32Z | Tony Bolivar | Because of Who You Are | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | 4 | tuoBmxts5Xo | 5075 |
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;