musiccaps_details (view)
3 rows where musiccaps_aspects contains "saxophones" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- saxophones · 3 ✖
- trumpets 2
- acoustic drums 1
- acoustic piano 1
- amateur recording 1
- bad sound quality 1
- baritone saxophone 1
- brass band 1
- classical 1
- dance music 1
- e-bass 1
- fast tempo 1
- groovy rhythm 1
- home music video 1
- instrumental squid 1
- jazz 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- male singer 1
- marimba 1
- medium tempo 1
- orchestral 1
- people dancing 1
- saxophone harmony 1
- syncopated rhythms 1
- traditional latin dance 1
- trombones 1
- very fast tempo 1
- wooden xylophone 1
youtube_published (date) 3 ✖
- 2009-08-04 1
- 2010-01-15 1
- 2011-02-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Buddy Rich / Channel One Suite Part 2 | This song contains acoustic drums playing a complex rhythm along with a e-bass playing a walking bassline and a piano playing jazz chords in the mid range. A baritone saxophone is playing the main melody accompanied by other brass instruments. This song may be playing during a live concert. | 2009-08-04T16:41:44Z | Bob Bowlby | Berlin Jazz Festival. November 3, 1984. | ["Brass instrument", "Saxophone"] | ["jazz", "baritone saxophone", "acoustic piano", "saxophones", "trombones", "trumpets", "acoustic drums", "e-bass", "very fast tempo"] | 6 | 3dzR3ZWOe8Y | 490 | |
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 | |
Introduction et variations sur une ronde populaire, Henri Pierné | This audio contains people playing saxophones in all ranges and with a fast melody. This song may be playing as part of an orchestral performance. | 2011-02-27T00:37:25Z | MichiganSaxStudio | Introduction et variations sur une ronde populaire, Henri Pierné Performance by Echo Saxophone Quartet: Spring 2010 Students of Donald Sinta Dan Graser (2nd year Doctoral at time of recording) Katherine Weintraub (Senior at time of recording) Chris Bartz (2nd year Masters at time of recording) Andy Hall (1st year Masters at time of recording) | ["Brass instrument", "Clarinet", "Saxophone"] | ["amateur recording", "orchestral", "saxophones", "fast tempo", "classical"] | 6 | v5SsASLy2c8 | 5154 |
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;