musiccaps_details (view)
2 rows where musiccaps_aspects contains "uplifting energy" and musiccaps_aspects contains "upright bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- uplifting energy · 2 ✖
- upright bass · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic piano 1
- brass 1
- country 1
- higher key 1
- latin/bossanova 1
- male voice singing 1
- marimba 1
- moderate tempo 1
- percussion 1
- piano 1
- shaker 1
- uptempo 1
musiccaps_names (array) 6 ✖
- Brass instrument 1
- Jazz 1
- Music 1
- Musical instrument 1
- Trumpet 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 | |
6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 |
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;