musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass band", musiccaps_aspects contains "trumpets" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- brass band · 2 ✖
- medium tempo 2
- trumpets · 2 ✖
- bad sound quality 1
- composer 1
- conductor 1
- dance music 1
- groovy 1
- groovy rhythm 1
- home music video 1
- instrumental music 1
- instrumental squid 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- live audience 1
- live concert 1
- male singer 1
- marimba 1
- movie soundtrack 1
- people dancing 1
- philharmonic orchestra 1
- saxophone harmony 1
- saxophones 1
- song ending 1
- song fade 1
- syncopated rhythms 1
- traditional latin dance 1
- triumphant 1
- trombones 1
- trumpets blaring 1
- tuba 1
- western classical music 1
- wooden xylophone 1
musiccaps_names (array) 4 ✖
- Brass instrument · 2 ✖
- French horn 1
- Saxophone 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 | |
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;