musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 2 ✖
- medium tempo · 2 ✖
- alto saxophone 1
- amateur recording 1
- bad audio quality 1
- brass band 1
- classical music 1
- composer 1
- conductor 1
- flourishes 1
- high gain volume 1
- instrumental music 1
- live audience 1
- live concert 1
- movie soundtrack 1
- music tutor 1
- music tutorial 1
- no other instrumentation 1
- philharmonic orchestra 1
- sax solo 1
- saxophone 1
- saxophonist 1
- song ending 1
- song fade 1
- song tutorial 1
- song walk through 1
- triumphant 1
- trombones 1
- trumpets 1
- trumpets blaring 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 | |
OMI - CHEERLEADER - (TRUMPET PART ON ALTO SAX) SANTIAGO PACHECO | A saxophonist plays a phrase on the alto sax and explains the movement. The song is medium tempo with no other instrumentation. The audio quality is poor and serves as an online music tutorial. | 2015-08-28T07:11:42Z | santiago pacheco | Hi! My name is Santiago Pacheco, and make sax tutorials. This tutorial is on the trumpet part on OIM's Cheerleader song, I hope you like it. Facebook link https://www.facebook.com/santiagosaxtutorials?ref=hl | ["Brass instrument", "Saxophone"] | ["saxophonist", "saxophone", "alto saxophone", "groovy", "classical music", "flourishes", "music tutorial", "song tutorial", "bad audio quality", "music tutor", "song walk through", "amateur recording", "medium tempo", "sax solo", "no other instrumentation", "high gain volume", "youtube saxophone lessons"] | 1 | iUxy2s5d60o | 4192 |
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;