musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy" and musiccaps_aspects contains "synth pad"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- groovy · 2 ✖
- synth pad · 2 ✖
- acoustic drums 1
- bass guitar 1
- brass sound 1
- compilation 1
- funky 1
- funky electric guitar melody 1
- generic 1
- groovy bass 1
- instrument showcase 1
- jam 1
- jazz 1
- keyboard 1
- live performance 1
- low quality 1
- noisy 1
- passionate 1
- punchy kick 1
- shimmering hi hats 1
- wide passionate harmonizing male vocals 1
musiccaps_names (array) 8 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Percussion 1
- Rimshot 1
- Ska 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roland BK9 Super Light Keyboard Demonstration - instruments2go | This is an instrument showcase jam. Different tracks are being played to show the features of a keyboard. Initially, there is a synth pad playing. Then, an acoustic sounding drum beat and a groovy bass line starts playing in the background of a brass sounding melody. The sounds are mostly generic. Parts of this recording could be sampled to be used in advertisement jingles. | 2013-05-08T19:21:58Z | A&C Hamilton Musical Instruments | FREE USB DRIVE with 100s of extra styles with all SUPER LIGHT BK-9's supplied by www.instruments2go.co.uk / www.achamilton.co.uk We have put together a demonstration of a few of the sounds and styles from the Roland BK-9. It's a fantastic 76 key arranger keyboard with a wealth of professional features, and is supplied with a USB stick with extra styles. Perfect for the home user and professional musician alike. And it weighs just 9.4kg! Our Roland BK-9 video offers just a small sample of everything this instrument can do and how it can sound. Product details, pricing and availability are all available from www.instruments2go.co.uk - or call us direct on 01772 36691 | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["jam", "compilation", "instrument showcase", "keyboard", "synth pad", "acoustic drums", "bass guitar", "brass sound", "groovy", "generic"] | 9 | KzzKguqINa8 | 2140 | |
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 |
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;