musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "youtube music video" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- exciting 2
- passionate · 2 ✖
- youtube music video · 2 ✖
- ambient crowd noise 1
- backing track 1
- bad audio quality 1
- bass drum 1
- clap box rhythm 1
- dance rhythm 1
- drum demonstration 1
- drum sticks 1
- drums demonstration 1
- energetic 1
- enthusiastic 1
- groovy music 1
- groovy rhythm 1
- instrumental music 1
- laitin dance hits 1
- latin dance rhythm 1
- live performance 1
- male singer 1
- male singer chants 1
- medium fast tempo 1
- medium tempo 1
- people talking 1
- percussion demonstration 1
- percussion practice 1
- percussionist 1
- steady rhythm 1
- vocal chants 1
musiccaps_names (array) 6 ✖
- Percussion · 2 ✖
- Drum 1
- Music 1
- Musical instrument 1
- Rattle (instrument) 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tema:ni tu ni yo,art: la barra (cuarteto) fctambora. | The song is an instrumental. The song is medium tempo with a percussionist practising Latin bass drums with a drum stick to a music track with male vocals, trumpet harmony and other percussion. The audio quality is poor and boomy. | 2012-09-12T01:14:54Z | fernando castro | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["percussion practice", "male singer", "backing track", "vocal chants", "exciting", "dance rhythm", "enthusiastic", "passionate", "drums demonstration", "steady rhythm", "latin dance rhythm", "male singer chants", "laitin dance hits", "bass drum", "drum sticks", "youtube music video", "groovy music", "medium tempo"] | 1 | CHo8wKj9J1w | 1347 | ||
Anjo caldas tocando havaneiro | The song is an instrumental. The song is medium fast tempo with percussionists playing a groovy rhythm on three clap boxes. The sound quality is poor with a lot of ambient crowd noise. | 2007-04-08T02:27:14Z | nochaoss | percussionista da elba ramalho tocando o trio de haveneiros fabricados pela virgo percussao(www.virgopercussao.com.br) | ["Wood block", "Percussion"] | ["clap box rhythm", "percussionist", "medium fast tempo", "live performance", "exciting", "energetic", "passionate", "drum demonstration", "youtube music video", "instrumental music", "ambient crowd noise", "groovy rhythm", "people talking", "bad audio quality", "percussion demonstration"] | 1 | NcsYdCbKgcc | 2351 |
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;