musiccaps_details (view)
2 rows where musiccaps_aspects contains "harmonizing mixed vocals" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- harmonizing mixed vocals · 2 ✖
- live performance · 2 ✖
- low quality 2
- acoustic rhythm guitar 1
- arpeggiate synth keys melody 1
- crowd excitement 1
- crushed 1
- distorted bass 1
- emotional 1
- fun 1
- happy 1
- harsh 1
- hollow male vocal 1
- mystical 1
- shimmering shakers 1
- thin 1
- unbalanced stereo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Rescues - Shout by Tears for Fears | The low quality recording features a live performance that consists of harmonizing mixed vocals singing over distorted bass and arpeggiated synth keys melody. It sounds crushed, harsh and the stereo image is unbalanced since the sound is leaning towards the right channel of the stereo image. There are some crowd excitement sounds in the background. | 2009-08-30T15:17:59Z | thevmannc | New Project 1 | ["Music", "Whoop"] | ["low quality", "harmonizing mixed vocals", "harsh", "live performance", "distorted bass", "arpeggiate synth keys melody", "crushed", "crowd excitement", "unbalanced stereo", "mystical"] | 4 | DKBbLySEGic | 1463 | |
"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 |
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;