musiccaps_details (view)
3 rows where musiccaps_aspects contains "soulful" and musiccaps_names contains "Harmonica"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- passionate 3
- soulful · 3 ✖
- groovy bass 2
- low quality 2
- noisy 2
- accordion melody 1
- acoustic rhythm guitar 1
- blues 1
- harmonica licks 1
- jazz 1
- mellow 1
- passionate fruity male vocal 1
- plastic tapping sounds 1
- saxophone solo melody 1
- shimmering bells melody 1
- shimmering hi hats 1
- soft 1
- steel guitar melody 1
- unbalanced stereo 1
musiccaps_names (array) 2 ✖
- Harmonica · 3 ✖
- Wind instrument, woodwind instrument 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slide Guitar Showdown II - Harry Manx & Greg Leisz | The low quality recording features a blues song that consists of a passionate fruity male vocal singing over harmonica licks, acoustic rhythm guitar, groovy bass and steel guitar melody. It sounds passionate and soulful. The recording is noisy and since the bass sound is leaning towards the right channel of the stereo image - the stereo image is unbalanced. | 2008-12-04T22:07:26Z | stevemarrinerofficial | Live in Vista, California, September 2006. Two of the finest slide guitarists in the 'biz, Harry Manx and Greg Leisz. Also featuring Steve Marriner on harmonica. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "blues", "passionate fruity male vocal", "harmonica licks", "acoustic rhythm guitar", "steel guitar melody", "passionate", "soulful", "groovy bass", "unbalanced stereo", "noisy"] | 4 | JCfZpSEH77Y | 1977 | |
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 | |
SpongeBob SquarePants Production Music - Spanish Ladies (b) | The low quality recording features an accordion melody with some plastic tapping keys along the way. It sounds soulful and passionate and the recording is noisy. | 2010-12-26T05:46:27Z | MonsieurCommandoMan | Composers: Robin Jeffrey, Tim Laycock Played in Enemy In-Law, Welcome to the Chum Bucket, Party Pooper Pants and Your Shoe's Untied. | ["Harmonica"] | ["low quality", "noisy", "accordion melody", "plastic tapping sounds", "soulful", "passionate"] | 4 | uA-JpZppFsc | 5093 |
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;