musiccaps_details (view)
3 rows where musiccaps_aspects contains "blues", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- blues · 3 ✖
- low quality 3
- noisy · 3 ✖
- passionate · 3 ✖
- groovy bass 2
- acoustic rhythm guitar 1
- cool 1
- cover 1
- easygoing 1
- electric guitar melody 1
- electric guitar solo melody 1
- energetic 1
- harmonica licks 1
- harmonica solo melody 1
- live performance 1
- mono 1
- passionate fruity male vocal 1
- punchy snare 1
- shimmering cymbals 1
- soulful 1
- steel guitar melody 1
- subtly strummed acoustic rhythm guitar 1
- unbalanced stereo 1
- whistling sound 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Guitar Lessons - Stormy Monday - Style Blues Progression | The low quality recording features a cover of a blues song and it consists of subtly strummed, acoustic rhythm guitar, followed by electric guitar solo melody. It sounds passionate, easygoing and cool - like something you would hear in high end bars or blues clubs. The recording is a bit noisy. | 2010-12-31T03:07:30Z | GuitarJamz | Free Ebook when you sign my email list http://www.guitarjamz.com/new_requests/ Tony's Site http://www.tonybrucco.com | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["cover", "low quality", "noisy", "blues", "subtly strummed acoustic rhythm guitar", "electric guitar solo melody", "passionate", "easygoing", "cool"] | 4 | 1JwoLPCIGhs | 259 | |
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;