musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "melodic" and musiccaps_aspects contains "slick drumming" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- melodic · 2 ✖
- slick drumming · 2 ✖
- acoustic guita 1
- acoustic guitar 1
- alto 1
- ambient 1
- animated vocals 1
- brass band 1
- cello bass 1
- choral harmony 1
- classic 1
- empahtic vocals 1
- engaging 1
- fast tempo 1
- female vocalist 1
- female vocalists 1
- funky bass line 1
- groovy 1
- groovy electric guitar 1
- lively cello 1
- lively trumpets 1
- medium tempo 1
- mellow 1
- mezzo-soprano 1
- no lyrics 1
- perky 1
- pop 1
- rhythmic acoustic guitar 1
- simple beat 1
- smooth 1
- soprano 1
- swing 1
- swing beat 1
- vocalisation 1
musiccaps_names (array) 7 ✖
- Music 2
- /t/dd00032 1
- Electric guitar 1
- Jazz 1
- Singing 1
- Song 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Royals - Lorde - Vintage/Swing Cover by Flash Mob Jazz ft Lady Armstrong | A group of female vocalists sing this enthusiastic swing song. The tempo is fast with bright trumpet harmony, cello , rhythmic acoustic guitar and slick drumming. The song is upbeat with vocal emphasis and a lively orchestra. This song is a Classic Swing. | 2015-07-09T13:46:23Z | Flash Mob Jazz | *Subscribe for more modern Covers Coming Soon* EP OUT NOW: http://flashmobjazz.bandcamp.com/releases We collaborated with the stunning Lady Armstrong team to creating this fun cover of Royals by Lorde! Check out our Digital albums at www.flashmobjazz.bandcamp.com Thanks for all the support! Website: www.flashmobjazz.com Instagram: @flashmobjazz Facebook: www.facebook.com/FlashMobJazz Twitter: @flashmobjazz Bandcamp: www.flashmobjazz.bandcamp.com Please direct all inquiries to: flashmobjazz@hotmail.co.uk Special thanks to Worthing Theatres and Lee Payne! Audio production: http://www.benjaminjamesrecording.com/ | ["Singing", "Swing music", "Jazz", "Music"] | ["female vocalists", "fast tempo", "choral harmony", "mezzo-soprano", "cello bass", "lively trumpets", "brass band", "slick drumming", "swing beat", "swing", "animated vocals", "melodic", "empahtic vocals", "alto", "soprano", "classic", "lively cello", "acoustic guitar"] | 7 | CWKBzt-v8w4 | 1372 | |
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 |
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;