musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2009-01-31
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 |
---|---|---|---|---|---|---|---|---|---|---|
Lee Sankey solo harmonica blues "Work'n" | The low quality recording features a funky harmonica solo melody being played. The recording is noisy and in mono. | 2009-01-31T19:59:34Z | Lee Sankey | Lee Sankey plays his county blues influenced instrumental called "Work'n". Interested in learning to play this style of blues harmonica? Check out Lee's in depth country blues course: http://vimeo.com/ondemand/countrybluesharmonica ▶︎ FOLLOW ME YouTube:http://bit.ly/LeeSankeyYouTube Facebook: http://bit.ly/leesankeyonfacebook Twitter: http://bit.ly/leesankeytwitter Email me info@leesankey.com ▶︎ MY IN-DEPTH HARMONICA COURSES Timing Skills for Blues Harmonica (31 exercises) http://bit.ly/timingskills Harmonica Tongue Blocking (24 lessons) https://www.youtube.com/playlist?list=PL62DB037B81B15454 🎵LISTEN iTunes: http://bit.ly/leesankeyapplemusic Spotify:http://bit.ly/leesankeyspotify Amazon: http://bit.ly/leesankeyamazon Thank you for watching my YouTube Channel. My name is Lee Sankey and here I post videos of my music, provide tips, tutorials and courses for playing blues harmonica. My content is mainly aimed at intermediate and advanced players. I hope you find my channel fun, informative and useful. #bluesharmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "harmonica solo melody", "funky"] | 4 | GyxH8ep_Vx8 | 1767 | |
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 |
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;