musiccaps_details (view)
6 rows where musiccaps_aspects contains "romantic" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 83 ✖
- romantic · 6 ✖
- love song 3
- medium tempo 3
- emotional 2
- female singer 2
- groovy bass line 2
- hip hop dance music 2
- hip hop music 2
- keyboard accompaniment 2
- keyboard harmony 2
- male singer 2
- passionate 2
- pop 2
- sentimental 2
- story telling 2
- 2000s r&b 1
- acoustic guitar 1
- african 1
- ambient 1
- backup singers 1
- bright warm pad synth 1
- cajun beat 1
- calm 1
- cheerful 1
- complex chords 1
- contemporary pop 1
- digital drum 1
- drum machine 1
- electric guitar 1
- ending song 1
- energetic 1
- first love 1
- foreign language 1
- groovy bass 1
- groovy music 1
- groovy rhythm 1
- high spirits 1
- infectious drumming 1
- inspiring 1
- intricate bassline 1
- jazz style piano 1
- life is good 1
- life lessons 1
- male backup singers 1
- male vocalist 1
- medium fast tempo 1
- melancholic 1
- mellow 1
- melodic 1
- melodious vocal backup 1
- minimal r&b drumming 1
- modern hip hop hits 1
- motivational 1
- ost 1
- passionate female vocalist 1
- peaceful 1
- persuasive 1
- r&b 1
- rapping vocals 1
- relaxing playlists 1
- retro dance hits 1
- seductive 1
- self discovery 1
- serene 1
- simple groove 1
- slick drumming 1
- slow tempo 1
- soft 1
- soft rock 1
- soul 1
- soulful 1
- spirited 1
- steady bass lines 1
- steady drumming 1
- steady percussive rhythm 1
- straight bass lines 1
- synth arrangements 1
- synthesiser arrangements 1
- tender 1
- violin harmony soft 1
- violin-like synth 1
- world music 1
- you’ve got mail 1
musiccaps_names (array) 9 ✖
- Rhythm and blues · 6 ✖
- Music 5
- Singing 2
- Exciting music 1
- Funk 1
- Jazz 1
- Music of Africa 1
- Reggae 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
You've got mail ending - Music: Forever J | A male vocalist sings this romantic song. The tempo is medium fast with keyboard harmony, infectious drumming, steady bass lines and electronic guitar. The song is simple, mellow, tender, sentimental, emotional and mellow. This is a Romantic Soft Rock. | 2007-02-17T09:45:14Z | john kouk | Sweet movie, sweet actors, sweet song... | ["Jazz", "Music", "Rhythm and blues"] | ["male vocalist", "medium fast tempo", "infectious drumming", "sentimental", "mellow", "tender", "love song", "first love", "pop", "ost", "you’ve got mail", "ending song", "keyboard harmony", "steady bass lines", "violin harmony soft", "mellow", "romantic", "soft rock", "electric guitar"] | 7 | 6PWiDlWmPs0 | 751 | |
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 | ||
Michael ofori ogyegyentwie ghana gospel music | A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. | 2009-04-20T09:40:57Z | gimwhp | Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. | ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] | ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] | 7 | D3FyfFIKLVc | 1430 | |
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 | ||
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 | |
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;