musiccaps_details (view)
2 rows where musiccaps_aspects contains "funk" and musiccaps_aspects contains "groovy bassline" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- funk · 2 ✖
- groovy bassline · 2 ✖
- bright synth 1
- dance 1
- dance music 1
- disco funk 1
- eighties 1
- electro-funk 1
- fun 1
- jazzy funk 1
- palm muted electric guitar 1
- retro electric piano 1
- rhythmic groovy drumline 1
- soul 1
- synth stabs 1
- trumpety-synth 1
- upbeat 1
- vibrant brass melody 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jazz Funk - The Scratch - Surface Noise | The clip is an upbeat, groovy funk song with jazzy elements. The retro vintage electric piano chords add an old school jazzy feel to the song. The bassline is intricate and bouncy and enables easy dancing. | 2011-06-30T21:59:36Z | Herecomesmongo79 | The Scratch - Surface Noise - 1980 | ["Jazz", "Music"] | ["funk", "jazzy funk", "groovy bassline", "upbeat", "dance", "fun", "vibrant brass melody", "palm muted electric guitar", "rhythmic groovy drumline", "disco funk", "retro electric piano"] | 3 | TPYNIc_M1ng | 2835 | |
remix funk de tueur | This is a groovy, electro-funk track which works well for dancing. A song like this would be heard in the eighties. It is soulful and upbeat. There are synth stabs and a trumpety synth motif in the background. | 2009-04-16T11:00:07Z | CHRIS CARA | dj ozzir | ["Funk", "Music"] | ["funk", "bright synth", "dance music", "eighties", "electro-funk", "soul", "groovy bassline", "trumpety-synth", "synth stabs"] | 3 | 4Vg0PQuHTk0 | 578 |
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;