musiccaps_details (view)
3 rows where musiccaps_aspects contains "blues", musiccaps_aspects contains "low quality" and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- blues · 3 ✖
- low quality · 3 ✖
- passionate male vocal 2
- acoustic 1
- acoustic guitar melody 1
- acoustic rhythm guitar chord progression 1
- brass melody 1
- crowd talking 1
- dull 1
- emotional 1
- groovy 1
- groovy bass 1
- groovy piano chords 1
- live performance 1
- mellow snare 1
- mono 1
- muted acoustic guitar melody 1
- nasal male vocal 1
- noisy 1
- nostalgic 1
- passionate 1
- poor quality mix 1
- sentimental 1
- shimmering cymbals 1
- smooth bass 1
- smooth double bass 1
- vintage 1
- whistling 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 | |
Guy Mitchell - Singing The Blues (Live!) | The low quality recording features a blues song that consists of passionate male vocal singing over groovy piano chords, brass melody, whistling melody and smooth bass. It sounds vintage and thus nostalgic and sentimental. The recording is very noisy. | 2008-12-13T21:28:30Z | animalz1969 | "Singing the Blues" is a popular song. It was written by Melvin Endsley and was published in 1956. The best-known recording of the song, released in October 1956 by Guy Mitchell, spent 9 weeks at #1 on the Billboard chart from December 8, 1956 - February 2, 1957, despite competition from rival versions by Tommy Steele and Marty Robbins. Tommy Steele's version also made no. 1 in the UK Singles Chart for one week on 11 January 1957. | ["Blues", "Music", "/t/dd00003"] | ["low quality", "blues", "mono", "noisy", "passionate male vocal", "groovy piano chords", "whistling", "brass melody", "smooth bass", "vintage", "nostalgic", "sentimental"] | 4 | AEwkS57P4eE | 1089 | |
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;