musiccaps_details (view)
5 rows where musiccaps_aspects contains "orchestra", musiccaps_author = 9 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- orchestra · 5 ✖
- classical music 3
- instrumental 3
- live performance 3
- tuba 3
- brass 2
- cheerful 2
- epic 2
- march 2
- winds 2
- anthem 1
- basset horn 1
- bassoon 1
- brass section 1
- clarinet 1
- classical 1
- contrabass 1
- festive 1
- folk dance 1
- french horn 1
- inauthentic 1
- joyful 1
- lively 1
- major key 1
- melancholic 1
- movie music 1
- no singer 1
- oboe 1
- polka 1
- positive 1
- slow tempo 1
- solemn 1
- trombone 1
- trombones 1
- tubular bells 1
- vibrant 1
- virtual sounds 1
musiccaps_names (array) 10 ✖
- Brass instrument · 5 ✖
- Clarinet 2
- Trumpet 2
- Foghorn 1
- French horn 1
- Keyboard (musical) 1
- Music 1
- Piano 1
- Trombone 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BARITON POLKA - COLI | This is a live performance of a polka music piece. It is being performed by a wind orchestra. The main melody is being performed by the tuba. There is a lively, cheerful atmosphere to this piece. It could be used as an accompaniment piece for a European folk dance course. | 2009-04-23T09:58:11Z | Primož Beuc | KONCERT PIHALNEGA ORKESTRA VIDEM KRŠKO - SOLIST COLNER GREGA | ["Brass instrument", "Clarinet", "Trumpet"] | ["live performance", "polka", "orchestra", "winds", "tuba", "lively", "cheerful", "folk dance"] | 9 | 3q9K2PgA2-U | 507 | |
ロンドンの小景(Ⅰ.Ⅴ.Ⅵ.ending) | This is a classical music piece that resembles the style of a march. It is an instrumental piece performed by a brass orchestra. The main theme is being played by the trombones while a bass line is played by the tuba. The tempo of the piece is slow and this creates an epic but solemn atmosphere. This piece would work perfectly as a movie music piece. It could be playing during the scenes of an important character dying. | 2011-05-05T04:37:45Z | hiroka2011 | アンサンブル発表会より。 | ["Brass instrument", "Foghorn", "Music"] | ["classical music", "march", "instrumental", "orchestra", "brass", "trombones", "tuba", "anthem", "epic", "solemn", "melancholic", "slow tempo", "movie music"] | 9 | Di7Rs4QmYKI | 1506 | |
Sibelius 7 Sounds - 3. Winds | This is a classical music piece played with the virtual sounds of a wind orchestra. The orchestra is composed of the oboe, the clarinet, the basset horn, the bassoon and the contrabass. The piece is in major key which gives the piece a more positive aura in general, but the virtual sounds make it feel inauthentic. | 2011-11-26T01:00:19Z | OrchestrationOnline | Third in a series of reviews of the new sound set from Sibelius 7. Please watch full-screen with high fidelity sound. Many thanks to special guest Justus Rozemond, contrabass clarinetist. | ["Brass instrument", "Clarinet", "Keyboard (musical)", "Piano", "Wind instrument, woodwind instrument"] | ["classical music", "no singer", "instrumental", "virtual sounds", "orchestra", "winds", "oboe", "clarinet", "basset horn", "bassoon", "contrabass", "major key", "positive", "inauthentic"] | 9 | GMFWnMRtfNI | 1711 | |
Mnozil Brass and Band of Flight -- Florentiner March | This is a live classical music performance. The piece is being performed by a brass orchestra. There is a trombone playing the lead melody while other trombones and a tuba play the bass backing. The atmosphere is epic. This piece could be playing in the soundtrack of a historical drama movie during the scenes of an army marching towards the enemy territory. | 2010-03-22T14:42:36Z | Michael Mench | UPDATE: The full version is finally up!! http://www.youtube.com/watch?v=UYohC-M22GA The Mnozil Brass joined the USAF Band of Flight on stage at the National Museum of the USAF 20 March 2010 for a concert. Florentiner closed the first half. | ["Brass instrument", "Trombone", "Trumpet"] | ["classical music", "live performance", "orchestra", "brass", "trombone", "tuba", "march", "epic", "cheerful"] | 9 | L9GXrmmlYhE | 2154 | |
Cape Horn - Otto M. Schwarz - WK Laufen Gmunden-Engelhof | This is a classical music piece performed by an orchestra. There is a wide ranging brass section that has the french horn as the lead playing the melody. In the percussive background there are the tubular bells which give the piece a festive feel. The atmosphere is vibrant. This piece would fit perfectly in the soundtrack of a Christmas movie either as the opening theme or during the scenes where there is a preparation going on. | 2010-04-03T09:24:48Z | Franz Schindlauer | Livevideo vom Jahreskonzert 2010 der WK Laufen Gmunden Engelhof aus Toscana Congress Gmunden Solist: Christoph Wiesenberger - Horn Dirigent: Franz Schindlauer Ton: FS-Produktionen - Franz Schindlauer Video: Hörak-Film, Leopold Hörak | ["Brass instrument", "French horn"] | ["classical", "instrumental", "orchestra", "live performance", "brass section", "french horn", "tubular bells", "vibrant", "festive", "joyful"] | 9 | kMNL4Y4XMhc | 4311 |
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;