musiccaps_details (view)
1 row where musiccaps_aspects contains "latin dance" and musiccaps_names contains "Rimshot" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- acoustic latin drums 1
- cowbell 1
- energetic 1
- instrumental 1
- latin dance · 1 ✖
- percussion 1
- rhythm 1
- timbale 1
musiccaps_names (array) 5 ✖
- Cowbell 1
- Drum 1
- Percussion 1
- Rimshot · 1 ✖
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marc Quinones Signature Primero Timbales Performance #3 | This is an instrumental percussion piece. There is an acoustic latin drum kit composed of the cowbells and the timbales. The drummer is playing an energetic solo on this kit. This piece could be playing in the background at a drum shop. | 2014-02-09T02:45:17Z | Pearl Drums | Marc Quinones (The Allman Brothers Band) performs on his Signature Primero Timbales and Signature New Yorker Cowbell. Designed in conjunction with one of today's premier percussionists, Marc's timbale set consists of standard 14"x7" and 15"x7" drums and a double-braced tilting stand. The Black Powder Coated Timbales produce a cutting "cascara" sound to ensure you're heard over any band. The Marc Quinones Timbal bell is the ultimate salsa campana bell. Similarly built to the New Yorkers, with its one-piece steel construction, this bell is engineered to cut through the largest latin ensembles. This is the only salsa bell approved by Marc Quinones. Find out more at http://pearldrum.com/products/percussion/cowbells/bala-bells/ Connect with Pearl Drums at: https://twitter.com/PearlDrumCorp https://www.facebook.com/pearldrumsfan http://instagram.com/pearl_drums https://plus.google.com/+PearlDrumCorp | ["Cowbell", "Drum", "Rimshot", "Snare drum", "Percussion"] | ["percussion", "rhythm", "instrumental", "acoustic latin drums", "timbale", "cowbell", "energetic", "latin dance"] | 9 | AkHaDKuiE_s | 1162 |
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;