musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_aspects contains "uplifting energy" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- percussion · 2 ✖
- uplifting energy · 2 ✖
- acoustic drums 1
- acoustic piano 1
- e-bass 1
- e-guitar 1
- fast tempo 1
- keys 1
- latin/bossanova 1
- marimba 1
- moderate tempo 1
- saxophone 1
- shaker 1
- ska 1
- upright bass 1
musiccaps_names (array) 7 ✖
- Music 2
- Jazz 1
- Music of Africa 1
- Musical instrument 1
- Reggae 1
- Swing music 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Torres - The Godfather Of Latin Jazz | The marimba takes the lead melody along with an acoustic piano providing some underlining jazzy chords with a lot of changes. The upright bass sounds round and quiet. The acoustic elements are providing latin grooves. The instruments are all slightly panned to the left and right side of the speakers. This song may be playing in an elevator. | 2012-12-28T23:49:18Z | Raul Rico | Joe Torres and his "Cool Latin Jazz Quartet" - Joe Torres - vibes; Cocho Arbe - piano; Jiovanni Cofino - bass & Leandro Mena - congas Available for all Occasions (703) 324-1224 Joe@coollatinjazz.com | ["Jazz", "Music", "Musical instrument", "Vibraphone"] | ["latin/bossanova", "marimba", "upright bass", "shaker", "percussion", "acoustic piano", "uplifting energy", "moderate tempo"] | 6 | CwHSb1NOi4c | 1414 | |
Revolucionario-Rompope Sound | An acoustic drum is playing along with a bassline giving the song a ska/reggae feeling. The e-guitar strumming on the offbeat supports that feeling while a keyboard is playing a bell-sounding chord. Bongos are setting little accents at the end. A saxophone is playing a melody along. This song may be playing at a festival outside while the sun is shining. | 2014-06-06T00:05:11Z | Zkanker Efrain Lorenzo Bautista | Demo! El facebook de la banda:https://www.facebook.com/bandda.rompoopee | ["Swing music", "Music of Africa", "Music", "Reggae"] | ["ska", "saxophone", "e-guitar", "acoustic drums", "percussion", "keys", "e-bass", "fast tempo", "uplifting energy"] | 6 | -kpR93atgd8 | 79 |
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;