musiccaps_details (view)

1 row where musiccaps_aspects contains "drum music", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Snare drum"

✎ 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
Allen & Heath ZED Sixty10FX USB mixer demo at Nevada Music UK This song features percussion being played at a fast tempo. The beat is of moderate difficulty. The kick is played on the first count of each bar. The snare is played on the second and fourth counts of each bar. The hi-hat is played at a unique rhythm with accents on the first 'and' and the third, third and and fourth counts. There are no voices in this song. This is an instrumental song at a fast tempo. There are no other instruments in this song. 2013-05-07T10:06:08Z PMTVUK http://www.pmtonline.co.uk/allen-and-heath-zed60-10fx-mixing-desk https://www.facebook.com/PMTHouseOfRock/ https://twitter.com/pmthouseofrock https://www.instagram.com/pmthouseofrock The Allen & Heath ZED60-10FX is designed as a portable mixer for solo artists, duos and small bands.The ZED60-10FX is essentially the same as Allen & Heath's popular ZED-10FX mixer, but it replaces the level knobs with 60mm faders for a more traditional mixing experience. Just like the ZED-10FX, the ZED60-10FX features 16 pro-quality FX and can be used both live or in the studio. The ZED60-10FX mixer is in fact the perfect choice for a guitar player .... Two of the 4 mono channels have high impedance jack inputs that can take a normal line level or a low level input from a guitar pickup, so guitars can be plugged straight into the mixer without the need for DI boxes. These inputs have been crafted to recreate the sound of a classic tube preamp in a combo or head amp for incredible definition and warmth whilst two stereo inputs are provided for MP3/CD players or keyboards. Allen & Heath's ZED60-10FX comes with configurable USB audio in/out, making it easy to capture a stereo recording at a gig or in the studio. The mixer is equipped with professional XLR main stereo outputs, a flexible monitoring section with headphone and speaker feed outputs, and 16 impressive sounding FX. Most important of all, ZED60-10FX lives up to the audio and build quality standards that have made Allen & Heath one of the most trusted names in professional audio for more than 40 years. ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["drum music", "instrumental", "no voices", "no other instruments", "fast tempo"] 0 A446kjocnCg 1064

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;