musiccaps_details (view)
3 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "percussion" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- claps · 3 ✖
- percussion · 3 ✖
- live performance 2
- chant 1
- dance 1
- darbuka 1
- eastern sounding 1
- egyptian 1
- female vocal 1
- human sounds 1
- hype 1
- khaliji music 1
- male vocals 1
- mystery 1
- orchestra 1
- oud 1
- rhythmic 1
- riq 1
- steps 1
- strings 1
- suspense 1
- vibrant 1
- violin 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Black & White 2 music - Egypt Chant Vocal | This is an Egyptian music piece. There is a heavy use of percussion in the rhythmic background with the accompaniment of occasional claps. Medium-pitched strings are leading the melody. The male vocals are chanting rhythmically while the female vocal is singing in a soothing manner that creates a contrast in between the two elements. There is an adventurous, suspense-filled feeling. This piece could be used in a mystery/thriller video game. It could also be used in a movie that takes place in the Middle East. | 2010-07-29T22:36:16Z | TheSovietEnd | Black & White 2 music | ["Music", "Middle Eastern music"] | ["chant", "male vocals", "female vocal", "percussion", "claps", "strings", "mystery", "suspense", "egyptian"] | 9 | HLXGkzzQHUU | 1791 | |
خالد الملا على كثر | This is a live performance of a Khaliji music piece. There is an orchestra performing the piece. The melody is being played by the oud and the violin. The rhythmic background is composed of various percussive elements such as the riq, the darbuka and performers clapping their hands. The atmosphere is vibrant. This piece could be playing in the background at an Arab cuisine restaurant. | 2012-12-22T12:53:27Z | saaa64 | المطرب خالد الملا حضرميه على كثر | ["Traditional music", "Music", "Musical instrument", "Middle Eastern music", "Plucked string instrument", "Bowed string instrument"] | ["khaliji music", "live performance", "orchestra", "violin", "oud", "percussion", "riq", "darbuka", "claps", "vibrant", "eastern sounding"] | 9 | MHHshnnqyco | 2251 | |
My Little Pony: Equestria Girls - Scarlet Project | This is the live recording of a dance piece. The dancer can be heard stepping her foot on the ground and clapping her hands in a rhythmic fashion. The recording is a bit poor in quality, but samples could be lifted to be used in beats. | 2014-03-24T20:55:09Z | CamRiper | ["Music", "Tap"] | ["steps", "claps", "live performance", "rhythmic", "human sounds", "percussion", "hype", "dance"] | 9 | vrxT5jhqu0Q | 5213 |
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;