musiccaps_details (view)
3 rows where musiccaps_aspects contains "brass instruments" and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- brass instruments · 3 ✖
- animated 1
- banjo 1
- brass band 1
- brassband 1
- buskers 1
- busking 1
- busking percussion 1
- clarinet 1
- fast tempo 1
- guiro 1
- horn 1
- instrumental 1
- instrumental music 1
- lively 1
- no percussion 1
- no voice 1
- orchestral music 1
- relaxing song 1
- resonator 1
- scratching sound 1
- shakers 1
- slow tempo 1
- slow to medium tempo 1
- spirited 1
- street busking 1
- symphonic feel 1
- trombone 1
- trombones 1
- trumpet 1
- tuba 1
- wind instrument 1
musiccaps_names (array) 4 ✖
- Brass instrument 3
- Trumpet · 3 ✖
- Trombone 2
- Clarinet 1
youtube_published (date) 3 ✖
- 2006-10-31 1
- 2010-06-23 1
- 2015-04-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tuba Skinny @ Louisiana Music Factory 2015 - Southern Sounds Tour Party - PT 1 | This music is a lively harmony of the brass and wind instruments. The tempo is fast with lively tuba, trombone, trumpet, clarinet with mandolin and resonator accompaniment and busking percussion that sounds like scratching. His music is loud, vibrant, perky, engaging and animated street busking. | 2015-04-17T00:17:15Z | LAMUSICFACTORY | CDs Available @ Link Below http://www.louisianamusicfactory.com Free Concert Series Southern Sounds Tour Party April 14th Tuba Skinny | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | ["instrumental", "fast tempo", "brass band", "tuba", "clarinet", "street busking", "trumpet", "scratching sound", "guiro", "busking percussion", "lively", "animated", "spirited", "trombones", "clarinet", "wind instrument", "brass instruments", "banjo", "resonator", "shakers", "busking", "buskers"] | 7 | 4EwWBI-tHLk | 549 | |
Giovanni Gabrieli Sacra Symphonia Sonata Pian'e Forte | This song features the brass section of a symphonic orchestra. The melody is played on trumpets. It is accompanied by a trombone and a brass horn playing individual parts. This song is at a slow tempo and has a relaxing feel. There are no voices in this song. There is no percussion in this song. This song can be played when a hero is returning victorious from a battle. | 2010-06-23T21:36:58Z | Maurizio De Marco | Zubin Metha conducts The Brass Section of the Bayerische Staatsoper | ["Brass instrument", "Trombone", "Trumpet"] | ["brass instruments", "orchestral music", "trombone", "symphonic feel", "horn", "no percussion", "instrumental music", "no voice", "slow tempo", "relaxing song"] | 0 | rQeikHMQGOM | 4876 | |
Brassband Willebroek - 'Intrada: Ein feste Burg' | This audio contains a brass band playing a slow melody. Some are playing a layer of a long chord in the mid to higher register. on top of that a trumpet is leading a melody than other trumpets are coming in giving a loud answer. This song may be played live, performed by part of an orchestra. | 2006-10-31T14:37:26Z | AlexvdLaan | Intrada: Ein feste Burg van Ray Farr, gespeeld door brassband Willebroek op het WMC 2005 | ["Brass instrument", "Trumpet"] | ["brassband", "brass instruments", "slow to medium tempo"] | 6 | uqAY4lCUcRY | 5138 |
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;