musiccaps_details (view)
3 rows where musiccaps_aspects contains "joyful", musiccaps_aspects contains "orchestra" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- joyful · 3 ✖
- orchestra · 3 ✖
- percussion · 3 ✖
- andalusian 1
- arabian 1
- bansuri 1
- bells 1
- cymbals 1
- indian traditional music 1
- instrumental 1
- lighthearted 1
- live performance 1
- male vocal 1
- marimba 1
- oud 1
- playful 1
- sitar 1
- strings 1
- tabla 1
- tarab 1
- timpani 1
- vibrant 1
musiccaps_names (array) 9 ✖
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 | ||
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 |
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;