musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "song cover"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- emotional · 4 ✖
- passionate · 4 ✖
- song cover · 4 ✖
- female singer 3
- romantic 3
- bad audio quality 2
- groovy bass line 2
- inspiring 2
- keyboard accompaniment 2
- live performance 2
- love song 2
- slow tempo 2
- spirited 2
- strong bass line 2
- amateur singing 1
- ambient noises 1
- bell tones 1
- cameras clicking 1
- church organ playing 1
- crowds clapping 1
- crowds whistling 1
- dealing with depression 1
- elvis presley 1
- encouraging crowd 1
- eternal love 1
- ethereal harmony 1
- greatest love sings 1
- guitar accompaniment 1
- hissing and buzzing distortions 1
- hissing tones 1
- home video 1
- instrumental music 1
- keyboard accomapniment 1
- life’s lessons 1
- loneliness 1
- medium tempo 1
- melancholic 1
- melodious 1
- modern pop covers 1
- motivational 1
- movie soundtrack 1
- music concert 1
- never give up 1
- odern pop hits 1
- poor audio quality 1
- pop song 1
- pop super hits 1
- retro pop hits 1
- rhythmic acoustic guitar 1
- sentimental 1
- slamming door percussion 1
- story telling 1
- suspense 1
- together forever 1
- violin harmony 1
- vocal echoes 1
musiccaps_names (array) 10 ✖
- Music 3
- Applause 1
- Crackle 1
- Electric piano 1
- Electronic organ 1
- Keyboard (musical) 1
- Organ 1
- Piano 1
- Sad music 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
"And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) | A female vocalist sings this romantic love song. The tempo is slow with a melodic violin harmony, groovy bass line, rhythmic acoustic guitar and keyboard accompaniment. The song is soft, mellow, romantic, emotional, sentimental, melancholic and gentle. This. The song is a cover of a Classic Elvis Presley song. | 2012-06-11T17:01:57Z | LeCommedieDellArte | "And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) (Songwriters: MCLEAN, DON ) And I love you so, The people ask me how, How I've lived till now I tell them I don't know I guess they understand How lonely life has been Life began again The day you took my hand And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me And you love me too Your thoughts are just for me You set my spirit free I'm happy that you do The book of life is brief Once the page is read All but love is dead This is my belief And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me | ["Music", "Sad music"] | ["female singer", "slow tempo", "violin harmony", "song cover", "elvis presley", "love song", "sentimental", "emotional", "melancholic", "melodious", "groovy bass line", "keyboard accomapniment", "romantic", "passionate", "rhythmic acoustic guitar"] | 7 | Inuq5W98ktA | 1942 | |
Frank Heinen auf der Wersi-Orgel in Konzert! | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | 2009-08-26T20:34:40Z | derjaschka | Ausschnitte von diversen Veranstaltungen 2009! https://www.facebook.com/frankheinenwersi | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | 1 | Pgpd1yxLcLI | 2558 | |
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 |
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;