musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "home music video" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- groovy rhythm · 3 ✖
- home music video · 3 ✖
- instrumental music 3
- medium tempo 3
- poor audio quality · 3 ✖
- emotional 2
- aboriginal instruments 1
- adventure of a lifetime 1
- backing track 1
- chord changes 1
- classic rock 1
- demonstration 1
- devotional 1
- didgeridoo 1
- didgeridoo player 1
- exciting 1
- forest music 1
- funk jazz 1
- groovy music 1
- guitar demo 1
- guitar lead 1
- guitar solo 1
- hand percussions 1
- healing 1
- jazz music 1
- keyboard accompaniment 1
- keyboard comparison video 1
- live music 1
- live performance 1
- music demonstration 1
- music store 1
- organ accompaniment 1
- passionate 1
- percussive horn play 1
- psychedelic 1
- retro rock music 1
- soloist 1
- spirited 1
- steady bass line 1
- steady rock drumming 1
- tambourine percussions 1
- tapping sounds 1
- tonal differences 1
- vintage rock vibes 1
- wood clock percussions 1
musiccaps_names (array) 6 ✖
- Music 2
- Didgeridoo 1
- Electric piano 1
- Grunge 1
- Keyboard (musical) 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kurzweil Artis vs Nord Stage vs Yamaha Motif XF8 vs Korg Kronos | The song is an instrumental. The song is medium tempo with chord changes played on different keyboards to check subtle differences in tonality. The song track is a comparison video playing funk jazz accompaniment. | 2014-01-09T20:53:42Z | Hit Space Hangszer- és Stúdiótechnikai Szaküzlet | Egy kis ízelítő pár népszerű billentyűs hangszerből. Mivel a hangszerek mindegyike rendelkezik valamiféle extrával a másikhoz képest, érdemes őket személyesen kipróbálni. A Hit Space-ben található Magyarország legszélesebb szintetizátor választéka, ahol minden érdeklődőt szeretettel látunk! | ["Electric piano", "Keyboard (musical)", "Piano"] | ["keyboard comparison video", "medium tempo", "jazz music", "groovy rhythm", "music store", "music demonstration", "home music video", "instrumental music", "funk jazz", "chord changes", "poor audio quality", "live performance", "groovy music", "exciting", "tonal differences", "keyboard accompaniment"] | 1 | M1ds6tRFxhs | 2236 | |
Snap Crackle and how`s your Dad | The song is an instrumental. The song is medium tempo with a groovy bass line, rock drumming, tambourine percussion, guitar rhythm and guitar lead. The song is adventurous and emotional. The song is classic rock and has a poor audio quality. | 2010-06-19T06:13:50Z | BurnsErnst | Here is another special tune by The Shadows. Backing track is from the original vinyl record without the first lead. On some parts, where the lead was on both channels, I try to play as exactly along with Hank as I could. I hope it`s ok. | ["Music", "Grunge"] | ["instrumental music", "guitar lead", "soloist", "guitar solo", "vintage rock vibes", "emotional", "spirited", "passionate", "groovy rhythm", "psychedelic", "backing track", "classic rock", "tambourine percussions", "medium tempo", "steady rock drumming", "organ accompaniment", "poor audio quality", "home music video", "guitar demo", "retro rock music", "steady bass line", "adventure of a lifetime"] | 1 | g6f-LxiT9Eo | 4006 | |
Ondrej Smeykal Didjeridu Solo 2 | The song is an instrumental. The tempo is medium with a wood block percussion and a didgeridoo playing percussively. The song is spiritual and emotional in nature. The audio quality is poor. | 2009-05-01T20:56:34Z | Barry Martin | Here's the much anticipated second clip of Ondrej Smeykal playing didgeridoo while visiting LA Outback. Ondrej is playing this didjeridu solo with a pair of clapsticks. If you ever have the chance to see him live definitely make it a point to do so. Check out a wide selection of didgerdioo made in Australia and available in the US at http://www.laoutback.com | ["Didgeridoo", "Music"] | ["didgeridoo", "didgeridoo player", "live music", "home music video", "demonstration", "aboriginal instruments", "poor audio quality", "wood clock percussions", "instrumental music", "hand percussions", "tapping sounds", "medium tempo", "percussive horn play", "groovy rhythm", "emotional", "devotional", "healing", "forest music"] | 1 | q7U8p-m8J3s | 4753 |
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;