musiccaps_details (view)
2 rows where musiccaps_aspects contains "funky" and musiccaps_aspects contains "synth pad"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- funky · 2 ✖
- synth pad · 2 ✖
- digital bass 1
- digital drums 1
- electro 1
- funky electric guitar melody 1
- groovy 1
- groovy bass 1
- jazz 1
- live performance 1
- low quality 1
- noisy 1
- passionate 1
- punchy kick 1
- shimmering hi hats 1
- slower tempo 1
- synth lead sound 1
- uplifting energy 1
- wide passionate harmonizing male vocals 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
Electro - Funk || Stereocool vs. Fais - The Funktotum | This song contains digital drums playing along with a funky synth bassline. Other synth sounds are playing pads and a lead melody. This song sounds like it was made for dancing. This song may be playing in a club. | 2012-07-22T14:23:45Z | Funky Panda™ | ¬ HQ Download Link: http://goo.gl/NDxQZ ¬ Facebook Share http://goo.gl/APV1z || Twitter Share: http://goo.gl/zX0Ml Stereocool http://soundcloud.com/stereocool facebook.com/stereoandcool http://www.youtube.com/user/DeeJayChipZ ¬ Funky Panda Dropbox : http://soundcloud.com/funky-panda-1/dropbox/profile ¬ Funky Panda Facebook : https://www.facebook.com/funkypanda ¬ Funky Panda Twitter : https://twitter.com/#!/Funkyy_Panda ¬ Funky Panda Contact : Funkypanda@hotmail.ca | ["Funk", "Music", "Techno"] | ["electro", "digital drums", "synth lead sound", "synth pad", "digital bass", "slower tempo", "uplifting energy", "funky"] | 6 | iSETDHfErjU | 4187 |
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;