musiccaps_details (view)
5 rows where musiccaps_aspects contains "joyful" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- joyful · 5 ✖
- percussion · 5 ✖
- instrumental 3
- orchestra 3
- live performance 2
- playful 2
- accordion 1
- acoustic guitar 1
- amadinda 1
- amateur recording 1
- andalusian 1
- arabian 1
- bansuri 1
- bells 1
- cymbals 1
- fiddle 1
- indian traditional music 1
- lighthearted 1
- lively 1
- male vocal 1
- marimba 1
- oud 1
- romanian folk music 1
- sitar 1
- strings 1
- tabla 1
- tarab 1
- timpani 1
- ugandan traditional music 1
- upbeat 1
- upright bass 1
- vibrant 1
- xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tarab andalosi | This is a live performance of a Tarab music piece. It is being played by an orchestra that is composed of string and oud players that provide the melody and percussion players that provide the rhythmic background. There is a male vocalist as the lead. Clear influences of Arabian music can be heard in the piece. There is a joyful atmosphere. It can be played in the background of a Middle Eastern/North African cuisine restaurant. | 2009-03-29T01:01:48Z | mohamed chokri | ["Traditional music", "Music"] | ["tarab", "andalusian", "arabian", "orchestra", "male vocal", "strings", "oud", "percussion", "joyful"] | 9 | DaiVfxATCEE | 1498 | ||
amadinda in kampala | This is an amateur recording of a Ugandan traditional music piece. The piece is instrumental and percussive in nature. The amadinda (which is a Ugandan xylophone) is playing a joyful tune. The atmosphere is playful. | 2011-03-13T17:40:54Z | Philipp Troestl | amadinda playing with albert ssempeke in kampala "naagenda kasana nga bulaba ("we will leave when it is daylight") | ["Wood block", "Percussion"] | ["ugandan traditional music", "instrumental", "percussion", "amadinda", "xylophone", "playful", "joyful", "amateur recording"] | 9 | KY5TY6ovKQg | 2093 | |
First time ever in the World, a Grand Symphony of a 1000 Sitarists - Raag Gara | This is an Indian traditional music piece performed live by an orchestra. The orchestra is composed of the bansuri, the sitars and the tabla percussion. There is a vibrant atmosphere in the recording. This piece could be used in the soundtrack of a Bollywood movie. | 2009-01-04T12:34:44Z | Rutwik Basu | 21st Nov, 2008 NCR Delhi, India BRAHM NAAD, for the first time ever in the world - a grand symphony of a 1000 sitarists, was conceived by Art of Living founder and spiritual guru His Holiness Sri Sri Ravi Shankar. | ["Carnatic music", "Music", "Musical instrument", "Classical music", "Sitar", "Bowed string instrument"] | ["indian traditional music", "live performance", "orchestra", "bansuri", "sitar", "tabla", "percussion", "vibrant", "joyful"] | 9 | WdxNikVdK-U | 3116 | |
雪灯籠 白虎 | This is an instrumental percussion piece performed by an orchestra. There is a marimba playing the main melody at the forefront while bell percussion adds texture around it. There is a timpani that plays a loud drum line that is accentuated by occasional cymbal hits. The atmosphere is lighthearted. This piece would fit perfectly in the soundtrack of an arcade video game. | 2009-09-20T13:55:29Z | hiratama1995 | 打楽器五重奏です。ニコニコより転送。 | ["Timpani", "Music", "Percussion"] | ["percussion", "orchestra", "instrumental", "marimba", "cymbals", "timpani", "bells", "playful", "joyful", "lighthearted"] | 9 | lTuEsrVV6Uw | 4403 | |
dorel bass boss si lilian de la craiova | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | 2010-10-02T11:31:13Z | bosssbosssmihaita | la o terasa in las palmas de gran canarias | ["Accordion"] | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | 9 | xR2p3UED4VU | 5328 |
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;