musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Sad 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 |
---|---|---|---|---|---|---|---|---|---|---|
"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 | |
XAVER VARNUS: MY LIFE IS THE ORGAN - 18TH PART (SONY MUSIC, 2007) | The song is a vintage recording of a church choir singing in vocal harmony. The song is medium tempo with a church organ accompanying the choir with no other instrumentation. The song is devotional and prayerful. The audio quality is highly deteriorated and is probably an amateur home video recording. The song is a classic church choir harmony. | 2011-08-28T23:36:51Z | Xaver Varnus | "The film about the incomparable Hungarian-Canadian organist Xaver Varnus is an experience for all, who have been deeply affected by this man's art. Varnus was often called "the Horowitz of the organ" - and not just by the press, but by many leading organists themselves. This film contains treasures of archival footage of Varnus in recitals, his own recollections of his fascinating life and the on-camera interviews given in 2008. The film is very well-made, balancing as it does Varnus' voice-over narration with historical footage of many events in Europe. It is incredible to follow the life of one human being, who rises to world prominence out of the circumstances, which made his very survival questionable and to sense in all of it the Guidance of a Higher Power. The Guidance, which is available to every human being, but which is simply more noticeable in Varnus' case." (Francois Fejto, journalist of Le Figaro) A film by Mate Vargha. Sony Music, 2007 (233 min.) 1st part: http://www.youtube.com/watch?v=x5rbXWfxz7k 2nd part: http://www.youtube.com/watch?v=yvqw4ZLR52Y 3rd part: http://www.youtube.com/watch?v=vEQHe-nXkns 4th part: http://www.youtube.com/watch?v=Ho5CiI_w02o 5th part: http://www.youtube.com/watch?v=RY09aVHM8Yg 6th part: http://www.youtube.com/watch?v=DqIcF2fMEbk 7th part: http://www.youtube.com/watch?v=2xwv-SOML7s 8th part: http://www.youtube.com/watch?v=XiZmkolLkZ0 9th part: http://www.youtube.com/watch?v=uwgsy-ZWhpk 10th part: http://www.youtube.com/watch?v=oFRyKnp5vNo 11th part: http://www.youtube.com/watch?v=j1AFilIqCn0 12th part: http://www.youtube.com/watch?v=PMWsILDGrmg 13th part: http://www.youtube.com/watch?v=J7sf8UR5c64 14th part: http://www.youtube.com/watch?v=Cz3c-0era7M 15th part: http://www.youtube.com/watch?v=4EXUu-Lf37k 16th part: http://www.youtube.com/watch?v=4r8v4CIufVA 17th part: http://www.youtube.com/watch?v=9qOj6pvDCQE 18th part: http://www.youtube.com/watch?v=tGv_L09pf6E | ["Background music", "Music", "Sad music"] | ["choral music", "bad quality recording", "western classical music", "audio buzz noises", "audio quality deterioration", "church choir", "children’s church choir", "amateur recording", "no percussion instruments", "heavenly", "meditational", "inspiring", "jarring tones", "inspiring", "christian classical music", "choral harmony", "male and female singers", "passionate", "prayerful", "emotional", "home video recording", "church organ playing", "slow tempo"] | 1 | tGv_L09pf6E | 5023 |
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;