musiccaps_details (view)
7 rows where musiccaps_aspects contains "backup singers", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "love song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 95 ✖
- backup singers · 7 ✖
- groovy bass line · 7 ✖
- love song · 7 ✖
- vocal harmony 5
- emotional 4
- groovy rhythm 4
- romantic 4
- cheerful 3
- female singer 3
- keyboard accompaniment 3
- passionate 3
- exciting 2
- hip hop music 2
- piano accompaniment 2
- story telling 2
- tambourine percussions 2
- together forever 2
- adoration 1
- arabic dance song 1
- arabic percussions 1
- arabic pop song 1
- arabic singer 1
- average audio quality 1
- bad audio quality 1
- belly dancing music 1
- black gospel influences 1
- bouncy drum rhythm 1
- brass band 1
- choral harmony 1
- clapping rhythm 1
- crooners 1
- cymbals crashing 1
- dance floor 1
- dance music 1
- dance song 1
- disco music 1
- disco romance hits 1
- enegetic 1
- energetic 1
- entertaining 1
- falsetto 1
- fast tempo 1
- female backup singers 1
- female singers 1
- funk pop hits 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- high spirits 1
- hip hop dance music 1
- hip hop hits 1
- hip hops love song 1
- inspiring 1
- jazz music influences 1
- keybiard accompaniment 1
- latin dance song 1
- latin pop song 1
- live audience 1
- live performance 1
- lyrical singing 1
- male latin singer 1
- male singer 1
- male singers 1
- marry me 1
- medium drumming rhythm 1
- medium fast tempo 1
- medium tempo 1
- modern hip hop hits 1
- motivational 1
- music 1
- music you 1
- need your loving 1
- percussive hits 1
- percussive horn section 1
- poor audio quality 1
- pop song 1
- reggae music influences 1
- retro hits 1
- retro pop hits 1
- retro pop influences 1
- retro pop song 1
- self discovery 1
- slick drumming rhythm 1
- slow tempo 1
- slowing down 1
- song retarding 1
- soul singers 1
- steady drumming 1
- steady drumming line 1
- steady percussive rhythm 1
- string section 1
- stro telling 1
- super hits 1
- traditional music influences 1
- trumpets playing percussively 1
musiccaps_names (array) 14 ✖
- Music 6
- Soul music 3
- Afrobeat 1
- Funk 1
- Happy music 1
- Middle Eastern music 1
- Music of Africa 1
- Music of Asia 1
- Music of Latin America 1
- Pop music 1
- Reggae 1
- Rhythm and blues 1
- Whoop 1
- Yell 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 | |
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 | ||
Despicable Me - Boogie Fever - The Sylvers | A male singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, ethnic drumming rhythm, trumpets playing percussively and a keyboard harmony. The song is groovy and cheerful. The song is retro final pop song; | 2010-07-15T01:19:34Z | Duke Tran | I do not own the music or take any credit for this video. I am not claiming that it is mine nor taking any form of incentive. | ["Funk", "Music"] | ["male singers", "backup singers", "vocal harmony", "funk pop hits", "dance floor", "percussive hits", "medium tempo", "groovy bass line", "medium drumming rhythm", "trumpets playing percussively", "story telling", "love song", "brass band", "pop song", "female backup singers", "exciting", "cheerful", "enegetic", "retro pop hits", "dance music"] | 1 | SSO7F_Ex0s4 | 2767 | |
yongseo arab fan- (عالبال (سميرة سعيد | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | 2011-09-20T18:50:38Z | yasmin ali | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | 1 | aOGNUGgTQ8k | 3534 | ||
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 | |
SHOUT - The Fabsisters [Cover Of - The Isley Brothers/Lulu] | A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. | 2012-02-22T18:56:06Z | The Fabsisters | Please watch: "The Drinks are all on him-Folake (The Fabsisters)" https://www.youtube.com/watch?v=pTs3mNrht_4 -~-~~-~~~-~~-~- Please watch: "The Fabsisters - Can't Be With You Tonight" ➨ https://www.youtube.com/watch?v=lG1ce8BrEQ4 | ["Music", "Whoop", "Yell"] | ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] | 1 | qpt3umHYfmY | 4824 |
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;