musiccaps_details (view)
7 rows where musiccaps_aspects contains "cover", musiccaps_aspects contains "passionate" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- cover · 7 ✖
- low quality 7
- passionate · 7 ✖
- noisy 6
- emotional 4
- mono 4
- rock 3
- energetic 2
- addictive 1
- arpeggiated acoustic guitar melody 1
- background pop instrumental 1
- boogie 1
- cultural 1
- distorted electric guitar melody 1
- energetic drums 1
- flat female vocal 1
- funky 1
- funky electric guitars melodies 1
- groovy 1
- groovy bass guitar 1
- harmonizing female choir vocals 1
- harmonizing male vocals 1
- loud shoe tapping 1
- passionate female vocal 1
- passionate male vocal 1
- plucked strings melody 1
- pop 1
- repetitive percussive element 1
- reverberant passionate female vocal 1
- roomy 1
- …
musiccaps_names (array) 19 ✖
- Singing · 7 ✖
- Music 5
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- /t/dd00004 2
- A capella 2
- Choir 2
- Carnatic music 1
- Chorus effect 1
- Classical music 1
- Effects unit 1
- Inside, small room 1
- Mandolin 1
- Psychedelic rock 1
- Song 1
- Tap 1
- Ukulele 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Impossible"- Shontelle( Katrina cover) | The low quality recording features a cover of a pop song. It is sung by passionate female vocalists over pop instrumental playing in the background. It is noisy and it sounds roomy as it is probably recorded with a phone or a camera microphone, but it is also emotional, passionate and addictive. | 2010-06-21T03:28:53Z | katrina briones | I DO NOT OWN ANY COPYRIGHTS its so nice to be back. i was just busy these past few days. but yeah lil' somethin for yah guys. i miss youtube!. :) Subscribe to me! yay!. i love ya'll Lyrics: i remember years ago someone told me i should take caution when it comes to love i did, i did and you were strong and i was not my illusion, my mistake i was careless, i forgot i did and now when all is done there is nothing to say you have gone and so effortlessly you have won you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible falling out of love is hard falling for betrayal is worst broken trust and broken hearts i know, i know thinking all you need is there building faith on love and words empty promises will wear i know (i know) and know when all is gone there is nothing to say and if you're done with embarrassing me on your own you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible impossible, impossible impossible, impossible impossible, impossible | ["Singing", "Music", "/t/dd00004"] | ["low quality", "cover", "passionate female vocal", "background pop instrumental", "noisy", "roomy", "emotional", "passionate", "addictive"] | 4 | 2f7NnTVQzR0 | 395 | |
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
LA Amp Show 2008 -- Carl Verheyen & Steve Trovato (Mercury Magnetics room) | The low quality recording features a cover of a boogie song sung by a passionate male vocalist, followed by funky electric guitar melodies. It sounds passionate, groovy, funky and the recording is in mono and noisy. | 2008-10-10T00:30:35Z | MercuryMagnetics | Mercury Magnetics - Carl Verheyen and Steve Trovato live jam at the Amp Show 2008 in the Mercury Magnetics room. Check out www.stevetrovato.com ! | ["Singing", "Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "boogie", "cover", "funky electric guitars melodies", "passionate male vocal", "passionate", "groovy", "funky"] | 4 | 89eBh_Djflw | 899 | |
Surrey Harmony - Bohemian Rhapsody | The low quality recording features a cover of a rock song sung by harmonizing female choir vocals. The recording is noisy, in mono and it sounds emotional and passionate. | 2008-07-02T11:24:33Z | Emma Riley | Surrey Harmony's Barbershop version of Bohemian Rhapsody, sung in the Sweet Adelines Region 31 Showcase, May 2008. | ["Singing", "Song", "Choir", "A capella"] | ["low quality", "harmonizing female choir vocals", "emotional", "passionate", "noisy", "mono", "cover", "rock"] | 4 | FHC7gN3NnX8 | 1633 | |
Raag Bhopali | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | 2011-01-20T17:29:46Z | aradhanakarhade | Raag Bhupali tutorial for beginners - Raag Bhopali has five notes, and is thus a raag of the "audhav jaati". Follow the instructions and practice this raag. Here, it is sung in the scale of B major. The corresponding notes in B scale are B, C#, D#, F#, G# PLEASE SUBSCRIBE TO OUR NEW CHANNEL: https://www.youtube.com/channel/UCezyky1nT-IVvKAEZagViUA | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | 4 | VV-DgnPPhSo | 3006 | |
Metallica - Fade to Black - Cover By Keara | The low quality recording features a cover of a rock song that consists of flat male vocal singing over distorted electric guitar melody, energetic drums and groovy bass guitar. The song sounds passionate and energetic. | 2013-08-28T00:39:45Z | guitarprincesskeara | This video took a lot of hard work and time. Enjoy, thanks for all the support! | ["Singing", "Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | ["low quality", "distorted electric guitar melody", "rock", "cover", "energetic drums", "groovy bass guitar", "energetic", "passionate", "flat female vocal"] | 4 | XJXn88r9ys8 | 3176 | |
UC Men's Octet - Bohemian Rhapsody | The low quality recording features a cover of a pop song and it consists of harmonizing male vocals and loud shoe tapping that serves as a rhythm. The recording is in mono and very noisy, as it was probably recorded with a phone. It sounds passionate and energetic - even without the instruments. | 2006-02-25T06:59:48Z | sv02 | UC Berkeley Men's Octet at UC Choral Ensemble's Annual A Cappella For AIDS 2006 (originally from Fall Show set 2005) | ["Singing", "Tap", "Choir", "Vocal music", "A capella"] | ["low quality", "loud shoe tapping", "harmonizing male vocals", "pop", "cover", "noisy", "mono", "passionate", "energetic"] | 4 | XWhmLbnrtd0 | 3190 |
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;