musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "perky" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- groovy · 4 ✖
- perky · 4 ✖
- catchy 3
- club music 2
- dance music 2
- dance pop 2
- electronic music 2
- fast tempo 2
- female vocalist 2
- punchy 2
- vocalisation 2
- acoustic guita 1
- alternative hip-hop 1
- ambient 1
- amplified flute 1
- amplified ney 1
- ardent 1
- bongos 1
- boomy bass lines 1
- breezy fresh 1
- bulgarian 1
- buoyant 1
- chimes 1
- congas 1
- dance groove 1
- dj 1
- dj mixer 1
- edm 1
- electronic sound arrangements 1
- energetic digital drum 1
- engaging 1
- funky 1
- funky bass line 1
- groovy electric guitar 1
- hand percussion 1
- hip-hop 1
- hip-hop hits 1
- infectious drumming 1
- instrumental 1
- intense 1
- interactive 1
- keyboard harmony 1
- lively backup vocals 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- melodic 1
- middle eastern music 1
- minimalist instrumentation 1
- ney 1
- no lyrics 1
- oud 1
- oud rhythm 1
- peppy 1
- pleasant 1
- pop 1
- pop folk 1
- punch bass line 1
- rap 1
- reggae fusion 1
- rhythmic acoustic guitar 1
- romantic 1
- simple beat 1
- simple melody 1
- slick drumming 1
- smooth 1
- steady drumming 1
- surround sound 1
- synth pop instrumental 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tambourine beats 1
- upbeat 1
- vivacious 1
musiccaps_names (array) 10 ✖
- Music · 4 ✖
- Music of Africa 2
- /t/dd00032 1
- Afrobeat 1
- Ambient music 1
- Background music 1
- Electric guitar 1
- Electronica 1
- Exciting music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
K'Naan ABC's | Male vocalist sings this upbeat Hip-Hop song. The tempo is fast with minimal instrumentation of a lively infectious, punchy drumming and enthusiastic vocal backup and incessant, vigorous vocalisation. The song is buoyant, catchy, punchy, funky, youthful,groovy, engaging, vibrant and vivacious. This song is contemporary Hip-Hop/Rap. | 2009-01-23T20:28:16Z | K'naan Warsame | The new video for "ABC's" from K'NAAN's upcoming release "Troubador"; featuring Chubb Rock | ["Afrobeat", "Music of Africa", "Music", "Exciting music"] | ["male singer", "lively backup vocals", "alternative hip-hop", "reggae fusion", "interactive", "vocalisation", "fast tempo", "infectious drumming", "keyboard harmony", "hip-hop", "rap", "hip-hop hits", "minimalist instrumentation", "upbeat", "catchy", "buoyant", "punchy", "peppy", "perky", "dj", "dj mixer", "dance pop", "dance music", "dance groove", "club music", "groovy", "funky"] | 7 | Ovk5EfFj7Ws | 2482 | |
PP,PE film crushing washing drying pelleting.mpg | This music is an instrumental. The tempo is fast with a keyboard harmony, boomy bass lines, chimes and electronic arrangements. The music is catchy, perky, vivacious, groovy, intense and ardent. This music is a Synth pop instrumental. | 2012-02-17T13:03:33Z | droway86 | We are manufacturer of waste plastic processing machines, If you have any questions ,Please contact us: www.recycle-way.com,mail:sales@recycle-way.com,TEL:008613794959740 | ["Background music", "Music", "Ambient music", "Electronica"] | ["instrumental", "fast tempo", "groovy", "synth pop instrumental", "catchy", "perky", "intense", "ardent", "surround sound", "boomy bass lines", "vivacious", "synthesiser arrangement", "chimes", "punch bass line", "edm", "electronic music", "electronic sound arrangements", "energetic digital drum"] | 7 | TcJ7rdYMHiQ | 2852 | |
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 | |
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 |
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;