musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "saxophone solo melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- groovy bass · 3 ✖
- saxophone solo melody · 3 ✖
- jazz 2
- low quality 2
- passionate 2
- shimmering hi hats 2
- soulful 2
- 4 on the floor kick 1
- bouncy snare 1
- car engine sound effects 1
- fun 1
- happy 1
- harmonized children vocals 1
- high pitched tire screech 1
- laughing 1
- live performance 1
- mellow 1
- mellow keys chords 1
- noisy 1
- punchy kick 1
- punchy snare 1
- quiet 1
- shimmering bells melody 1
- shimmering open hat 1
- soft 1
- static tv sound effect 1
- thin 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
WAKE, RATTLE & ROLL Episode 2 part 1 | The low quality recording features a song that consists of harmonized children vocals singing over bouncy snare, saxophone solo melody, groovy bass, shimmering open hats and "4 on the floor" kick pattern. There are some laughing, high pitched tire screeches and car engine sound effects in the background. The recording is very noisy and the song is quiet and thin, as it lacks bass frequencies, but it still sounds fun and happy - like something you would hear in TV shows for kids. | 2008-10-08T19:05:34Z | Jack Box | A new episode! | ["Music", "Rattle (instrument)"] | ["low quality", "quiet", "noisy", "fun", "happy", "harmonized children vocals", "bouncy snare", "thin", "laughing", "car engine sound effects", "static tv sound effect", "high pitched tire screech", "saxophone solo melody", "groovy bass", "shimmering open hat", "4 on the floor kick"] | 4 | mQM3Fd3eN9E | 4470 | |
Blessed Relief - Frank Zappa | The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. | 2007-09-16T15:33:59Z | zemoraes000 | A Tribute to Frank Zappa - Blessed Relief, one of the best songs composed by him. I took the video from "trance fusion - Chunga's Revenge" (author unknown). Awsome!!! see also: http://br.youtube.com/watch?v=smSfnpCZMeI hehehe | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] | 4 | sSavMIH-e-w | 4951 |
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;