musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "syncopated rhythms"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- groovy rhythm · 2 ✖
- medium tempo 2
- syncopated rhythms · 2 ✖
- amateur recording 1
- bad audio quality 1
- bad sound quality 1
- brass band 1
- dance music 1
- dance rhythm 1
- drum solo 1
- drums maestro 1
- echoes 1
- energetic 1
- exciting 1
- exemplary stick work 1
- gripping experience 1
- home music video 1
- impressive playing 1
- instrumental music 1
- instrumental squid 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- live audience 1
- live performance 1
- male singer 1
- marimba 1
- people dancing 1
- pulsating experience 1
- retro drum hits 1
- saxophone harmony 1
- saxophones 1
- traditional latin dance 1
- trumpets 1
- wooden xylophone 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Brass instrument 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Percussion 1
- Rimshot 1
- Saxophone 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 | |
Drums Steve Gadd Cowbell.wmv | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | 2008-12-16T11:27:34Z | bestdrumvideos | Drums Steve Gadd | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | 1 | nrj2zTr7U0o | 4584 |
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;