musiccaps_details (view)
5 rows where musiccaps_aspects contains "saxophones" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- saxophones · 5 ✖
- trumpets · 5 ✖
- trombones 3
- acoustic drums 2
- drums 2
- e-bass 2
- instrumental 2
- latin music 2
- no voice 2
- piano 2
- acoustic piano 1
- almost fast tempo 1
- bad sound quality 1
- baritone saxophone 1
- bass guitar 1
- brass band 1
- congas 1
- cuban ska 1
- dance music 1
- e-guitar 1
- electric guitar 1
- electronic sound 1
- energetic 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
- organ 1
- people dancing 1
- saxophone harmony 1
- syncopated rhythms 1
- traditional latin dance 1
- upbeat 1
- upright bass 1
- very fast tempo 1
- wooden xylophone 1
musiccaps_names (array) 9 ✖
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 | |
DR. RING DING - "Latin Goes Ska" | The instrumental music features a medium sized band playing Latin music. The melody is being played in unison by the saxophones, trumpets and trombones in an almost fast tempo. A bass guitar is playing repeating lines in the low register. The drums play a busy rhythm. An electric guitar is playing a chord on the second half of every beat. | 2012-01-16T08:38:37Z | thegroverrecords | Album - DANDIMITE www.moskito-mailorder.com | ["Swing music", "Funk", "Music", "Music of Latin America", "Salsa music"] | ["trumpets", "saxophones", "trombones", "drums", "bass guitar", "electric guitar", "instrumental", "no voice", "latin music", "almost fast tempo"] | 2 | CuUu6L5hhMs | 1412 | |
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 | |
Jerry rivera Para ti | The instrumental latin music features a big band. The trumpets, saxophones and trombones play the same melody but on different pitches. The percussion section includes a drum kit played in the latin style and a pair of congas. A piano accompanies the brass section and blends in with the rest of the band. An electronic sound can be heard playing the same note throughout the music excerpt. | 2007-09-10T07:54:12Z | Donabboy | para ti | ["Music", "Salsa music"] | ["latin music", "trumpets", "trombones", "saxophones", "congas", "piano", "upright bass", "electronic sound", "instrumental", "no voice", "drums"] | 2 | nH_lVl3a3Uw | 4529 | |
Ska Cubano - Identity | This audio contains acoustic drums playing something like a reggae groove along with an e-bass. A e-guitar strumming chords, piano, organ saxophones and trumpets are playing a short melody on the backbeat giving this song its reggae feeling. In-between the instruments are playing a short loud melody to break into the next part. The instruments are spread across the sides of the speakers. This audio may be playing in an urban coffee shop. | 2011-05-16T22:21:47Z | Eder Eulogio | Canción del disco Mambo Ska de esta banda de nacionalidades múltiples y que ha resaltado la cultura musical de dos islas caribeñas como lo son Cuba y Jamaica..... Disfruten, Comenten y Suscríbanse!!!!!!!!!!!!!! | ["Wind instrument, woodwind instrument", "Accordion"] | ["cuban ska", "e-guitar", "trumpets", "saxophones", "organ", "piano", "acoustic drums", "e-bass", "upbeat", "energetic"] | 6 | nW6Naj6eeI4 | 4547 |
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;