musiccaps_details (view)
3 rows where musiccaps_names = "["Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"]", musiccaps_names contains "Music" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;