musiccaps_details (view)
2 rows where musiccaps_aspects contains "horn section" and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- brass section 2
- horn section · 2 ✖
- bassoons 1
- battle song 1
- clarinet player 1
- clarinets 1
- composers 1
- concert hall 1
- conductor 1
- energetic 1
- exciting 1
- grand 1
- high pitched melody 1
- humour 1
- instrumental 1
- instrumental music 1
- live audience 1
- live performance 1
- medium tempo 1
- no other instruments 1
- no percussion 1
- no voices 1
- orchestra music 1
- passionate 1
- philharmonic orchestra 1
- pomp 1
- poor audio quality 1
- slow tempo 1
- spirited 1
- syncopated rhythms 1
- trumpets 1
- tubas 1
musiccaps_names (array) 5 ✖
- Brass instrument 2
- Trumpet · 2 ✖
- Clarinet 1
- French horn 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Britten: War Requiem / Rattle · Rundfunkchor Berlin · Berliner Philharmoniker | This song features the main melody played on a french horn and on a trumpet. The first part of the song is played on a french horn and the melody is continued on the trumpet. There are no other instruments in this song. The trumpet plays a battle call pattern. This is an instrumental song. There are no voices in this song. This song can be played just before a battle scene in a movie. | 2013-07-30T09:00:13Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/3470/?a=youtube&c=true Benjamin Britten: War Requiem / Sir Simon Rattle, conductor · Simon Halsey, chorus master · Rundfunkchor Berlin · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 15 June 2013. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["orchestra music", "horn section", "brass section", "no other instruments", "no percussion", "no voices", "instrumental", "battle song", "slow tempo"] | 0 | IGAzIIZRczw | 1887 | |
Immer Kleiner Philips Harmonie | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | 2010-02-08T15:01:49Z | juudruud | Guido van de Ven speelt 'Immer Kleiner' tijdens het nieuwjaarsconcert 2010 van de Philips Harmonie. dirigent: Matty Cilissen special guest star: Jos de Wit Guido van de Ven plays 'Always Smaller'. Newyearconcert 2010 Philips Harmonie Eindhoven. conductor: Matty Cilissen special guest star: Jos de Wit Bekijk ook het officiële Philips Harmonie Youtube-kanaal https://www.youtube.com/channel/UCD7B2SzauFUtJ58DHheWy4w | ["Brass instrument", "Clarinet", "Trumpet"] | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | 1 | Z-Vb1Ay-zNA | 3333 |
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;