musiccaps_details (view)
3 rows where musiccaps_aspects contains "saxophone", musiccaps_aspects contains "trumpet" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- instrumental 3
- saxophone · 3 ✖
- trumpet · 3 ✖
- acoustic drums 2
- piano 2
- acordion 1
- bass guitar 1
- brass band 1
- cheerful 1
- chill 1
- classical 1
- electric guitar 1
- fast tempo 1
- groovy 1
- happy 1
- jazz 1
- jazz music 1
- melodious harmony 1
- merry 1
- pleasant harmonious 1
- slow tempo 1
- trombone 1
- tuba 1
- upright bass 1
- vibrant 1
- wind instruments 1
- wood wind 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HOW TO FIBERGLASS * The Real Deal * Simple Mold * Part 5 * The Series | This is a jazz music piece. It is an instrumental piece. The saxophone and the trumpet are playing the melody. The piano, the electric guitar and the bass guitar are accompanying them in the background. The tempo is slow. The atmosphere is chill. This piece could be playing in the background at a coffee shop. | 2011-10-13T00:12:26Z | GasserGlass | Part FIVE (5) of the Original YOUTUBE - HOW TO FIBERGLASS Series...... | ["Brass instrument", "Saxophone", "Trombone"] | ["jazz music", "instrumental", "saxophone", "trumpet", "electric guitar", "piano", "bass guitar", "acoustic drums", "slow tempo", "chill"] | 9 | IGyDtKAU1u8 | 1888 | |
Miles Davis Quintet - Doxy | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | 2014-06-22T16:09:17Z | 60otaku4 | Miles Davis Quintet - Doxy (1954) Personnel: Miles Davis (trumpet), Sonny Rollins (tenor sax), Horace Silver (piano), Percy Heath (bass), Kenny Clarke (drums) from the album 'BAGS' GROOVE' (Prestige Records) | ["Brass instrument", "Saxophone", "Trumpet"] | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | 9 | XpueyrkcMyQ | 3228 | |
Tocata Enxovia CCB (Rancho do Ezequiel) | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | 2016-10-10T21:54:41Z | Doglinha Vieira | Acordeon Fabricio Sousafone Doglinha Trombone Ezequiel Saxofone Everton | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | 7 | rOOBAGxxjBk | 4873 |
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;