musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- passionate · 2 ✖
- punchy kick 2
- punchy snare · 2 ✖
- addictive 1
- disco 1
- emotional 1
- funky 1
- funky electric guitar melody 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- groovy synth keys melody 1
- passionate female vocal 1
- passionate male vocal 1
- r&b 1
- shimmering cymbals 1
- shimmering hi hats 1
- wide background female vocals 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
70s Disco Hits - A Video Compilation of Disco Music from the 70's | The Disco song features a passionate male vocalist singing over funky electric guitar melody, groovy bass, punchy kick and snare hits, shimmering hi hats and groovy synth keys melody. It sounds groovy, funky and passionate. | 2008-11-27T00:42:17Z | TheGreat70s | Song List w/ Full Videos : https://thegreat70s.com/Song-List-70s-Disco-Hits.html 70 Disco Music Video Station: https://thegreat70s.com/music-video-stations/ Video Description: A medley of video clips of Disco music from the 70s. For more great 70s videos visit https://www.thegreat70s.com | ["Music", "Rhythm and blues"] | ["disco", "passionate male vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering hi hats", "groovy synth keys melody", "passionate", "groovy", "funky"] | 4 | JlzlNpttvVM | 2031 | |
Faith Evans- Mesmerized | The R&B song features a passionate female vocal, alongside wide background female vocals, singing over shimmering cymbals, punchy kick and snare hits, groovy bass guitar and wide electric guitar melody. It sounds passionate, emotional and addictive - like something you would hear in clubs a lot. | 2007-04-16T15:46:14Z | Amanda Ab | Faith evans video | ["Music", "Rhythm and blues"] | ["r&b", "wide background female vocals", "passionate female vocal", "shimmering cymbals", "punchy kick", "punchy snare", "groovy bass guitar", "wide electric guitar melody", "passionate", "emotional", "addictive"] | 4 | NC5tIv4-8fg | 2325 |
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;