musiccaps_details (view)
3 rows where musiccaps_aspects contains "pop" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- pop · 3 ✖
- acoustic guitar 1
- amateur recording 1
- country hits 1
- country pop 1
- duet 1
- emotional 1
- female voices singing 1
- finger licking sound 1
- flat repetitive female vocal 1
- folk music 1
- folk pop 1
- fun 1
- groovy bass 1
- happy 1
- harmony 1
- low quality 1
- male vocal mumbling 1
- mandolin 1
- medium tempo 1
- medium to uptempo 1
- mellifluous 1
- mellow 1
- mellow bells melody 1
- melodious 1
- noisy 1
- punchy kick 1
- punchy snare 1
- romantic 1
- sentimental 1
- shimmering hi hats 1
- simple melody 1
- soft 1
- string instruments 1
- ukelele 1
- ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Watch Lennon and Maisy's Ukulele Cover of the "Katie" Theme Song! | Two female voices are singing in harmony to a ukulele strumming chords. One of the voices is deeper and the other one higher. This song may be jamming together at home. | 2013-03-01T19:28:34Z | Katie Couric | We asked YouTube sensations Lennon and Maisy Stella to do their own version of the "Katie" theme song for our Wonder Kids show. Watch their amazing ukulele cover of "This Day"! | ["Singing", "Music", "Ukulele"] | ["pop", "ukulele", "female voices singing", "harmony", "amateur recording", "medium to uptempo"] | 6 | -e4wXAy1iVo | 69 | |
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 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 |
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;