musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "funky bass line" and musiccaps_names contains "Song" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- funky bass line · 2 ✖
- groovy 2
- rhythmic acoustic guitar 2
- acoustic guita 1
- ambient 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- female vocalist 1
- galloping beat 1
- groovy electric guitar 1
- heavy reverb 1
- jazz 1
- male vocalist 1
- mediocre audio recording 1
- medium tempo 1
- mellow 1
- melodic 1
- no lyrics 1
- perky 1
- piano accompaniment 1
- pop 1
- simple beat 1
- simple melody 1
- slick drumming 1
- slightly off key vocals 1
- smooth 1
- steady drumming 1
- swing 1
- vocalisation 1
musiccaps_names (array) 7 ✖
- Music 2
- Song · 2 ✖
- /t/dd00032 1
- Electric guitar 1
- Funk 1
- Pop music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fatoumata Diawara - Mandela - Blackberrys Sharp Nights:Masters of World Music (New Delhi) | This song is a vocalisation by a female singer. The tempo is medium with an upbeat electronic guitar harmony, funky bass guitar, slick drumming and acoustic guitar accompaniment. The music is simple, engaging, pleasant, melodic, engaging and has a perky groove. | 2015-02-27T17:32:18Z | Blackberrys Menswear | Fatoumata Diawara paying tribute to the late great Nelson Mandela with her hit track 'Mandela', at Blackberrys Sharp Nights:Masters of World Music. #MOWM 'The Hendrix of The Sahara' Vieux Farka Toure; performing 'Ai Du' as part of the Blackberrys Sharp Nights: Masters of World Music tour. Live at Tote on The Turf, Mumbai. #MOWM For more, visit: http://facebook.com/BlackberrysMenswear http://twitter.com/BlackberrysMens | ["Electric guitar", "Music", "Song", "/t/dd00032"] | ["female vocalist", "vocalisation", "groovy", "perky", "no lyrics", "medium tempo", "groovy electric guitar", "funky bass line", "rhythmic acoustic guitar", "mellow", "melodic", "engaging", "slick drumming", "pop", "no lyrics", "simple beat", "ambient", "smooth", "acoustic guita"] | 7 | c9tRbWSk7c4 | 3685 | |
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 |
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;