musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy rhythm" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- groovy rhythm · 2 ✖
- medium tempo 2
- bad sound quality 1
- bass clarinet 1
- brass band 1
- cell player 1
- clarinet 1
- clarinet melody 1
- dance music 1
- home music video 1
- horn and string quartet 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
- melancholic music 1
- mysterious 1
- people dancing 1
- rich quality 1
- rock music cover 1
- saxophone harmony 1
- saxophones 1
- song cover 1
- syncopated rhythms 1
- traditional latin dance 1
- trombone 1
- trumpets 1
- western classical quartet 1
- wooden xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Fade to Black" by Metallica, for clarinet, bassoon, trombone, and cello | The song is an instrumental. The song is in medium tempo with a cello playing percussively, a clarinet in melody and supported in harmony by a bass clarinet and a trombone. The song is a rock song cover played live. The song is engaging and rich in quality. | 2013-04-28T00:01:16Z | Ceylan Yagmur | From Ceylan Yagmur's Senior Recital, part 6/6 April 5, 2013 UCLA Popper Theater Audio / Video by Umberto Belfiore Arr. by Ceylan Yagmur Alexander Chay - bassoon Eunice Heo - cello Adam Korynta - trombone Ceylan Yagmur - clarinet | ["Brass instrument", "Clarinet", "Trombone"] | ["clarinet", "bass clarinet", "trombone", "cell player", "rich quality", "western classical quartet", "song cover", "rock music cover", "medium tempo", "clarinet melody", "horn and string quartet", "live performance", "groovy rhythm", "instrumental music", "melancholic music", "mysterious", "live audience"] | 1 | cSBRb4KF5xs | 3708 | |
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 |
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;