musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "ukulele melody" and musiccaps_names contains "Musical instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;