musiccaps_details (view)
4 rows where musiccaps_names contains "Guitar", musiccaps_names contains "Plucked string instrument", musiccaps_names contains "Speech" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chikungunya | This music is a ukelele instrumental. The tempo is medium with the sound of a bee buzzing and an animated sound followed by a dialogue between two men in a foreign language. The music is mellow, soft and simple like it's meant for children. | 2014-10-04T21:51:37Z | Sancocho | Chinkungunya by Sancocho De los Creadores de "Ser Boricua Esta Brutal" Ahora les traemos Un tema exclusivo para internet Chinkungunya. Pronto Esperen el Disco Entero, pronto en Algun Momento y Despues las Presentaciones en Vivo, Creemos! WHAT!?! Composicion por Andre Caro y Osvaldo Friger con la Ayuda de Lejos de Dwella | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice talking", "soft", "mellow", "animated", "foreign language", "four stringed instrument", "bee buzzing", "ukelele melody", "animated electronic sound", "funny", "animated", "children’s song"] | 7 | I_wT76iYBdQ | 1920 | |
Canon in D Ukulele Tutorial Part 1- Play it forward entry | The low quality recording features a flat male vocal talking over ukulele melody. It sounds like a tutorial and the recording is noisy and in mono. | 2008-03-29T15:59:48Z | Dave MacTech | Heres a good start for Canon in D. In this video you will learn the chords for Canon in D, How to do those chords, and a simple picking melody. Heres a link to the parts of this tutorial: 1: http://youtube.com/watch?v=US3ZL2zhXgI 2: http://youtube.com/watch?v=A7QAAatmAd4 check out www.ukuleleunderground.com and get on those forums! **Tabs can be found here! join up on the forums so you can access the tab area where you will find ALL kinds of uke tabs. Say 'davoomac' referred you! http://ukuleleunderground.com/forum/showthread.php?p=35915#post35915 | ["Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["low quality", "noisy", "mono", "flat male vocal", "ukulele melody", "tutorial"] | 4 | US3ZL2zhXgI | 2918 | |
Lion Sleeps tonight Ukulele Easy version | solo ukelele playing in free time in a demonstrative manner with a female voiceover. | 2012-02-24T17:10:57Z | Ukulele Bex | Easy version of the Lion Sleeps tonight on the ukulele :D Facebook: https://www.facebook.com/UkuleleBex Twitter: https://twitter.com/UkuleleBex | ["Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["female voice over", "solo ukelele", "demonstartional", "free time"] | 8 | kH-F9JzC7eE | 4306 | |
Jammin - Bob Marley | This is a live recording which features strums of a single chord on a ukulele. At points in the clip, there is the voice of someone who is speaking. The recording is of a low-quality, and thus the audio has a slight fuzzy sound the whole way through. | 2010-06-25T07:28:02Z | Seto Makura | skip tutorial to 2:00 | ["Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["live recording", "low audio quality", "ukulele", "speaking", "audio fuzz"] | 3 | oARFeTnImOg | 4607 |
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;