musiccaps_details (view)
2 rows where musiccaps_aspects contains "hand percussion", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Maraca"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- fast tempo 2
- hand percussion · 2 ✖
- instrumental · 2 ✖
- bongos accompaniment 1
- caribbean 1
- carrie an 1
- celebration song 1
- chac-chac 1
- clarinet song 1
- folk song 1
- latin music 1
- latin percussion 1
- maracas rhythm 1
- no voice 1
- no voices 1
- percussion dual 1
- rattle like instrument 1
- rhythmic 1
- shaker 1
- sound of trumpets 1
- tambourine 1
- vigorous 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cómo aprender a tocar las maracas | This music is a lively instrumental using a maracas. The tempo is fast with a bongos accompaniment . The music is a duel between the two hand percussion. It is lively, vigorous and vibrant. | 2011-06-06T15:51:04Z | Practicopedia | Un instrumento de percusión que se utiliza para acompañar a otros instrumentos | ["Music", "Maraca"] | ["instrumental", "fast tempo", "maracas rhythm", "caribbean", "percussion dual", "hand percussion", "bongos accompaniment", "vigorous", "shaker", "chac-chac", "rattle like instrument", "latin percussion", "latin music", "rhythmic", "carrie an"] | 7 | KoP8T0QqzeM | 2120 | |
SHOLOHO Vadim Gavrilov-Vugar Sultanov | This folk song features the main melody played on the clarinet. This is accompanied by percussion played by hand. The tambourine is playing on every count. The bass plays with a groovy feel. The bass plays notes continuously at every count. The mood of this song is upbeat and happy. There are no voices in this song. This song can be played at a celebration party. | 2011-07-02T00:14:04Z | Vadim Gavrilov | Snew Group- ORIGINAL. Tancuut vse!!! SHOLOHO-PAPAH-SULEIMANI+MIZRAHI | ["Music", "Maraca"] | ["folk song", "clarinet song", "tambourine", "no voices", "hand percussion", "sound of trumpets", "fast tempo", "instrumental", "no voice", "celebration song"] | 0 | PZZxVIIOQPo | 2545 |
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;