musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "male singer" and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- energetic · 3 ✖
- male singer · 3 ✖
- medium tempo 2
- spirited 2
- steady drumming 2
- animated 1
- animated vocals 1
- backup singer 1
- bad audio quality 1
- beach party 1
- buoyant 1
- cheerful 1
- congas 1
- dance club 1
- dance groove 1
- dance mix 1
- dance rhythm 1
- disco rap 1
- dj 1
- drum stick clicks 1
- entertaining 1
- excitement 1
- exciting 1
- foreign language 1
- groove to the music 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar playing rhythm 1
- guitar rhythm 1
- hip-hop 1
- horns playing 1
- keyboard accompaniment 1
- keyboard harmony 1
- live audience 1
- live performance 1
- live recording 1
- noisy crowds 1
- organ accompaniment 1
- people cheering 1
- people dancing 1
- pop rap 1
- pop song 1
- positive 1
- punchy 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- rap 1
- reggae band 1
- reggae music 1
- rhythmic patter 1
- steady bass line 1
- studio recording 1
- trumpets play percussively 1
- vibrant 1
- video sound track 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 6 ✖
- Afrobeat · 3 ✖
- Music 3
- Music of Africa 2
- Hip hop music 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 |
---|---|---|---|---|---|---|---|---|---|---|
พ่อพันธุ์วัวไทยพื้นเมือง | A male singer sings this cool and animated melody with backup singers in vocal harmony. The song is medium tempo with steady drumming rhythm, groovy bass line, organ accompaniment and horns playing. The song is entertaining and cheerful. The audio quality is bad. | 2012-07-22T11:31:33Z | thanandorn limlek | ขออนุญาตเจ้าของวัวครับ | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "backup singer", "vocal harmony", "cheerful", "positive", "animated vocals", "video sound track", "guitar rhythm", "horns playing", "organ accompaniment", "steady bass line", "groovy rhythm", "energetic", "entertaining", "bad audio quality", "pop song", "medium tempo", "keyboard accompaniment"] | 1 | Ipow026xzVw | 1945 | |
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;