musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Music of Africa" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- electronic drums · 2 ✖
- airy synth 1
- bass guitar 1
- chill 1
- dancehall 1
- electric guitar 1
- female vocal 1
- groovy 1
- hip 1
- instrument samples 1
- jamaican accent 1
- keys 1
- male voice rapping 1
- moderate tempo 1
- rap-like singing 1
- rap/reggeaton 1
- reggae 1
- sound-effects 1
- sub bass 1
musiccaps_names (array) 5 ✖
- Music of Africa · 2 ✖
- Hip hop music 1
- Music 1
- Ping 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 |
---|---|---|---|---|---|---|---|---|---|---|
E Weg'i Ping - BlackJoker ft JeWeet, Remyman, Uncle Jee & Lady Shanti | This song has a typical reggaeton drumbeat that just sounds a little softer and not so much in the foreground. A synthetic bass is supporting the drums with a simple bassline. A processed guitar-like sound is panned to the left side of the speakers. Some gameboy coinlike sound is popping up here and there. A male voice is rapping while getting backing voices from another male voice. This song may be playing at a latin barber shop. | 2011-09-06T21:05:39Z | BlackJoker Music | E Weg'i Ping, BlackJoker, RemyMan, Uncle Jee, Lady Shanti Dancehall, Bubbling, Reggaeton, Rub A Dub. | ["Music of Africa", "Music", "Ping", "Hip hop music"] | ["rap/reggeaton", "electronic drums", "sub bass", "sound-effects", "instrument samples", "keys", "male voice rapping", "moderate tempo"] | 6 | Pln4GLIMqKY | 2563 | |
Tanya Stephens - Corners Of My Mind (Guilty) | This is a dancehall/reggae music piece. There is a female vocalist singing in a rap-like manner with a Jamaican accent in the lead. The melody is being played by two layers of electric guitar with a bass guitar backing. The rhythm is being played by the electronic drums. An airy synth sound can be heard very faintly in the distance. The atmosphere is chill. This piece can be used in the soundtrack of a summer movie during scenes where everybody is relaxing. | 2014-03-07T08:00:01Z | TanyaStephensVEVO | Music video by Tanya Stephens performing Corners Of My Mind (Guilty). © 2013 Sanctum Entertainment | ["Music of Africa", "Rhythm and blues"] | ["dancehall", "reggae", "female vocal", "rap-like singing", "jamaican accent", "electric guitar", "bass guitar", "airy synth", "electronic drums", "groovy", "chill", "hip"] | 9 | qfwTbBprDVU | 4807 |
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;