musiccaps_details (view)

1 row where musiccaps_aspects contains "beatboxing", musiccaps_aspects contains "mono" and musiccaps_names contains "Beatboxing"

✎ 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
Beatbox With Me - Advanced beat 1 with inward rimshot (inward K snare) The low quality recording features hip hop beatboxing. The recording is noisy and in mono, as it was probably recorded with a phone. 2009-09-23T20:00:38Z Fat Tony A tricky beat that can be a real tongue twister. Done using the inward K. Great for practicing kick rolls. This beat is also a great example of an auditory illusion - if you get all the hi-hats right, they sound separated from the rest of the beat making it appear that you're doing more than one sound at a time. You'll need to know... -Kick drum (taught in my basic sounds tutorial) -Dry kick (taught in my dry kick tutorial... you need to be able to do them with your lips together) -Kick rolls (taught in my kick rolls tutorial and encompasses the above) -Hi-hats (taught in my basic sounds tutorial) -Inward rimshot (taught in my inward K snare tutorial) Updated on a regular basis this series will teach you various beats using a variety of sounds. The "simple" beats are good for practicing new sounds or for newcomers to beatbox, the "intermediate" beats are a little faster or more complicated, while the "challenging" beats are for the more advanced beatboxer. "Song covers" are, obviously, covers of songs and can be any difficulty. Please feel free to hit the subscribe button, or leave a comment mentioning my awesomeness. If you would like help with the sounds or feedback on your beats, post a video response showing the sound as you are doing it, and I will be happy to give feedback. Become a fan on Facebook for regular updates - http://www.facebook.com/pages/Fat-Tony/118561857365 Follow me on Twitter - http://www.twitter.com/fattonybbx If you have any questions you'd like answered, please feel free to email me: Fat_Tony@HUMANBEATBOX.COM Peace, love, and noise -FT ["Beatboxing", "Music"] ["low quality", "beatboxing", "noisy", "hip hop", "mono"] 4 Vbcy6KBJsAA 3011

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;