musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate male vocal", musiccaps_names contains "Country" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Blind Pilot "Three Rounds and a Sound" (3 of 4) Indie Pop from Portland, OR | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | 2010-03-17T20:59:05Z | One Night Music | One Night Music recorded Blind Pilot at Muddy Waters Cafe in Santa Barbara, CA on August 1, 2009. Find all 4 videos and a story at: http://www.onenightmusic.com/blog/post/love-at-muddy-waters-rey-villalobos-and-blind-pilot/ Filmed and edited by Megan Sullivan Audio editing by Ryan Andersen Filmed with VADO HD, audio with Zoom H2. Follow us: http://www.twitter.com/onenightmusic http://www.facebook.com/onenightmusic http://www.onenightmusic.com One Night Music is a San Francisco based collective of volunteers creating high quality video and audio recordings of live performances by quality independent music artists. Learn how to record with us or how to volunteer with us at http://www.OneNightMusic.com/about | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | 4 | QtjMlA_7dds | 2647 | |
Tìm lại bầu trời - hướng dẫn guitarist CHop Bi (phần 2 - chơi mẫu) | The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. | 2012-03-10T11:35:16Z | thachsungabc | Lớp guitar - CLB nghệ thuật trẻ Hà Nội - link: http://enbac.com/Ha-Noi/Tong-hop/p1174061/Lop-guitar-CLB-nghe-thuat-tre-chieu-sinh-Thong-bao-chuong-trinh-tang-dan-guitar-cho-hoc-vien-moi.html | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] | 4 | cOgNXgF21u4 | 3702 |
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;