musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance" and musiccaps_aspects contains "groovy bassline" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- dance · 3 ✖
- groovy bassline · 3 ✖
- upbeat 3
- soulful 2
- vibrant 2
- blues 1
- brass instruments 1
- calm electric piano 1
- charismatic male lead vocals 1
- disco funk 1
- disco style 1
- eighties 1
- energetic male vocalist 1
- fun 1
- funk 1
- funky 1
- funky background vocals 1
- funky song 1
- jazzy funk 1
- palm muted electric guitar 1
- raspy male vocal 1
- retro electric piano 1
- rhythm & blues 1
- rhythmic groovy drumline 1
- simple drum beat 1
- trumpet 1
- vibrant brass melody 1
musiccaps_names (array) 4 ✖
- Music 3
- Funk 1
- Jazz 1
- Soul music 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 | |
One On One - Body Music ( Disco Funk 1981 ) | This is a funky disco song. A song like this would be suitable for an eighties themed dance party. It has a groovy bassline, upbeat rhythmic percussion, and vibrant brass motifs. The singer sounds charming and energetic. The background singers are soulful and sharp on the beat with their vocals - they sing their notes almost in staccato, so that they can stay close to the beat and keep the song feeling groovy. | 2009-02-09T07:41:33Z | andersnordhagen | ["Funk", "Music"] | ["funky song", "disco style", "upbeat", "dance", "groovy bassline", "eighties", "vibrant", "soulful", "funky background vocals", "charismatic male lead vocals", "brass instruments", "trumpet", "calm electric piano"] | 3 | 9JeN1ld-3fY | 992 | ||
Arthur Conley ~ Sweet Soul Music (1967) | This is an upbeat, soulful and funky song. It's got a catchy and fast paced rhythm which makes it good to dance to. The singer has a raspy and energetic voice. | 2011-10-24T15:04:43Z | TheOldrecordclub | This great soul song by "Arthur Conley" was released in 1967 and i believe this was the biggest hit song he had.He actually wrote this song with "Otis Redding" and the song was originally released on the Atco label. | ["Music", "Soul music"] | ["blues", "funky", "soulful", "upbeat", "dance", "vibrant", "groovy bassline", "rhythm & blues", "raspy male vocal", "energetic male vocalist", "simple drum beat"] | 3 | grE0lwTsSPg | 4060 |
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;