musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Afrobeat" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- male voice · 3 ✖
- bass 2
- moderate tempo 2
- programmed percussion 2
- bowed lute 1
- caribbean music 1
- crossover song 1
- dance music 1
- dance pop song 1
- emotional song 1
- female backing voices 1
- foreign language 1
- guitar 1
- happy mood 1
- male backing voices 1
- marimba 1
- middle-eastern feel 1
- reggae bassline 1
- reggae feel 1
- reggae song 1
- simple percussion 1
- slow tempo 1
- soul song 1
- synth 1
- synth sounds 1
- trumpets 1
musiccaps_names (array) 7 ✖
- Afrobeat · 3 ✖
- Music 3
- Music of Africa 2
- Dance music 1
- Pop music 1
- Reggae 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mabermuda-Vuthu Marabenta (mocambique musica) | This song features a male voice singing the main melody. Other male voices sing fills in between lines as backing voices. A repetitive melody is played on the marimba. The percussion is programmed and the focus is on the continuous hi-hat strokes. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played at a dance party. | 2012-07-18T16:56:33Z | DOPEITSDAZ MUSIC | ["Afrobeat", "Music of Africa", "Music"] | ["caribbean music", "dance music", "reggae feel", "programmed percussion", "bass", "male voice", "male backing voices", "marimba", "moderate tempo", "happy mood"] | 0 | G9gsCU85c8k | 1695 | ||
اغنية تركية- اسماعيل - Turkish Pop Dance Music | This dance pop song features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a dance beat. The percussion is programmed. The bass plays the root notes of the chords. Synth sounds are played in the background. Bowed lute play fills in between lines to give this song a middle-eastern feel. This song can be played in a club. The mood of this song is flirty. | 2009-05-30T10:00:18Z | Mozzoona | ismail yk bomba bomba: Turkish music, turkish dance, turkish travel, turkish food, turkish boy, turkish man, turkish gay, turkish sex, turkish lesbian, turkish girl, turkish woman, turkish homosexual, istanbul, turkey, ankara, izmir, tarkan, arabic music, arabic dance, belly dance, sex video, sexy girl, erotic pictures, sex images, porno images, arabic language, arabic football, asian, olympic, china, beijin, middle east, medditerian, italy, spain, rome, madrid, andalucia, algeria, morocco, tunisia, libya, egypt, syria, israel, palestine, jordan, lebanon, iraq, saudi arabia, yemen, sudan, bahrain, kuwait, qatar, emirates, oman, iran, pakistan, afghanistan, kabul, india, karachi, tehran, new delhi, pop music, classical music, jazz, techno, greek, greek music, funny cat, funny video, comedy, guru, oriental music, arabian gulf, persian gulf, song, romance, romantic, madonna, keylie minogue, britney spears, michael jackson, japan, tokyo, philippine, australia, USA, washington, chicago, los angeles, miami, havana. | ["Afrobeat", "Music", "Pop music", "Song", "Dance music"] | ["dance pop song", "male voice", "foreign language", "programmed percussion", "moderate tempo", "middle-eastern feel", "synth", "bass", "bowed lute"] | 0 | bmVd2Zj8_Cc | 3652 | |
|AFRICA UNITE| Rebellion, Mandingo, DJ Taff, Good Vibration @ Stadtwerkstatt Linz | This song is a crossover of a reggae song with a soul song. This features a male voice singing the main melody. It starts off with the voice which is accompanied by the guitar, bass and percussion playing in the pause between lines. During the pause, a synth sound is played which is modulated by a ring modulator. After the pause, the voice starts the main melody. Trumpets play a melody. The bass and percussion continue to play with a reggae feel. Female backing voices sing vocables. This song is relaxing. This song can be played at the end of a war movie. | 2010-04-29T21:39:57Z | GoodVibrationSound | ["Afrobeat", "Music of Africa", "Music", "Reggae"] | ["reggae song", "soul song", "crossover song", "male voice", "guitar", "reggae bassline", "synth sounds", "trumpets", "simple percussion", "female backing voices", "slow tempo", "emotional song"] | 0 | chfTjqlrFQQ | 3731 |
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;