musiccaps_details (view)
5 rows where musiccaps_aspects contains "classical", musiccaps_author = 6 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- classical · 5 ✖
- orchestral 3
- horn 2
- oboes/flutes 2
- alarm ringing 1
- amateur recording 1
- brass composition 1
- fast tempo 1
- medium tempo 1
- medium to uptempo 1
- saxophones 1
- slow tempo 1
- soothing 1
- string section 1
- trumpets 1
- uplifting energy 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Brass instrument · 5 ✖
- French horn 3
- Clarinet 1
- Inside, small room 1
- Music 1
- Saxophone 1
- Telephone bell ringing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joseph & Michael Haydn, Horn Concertos 1 | This audio contains someone playing a melody on a horn with reverb on it. This song may be playing as a solo in an orchestra performance. | 2014-07-01T16:37:11Z | Trombone Keiji | Joseph Haydn ・ Michael Haydn HORN CONCERTOS DALE CLEVENGER, French Horn Franz Liszt Chamber Orchestra János Rolla, Konzertmeister JOSEPH HAYDN (1732-1809) Konzert für Horn und Orchester Nr.3 (1) D-dur, Hob. VII: d3 Allegro Adagio Allegro | ["Brass instrument", "French horn"] | ["classical", "horn", "medium tempo"] | 6 | 6elnFyuUnaU | 774 | |
Michel Bequet - Big Brass Fest 2007 | A trombone is ending a melody together with a tuba and other brass instruments before going into the next part that sounds fast paced and uplifting. This song may be playing at a live performance. | 2007-09-18T12:10:19Z | Gabriele Dresdo | Michel Bequet in a solo performance with PentaBrass italian brass quintet during the "Teachers Concert" | ["Brass instrument", "French horn"] | ["classical", "brass composition", "uptempo", "uplifting energy"] | 6 | PWVr9weg00U | 2543 | |
Expectations vs. Reality of a Studyblr | This audio contains trumpets playing the main melody in the higher mid range while oboes and flutes are playing a melody that sounds like a bunny hopping over obstacles. Then the music stops with a crashing sound and an alarm clock starts ringing. This song may be playing live as part of an orchestra composition. | 2015-10-02T11:32:00Z | Leo Studies | Hope you guys like the video! Obviously it's all a bit exaggerated ;) Make sure to subscribe for more videos! Lots of love, Leo xx ---- LINKS --- TUMBLR: leostudies.com (yay I got my own domain!) INSTAGRAM: @leoleclerc | ["Brass instrument", "Music", "Telephone bell ringing", "Inside, small room"] | ["orchestral", "classical", "trumpets", "oboes/flutes", "alarm ringing", "medium to uptempo"] | 6 | XW6tS4zAZ5E | 3188 | |
R Strauss Horn Concerto No 1 - 2 Barry Tuckwell 1987 | This composition contains someone playing a solo melody on a horn in the mid to higher register. A string section, flutes and oboes are supported with a short rising harmony. This song may be playing live while listening to an orchestra. | 2009-05-24T20:19:57Z | hkakita | With NHK Symphony Orchestra, Japan | ["Brass instrument", "French horn"] | ["classical", "orchestral", "horn", "string section", "oboes/flutes", "soothing", "slow tempo"] | 6 | t3-xANiQrho | 4999 | |
Introduction et variations sur une ronde populaire, Henri Pierné | This audio contains people playing saxophones in all ranges and with a fast melody. This song may be playing as part of an orchestral performance. | 2011-02-27T00:37:25Z | MichiganSaxStudio | Introduction et variations sur une ronde populaire, Henri Pierné Performance by Echo Saxophone Quartet: Spring 2010 Students of Donald Sinta Dan Graser (2nd year Doctoral at time of recording) Katherine Weintraub (Senior at time of recording) Chris Bartz (2nd year Masters at time of recording) Andy Hall (1st year Masters at time of recording) | ["Brass instrument", "Clarinet", "Saxophone"] | ["amateur recording", "orchestral", "saxophones", "fast tempo", "classical"] | 6 | v5SsASLy2c8 | 5154 |
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;