musiccaps_details (view)
2 rows where musiccaps_aspects contains "birds chirping", musiccaps_aspects contains "noisy", musiccaps_author = 4 and musiccaps_names contains "Wind instrument, woodwind 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
128-THE GATHERING | The low quality recording features a short snippet of breathy flute melody at the beginning of the loop, followed by birds chirping and water flowing sounds, due to the fact that it was recorded outdoors. The recording is noisy and in mono. | 2009-08-11T08:09:51Z | MOUNTAINOUS | I TAKE THE VIEWER ON A ADVENTURE IN THE FOREST. THIS IS A TRAIL CALLED THE CROSS TOWN TRAIL IN GOVERNMENT CAMP OREGON WHERE I LIVE ON MT HOOOD. THIS TRAIL GOES NEXT TO OUR VILLAGE THROUGH THE WOODS AND IT COMES OUT RIGHT WHERE I WORK. THIS IS A JOURNEY SHOWING MY MEDITATION, SHAKUHACHI PRACTICE, AND BOJUTSU. I ALSO TALK ABOUT SOME THINGS I WILL DO IN MY FUTURE VIDEOS. AND I GATHER THE GREAT HUCKLEBERRIES. THEY ARE ABOUT IN SEASON. THE MUSIC IS SHAKUHACHI FLUTE. MY NAME IS JASON STORK AND I HAVE THE MOUNTAINOUS DOJO. THIS IS ME PRACTICING NOT TEACHING. I HAVE A 4TH KYU IN THE BUJINKAN. I ALSO HAVE A SHODAN FROM KAMIYAMA BUGEI DOJO I SPENT 6 YEARS IN THE BUJINKAN. THE MUSIC IS THE ZEN GARDEN. THIS VIDEO IS NOT ME TEACHING TECHNIQUES. IT IS A VIDEO OF ME DOCUMENTING MY TRAINING AND MAKING A FUN ADVENTURE OUT OF IT. IF YOU SEEK REAL NINJUTSU TRAINING SEEK THE TEACHINGS OF SOKE HATSUMI AND HIS BUJINKAN SCHOOL OF NINPO AND BUDO TAIJTUSU. THE JAPANESE ART OF THE SAMURAI AND NINJA. IF YOU TRAIN, BE SAFE AND HAVE A QUALIFIED PROFESSIONAL PRESENT. THE CREATOR OF THIS VIDEO IS NOT LIABLE IF YOU GET HURT TRYING THINGS IN THIS VIDEO. I HAVE 6 YEARS EXPERIENCE IN THE BUJINKAN OF HATSUMIS BUDO TAIJUTSU AND NINJUTSU SCHOOLS. I ALSO RECOMMEND THE TEACHINGS OF THE KAMIYAMA DOJOS, GENBUKAN, JINENKAN, BUDORYUNINJUTSU, AND TOSHINDO. THANKS FOR WATCHING | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "breathy flute", "outdoors", "birds chirping", "water flowing", "noisy", "mono"] | 4 | cjTrK-kA6x0 | 3735 |
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;