musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_names contains "Harmonica" and "youtube_published" is on date 2012-06-27
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 |
---|---|---|---|---|---|---|---|---|---|---|
playing the blues on chromatic harmonica (Gussow 2012) | The low quality recording features a dissonant harmonica melody, followed by lag tapping, birds chirping and dog barking sounds, as it was recorded outdoors. The recording is noisy and it sounds like a tutorial. | 2012-06-27T18:12:41Z | Modern Blues Harmonica | An introductory lesson on playing the blues on chromatic harmonica. With Adam Gussow of Oxford, Mississippi. The lesson begins with a brief pitch for an upcoming harmonica clinic/concert with Gussow, Ronnie Shellist, and Aki Kumar, which will take place at the Grand Dell Saloon in Campbell, California (part of greater San Jose) on September 15, 2012. For more info on the clinic, please visit the website: http://californiaharmonicaworkshop.weebly.com/ If you're interested in learning how to play the blues on diatonic (10-hole) harmonica, please visit Gussow's website, Modern Blues Harmonica: http://www.modernbluesharmonica.com/home.html The outro music is the opening minute of "Grazing in the Grass," a cover of the Hugh Masekela pop-jazz hit. It's part of Gussow's new album, SOUTHBOUND. You can purchase it at iTunes, Amazon mp3s, or at Gussow's website: http://www.modernbluesharmonica.com/southbound_1.html | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "dissonant harmonica melody", "birds chirping", "dog bark", "outdoor", "tutorial", "leg tapping"] | 4 | PufDOSkxwzQ | 2576 |
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;