musiccaps_details (view)
2 rows where musiccaps_aspects contains "uplifting mood" and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- brass section 2
- uplifting mood · 2 ✖
- amateur recording 1
- drums/percussion 1
- horn section 1
- instrumental 1
- marching band 1
- no percussion 1
- no voices 1
- orchestra 1
- strings 1
- symphonic song 1
- theme of impending danger 1
- uptempo 1
musiccaps_names (array) 8 ✖
- Orchestra · 2 ✖
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Clickety-clack 1
- Double bass 1
- French horn 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
5th Quarter - Texas Southern vs Jackson State (2011) | This song contains a marching band playing a melody with a big brass section. Horns are playing the bass melody and kicks and snare rolls are providing the rhythm along with some cymbal hits. This song may be playing at a national sports-event. | 2011-09-30T05:35:55Z | /\/\ MARCHINGSPORT | The 3 1/2 Minute 5th Quarter Texas Southern vs Jackson State (2011) Thanks for watching. Click here to subscribe. https://www.youtube.com/channel/UC2ZCPyxCK9HxTL2Qqh1l7eg?sub_confirmation=1 ------------------------------------------------------ 🎧 /\/\ MARCHINGSPORT RADIO ------------------------------------------------------ Put it on, hit shuffle and let the music play. https://www.youtube.com/playlist?list=PLiY7vwlmu-63X-dcS_Q81RrtPlNbgKzOF ---------------------------------------------- 🎧 FOOTAGE BY SEASONS ---------------------------------------------- Grab Your Headphones, select a season, Hit shuffle, and enjoy hours of your favorite marching bands. Fall 2019 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-63aDSm1wqwUkzxIMAjbq9aB Fall 2018 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-615is8oBCivg7Mk5Oo7qHxM Fall 2017 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-61W5HDVHwQmHlapauU4fFfc Fall 2016 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-6135fJ-e1GuAOE3lDY6EQRf Fall 2015 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-63NYSWRGwyvCvfREvL_M-2r Fall 2014 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-634EK7kFQKAIa9pzE5k5piB Fall 2013 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-60Q1G0ogrJX_TuhrqUen_0Q Fall 2012 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-61ZDnXTGyPntFpGqFkDSAB5 Fall 2011 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-62asrvOZlRH4n0LBdELat_q Fall 2010 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-6073aGGKnkjW7JqHGunlrMp Fall 2009 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-60Qi9fxShQnueq_urhS5vlK Fall 2008 HBCU Marching Band Season https://www.youtube.com/playlist?list=PLiY7vwlmu-60qHusXZ6e0U6Etz69gdP0k Fall 2007 HBCU Marching Band Season https://www.you… | ["Orchestra", "Clickety-clack"] | ["marching band", "brass section", "drums/percussion", "amateur recording", "uplifting mood", "uptempo"] | 6 | MmqRlHntd0Q | 2296 | |
Mahler Symphony No 5, horn solos 3rd mov- Abel Pereira | This symphonic song features an orchestra. At the beginning, a French horn plays a melody. This is followed by a harmony played by the string section and brass section. There is no percussion in this song. This song is uplifting. The mood of this song is suspenseful. This song can be played in a movie where a dangerous scene is taking place. | 2012-05-01T15:03:06Z | brassgang2 | Mahler Symphony No 5, horn solos 3rd mov - Abel Pereira, Porto Symphony Orchestra, Casa da Música, Orquestra Sinfónica do Porto | ["Brass instrument", "Cello", "Double bass", "French horn", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | ["symphonic song", "orchestra", "horn section", "no percussion", "strings", "brass section", "instrumental", "no voices", "uplifting mood", "theme of impending danger"] | 0 | v4sANJkuwP4 | 5151 |
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;