musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano accompaniment", musiccaps_aspects contains "steady drumming" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- piano accompaniment · 3 ✖
- steady drumming · 3 ✖
- groovy 2
- keyboard harmony 2
- rhythmic acoustic guitar 2
- animated 1
- buoyant 1
- captivating 1
- electric guitar lead 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 bass line 1
- heavy reverb 1
- high notes 1
- instrumental 1
- jazz 1
- lively piano 1
- male singer 1
- male vocalist 1
- mediocre audio recording 1
- melodic 1
- mesmerising 1
- punchy beats 1
- retro feel 1
- rock and roll 1
- rock music 1
- simple melody 1
- skilful 1
- skilled musician 1
- slightly off key vocals 1
- slow tempo 1
- soft rock 1
- spirited 1
- steady bass lines 1
- swing 1
- syncopated harmony 1
- synthesised arrangements 1
- synthesiser arrangement 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 | |
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 |
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;