musiccaps_details (view)
6 rows where musiccaps_aspects contains "emotional", 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Cacophony The Ninja cover) | The low quality recording features a cover of a rock song with a rock instrumental playback playing in the background and electric guitar solo melody playing on top of it. It sounds muffled and noisy, as it was probably recorded with a low quality microphone, but it is still passionate and emotional. | 2013-05-19T04:18:09Z | Andres thunder | Humilde tributo a la legendaria banda CACOPHONY ( Jason becker / Marty Friedman ) Guitarras Camilo Henriquez Andres Caucao | ["Blues", "Guitar", "Music"] | ["low quality", "noisy", "muffled", "electric guitar solo melody", "cover", "rock instrumental playback", "passionate", "emotional"] | 4 | -Umconw-CRE | 51 | |
| 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 | |
| Cody Simpson - Perfect - Music Video - Full - HQ | The low quality recording features a passionate boy vocal singing over punchy kick, groovy bass, shimmering hi hats and crash cymbal hit and groovy piano melody. It sounds emotional and passionate. | 2010-01-11T17:02:15Z | CodySupport | CREATE AND ORDER YOUR OWN GUITAR PICK HERE http://www.MyPickShopOnline.com/ Learn To Play Guitar Online: http://youtube.com/EasyTabber/ | ["Blues", "Music", "Pop music"] | ["low quality", "groovy bass", "punchy kick", "passionate boy vocal", "shimmering hi hats", "shimmering crash cymbal", "groovy piano melody", "emotional", "passionate"] | 4 | 9cojCCMSABc | 1029 | |
| ☆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 | |
| 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 |
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;