musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "noisy" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- groovy bass · 3 ✖
- low quality 3
- noisy · 3 ✖
- passionate 3
- blues 2
- electric guitar melody 2
- harmonica solo melody 2
- mono 2
- acoustic rhythm guitar 1
- boomy playback 1
- energetic 1
- harmonica licks 1
- live performance 1
- passionate fruity male vocal 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- soulful 1
- steel guitar melody 1
- unbalanced stereo 1
- whistling sound 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slow Blues in E - Harmonica | The low quality recording features a harmonica solo melody playing over a boomy playback song in the background. The song consists of shimmering hi hats, groovy bass and electric guitar melody. The recording is noisy and in mono. | 2011-11-24T22:29:26Z | pistolkatt | A take at slow blues key of E. Harmonica is a Hohner Crossover in key of A. Second position. Backing track is Dumb dog blues by Lawrence Fritts. Keeping it kind of minor with no major thirds or sixths. I've been jamming to slow blues all week because it's as bluesy as it gets but hard as hell to play. Timekeeping, phrasing and feeling have to be just right. This felt as a fairly close miss :) | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "boomy playback", "harmonica solo melody", "shimmering hi hats", "groovy bass", "electric guitar melody", "noisy", "mono", "passionate"] | 4 | CwImmV7q1MY | 1415 | |
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 | |
Steve Miller mercury blues norton buffalo harmonica solo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | 2006-10-04T03:46:37Z | Sunshine Day | part of song with awesome harmonica solo by norton | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | 4 | ovomUNSo_uo | 4666 |
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;