musiccaps_details (view)
5 rows where musiccaps_aspects contains "orchestral", musiccaps_author = 6 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- orchestral · 5 ✖
- classical 3
- slow tempo 3
- horn 2
- oboes/flutes 2
- soothing 2
- string section 2
- alarm ringing 1
- amateur recording 1
- background wind noise 1
- brass composition 1
- cinematic 1
- dangerous 1
- dramatic 1
- fast tempo 1
- marching drums 1
- medium to uptempo 1
- saxophones 1
- trumpets 1
musiccaps_names (array) 8 ✖
- Brass instrument · 5 ✖
- French horn 2
- Clarinet 1
- Inside, small room 1
- Music 1
- Saxophone 1
- Telephone bell ringing 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Space Above and Beyond Trailer for Season 2 | This audio contains marching drums with a kick and snare rolls. A brass section starts to play a melody in the low to mid range up to the higher register. In the background you can hear a strong wind that seems not to be part of the song. This song may be playing in a pirate movie-scene. | 2007-02-07T02:35:50Z | sjc2006 | Trailer for possible continuation for a show that was cancelled way too soon. Maybe Morgan and Wong will get to see this and be inspired by knowing that the fanbase still holds out hope. We believe in you. Semper fi!!!!! | ["Brass instrument", "Trumpet"] | ["cinematic", "orchestral", "brass composition", "background wind noise", "marching drums", "dangerous", "dramatic", "slow tempo"] | 6 | F9LJIyqQFe8 | 1619 | |
The Elder Scrolls Online - Heavy Armor Preview (All Races) | This composition contains a horn playing a melody with reverb on it. Then a string section comes in playing a soothing melody rising and falling in pitch. You can hear some digital clicking sounds that seem not to belong to the musical composition. This song may be playing in a fantasy adventure video-game. | 2014-02-15T20:53:40Z | Birds | The Elder Scrolls Online Beta Armor Preview. All Races! Medium Armor: http://www.youtube.com/watch?v=yUVXHEYBeBk Light Armor: http://www.youtube.com/watch?v=M32D9Ai5uKk | ["Brass instrument", "French horn"] | ["orchestral", "string section", "horn", "soothing", "slow tempo"] | 6 | WKL40jfQD3g | 3086 | |
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;