musiccaps_details (view)
6 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
| ☆Black Sheep cover Ver☆Fastest Pram☆the pillowsカバーコンテスト | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over simple electric guitar chords. The recording is noisy and it has some seat crackling noises in it. It sounds sad and emotional though. | 2009-07-22T12:28:48Z | hiro2cyclone | [black sheep/ Fastest Pram] the pillowsカバーコンテスト。 the pillows20周年おめでとうございます！ 7/20 BUSTERS TRIBUTE SHOW!!!と銘打って関東関西同時に行われたイベントから！ ピロウズの曲は楽しく弾いてなんぼ！ってことでこの曲を＾＾ | ["Blues", "Guitar", "Music"] | ["low quality", "live performance", "seat crackles", "noisy", "simple electric guitar chords", "flat male vocal", "emotional", "sad", "rock"] | 4 | FbV2Lgt3H1Q | 1655 | |
| "No Matter Where You Are" - Us The Duo (Live Wedding Performance) | The low quality recording features a live performance sung by harmonizing mixed vocals and followed by acoustic rhythm guitar and shimmering shaker. In the second part, a hollow male vocal continues to sing over shaker and acoustic guitar. It sounds thin, but fun, happy and emotional - it was probably recorded with a phone or camera microphone. | 2014-05-06T13:51:38Z | Us The Duo | Come see us play LIVE!! Tickets on sale now: http://ustheduo.co/tour Our new album “Just Love” is available now! iTunes: http://ustheduo.co/JustLove Apple Music: http://ustheduo.co/JustLoveAM Amazon: http://ustheduo.co/JustLoveAmz Spotify: http://ustheduo.co/JustLoveSp Google Play: http://ustheduo.co/JustLoveGP Follow us on all socials @UsTheDuo / http://www.ustheduo.com/ Filmed by Justin Element Productions - justinelement.com Edited by Yes Equals Yes. Song written by : Michael & Carissa Alvarado | ["Blues", "Singing", "Music"] | ["low quality", "live performance", "shimmering shakers", "harmonizing mixed vocals", "hollow male vocal", "acoustic rhythm guitar", "fun", "happy", "emotional", "thin"] | 4 | GBsate-JQAo | 1700 | |
| 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 | |
| Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
| Shirley King - Let The Good Times Roll | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-11-26T05:14:33Z | Bob .Hampton | Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | 4 | mFcHGbnNtSQ | 4456 |
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;