musiccaps_details (view)

2 rows where musiccaps_aspects contains "noisy", musiccaps_names = "["Cowbell", "Percussion"]" and musiccaps_names contains "Percussion"

✎ View and edit SQL

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
LP Mambo Cowbell DEMO The low quality recording features a cowbell percussion, after which there is a tinny metallic impact. It sounds loud, resonating and the recording is noisy and in mono. 2014-02-18T14:40:39Z Joe Hobkirk A quick sound demo of my Latin Percussion mambo cowbell. This cowbell works great in all situations and at the beginning of the video is a short audio clip of a recording I did with my band using this exact cowbell. ["Cowbell", "Percussion"] ["low quality", "noisy", "mono", "cowbell percussion", "tinny metallic impacts", "loud", "resonating"] 4 Pv8ZWvM8bhw 2578
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

CSV options: 

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;