musiccaps_details (view)
11 rows where musiccaps_aspects contains "brass instruments", musiccaps_author = 3 and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| One On One - Body Music ( Disco Funk 1981 ) | This is a funky disco song. A song like this would be suitable for an eighties themed dance party. It has a groovy bassline, upbeat rhythmic percussion, and vibrant brass motifs. The singer sounds charming and energetic. The background singers are soulful and sharp on the beat with their vocals - they sing their notes almost in staccato, so that they can stay close to the beat and keep the song feeling groovy. | 2009-02-09T07:41:33Z | andersnordhagen | ["Funk", "Music"] | ["funky song", "disco style", "upbeat", "dance", "groovy bassline", "eighties", "vibrant", "soulful", "funky background vocals", "charismatic male lead vocals", "brass instruments", "trumpet", "calm electric piano"] | 3 | 9JeN1ld-3fY | 992 | ||
| Los Blancos (en vivo) | This is a traditional Latin American song which would be suitable for salsa dancing. There are layers of percussion including bongo drums and snare drums. The pianist plays intricate melodies and the brass section plays vibrant and punchy motifs. It's a live performance with a relatively poor audio quality. There is a male group of singers performing energetically. | 2008-07-14T19:10:04Z | juandog2000 | en concierto (el Rey del timbal) Leopoldo Blanco en los timbales | ["Music", "Musical instrument", "Music of Latin America", "Percussion", "Salsa music"] | ["latin american music", "upbeat", "brass instruments", "bongo drums", "piano", "male hispanic vocal group", "salsa dancing", "live performance", "low quality audio"] | 3 | DAX9uKYlDvw | 1449 | |
| Ya te olvide - Son Tentación // Mulata Salsa Club | This is a live recording of the outro of a latin american salsa song. There are brass instruments like the saxophone and trumpet. There is a man who speaks in Spanish once the music stops. It was the end section or outro of a song. | 2015-05-21T06:59:37Z | Mulata Salsa | https://www.facebook.com/MulataSalsaClub Son Tentación@Ya te olvide MULATA SALSA CLUB | ["Singing", "Music", "Speech", "Music of Latin America", "Salsa music"] | ["latin american music", "salsa", "spanish", "outro", "brass instruments", "saxophone", "trumpet", "spanish speaking", "live recording", "live performance", "bongo drums", "drum roll", "piano"] | 3 | FYux89o7Hhk | 1649 | |
| 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 | |
| Pop'n music 8 - Miami Salsa - El dia feliz | This is a salsa song with an upbeat and vibrant energy. It contains typical salsa instruments like the conga, the trumpet, and the piano. The percussion is upbeat and involves bongos and congas, and the singer is lively. | 2010-03-11T04:44:33Z | Pan | BAILANDO~ | ["Music", "Music of Latin America", "Salsa music"] | ["salsa music", "upbeat", "dance", "fun", "brass instruments", "piano", "bongo", "conga", "claves", "charming female vocalist", "energetic female vocalist"] | 3 | RneRJ5ZnHlE | 2725 | |
| Madeline and the Dinosaur Bone 1 | The song is fun, playful and cheerful. It involves child vocalists who sing in unison, and various sound effects of children laughing, and a child exclaiming. The song features an intricate clarinet melody which follows the vocal in note selection. | 2010-01-27T07:42:27Z | littlemissmadeline28 | From the New Adventures of Madeline. No copyright infringement intended; for fan purposes only. | ["Jazz", "Music"] | ["children's song", "children singing", "cheery female vocalist", "children laughing", "cheerful upbeat song", "happy song", "clarinet", "brass instruments", "playful"] | 3 | UOAv5b6MGxw | 2911 | |
| SALS@.COMBO - Los Angeles De La Salsa | The song is a latin american dance song suitable for salsa dancing. There are brass instruments, traditional percussion instruments like bongo drums, and the male vocal group sings in a cheery way in Spanish. | 2008-03-21T23:05:17Z | LOS DE LA K.Y. ORQUESTA | Audio foto del tema promocional de SALS@.COMBO Yusel Barraza Director General Contacto: 3162660803 - 3102014159 https://www.facebook.com/LOSDELAKYORQUESTA/ | ["Music", "Salsa music"] | ["latin american music", "salsa music", "upbeat", "party", "dance", "spanish", "brass instruments", "traditional percussion instruments", "bongo drums", "latin vocal group"] | 3 | cBd0yZ27dtA | 3687 | |
| mezcla de salsa romantica 2012-2013 | This song is a salsa song, with various layers of upbeat percussion which are suitable for dancing. There are bongo drums and maracas, played at a medium to high tempo. The vocalist has a dainty voice and sings in almost a high pitched voice in almost a whisper. There are brass instruments, especially trumpet and the song would be suitable for a salsa party. | 2013-04-25T05:38:43Z | Dickson Villarroel | para los amantes de la salsa, espero que les guste... | ["Music", "Music of Latin America", "Salsa music"] | ["salsa music", "latin american music", "dance", "rhythmic latin percussion", "brass instruments", "trumpet", "bongo drums", "maracas", "piano", "dainty female vocal"] | 3 | gRGiTueWUVI | 4029 | |
| 《吹奏楽コンサート》Let's Swing!! | This is an upbeat swing style song with a choir of brass instruments playing a vibrant motif. The motif is a sort of crescendo that announces the next segment. It would be suitable as an intro to the arrival of a character in a musical or movie. | 2012-09-28T02:33:25Z | エムハチチャンネル | 【QC-190】Let's Swing!! 商品詳細はこちら→https://www.music8.com/products/detail3132.php 《収録曲》 0:00 メイク・ハー・マイン【MAKE HER MINE】 1:49 故郷の空 3:36 シング・シング・シング【SING,SING,SING】 | ["Swing music", "Brass instrument", "Music"] | ["orchestra", "brass instruments", "swing", "upbeat", "groovy", "swing genre", "vibrant", "hi-hats", "crescendo"] | 3 | pKFXFu8st9I | 4701 | |
| Villancicos Navideños de Los niños cantores de Huaraz - Popurri 2 | This is a Spanish Christmas song with child vocalists. The song has a jolly and positive vibe to it. There are string instruments and brass instruments. The brass plays a three note motif that is vibrant and positive. | 2008-12-01T05:41:23Z | Carito MC | Esta es la 2da parte del popurrí, las canciones son las siguientes: - Cholo, cholito - No se niño hermoso - El churumbel - Una nueva ronda - Dulce Jesús mío - Fiesta en el pesebre - Niño Manuelito - Villancico inglés | ["Christmas music", "Christian music", "Music"] | ["latin american music", "spanish folk music", "christmas music", "child vocalists", "choral vocals", "children's choir", "string instruments", "violin", "brass instruments", "trumpet", "lively", "fun", "jolly", "bongo drums", "shaker"] | 3 | s3Q8pVDY7ZI | 4920 |
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;