musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- groovy bass · 2 ✖
- acustic guitar 1
- bass guitar 1
- blues 1
- boomy 1
- chaotic 1
- confusing 1
- dissonant strings 1
- fast tempo 1
- finger licking sound 1
- flat repetitive female vocal 1
- fun 1
- groovy bass lines 1
- happy 1
- intense 1
- jazz 1
- keyboard harmony 1
- lively drumming 1
- low quality 1
- male vocal mumbling 1
- male vocalist 1
- mellow bells melody 1
- noisy 1
- pop 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- steady drumming 1
- superimposed syncopated strings 1
- syncopated music 1
- two tracks playing 1
- ukele 1
- unrelated tracks 1
musiccaps_names (array) 4 ✖
- Music 2
- Ukulele · 2 ✖
- Guitar 1
- Inside, small room 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra - Wuthering Heights | A male vocalist sings this melodic jazz/blues. The tempo is medium fast with a piano accompaniment, groovy bass lines, infectious drumming and guitar accompaniment. There is a sound of syncopated ukulele and another string instrument playing over the song. The song is melodic and ambient but the superimposed strings melody is making it chaotic, busy, confusing and confusing. | 2007-02-12T00:31:35Z | daviie | The Ukulele Orchestra - Wuthering Heights | ["Music", "Ukulele"] | ["male vocalist", "fast tempo", "jazz", "blues", "dissonant strings", "groovy bass", "steady drumming", "intense", "keyboard harmony", "lively drumming", "superimposed syncopated strings", "syncopated music", "groovy bass lines", "two tracks playing", "unrelated tracks", "chaotic", "confusing", "ukele", "acustic guitar", "bass guitar", "boomy"] | 7 | KmBaE7ozWow | 2117 | |
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 |
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;