musiccaps_details (view)
4 rows where musiccaps_aspects contains "love song" and musiccaps_aspects contains "r&b"
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- love song · 4 ✖
- r&b · 4 ✖
- emotional 3
- male singer 3
- romantic 3
- sentimental 3
- soul 3
- blues 2
- drum machine 2
- medium tempo 2
- slow tempo 2
- soft 2
- ambient 1
- ambient music 1
- ambient piano 1
- bad audio quality 1
- cajun beat 1
- complex chords 1
- complex harmony 1
- contemporary pop 1
- digital drum 1
- groovy bass 1
- groovy bass line 1
- guitar rhythm 1
- inspiring 1
- jazz 1
- jazz style piano 1
- madly in love 1
- male vocalist 1
- melancholy 1
- mellow 1
- melodious vocal backup 1
- memdium tempo 1
- minimalist 1
- modern pop hits 1
- modern r&b hits 1
- motivational 1
- never give up on you 1
- nostalgic 1
- organ accompaniment 1
- passionate 1
- pensive 1
- percussive bass line 1
- persuasive 1
- pleasant 1
- poignant 1
- pop 1
- proposal song 1
- romantic piano 1
- sad 1
- saxophone harmony 1
- slick drumming 1
- smooth jazz 1
- soul singer 1
- steady drumming 1
- steady drumming rhythm 1
- story telling 1
- syncopated 1
- synthesiser arrangements 1
- vocal harmony 1
- wedding song 1
musiccaps_names (array) 6 ✖
- Music 3
- Music of Asia 1
- Rhythm and blues 1
- Singing 1
- Tender music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2013 Wedding Song (You Are) Derek Rusel | A male vocalist sings this soft love song. The tempo is slow with a romantic piano accompaniment, groovy bass line, steady drumming and ambient saxophone harmony. The song is a romantic, emotional, mellow, sentimental, proposal or wedding song. This song is a R&B/Soul song. | 2011-01-14T10:13:18Z | Vent Music | ["Music", "Wedding music"] | ["male singer", "slow tempo", "romantic piano", "ambient music", "saxophone harmony", "steady drumming", "groovy bass line", "r&b", "soul", "blues", "jazz", "complex harmony", "syncopated", "pleasant", "romantic", "emotional", "sentimental", "love song", "wedding song", "proposal song"] | 7 | 07xGXxIHOL4 | 125 | ||
ne-yo why does she stay | A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. | 2008-09-25T21:35:05Z | X-tazi | ne-yo why does she stay from the new album-Year Of The Gentleman | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] | 7 | C-1i2GlbiIY | 1313 | |
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 | ||
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;