musiccaps_details (view)
3 rows where musiccaps_aspects contains "backing voices", musiccaps_aspects contains "male voice singing" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- backing voices · 3 ✖
- male voice singing · 3 ✖
- digital drums 2
- acoustic piano 1
- african/dance/pop/r&b 1
- bass 1
- digital bass 1
- e-bass 1
- e-guitar 1
- funk/r&b/jazz 1
- male voice rapping 1
- medium tempo 1
- medium to uptempo 1
- piano 1
- pop 1
- shaker 1
- uplifting mood 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Music 3
- Afrobeat 2
- Music of Africa 2
- Blues 1
- Hip hop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
M.Trill - "Beautiful" Official Video | A digital drum is playing a groove that motivates to dance with a kick on every beat along with a shaker. Male backing voices are singing a melody in harmony and adlips that are panned to the right side of the speakers. A piano is playing a simple repeating melody and a soft bass sound is rounding the recording up. On top of that a male voice is singing phrases. This song may be playing at home dancing. | 2009-01-14T18:29:17Z | Jachimma | Ghana-Nigeria collaboration feat.FIRE MTrill describes his ideal woman | ["Afrobeat", "Music of Africa", "Music"] | ["african/dance/pop/r&b", "digital drums", "shaker", "piano", "bass", "male voice singing", "backing voices", "medium to uptempo"] | 6 | 3JYQgXudiH8 | 455 | |
Blk Jks - Lakeside Music Video | This song contains a male voice singing in the midrange while backing voices are supported with vocals in the higher register. Someone is playing a complex jazzlike groove on the drums. An e-guitar is playing a loud arpeggio melody panned to the right side of the speakers along with an e-bass. This song may be playing live at a jazz festival. | 2008-02-10T22:44:05Z | jeffersonlemon | The first single for South African afro avant noise rock band The Blk Jks. Filmed by Adam Edwards and Russell Grant of Fong Kong Filmmaking. Edited by Adam Edwards. The single is available on vinyl. visit blkjks.blogspot.com and www.redteamgo.co.za | ["Blues", "Music"] | ["funk/r&b/jazz", "acoustic piano", "e-bass", "e-guitar", "male voice singing", "backing voices", "uptempo"] | 6 | 8oUI02eK3SM | 947 | |
Ding Dong Holiday Official Video | This song contains digital drums playing a hiphop kinda feel along with a bassline. The most energy comes from the male voice singing with autotune and a lot of backing voices cheering and singing along: Then a male voice starts rapping. The backing voices are spread across the both sides of the speakers. This song may be playing outside chilling with your friends. | 2012-02-02T21:54:29Z | Teonray Chichester | ["Afrobeat", "Music of Africa", "Music", "Hip hop music"] | ["pop", "digital bass", "digital drums", "male voice singing", "backing voices", "male voice rapping", "medium tempo", "uplifting mood"] | 6 | w6MtzUCl4vM | 5241 |
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;