musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion" and musiccaps_aspects contains "xylophone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- instrumental 3
- percussion · 3 ✖
- xylophone · 3 ✖
- acoustic drums 1
- amadinda 1
- amateur recording 1
- calming engaging 1
- congas 1
- drum beat 1
- folk music 1
- gamelan 1
- hand pan 1
- joyful 1
- lively 1
- maracas 1
- marimba 1
- medium tempo 1
- metal bowls 1
- metal plates 1
- metallophones 1
- orchestra 1
- percussion instrument 1
- playful 1
- pleasant 1
- regional music 1
- rhythmic 1
- sharp 1
- simple melody 1
- soothing 1
- ugandan traditional music 1
musiccaps_names (array) 8 ✖
youtube_published (date) 3 ✖
- 2008-01-19 1
- 2010-11-27 1
- 2011-03-13 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Wedding Dress [impromptu] - Nanyang Polytechnic Chinese Orchestra (Percussionists) | This is a percussion orchestra performance. There are many percussive elements in this orchestra such as the congas, the maracas, the marimba and the xylophone. There is also an acoustic drum playing in the orchestra. The atmosphere is lively. | 2010-11-27T10:00:58Z | NYPChineseOrchestra | Nanyang Polytechnic Chinese Orchestra (Percussionists) Messing around during practice. ^^ Our Impromptu Wedding Dress. Hope you'll enjoy! :D | ["Orchestra", "Marimba, xylophone", "Glockenspiel", "Mallet percussion"] | ["orchestra", "instrumental", "percussion", "congas", "maracas", "xylophone", "marimba", "acoustic drums", "rhythmic", "lively"] | 9 | aURLQXt_6fE | 3544 | |
Traditional Music from Malaysia | This music clip is an instrumental with gamelan instrumental lead along with a hand percussion. The tempo is medium with melodic sounds and harmony from the striking of metal bowls or plates. The music is soft, melodious, calming, engaging and interesting and sounds a lot like a xylophone. | 2008-01-19T15:34:23Z | gosites | Meim Besuch der Kota Masuri, dem Grab einer auf Langkawi verehrten Prinzessin, wird man mit Musik empfangen. | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "drum beat", "metal plates", "metal bowls", "calming engaging", "folk music", "regional music", "percussion", "soothing", "gamelan", "metallophones", "percussion instrument", "xylophone", "hand pan", "sharp", "pleasant", "simple melody"] | 7 | mfZMcNmLxWM | 4485 |
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;