musiccaps_details (view)
2 rows where musiccaps_aspects contains "romantic", musiccaps_names contains "Rhythm and blues" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- romantic · 2 ✖
- 2000s r&b 1
- ambient 1
- bright warm pad synth 1
- cajun beat 1
- complex chords 1
- contemporary pop 1
- digital drum 1
- drum machine 1
- groovy bass 1
- intricate bassline 1
- jazz style piano 1
- love song 1
- male singer 1
- medium tempo 1
- melodious vocal backup 1
- minimal r&b drumming 1
- passionate 1
- passionate female vocalist 1
- persuasive 1
- pop 1
- r&b 1
- seductive 1
- sentimental 1
- slick drumming 1
- soft 1
- soul 1
- soulful 1
- synthesiser arrangements 1
- violin-like synth 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ginuwine - Stingy | A male vocalist sings this mellow song.he tempo is medium with jazz style piano accompaniment, synthesiser articulation, slick drumming, funky bass line, cajun beat and an interactive vocal harmony. The music is mellow, soothing, ambient, soulful, passionate, emotional and persuasive. This song is a contemporary R&B/Soul. | 2010-12-30T03:27:51Z | PrezSteej | ["Singing", "Music", "Rhythm and blues"] | ["male singer", "medium tempo", "soft", "romantic", "passionate", "persuasive", "sentimental", "melodious vocal backup", "r&b", "soul", "jazz style piano", "synthesiser arrangements", "pop", "contemporary pop", "ambient", "love song", "passionate", "complex chords", "slick drumming", "groovy bass", "cajun beat", "digital drum", "drum machine"] | 7 | C0AQyOVGvFM | 1316 | ||
Fabulous Girls - Something ft. Cymphonique | This is a mellow and soulful 2000s R&B song. The female vocalist gives a sensual and passionate vocal performance. The song is seductive, intimate and relaxed. There are string-like sounds and a warm and bright pad-synth along with the mellow groovy drum beat. | 2011-07-05T07:00:00Z | FabulousGirlsVEVO | Music video by Fabulous Girls performing Something. (C) 2011 Hollywood Dream Music | ["Singing", "Music", "Rhythm and blues"] | ["2000s r&b", "soulful", "romantic", "seductive", "passionate female vocalist", "violin-like synth", "intricate bassline", "minimal r&b drumming", "bright warm pad synth"] | 3 | Ycid0vBwqUg | 3300 |
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;