musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_names contains "Clarinet" and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- live performance · 4 ✖
- passionate 3
- low quality 2
- accordion melody 1
- bassoons 1
- brass section 1
- cheerful 1
- chill 1
- clarinet player 1
- clarinet solo melody 1
- clarinets 1
- composers 1
- concert hall 1
- conductor 1
- cultural 1
- easygoing 1
- emotional 1
- energetic 1
- exciting 1
- folk 1
- folk dance 1
- grand 1
- groovy bass 1
- groovy piano melody 1
- high pitched melody 1
- horn section 1
- humour 1
- instrumental music 1
- jazz 1
- live audience 1
- lively 1
- medium tempo 1
- mellow brass melody 1
- mellow kick hits 1
- metallic percussions 1
- orchestra 1
- philharmonic orchestra 1
- polka 1
- pomp 1
- poor audio quality 1
- shimmering hi hats 1
- spirited 1
- syncopated rhythms 1
- trumpet melody 1
- trumpets 1
- tuba 1
- tubas 1
- winds 1
- woodwind melody 1
musiccaps_names (array) 6 ✖
- Brass instrument 4
- Clarinet · 4 ✖
- Trumpet · 4 ✖
- Accordion 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 | |
Sleepy Time Down South | The low quality recording features a live performance of a jazz song that consists of a clarinet solo melody played over groovy piano, mellow brass melody, shimmering hi hats and mellow kick hits. It sounds emotional, easygoing and chill. | 2007-06-23T22:34:36Z | glengillo | Another clip from the Carling family at the Stockamollan Jazz Festival in June 2007, playing the old Louis Armstrong classic "When it's Sleepy Time Down South". With such tight ensemble playing it would be wrong to pick out any particular soloist -- they are all great! | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | ["low quality", "live performance", "jazz", "clarinet solo melody", "mellow brass melody", "groovy piano melody", "shimmering hi hats", "mellow kick hits", "passionate", "emotional", "easygoing", "chill"] | 4 | 588osm3C4bw | 635 | |
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 | |
adm&buldumea.mp4 | The low quality recording features a live performance of a folk song that consists of a woodwind melody, followed by accordion melody, trumpet melody, metallic percussion and groovy bass. It sounds passionate and cultural. | 2010-01-24T19:15:25Z | clivik tr-ta | adm&buldumea.mp4 | ["Brass instrument", "Clarinet", "Trumpet", "Wind instrument, woodwind instrument", "Accordion"] | ["low quality", "live performance", "woodwind melody", "trumpet melody", "folk", "passionate", "cultural", "accordion melody", "metallic percussions", "groovy bass"] | 4 | b12xqPnM0So | 3596 |
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;