musiccaps_details (view)
2 rows where musiccaps_aspects contains "metronome beep" and musiccaps_names contains "Percussion" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- metronome beep · 2 ✖
- drum practice pad 1
- energetic 1
- exciting 1
- instrumental 1
- low quality 1
- mono 1
- noisy 1
- percussion 1
- rhythm 1
- rudiments 1
- snare roll 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Percussion · 2 ✖
- Drum 1
- Drum roll 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Single Stroke Roll Speed - Drum Lesson (DRUMEO) | The low quality recording features a snare roll played over metronome beep. It sounds energetic and exciting, even though the recording is in mono and a bit noisy. | 2011-12-06T20:53:48Z | Drumeo | Learn The Drums Faster, Easier, Better: ► https://www.Drumeo.com/ Faster Hands & Feet (in 10 days) ► https://www.Drumeo.com/faster/ Study with your favorite drummers for a FREE 30-days: ►http://www.Drumeo.com/trial/ Follow us! ►Facebook: http://www.facebook.com/Drumeo/ ►Instagram: http://www.instagram.com/drumeoofficial/ ►Twitter: http://www.twitter.com/Drumeo/ View the resources for this lesson at: ►http://www.drumlessons.com/drum-lessons/drum-set-rudiments/single-stroke-roll-speed/ | ["Drum", "Drum roll", "Percussion"] | ["low quality", "snare roll", "metronome beep", "uptempo", "energetic", "exciting", "noisy", "mono"] | 4 | 8LYWfpPUokc | 914 | |
Bell Ruschel - solo 53 | This is an instrumental percussion piece recording. There is a drummer playing rudiments in rapid procession on a practice pad. A loud metronome beep can be heard close by. This piece could be used in rudimentary education during drum lessons. | 2011-04-10T11:43:29Z | BellRuschel | solo com documentário do show da Fresno em Salvador 150 solos - Charley Wilcoxon | ["Wood block", "Percussion"] | ["instrumental", "percussion", "rhythm", "drum practice pad", "rudiments", "metronome beep"] | 9 | d-AcpHG7OjU | 3753 |
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;