musiccaps_details (view)
5 rows where musiccaps_aspects contains "trumpets" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- trumpets · 5 ✖
- brass instruments 4
- epic 2
- vibrant 2
- african music 1
- autotuned vocal 1
- background ad-libs 1
- background shouting 1
- bongo drums 1
- bongos 1
- build-up 1
- cinematic 1
- classical music 1
- dance 1
- electric bass guitar 1
- electric keyboard 1
- exciting 1
- french horns 1
- gospel 1
- groovy 1
- impressive 1
- intricate drum pattern 1
- intricate piano playing 1
- jazz 1
- latin music 1
- live recording 1
- low quality recording 1
- medium tempo 1
- mellow groove 1
- orchestral music 1
- reggae style rhythm 1
- saxophone 1
- south asian dance music 1
- thrilling 1
- timpani 1
- traditional percussive instruments 1
- trombones 1
- tubas 1
- upbeat 1
- uplifting 1
- wooden percussion instrument 1
musiccaps_names (array) 13 ✖
- Music 3
- Orchestra 3
- Brass instrument 1
- Classical music 1
- Drum 1
- Gospel music 1
- Middle Eastern music 1
- Music of Africa 1
- Musical instrument 1
- Percussion 1
- Reggae 1
- Song 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 | |
GHANA GOSPEL MUSIC PROJECT 2008 AKWAABA JUNIOR LTJBM BAND Ayeyie oo! | This is a live performance by an African music group in a gospel style. The drum pattern is intricate and there are other percussive elements like an occasional bongo and a wooden percussion instrument. The melodic elements are the vintage sounding electric piano as well as the vibrant and fun brass melody played on the trumpets. | 2008-09-09T12:42:40Z | livegospelbandghana | SHILOH EVANGELICAL GOSPEL MUSIC ACADEMY presente to the world Afric's No. 1 juvenile live gospel band, playing three fusions. African gospel music revolution fusion, playing high life reggea jazz etc. contact: neelante@journalist.com, tel: (+233) 244 654 400 / 277 338 172 | ["Gospel music", "Music", "Middle Eastern music"] | ["african music", "gospel", "trumpets", "upbeat", "vibrant", "electric bass guitar", "bongo drums", "intricate drum pattern", "wooden percussion instrument", "electric keyboard", "mellow groove", "medium tempo"] | 3 | C0eCERYt4bA | 1317 | |
Gonder | The song is a traditional south asian dance song with clear reggae influences. It is upbeat, vibrant and features bouncy reggae percussion. There are brass instruments playing cheerful motifs, and the lead singer has reverb and ample autotune applied to his vocal. There's a background vocalist adding shouted ad-libs to the song. | 2011-10-11T01:52:05Z | Addis | ["Music of Africa", "Music", "Reggae", "Song"] | ["south asian dance music", "reggae style rhythm", "brass instruments", "trumpets", "autotuned vocal", "background shouting", "background ad-libs", "vibrant"] | 3 | L5Uu_0xEZg4 | 2152 | ||
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;