musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "/t/dd00004" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate · 3 ✖
- cover 2
- emotional 2
- low quality 2
- noisy 2
- addictive 1
- ambient crowd noise 1
- background pop instrumental 1
- blues music 1
- blues turnaround 1
- cultural 1
- female singer 1
- fret noise 1
- guitar notes playing 1
- guitar playing 1
- hissing ambient sound 1
- lilting vocals 1
- live audience 1
- live performance 1
- love song 1
- madly in love 1
- passionate female vocal 1
- plucked strings melody 1
- poor audio quality 1
- pop diva 1
- pop song 1
- pop super hits 1
- repetitive percussive element 1
- reverberant passionate female vocal 1
- romantic 1
- …
musiccaps_names (array) 6 ✖
- /t/dd00004 · 3 ✖
- Music 3
- Singing · 3 ✖
- Carnatic music 1
- Classical music 1
- Inside, large room or hall 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 | |
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
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 |
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;