musiccaps_details (view)
4 rows where musiccaps_aspects contains "spirited", musiccaps_names contains "Afrobeat" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- spirited · 4 ✖
- energetic 3
- buoyant 2
- exciting 2
- groovy bass line 2
- keyboard harmony 2
- male singer 2
- reggae music 2
- steady drumming 2
- youthful 2
- animated 1
- backup singers 1
- beach party 1
- bouncy 1
- catchy riff 1
- club music 1
- congas 1
- contemporary pop 1
- dance club 1
- dance groove 1
- dance hits 1
- dance mix 1
- dance rhythm 1
- disco rap 1
- dj 1
- drum stick clicks 1
- enthusiastic 1
- excitement 1
- fast tempo 1
- female singer 1
- foreign language 1
- groove to the music 1
- groovy dance rhythm 1
- groovy drum rhythm 1
- groovy melody 1
- guitar accompaniment 1
- guitar playing rhythm 1
- hip-hop 1
- horns playing trumpets 1
- infectious 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- live audience 1
- live performance 1
- live recording 1
- lively accordion 1
- male singers 1
- medium fast tempo 1
- medium tempo 1
- noisy crowds 1
- passionate 1
- people cheering 1
- people dancing 1
- peppy 1
- percussive bass line 1
- pop hits 1
- pop rap 1
- punchy 1
- punchy drumming 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- rap 1
- reggae band 1
- retro dance hits 1
- rhythmic patter 1
- simple melody 1
- sonic effects 1
- story telling 1
- studio recording 1
- synthesiser arpeggio 1
- teen pop 1
- tero pop hits 1
- trumpets play percussively 1
- vibrant 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
- Afrobeat · 4 ✖
- Music · 4 ✖
- Hip hop music 2
- Dance music 1
- Music of Africa 1
- Music of Asia 1
- Rapping 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ghana Hiplife: VIP : Manenko | A male singer sings this reggae melody with backup singers in vocal harmony. The song is medium fast tempo with a groovy drum drumming rhythm, keyboard accompaniment, percussive bass line and various percussive effects. The song is groovy and enthusiastic with a reggae influence. | 2007-07-10T10:45:13Z | vyrusnana | vission in progress | ["Afrobeat", "Music", "Hip hop music"] | ["male singers", "backup singers", "vocal harmony", "keyboard accompaniment", "reggae music", "tero pop hits", "retro dance hits", "groovy dance rhythm", "percussive bass line", "groovy drum rhythm", "keybiard accompaniment", "sonic effects", "horns playing trumpets", "passionate", "story telling", "spirited", "enthusiastic", "exciting", "medium fast tempo"] | 1 | 4Lk8pUeLCwQ | 559 | |
เพลงแดนซ์เพราะๆ Ri'ryo music sweet love Remix-2016 HD【OFFICIAL MV】 | A female vocalist sings this groovy pop song. The tempo is fast with accordion harmony, funky bass lines, punchy drumming and keyboard accompaniment. The song is youthful, infectious, catchy, bouncy, nifty and groovy with a dance rhythm. This song is Modern pop. | 2016-01-24T12:25:52Z | ริเรียว หลงทาง | มาติดตามที่นี่เลย Ri'Ryo music (Thank for Watching Contact) https://www.facebook.com/Ri-Ryo-Music-815679285186249/ 1. move Sucker punch ชื่อภาษาไทย อีหนูดุทะลุโลก 2011 2. move The Avengers 2 ชื่อภาษาไทย ดิอเวนเจอร์ส 2015 3. move Thor 2 The Dark World ชื่อภาษาไทย เทพเจ้าสายฟ้าโลกาทมิฬ 2013 4. movie ant-man ชื่อภาษาไทย มนุษย์มดมหากาฬ 2015 5. movie Man of Steel ชื่อภาษาไทย บุรุษเหล็กซูเปอร์แมน 2013 เครดิต DJ-bOe Remixer - Sweet love 3CHA https://www.youtube.com/watch?v=d3brT7nmRHI เพลงฉบับเต็ม Liviu Hodor feat. Mona - Sweet Love จัดทำเพื่อความบันเทิงเท่านั้น By Ri'ryo music 2016 【OFFICIAL MV】 เพลงแดนซ์สนุกๆ DJ-Dance Remix By ริเรียว หลงทาง 2016 ติดตามแซนแนล Ri'ryo music ได้ที่ลิงค์ด้าน ล่าง https://www.youtube.com/channel/UCbAuON-0IQNGvGbiJr55J-A ดาวน์โหลดเพลงนี้ http://www5.zippyshare.com/v/wsjgusTv/file.html | ["Afrobeat", "Music of Asia", "Music", "Dance music"] | ["female singer", "fast tempo", "lively accordion", "synthesiser arpeggio", "bouncy", "infectious", "dance hits", "club music", "dance hits", "pop hits", "catchy riff", "simple melody", "energetic", "spirited", "groovy bass line", "punchy drumming", "keyboard harmony", "groovy melody", "buoyant", "youthful", "teen pop", "contemporary pop", "peppy", "youthful"] | 7 | E16FgDFQI_w | 1524 | |
Busy Signal - How Dem A Talk [Clean Version] | A male vocalist sings this peppy rap. The tempo is medium fast with an enthusiastic and catchy guitar rhythm, drum stick clicks, congas, steady drumming and keyboard accompaniment. The song is simple, punchy; buoyant, youthful, animated, vibrant and has a catchy dance groove. This song is contemporary Hip-Hop/Rap. | 2015-08-20T01:50:47Z | BusySignalRealVEVO | Music video by Busy Signal performing "How Dem A Talk" (Official Visual). ©: Turf Music Entertainment /Stainless Music http://vevo.ly/nWNEGT | ["Afrobeat", "Music of Africa", "Music", "Rapping", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "spirited", "vibrant", "buoyant", "foreign language", "punchy guitar rhythm", "drum stick clicks", "disco rap", "punchy", "guitar accompaniment", "steady drumming", "congas", "keyboard harmony", "energetic", "rap", "hip-hop", "pop rap", "youthful", "spirited", "animated", "dance groove", "vibrant", "punchy guitar rhythms drum stick clicks", "rhythmic patter"] | 7 | NWL-P08eM-U | 2342 | |
robzn - Kill the sound boy feat. Karen Firlej | A male singer sings this reggae melody with a live audience. The song is medium tempo with a groovy drum rhythm, trumpet playing rhythmically, guitar playing accompaniment and a groovy bass line. The song is exciting and cheerful. The song is a modern reggae tune and played in both a live audience situation and studio recording quality. | 2015-03-08T15:21:56Z | Das Octagon | Luiggis Finest Kill the sound boy feat. Karen Firlej Karen: https://www.facebook.com/pages/Karen-Firlej/179074595612477 robzn: https://www.facebook.com/robznoffiziellergehtnicht http://robznoffiziell.de/ vrob: https://www.facebook.com/vroboffiziellergehtnicht Luiggis Finest: https://soundcloud.com/luiggisfinest/luiggis-finest-hip-hop-reggaeneration | ["Afrobeat", "Music"] | ["reggae music", "live recording", "reggae band", "exciting", "energetic", "dance rhythm", "spirited", "beach party", "dance club", "dance mix", "excitement", "groove to the music", "people dancing", "studio recording", "dj", "noisy crowds", "people cheering", "guitar playing rhythm", "trumpets play percussively", "steady drumming", "live audience", "live performance", "male singer", "people cheering", "dance rhythm", "groovy bass line"] | 1 | fWypK9RHJJI | 3955 |
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;