musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "rhythmic beats" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- instrumental · 3 ✖
- rhythmic beats · 3 ✖
- fast tempo 2
- acerbic 1
- amateur recording 1
- bass drum 1
- beat boating 1
- catchy beat 1
- cymbal crash 1
- digital drum imitation 1
- drum head 1
- drum lesson 1
- drumming instructions 1
- drumming pattern lesson 1
- energetic 1
- energetic drumming 1
- enthusiastic drumming 1
- foot pedal 1
- hand percussion 1
- hi hat 1
- hip-hop 1
- home recording 1
- inferior audio quality 1
- jingles 1
- male voice speaking 1
- medium fast tempo 1
- metallic sounds 1
- minimal instrumentation 1
- percussion 1
- percussion instrument 1
- percussive instrumental 1
- portable percussion instrument 1
- rap 1
- rapid 1
- repeated rhythm 1
- rhythmic beat 1
- rhythmic pattern 1
- sharp 1
- small metal plates 1
- snare drum 1
- soft drum head beat 1
- tambourine beats 1
- throbbing 1
- tutorial 1
- vigorous 1
- vocal drumming 1
- vocal percussion 1
- youthful 1
musiccaps_names (array) 13 ✖
- Bass drum 1
- Beatboxing 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Tambourine 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Conversation for Two Tambourines | This music is a percussion instrumental . The tempo is medium fast with a rhythmic tambourine beat. The music is minimal with the sound of the tambourine metal plates clanging and a dull drum head beat. The music is catchy, enthusiastic and has a rhythmic beat. | 2010-01-08T01:22:27Z | jmvdude | A tambourine duet written by my instructor, Bobby Lopez | ["Music", "Tambourine"] | ["instrumental", "medium fast tempo", "percussion instrument", "minimal instrumentation", "soft drum head beat", "catchy beat", "rhythmic beat", "small metal plates", "jingles", "portable percussion instrument", "sharp", "acerbic", "tambourine beats", "hand percussion", "rhythmic beats", "metallic sounds", "drum head"] | 7 | 7_80oVTLkGU | 861 | |
Drum Lesson - Does your Fill Fit? - Vanz Drumming | This music is a percussive instrumental. The tempo is fast with a vigorous, vivacious beat. It is rhythmic, pulsating, vigorous and energetic with a male voice giving instructions on drumming styles. This clip is an instruction audio/video on drumming patterns. | 2008-02-04T01:32:19Z | Vanz Drumming | Make sure your fills fit the groove you are playing. A look at various grooves and fills that compliment the groove. Enjoy. Randy Van Patten www.vanzdrumming.com | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["instrumental", "fast tempo", "male voice speaking", "tutorial", "drumming instructions", "drumming pattern lesson", "drum lesson", "snare drum", "bass drum", "foot pedal", "cymbal crash", "hi hat", "energetic drumming", "enthusiastic drumming", "percussive instrumental", "throbbing", "rhythmic beats", "rhythmic pattern", "repeated rhythm"] | 7 | pLqa0cqsICA | 4703 | |
Beatbox by krNfx 2 | This music is a percussive instrumental. The tempo is fast with a beatboxing rhythm. The beat is a vigorous, rapid, youthful, energetic, enthusiastic imitation of the drum machine. The audio quality is inferior so the music is muffled. | 2010-05-29T09:48:21Z | krnfx | Check out more videos of KRNFX: http://www.youtube.com/KRNFXtv visit KRNFX on facebook: http://www.facebook.com/KRNFX follow KRNFX on twitter: http://www.twitter.com/KRNFX | ["Beatboxing", "Vocal music"] | ["instrumental", "fast tempo", "percussion", "beat boating", "rapid", "vocal drumming", "rap", "hip-hop", "vocal percussion", "rhythmic beats", "home recording", "amateur recording", "inferior audio quality", "digital drum imitation", "vigorous", "energetic", "youthful"] | 7 | yZRTQX8pcMY | 5419 |
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;