musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_names (array) 14 ✖
- Percussion · 5 ✖
- Drum 4
- Music 2
- Musical instrument 2
- Tabla 2
- Bass drum 1
- Cymbal 1
- Drum and bass 1
- Drum kit 1
- Drum roll 1
- Electronic music 1
- Hi-hat 1
- Snare drum 1
- Tambourine 1
musiccaps_aspects (array) 11 ✖
- amateur recording · 5 ✖
- fast tempo · 5 ✖
- tablas 2
- zitar 2
- acoustic drum 1
- complex 1
- drum roll 1
- hindi 1
- playful 1
- tambourine 1
- tao percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ustad Shujaat Khan Performs Shudh Kalyan | Someone is playing a fast paced melody on a sitar accompanied by someone playing a rhythm on tablas. This song may be playing live during a concert. | 2007-05-07T15:50:46Z | kamalhyder | This recording is from a live concert in Calcutta on March 13, 2005. Accompanying Khansahib on tabla is Yogesh Samsi, a brilliant young artist. The clarity and speed of Khansahib's jhalla is unbelievable!! | ["Tabla", "Drum", "Percussion"] | ["amateur recording", "hindi", "zitar", "tablas", "fast tempo"] | 6 | OseeYF_ud7g | 2477 | |
KJ Sawka in his Basement | This audio contains someone playing an acoustic drum with a fast paced and complex rhythm. This is an amateur recording. | 2006-11-20T22:00:36Z | briandewaide | Buy KJ Sawka's music at kjsawka.com or www.waxorchard.com Hi. My name is Kevin Sawka, and I play jungle and drum'n'bass beats. | ["Cymbal", "Drum", "Drum and bass", "Drum kit", "Electronic music", "Hi-hat", "Music", "Musical instrument", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "acoustic drum", "fast tempo", "complex"] | 6 | b98BJ36K1wo | 3605 | |
Nishat Khan & Zakir Hussain in Calcutta - Part 2 | This audio contains someone playing a complex groove on tablas along with someone playing a solo on a zitar with the same complex rhythm. This song may be playing in a live concert having a little solo together with instruments. | 2010-02-18T13:51:36Z | Alexandre de Mortemart | Part 2 of extracts of a concert of Ustad Nishat Khan (Sitar) and Ustad Zakir Hussain (Tablas) held on 9th February 2010 at Kalamandir in Calcutta, India. | ["Tabla", "Drum", "Percussion"] | ["amateur recording", "tablas", "zitar", "fast tempo", "playful"] | 6 | dj-DWiV1z9g | 3809 | |
Alessandra Belloni LESSON 1: Tarentella, Pizzica Tarantata | This audio contains someone playing a complex and fast rhythm on the tambourine. Also playing percussive. This song may be playing at a traditional ceremony. | 2010-11-11T00:31:24Z | BrooklynBikeBeat | Alessandra Belloni teaches and plays the healing trance dance known as Pizzica Tarantata | ["Music", "Musical instrument", "Tambourine", "Percussion"] | ["amateur recording", "tambourine", "fast tempo"] | 6 | lfCWGQ6URds | 4414 | |
Tao percussion | This audio contains someone playing tao percussion with fast drumrolls. In the background you can hear other noises. This is an amateur recording. This song may be playing live at a traditional performance. | 2008-10-08T20:40:21Z | Bazzo75 | Tao percussionisti giapponesi | ["Drum", "Drum roll", "Percussion"] | ["tao percussion", "amateur recording", "drum roll", "fast tempo"] | 6 | uQE3fLdzpKs | 5111 |
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;