musiccaps_details (view)
4 rows where musiccaps_author = 9, musiccaps_names contains "Drum" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- live performance 3
- percussion 3
- instrumental 2
- male vocal 2
- acoustic drums 1
- afro cuban 1
- aggressive 1
- bass guitar 1
- chainsaw 1
- choir 1
- conga 1
- dance 1
- didgeridoo 1
- easygoing 1
- eccentric 1
- electric guitar 1
- hard rock 1
- hard-hitting 1
- jazz steel pan 1
- joyful singing 1
- lively 1
- playful 1
- relaxing 1
- rhythm 1
- rumba 1
- shekere 1
- shouting 1
- street performance 1
- tribal 1
- unique 1
- vibrant 1
musiccaps_names (array) 15 ✖
- Drum · 4 ✖
- Music 4
- Musical instrument · 4 ✖
- Percussion 3
- Chainsaw 1
- Didgeridoo 1
- Drum kit 1
- Electronic organ 1
- Guitar 1
- Heavy metal 1
- Jazz 1
- Organ 1
- Rattle (instrument) 1
- Rock music 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Front row! Jackyl 'The Lumberjack Song' live in concert in California! Enjoy! NAMM | This is the live performance of a hard rock piece. There is a male vocal who is shouting at the crowd while revving up a chainsaw. The electric guitar is playing the melody while the bass guitar is playing in the background. The acoustic drums are playing a simple blues rock beat. The atmosphere is aggressive. | 2012-01-23T22:46:42Z | pasha28dio | Filmed at the 'Grove in Anaheim' during NAMM 2012 at the 3rd Annual Dean Guitars Namm Jamm. You just have to love any song that has a chainsaw solo. :-) Testament and Static X also played. Great night of jams. | ["Chainsaw", "Drum", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music"] | ["hard rock", "live performance", "male vocal", "shouting", "electric guitar", "bass guitar", "acoustic drums", "chainsaw", "hard-hitting", "aggressive"] | 9 | MQ1Q7xydJPU | 2265 | |
Shibaten goes crazy | This is a street performance of an instrumental music piece. The performer is playing a melody on the didgeridoo while he is using various percussive elements to create the rhythmic background. The atmosphere is eccentric and there is a tribal sound to the piece. This piece could be used in the soundtrack of an adventure movie with a jungle or a desert setting. | 2007-08-26T17:16:19Z | versafan | Shibaten performs on the didgeridoo at Buskerfest 2007, in front of St. Lawrence Market, Toronto | ["Drum", "Didgeridoo", "Music", "Musical instrument", "Percussion"] | ["street performance", "instrumental", "didgeridoo", "percussion", "unique", "eccentric", "tribal"] | 9 | YODoF8e7Jlk | 3283 | |
Andy Narell Solo | This is the live performance of a percussion piece. There is a playful sounding jazz steel pan solo being performed on stage. The atmosphere is easygoing. This piece could be used during tropical scenery shots in a movie with a summer/vacation theme. | 2008-03-30T15:10:09Z | nehpets99 | Andy Narell, world famous steel pan composer/performer, solos as the guest artist for Miami University's Steel Band. | ["Organ", "Drum", "Drum kit", "Jazz", "Electronic organ", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["percussion", "rhythm", "live performance", "instrumental", "jazz steel pan", "playful", "relaxing", "easygoing"] | 9 | cQpK9zs_uv0 | 3706 | |
Yamil Castillo - Rumba Grupo Afro Cubano Bakinikini | This is an Afro-cuban music piece in the style of rumba. It is a live performance. There is a male vocal and a choir singing in a joyful manner. The rhythmic background is composed of Afro-Cuban percussive elements such as the shekere and the conga. The atmosphere is lively and vibrant. This piece could be used as an accompaniment piece for a rumba dance course. | 2006-11-04T22:29:10Z | Yamil Castillo | Grupo Afro Cubano Bakinikini. Yamil Castillo: Conga( Quinto )y Coro. Llensy Zafra: Congas ( Tumbadora Tres dos )y Coro. Camilla Brena: Kata ( Guagua ) Eduardo Cespedez: Chequere y Coro. Yusniel "El Niño Lopez": Canto. | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["afro cuban", "rumba", "live performance", "male vocal", "choir", "joyful singing", "percussion", "shekere", "conga", "lively", "vibrant", "dance"] | 9 | wMN-Xp9IMUw | 5260 |
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;