musiccaps_details (view)
6 rows where musiccaps_author = 4, musiccaps_names contains "Jazz" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 42 ✖
- low quality 6
- groovy double bass 2
- jazz 2
- live performance 2
- mono 2
- noisy 2
- passionate 2
- punchy kick 2
- relaxing 2
- acoustic guitar chords 1
- acoustic rhythm guitar chords 1
- calming 1
- chill 1
- dissonant string melody 1
- drums solo 1
- easygoing 1
- emotional 1
- energetic 1
- exciting 1
- groovy bass 1
- groovy piano melody 1
- hypnotic 1
- jazzy electric guitar melody 1
- joyful 1
- mellow piano chords 1
- passionate woodwind melody 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- smooth 1
- snappy rimshots 1
- soft hi hats 1
- soulful 1
- spanish guitar solo melody 1
- sustained strings 1
- tenor sax solo melody 1
- traditional 1
- uptempo 1
- weird 1
- weird repetitive electric guitar melody 1
- wide sustained strings 1
musiccaps_names (array) 14 ✖
- Jazz · 6 ✖
- Music 6
- Musical instrument · 6 ✖
- Guitar 2
- Plucked string instrument 2
- Saxophone 2
- Acoustic guitar 1
- Bluegrass 1
- Brass instrument 1
- Drum 1
- Drum kit 1
- Strum 1
- Swing music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Fingerstyle Jazz Guitar Improv - Jody Fisher | The low quality recording features a jazzy electric guitar melody. The recording is noisy and it is in mono - regardless, it sounds calming and relaxing. | 2006-02-23T23:43:33Z | workshoplive | http://www.workshoplive.com/index.cfm?WT.mc_id=YTJZGIT-JF1 Jody Fisher, one of our jazz instructors at workshoplive, took some time to jam some jazz musings on his Klein electric guitar. Enjoy Jody's music! | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jazzy electric guitar melody", "low quality", "mono", "noisy", "calming", "relaxing"] | 4 | 476vNb6thyM | 540 | |
Days of Wine and Roses Dexter Gordon | The low quality recording features a jazz song that consists of groovy double bass located in the right channel, groovy piano melody leaning towards the left channel of the stereo image and widely spread shimmering shakers and soft hi-hats. It sounds smooth, chill, easygoing and relaxing - like something you would hear in high-end restaurants. | 2011-03-27T23:23:26Z | nickwreiter | From the album "Tangerine" (1972) New Jersey at the Van Gelder Studios Personnel: Dexter Gordon - Tenor Sax Cedar Walton - Piano Buster Williams - Bass Billy Higgins - Drums | ["Jazz", "Music", "Musical instrument", "Saxophone"] | ["low quality", "jazz", "groovy piano melody", "groovy double bass", "shimmering shakers", "soft hi hats", "smooth", "easygoing", "chill", "relaxing"] | 4 | AgVUGzrzJ20 | 1154 | |
Keith Carlock: Modern Drummer Festival 2005 | The low quality recording features a drummer playing his solo over a weird repetitive electric guitar solo melody. The drums consist of punchy kick and snare hits and shimmering cymbals. Overall it sounds energetic and exciting. | 2008-01-17T21:53:20Z | Hudson Music | Keith Performs at the Modern Drummer Festival 2005. More information at HudsonMusic.com | ["Drum", "Drum kit", "Jazz", "Music", "Musical instrument"] | ["low quality", "weird repetitive electric guitar melody", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "drums solo", "exciting"] | 4 | P39x5dOsJ40 | 2498 | |
Swing Amor "Rose Room" | The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. | 2008-12-02T16:54:14Z | hailletmusic | About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. | ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] | 4 | iUHqyjf3NcQ | 4191 | |
IPIROS PETROLOUKAS XALKIAS GAIDA KLARINO | The low quality recording features a traditional song that consists of a passionate woodwind melody playing over wide sustained strings, acoustic guitar chords and dissonant string melody. It sounds joyful, weird and hypnotic. | 2008-09-09T17:33:38Z | Lupo1908 | IPIROS PETROLOUKAS XALKIAS GAIDA KLARINO | ["Jazz", "Music", "Musical instrument"] | ["low quality", "traditional", "dissonant string melody", "acoustic guitar chords", "wide sustained strings", "passionate woodwind melody", "joyful", "weird", "hypnotic"] | 4 | mRKud6yP4iU | 4472 | |
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;