musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "steady drumming" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- piano accompaniment · 2 ✖
- rhythmic acoustic guitar 2
- steady drumming · 2 ✖
- animated 1
- captivating 1
- engaging 1
- enthralling 1
- enthusiastic 1
- ethereal 1
- fast tempo 1
- female soprano like sound 1
- funky bass line 1
- galloping beat 1
- groovy 1
- heavy reverb 1
- high notes 1
- instrumental 1
- jazz 1
- keyboard harmony 1
- lively piano 1
- male vocalist 1
- mediocre audio recording 1
- melodic 1
- mesmerising 1
- simple melody 1
- skilful 1
- skilled musician 1
- slightly off key vocals 1
- spirited 1
- steady bass lines 1
- swing 1
- synthesised arrangements 1
- tambourine 1
- theremin 1
- thereminist 1
- unique 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNKY B & THE KINGS OF SHUFFLE - Phonin' - LIVE 2009 | A male vocalist sings this jazz style melody. The tempo is fast with syncopated piano accompaniment, slick drumming, groovy bass line and rhythmic acoustic guitar. The music is energetic, ambient, mellow, pleasant with a dance groove. | 2010-10-30T21:08:57Z | Kings of Shuffle | FUNKY B & THE KINGS OF SHUFFLE playing "Phonin'" live in Baden-Baden November 04, 2009 Hammond B3: Markus Lauer "Funky B" Guitar: Carsten Egger "Shuffle King Car" Drums: Jörg Mattern "Shuffle King Matt" | ["Singing", "Funk", "Music", "Pop music", "Song"] | ["male vocalist", "fast tempo", "piano accompaniment", "slightly off key vocals", "swing", "jazz", "galloping beat", "steady drumming", "rhythmic acoustic guitar", "mediocre audio recording", "heavy reverb", "funky bass line", "enthusiastic", "simple melody", "groovy"] | 7 | VHYxygh1STA | 2987 | |
Thereminist IN HIS NATURAL HABITAT | A feminist plays this intriguing instrumental. The tempo is fast with keyboard accompaniment, steady drumming, rhythmic acoustic guitar, lively piano harmony , steady bass lines and shakers. The music is sharp, height pitched and almost like a female soprano vocalising. The song is energetic, spirited, melodic, animated, unique, skilful, engaging, ethereal and captivating; | 2009-03-25T22:15:57Z | ThomasGrillo | http://www.thomasgrillo.com Enjoy a little tour of "the coolest room in town" according to an anthropology major who recently documented thereminist Thomas Grillo in his natural habitat. ;) The song is an original jazz compostion by Thomas Grillo, called Mint Julep Fantasy, which is now available on CD, and MP3. Just visit http://www.thomasgrillo.com/shop.html and check out the album, Secret Agents from the id. The piece has been much improved since this video's release. Video was shot by professional photographer Josh Haley. Visit him at http://www.joshhaileystudio.com The lens was a 120 degree wide angle, fish eye lens. ;) Song and video are Copyright 2009 Thomas Grillo, and Josh Hailey. | ["Music", "Theremin"] | ["instrumental", "keyboard harmony", "theremin", "tambourine", "unique", "melodic", "spirited", "enthralling", "melodic", "skilful", "ethereal", "captivating", "steady bass lines", "lively piano", "mesmerising", "engaging", "animated", "thereminist", "piano accompaniment", "steady drumming", "synthesised arrangements", "rhythmic acoustic guitar", "theremin", "high notes", "female soprano like sound", "skilled musician"] | 7 | bHiRX6QYwEk | 3613 |
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;