musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass composition" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- brass composition · 2 ✖
- background wind noise 1
- cinematic 1
- classical 1
- dangerous 1
- dramatic 1
- marching drums 1
- orchestral 1
- slow tempo 1
- uplifting energy 1
- uptempo 1
musiccaps_names (array) 3 ✖
- Brass instrument · 2 ✖
- French horn 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 | |
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 |
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;