musiccaps_details (view)
1 row where musiccaps_aspects contains "cowbell one shots", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "mono" and musiccaps_aspects contains "tutorial"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Lea Mullen: Pearl Horacio Hernandez Cowbells - JOHNNY ROADHOUSE MUSIC Demo Video | The low quality recording features a tutorial that consists of a flat male vocal talking, after which there are a few different pitch cowbell one shots. The recording is in mono and it is noisy. | 2014-08-16T18:18:33Z | Johnny Roadhouse Music | Demo video for the brand new Pearl Horacio Hernandez signature cowbells, played in store at Johnny Roadhouse Music in Manchester, UK by Pro Pearl Percussionist, Lea Mullen. The Horacio Hernandez cowbells come in five sizes: HH-1X BELLa (High-Pitched Cha-Cha) HH-2X ClaBELL (Foot Clave) HH-3X ChaBELLa (Low-Pitched Cha-Cha) HH-4X IsaBELL (Mambo) HH-5X MaryBELL (Timbale) Please visit our website for this instrument along with the rest of our stock: http://www.johnnyroadhouse.co.uk/pearl-hh-5x-horacio-hernandez-ii-marybell-cowbell.html "Manchester Percussion" is the percussion-focussed drum department situated in Manchester's famous musical superstore, Johnny Roadhouse Music. JRM has been established for over 55 years in the same building, it remains a family-run high street business: run by musicians, for musicians. Filmed by Evan Wilson & Kamran Ali Directed & Edited by Evan Wilson Graphics & Music by Evan Wilson --------------- Johnny Roadhouse Music 123 Oxford Road Manchester M1 7DU UK Tel.: 0161 273 1000 http://www.johnnyroadhouse.co.uk https://twitter.com/JohnnyRoadhouse | ["Cowbell", "Percussion"] | ["low quality", "flat male vocal", "cowbell one shots", "noisy", "mono", "tutorial"] | 4 | YAVVMxqtxGE | 3260 |
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;