musiccaps_details (view)
3 rows where musiccaps_aspects contains "brass instruments" and musiccaps_names contains "Orchestra" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- brass instruments · 3 ✖
- trumpets 3
- epic 2
- bongos 1
- build-up 1
- cinematic 1
- classical music 1
- dance 1
- exciting 1
- french horns 1
- groovy 1
- impressive 1
- intricate piano playing 1
- jazz 1
- latin music 1
- live recording 1
- low quality recording 1
- orchestral music 1
- saxophone 1
- thrilling 1
- timpani 1
- traditional percussive instruments 1
- trombones 1
- tubas 1
- uplifting 1
musiccaps_names (array) 8 ✖
- Orchestra · 3 ✖
- Brass instrument 1
- Classical music 1
- Drum 1
- Music 1
- Musical instrument 1
- Percussion 1
- Timpani 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marvin Diz Performs in the LP Studio | This is a jazz song with some latin infusions into the style. The brass section plays bright and ascending melodies. The percussionists play bongos and snares with brushes. The song is fun and suitable for some loose dancing. | 2009-12-15T20:54:15Z | Latin Percussion | The Marvin Diz Band Performs "Pensando en la Habana" LP Instruments: LP Bata Drums LP Giovanni Palladium Series Congas LP Giovanni Palladium Series Bongos LP Tito Puente Timbales LP Jam Block LP Salsa Cowbell | ["Drum", "Orchestra", "Percussion"] | ["jazz", "latin music", "brass instruments", "trumpets", "saxophone", "traditional percussive instruments", "bongos", "intricate piano playing", "groovy", "dance"] | 3 | A6HJBIU1rD0 | 1068 | |
Richard Strauss - Also Sprach Zarathustra (das Ziege) [Opening of 2001: A Space Goat Odyssey] | This is a classical orchestral piece. The melody played on the trumpets feels like a prelude to an important, impressive moment. This music would suit any momentous occasion - like the countdown to a rocket launch. | 2013-02-28T09:51:34Z | switchmodthree | Wait for it... :) --------------------- Source: http://www.youtube.com/watch?v=Y9QxaJLt7EA | ["Timpani", "Brass instrument", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical music", "brass instruments", "trumpets", "timpani", "build-up", "epic", "uplifting", "impressive"] | 3 | LSaLPObrnZw | 2190 | |
「ラピュタ」~キャッスル・イン・ザ・スカイ~ | This is an exciting, epic cinematic orchestral piece. This kind of music would be used for a scene involving a chase or something thrilling. There are tubas, trombones, trumpets and french horns playing the same exciting motif. | 2012-10-12T10:05:51Z | Toshikazu Sugita | 庄内ハーモニーオーケストラ30周年コンサート 第2部 5曲目 | ["Orchestra"] | ["orchestral music", "cinematic", "thrilling", "epic", "exciting", "live recording", "low quality recording", "brass instruments", "french horns", "tubas", "trumpets", "trombones"] | 3 | e1sWvJsGOAc | 3837 |
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;