musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- happy · 3 ✖
- low quality 3
- fun 2
- noisy 2
- acoustic rhythm guitar 1
- aggressive strumming 1
- cover 1
- finger licking sound 1
- flat repetitive female vocal 1
- groovy bass 1
- hollow 1
- kids song 1
- loud 1
- male vocal mumbling 1
- mellow bells melody 1
- mono 1
- pop 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- sweet girl vocal 1
- uptempo acoustic rhythm guitar chord progression 1
musiccaps_names (array) 7 ✖
- Music 3
- Ukulele · 3 ✖
- Guitar 2
- Inside, small room 1
- Mandolin 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Cat that loves Horses | The low quality video features a cover of a kids song and it consists of a sweet girl vocal singing over acoustic rhythm guitar. The recording is in mono, noisy and it sounds fun and happy. | 2008-10-19T03:57:30Z | kangurski | so cute :) | ["Music", "Mandolin", "Ukulele"] | ["low quality", "mono", "cover", "sweet girl vocal", "acoustic rhythm guitar", "noisy", "fun", "happy", "kids song"] | 4 | 9ZWmZdgrE78 | 1023 | |
Gwiyomi / Kiyomi 하리 (Ukulele cover)_牛奶哥哥_烏克麗麗 | The low quality recording features a pop song played on playback while a male vocalist is mumbling over it. The song consists of a groovy bass, shimmering hi hats, punchy kick and snare hits, mellow bell melody, and flat repetitive female vocals singing over it. The recording is noisy, which is very audible at the very end of the loop where there is a finger licking sound. It still sounds happy and fun. | 2013-03-29T16:37:16Z | 林宗彥 | My Facebook:http://www.facebook.com/milkbrother0808 | ["Guitar", "Music", "Ukulele", "Inside, small room"] | ["low quality", "pop", "noisy", "male vocal mumbling", "groovy bass", "shimmering hi hats", "punchy kick", "punchy snare", "mellow bells melody", "happy", "fun", "finger licking sound", "flat repetitive female vocal"] | 4 | ca-rGWC4xPc | 3720 | |
He'eia (Ukulele, Traditional Hawaiian Song) | The low quality recording features an acoustic rhythm guitar being aggressively strummed, while producing some happy sounding melodies. The guitar sounds a bit hollow, almost as if it is recorded with a phone. | 2007-02-20T21:09:49Z | Chris Brown | He'eia is an traditional Hawaiian song about the Kings favorite surfing spot. It was originally a chant that has been adapted to ukulele. Carl Ray VillaVerde plays both rhythm and lead in this version. He and wife Joannie form a duet called "Mango" and have produced a number of entertaining recordings. There is a site where downloads and CD's are available at http://cdbaby.com/cd/mangolilikoi | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "uptempo acoustic rhythm guitar chord progression", "hollow", "loud", "aggressive strumming", "happy"] | 4 | mW5_chAgg8c | 4475 |
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;