musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "romantic" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- passionate · 4 ✖
- romantic · 4 ✖
- emotional 3
- groovy bass line 2
- love song 2
- male singer 2
- passionate male vocal 2
- shimmering shakers 2
- auto harp 1
- backup singers 1
- clapping rhythm 1
- country pop 1
- country song 1
- dance song 1
- dobro 1
- dulcet 1
- echoing harmonizing vocals 1
- energetic crash cymbal 1
- fiddle 1
- fingers snapping 1
- groovy rhythm 1
- hip hop hits 1
- hip hop music 1
- hip hops love song 1
- live audience 1
- live performance 1
- low quality 1
- mandolin 1
- mellow 1
- mellow bass 1
- noisy percussion 1
- piano accompaniment 1
- piano chords 1
- pleasant melody 1
- pulsating synth melody 1
- punchy kick 1
- punchy snare 1
- r&b 1
- regional pop 1
- resonator 1
- sentimental 1
- shimmering hi hats 1
- simple melody 1
- sizzling triangle 1
- slick drumming rhythm 1
- slow tempo 1
- snappy snare 1
- soft 1
- soul/r&b 1
- steady drumming 1
- steady drumming line 1
- super hits 1
- synth pad chord 1
- tambourine 1
- together forever 1
- wide acoustic rhythm guitar melody 1
musiccaps_names (array) 4 ✖
- Music 4
- Soul music · 4 ✖
- Musical instrument 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stevie Hoang - Addicted - new music video 2009 | A male singer sings this cool hip hop love song with backup singers in vocal harmony. The tempo is medium with keyboard accompaniment, piano accompaniment, steady drumming rhythm, clapping percussion and other sonic effects. The song is emotional and romantic with a cool dance groove, | 2009-05-18T16:36:44Z | steviehoang | Buy the Physicial CD http://www.cdbaby.com/cd/steviehoang3 Official Facebook https://www.facebook.com/StevieHoangMusic Twitter https://twitter.com/steviehoang | ["Music", "Soul music"] | ["male singer", "hip hop music", "backup singers", "live performance", "live audience", "super hits", "piano accompaniment", "groovy bass line", "steady drumming line", "slick drumming rhythm", "emotional", "romantic", "passionate", "together forever", "love song", "hip hop hits", "groovy rhythm", "dance song", "hip hops love song", "clapping rhythm"] | 1 | -oP-XX28B0s | 87 | |
Max Mutzke - Can´t Wait Until Tonight (official Video) | The Soul/R&B song features a passionate male vocal singing over shimmering hi hats, energetic crash cymbals, wide acoustic rhythm guitar melody, shimmering shakers, snappy snare, piano chords and mellow bass. It sounds passionate and romantic - like something you would sing to your partner. | 2010-01-25T11:53:51Z | Max Mutzke | Der Videoclip zu Can´t Wait Until Tonight von Max Mutzke. Mehr Max gibt es hier http://www.maxmutzke.de | ["Singing", "Music", "Musical instrument", "Soul music"] | ["soul/r&b", "passionate male vocal", "shimmering hi hats", "energetic crash cymbal", "wide acoustic rhythm guitar melody", "shimmering shakers", "snappy snare", "piano chords", "mellow bass", "passionate", "romantic"] | 4 | 5ZX9Ig7XXsw | 668 | |
H-Town - Part Time Lover | The low quality recording features a R&B song that consists of echoing harmonizing vocals, alongside passionate male vocal singing over noisy percussion, punchy snare and kick hits, pulsating synth melody, synth pad chord, shimmering shakers and sizzling triangle. It sounds romantic, passionate and emotional - like something you would slow dance to with your partner. | 2009-04-25T19:56:38Z | ManUtdAL3X | Above The Rim Soundtrack [1994] http://www.imdb.com/title/tt0109035/ "Part Time Lover" Performed by H-Town Written by DeVante DeGrate (as Devante Swing) and Darryl Pearson Courtesy of Luke Records | ["Music", "Soul music"] | ["low quality", "r&b", "noisy percussion", "punchy snare", "pulsating synth melody", "synth pad chord", "echoing harmonizing vocals", "passionate male vocal", "punchy kick", "shimmering shakers", "sizzling triangle", "romantic", "emotional", "passionate"] | 4 | 5mLYN-F2Oek | 692 | |
Viggo Mortensen - Breathe A Sigh | A male vocalist sings this dulcet melody. The tempo is soft with acoustic guitar, resonator, fiddle, mandolin, banjo, dobro and auto harp accompaniment, steady drumming, tambourine beats , fingers snapping and funky bass lines. The song is soft, mellow, dulcet, emotional, sentimental, soothing , pleasant and simple. The song is Country Pop. | 2007-07-08T11:59:56Z | athelas51 | Again with my favorite Def Leppard's song. | ["Music", "Soul music"] | ["male singer", "slow tempo", "groovy bass line", "dulcet", "fingers snapping", "tambourine", "simple melody", "auto harp", "fiddle", "resonator", "dobro", "mandolin", "steady drumming", "soft", "mellow", "love song", "romantic", "passionate", "sentimental", "emotional", "country song", "country pop", "regional pop", "mellow", "pleasant melody"] | 7 | mJuJfKbcJcw | 4459 |
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;