musiccaps_details (view)
2 rows where musiccaps_aspects contains "animated", musiccaps_aspects contains "vivacious" and musiccaps_aspects contains "vocal backup"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- animated · 2 ✖
- buoyant 2
- spirited 2
- vibrant 2
- vivacious · 2 ✖
- vocal backup · 2 ✖
- animated piano 1
- bongos 1
- bright trumpets 1
- charming 1
- cheerful 1
- classic rock 1
- congas 1
- electric guitar 1
- fast tempo 1
- female singer 1
- funk 1
- funky 1
- groovy 1
- groovy bass line 1
- happy 1
- infectious drumming 1
- jive music 1
- latin folk 1
- latin music 1
- latin pop 1
- lively animated 1
- lively cello 1
- lively trumpet 1
- male singer 1
- medium fast tempo 1
- peppy 1
- perky 1
- r&b 1
- regional music 1
- retro 1
- rock and rock 1
- rock pop 1
- upbeat 1
- vic latin dance 1
- world music 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- Jazz 1
- Music 1
- Salsa music 1
- Singing 1
- Song 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Perfume De Salsa - Dame Un Traguito (Music Video Latin Jazz/Salsa) | A female vocalist sings this spirited latin song.the tempo is medium fast with an animated piano accompaniment, rhythmic congas and bongos, funky bass line and bright trumpet harmony. The song is lively, spirited, upbeat, catchy, vivacious;vibrant and peppy with a salsa dance groove. This song is Latin Pop. | 2015-10-21T16:12:43Z | Sam Sam Music | Fabulous all women Latin Jazz / Salsa band Perfume de Salsa: On disc and download: http://www.samsammusic.com/Perfume-De-Salsa https://itunes.apple.com/us/album/solo-ella/id369866081 https://play.spotify.com/album/4Uhhl8qh5YiIibzNku0wpf http://www.amazon.com/Solo-Ella-Perfume-Salsa/dp/B003JJUJWS https://play.google.com/store/music/album/Perfume_de_Salsa_Solo_Ella?id=Bmu4rc6lk6hmr4ohcqoufeqbooa&hl=en http://www.rdio.com/artist/Perfume_De_Salsa/album/Solo_Ella/ http://www.deezer.com/album/543046 Subscribe to Sam Sam Music ➤https://bit.ly/34fRMti Great New Music Videos ➤ https://bit.ly/34fXevV Rock’n Roll Sixties ➤ http://bit.ly/RocknRollSixties Follow us on Social Media: Website ► https://bit.ly/2NGpfHJ Facebook ► http://bit.ly/2NJztas Twitter► http://bit.ly/32KMt3A Instagram► http://bit.ly/2NKdUXh #latin #salsa #jazzmusic | ["Singing", "Jazz", "Music", "Song", "Salsa music"] | ["female singer", "medium fast tempo", "vivacious", "animated", "spirited", "buoyant", "perky", "peppy", "cheerful", "vibrant", "latin music", "latin pop", "vic latin dance", "latin folk", "regional music", "world music", "animated piano", "lively trumpet", "groovy bass line", "bongos", "congas", "vocal backup"] | 7 | fPYeqTFc3IQ | 3944 | |
She's So Fine - Jackie Wilson | A male vocalist sings this lively Rock song. The tempo is fast with bright trumpet harmony, groovy bass, infectious drumming , electric guitar and vocal backup. The music is upbeat, groovy, funky, high-spirited, vibrant and enthusiastic. This song is Retro Rock and Roll. | 2012-09-22T18:49:33Z | Mike Swindle | Hard to find music. | ["Brass instrument", "Trombone"] | ["male singer", "fast tempo", "lively cello", "bright trumpets", "vibrant", "classic rock", "animated", "buoyant", "groovy", "funky", "vibrant", "vivacious", "happy", "charming", "vocal backup", "spirited", "retro", "jive music", "upbeat", "spirited", "infectious drumming", "electric guitar", "lively animated", "rock and rock", "rock pop", "funk", "r&b"] | 7 | r4nPBNL3D0E | 4849 |
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;