musiccaps_details (view)
3 rows where musiccaps_aspects contains "blues", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- blues · 3 ✖
- groovy bass · 3 ✖
- low quality 3
- passionate · 3 ✖
- noisy 2
- shimmering cymbals 2
- acoustic guitar melody 1
- acoustic rhythm guitar 1
- electric guitar melody 1
- emotional 1
- energetic 1
- harmonica licks 1
- harmonica solo melody 1
- live performance 1
- mellow snare 1
- mono 1
- muted acoustic guitar melody 1
- passionate fruity male vocal 1
- passionate male vocal 1
- poor quality mix 1
- punchy snare 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ryszard Riedel i Nocna Zmiana Bluesa - Hotelowy Blues | The low quality recording features a blues song that consists of a passionate male vocal singing over acoustic guitar melody in the left channel, muted acoustic guitar melody in the right channel of the stereo image, groovy bass, mellow snare and shimmering cymbals. It sounds passionate and emotional. | 2008-01-12T15:37:19Z | paweuek92 | Fajny kawałek :) | ["Blues", "Country", "Music"] | ["low quality", "poor quality mix", "blues", "passionate male vocal", "acoustic guitar melody", "muted acoustic guitar melody", "groovy bass", "mellow snare", "shimmering cymbals", "passionate", "emotional"] | 4 | 9Rx57dlJtIA | 1008 | |
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;