musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "blues", musiccaps_aspects contains "low quality" and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- blues · 2 ✖
- low quality · 2 ✖
- acoustic 1
- acoustic guitar melody 1
- acoustic rhythm guitar chord progression 1
- crowd talking 1
- dull 1
- emotional 1
- groovy 1
- groovy bass 1
- live performance 1
- mellow snare 1
- muted acoustic guitar melody 1
- nasal male vocal 1
- passionate 1
- passionate male vocal 1
- poor quality mix 1
- shimmering cymbals 1
- smooth double bass 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 | |
Lonesome Blues - Acoustic Guitar & Double Bass | The low quality recording features a live performance of a blues song that consists of nasal male vocal singing over acoustic rhythm guitar chord progression and smooth double bass. There are also some crowd talking noises. It sounds groovy and kind of dull, since it is probably recorded with a phone. | 2012-06-03T10:13:40Z | wehappyfewmusic | This is one of our new tunes called The Lonesome Blues played at a charity fund raising gig at Teddington School. | ["Blues", "Country", "Flamenco", "Music"] | ["low quality", "acoustic", "live performance", "blues", "acoustic rhythm guitar chord progression", "smooth double bass", "crowd talking", "nasal male vocal", "groovy", "dull"] | 4 | ZLDQ8-8AyI4 | 3364 |
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;