musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "love songs"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- keyboard accompaniment · 3 ✖
- love songs · 3 ✖
- romantic 3
- female singer 2
- medium tempo 2
- passionate 2
- poor audio quality 2
- arabic dance music sultry vocals 1
- arabic music 1
- arabic percussion 1
- couples dancing 1
- cymbal crashes 1
- dance club mix 1
- dance groove 1
- dance hits 1
- dance tunes 1
- dholak percussions 1
- emotional 1
- funky music 1
- groovy bass line 1
- groovy drum rhythm 1
- groovy music 1
- guitar accompaniment 1
- guitar rhythm 1
- keyboard harmony 1
- latin folk music 1
- latin percussions 1
- latin romantic hits 1
- male singer 1
- mysterious 1
- passionate song 1
- percussion hit 1
- reggae style influences 1
- retro pop hits 1
- salsa 1
- slick drumming 1
- spirited singing 1
- steady drumming rhythm 1
- strong percussive bass line 1
- tambourine percussion 1
- trumpets playing 1
- various percussion hits 1
musiccaps_names (array) 5 ✖
- Music 3
- Folk music 1
- Middle Eastern music 1
- Reggae 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
High Tone ft Pupajim - Rub a Dub Anthem | A female singer sings this cool melody. The song is medium tempo with a percussive bass line, slick drumming rhythm, guitar accompaniment , keyboard accompaniment and various percussion hits. The song has a strong dance groove and retro pop in style. | 2010-05-19T17:31:01Z | Smashing Sound | Out back (jarring effect 17-05-2010) | ["Music", "Reggae"] | ["female singer", "strong percussive bass line", "reggae style influences", "groovy drum rhythm", "guitar rhythm", "slick drumming", "keyboard accompaniment", "funky music", "guitar accompaniment", "dance groove", "retro pop hits", "cymbal crashes", "romantic", "love songs", "dance hits", "dance club mix", "percussion hit"] | 1 | TabaOeYq2ek | 2848 |
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;