musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "female vocal" and musiccaps_names contains "Rhythm and blues" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bass guitar 2
- electric guitar 2
- electronic drums 2
- female vocal · 2 ✖
- airy synth 1
- chill 1
- dancehall 1
- easygoing 1
- generic 1
- groovy 1
- hip 1
- jamaican accent 1
- keyboard 1
- melodic singing 1
- pop 1
- r&b 1
- rap-like singing 1
- reggae 1
musiccaps_names (array) 3 ✖
- Rhythm and blues · 2 ✖
- Music 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
NewChristianArtist.com Sell Your Christian Music! | This is an R&B/pop music piece. There is a female vocalist singing melodically in the lead. The melody is being played on the electric guitar. The bass guitar is playing in the background. The rhythmic background consists of an electronic drum beat. The atmosphere is easygoing and generic. This piece could work well as an advertisement jingle. | 2008-05-06T02:48:37Z | Jordan Biel | Promo Video for NewChristianArtist.com Create your page! Connect with fans! Share your bio, calendar, photos, and more! Beginning JUNE 15th, 2008!!!!! | ["Music", "Rhythm and blues"] | ["r&b", "pop", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "easygoing", "generic"] | 9 | gVMoI2ukbtc | 4033 |
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;