musiccaps_details (view)
4 rows where musiccaps_aspects contains "trumpets" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- trumpets · 4 ✖
- brass instruments 2
- male singer 2
- medium tempo 2
- adrenaline rush 1
- ambient 1
- ambient room noise 1
- animated piano 1
- autotuned vocal 1
- background ad-libs 1
- background shouting 1
- blues 1
- drums 1
- exercise class 1
- groovy bass lines 1
- groovy music 1
- guitar accompaniment 1
- gym music 1
- harp 1
- horns 1
- improvisations 1
- jazz 1
- jazz piano 1
- latin dance hits 1
- latin dance music 1
- latin percussion 1
- male voice 1
- marimba 1
- passionate 1
- pleasant 1
- poor audio quality 1
- reggae style rhythm 1
- romantic 1
- saxophone accompaniment 1
- slick drumming 1
- south asian dance music 1
- spirited 1
- strong bass line 1
- swing 1
- syncopated harmony 1
- tuba 1
- vibrant 1
- wind instruments 1
- workout playlist 1
- yodeling 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 8 ✖
- Music 4
- Song · 4 ✖
- Maraca 1
- Music of Africa 1
- Reggae 1
- Steelpan 1
- Swing music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Straighten up and Fly Right-SWING SUPREME | A male vocalist sings this mellow jazz song. The tempo is medium with a spirited saxophone accompaniment, jazzy piano, groovy bass lines, slick drumming and trumpet . The song is melodic, catchy, ambient, romantic, groovy, light and breezy with a swing rhythm. This song is a lively Jazz song. | 2008-11-13T17:49:53Z | Ian Boyter | A swing standard recorded by the Edinburgh Band Swing Supreme. www.swingsupreme.co.uk | ["Swing music", "Music", "Song"] | ["male singer", "medium tempo", "jazz piano", "trumpets", "romantic", "pleasant", "saxophone accompaniment", "wind instruments", "brass instruments", "slick drumming", "groovy bass lines", "animated piano", "swing", "jazz", "blues", "ambient", "pleasant", "syncopated harmony", "improvisations"] | 7 | CphwhKgYHaM | 1405 | |
Home on the Range "Yodle Adle Eedle Idle Oo" Russian | The music features for the most part an instrumental but almost at the end of the excerpt a male voice starts to yodel. Up to that point the melody is being played by a marimba, then trumpets and horns, possibly trombones too. A tuba is holding the beat pulsation in the low register. At the end of the excerpt a harp can be heard. | 2008-07-01T06:11:14Z | Titania1989 | =) | ["Yodeling", "Music", "Song", "Steelpan"] | ["trumpets", "marimba", "horns", "tuba", "drums", "yodeling", "male voice", "harp"] | 2 | F5e-SEICJP4 | 1612 | |
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 | ||
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 |
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;