musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo", musiccaps_author = 6 and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
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 | |
Art of Brass Vienna plays Austrian Christmas Carols | This audio contains a composition played by brass instruments such as trumpets playing a melody in the higher range along with a deeper horn and a bass horn. This song may be playing at a theater presenting this composition. | 2014-04-13T18:51:13Z | brassysounds | Art of Brass Vienna (Hans Gansch, Heinrich Bruckner, Thomas Bieber, Erich Kojeder, Jonathan Sass) plays Austrian Christmas Carols arr. by Heinrich Bruckner. This arrangement is available at https://primverlag.at/produkte/weihnachtslieder/ | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["brass performance", "trumpets", "bass horns", "slow tempo"] | 6 | r_KdRKquXsM | 4886 |
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;