musiccaps_details (view)
3 rows where musiccaps_aspects contains "conductor" and musiccaps_aspects contains "love song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- conductor · 3 ✖
- love song · 3 ✖
- medium tempo 3
- emotional 2
- poor audio quality 2
- western classical music 2
- cathedral 1
- cello playing 1
- choir 1
- choral harmony 1
- christian choir 1
- church choir 1
- church service 1
- classic composers 1
- composer 1
- dance like 1
- devotional 1
- dynamics 1
- ethereal voices 1
- female opera singer 1
- forever classics 1
- four part harmony 1
- gospel music 1
- heartfelt 1
- heavenly 1
- hymns 1
- in love 1
- instrumental music 1
- lilting vocals 1
- lullaby 1
- madly in love 1
- meditational 1
- melancholic 1
- movie soundtrack 1
- passionate 1
- piano accompaniment 1
- piano playing 1
- piano solo 1
- poignant 1
- praise and worship 1
- prayer 1
- romantic 1
- sensual 1
- soaring vocals 1
- string section harmony 1
- together forever 1
- tragic 1
- violins 1
- vocal harmony 1
- western classical masterpieces 1
- winter 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Swan Lake for piano, Tchaikovsky + sheet music | The song is instrumental music. The song is medium tempo with just a piano playing pensively and no other instrumentation. The song is emotional and poignant. The song is a western classical masterpiece, but with bad audio quality issues. | 2011-01-22T16:54:57Z | ken | Swan Lake by Tchaikovsky. Sheet music available here: https://sowl.co/bgZ9cg | ["Music", "Sad music"] | ["western classical music", "poor audio quality", "poor audio quality", "western classical masterpieces", "piano playing", "love song", "forever classics", "poignant", "melancholic", "winter", "classic composers", "conductor", "piano solo", "emotional", "medium tempo", "dynamics", "instrumental music", "in love", "dance like", "lullaby"] | 1 | 1WlvXneu6oY | 284 | |
This Is the Christ ♬♪ ~ Mormon Tabernacle Choir : Book of Mormon MUSIC | A choral harmony consisting of four parts sings this ethereal harmony. The song is medium tempo with a church organ and orchestra accompaniment. The song is heavenly and innocent. The audio quality is poor. | 2011-04-02T09:51:41Z | Book of Mormon Answers | http://mormon.org/book-of-mormon/ Jesus Christ visited and taught the ancient american people Nephites and Lamanites shortly after His resurrection. He taught them the Sermon on the Mount, and they all witnessed to His divinity and Godhood. This video is copyright by IRI of the Church of Jesus Christ of Latter Day Saints, who grants permission for use by members on a non commercial social media platform or website. I relate these stories/videos to my own personal beliefs and testimony of the same. The Church of Jesus Christ of Latter Day Saints is true. | ["Music", "Choir"] | ["choral harmony", "four part harmony", "church choir", "vocal harmony", "western classical music", "medium tempo", "love song", "heartfelt", "gospel music", "cathedral", "meditational", "devotional", "prayer", "composer", "conductor", "choir", "hymns", "praise and worship", "church service", "poor audio quality", "heavenly", "ethereal voices", "christian choir"] | 1 | 2kORDnISun4 | 402 | |
Fifty Shades Of Grey (2013) | Teaser Trailer | A female singer sings this operatic melody. The song is medium tempo with a string section playing harmony and a piano accompaniment. The song is emotional and passionate. The song is a classic western music hit and a movie soundtrack. | 2012-06-13T15:16:41Z | JLongbone | **WATCH IN HD** (NEW!! Jamie Dornan/Dakota Johnson version: https://www.youtube.com/watch?v=ddPxOJZKQmQ) **Fan made teaser** Song from trailer: http://www.youtube.com/watch?v=YBt-9LhE8ms | ["Music", "Opera"] | ["female opera singer", "medium tempo", "lilting vocals", "madly in love", "together forever", "movie soundtrack", "soaring vocals", "string section harmony", "violins", "piano accompaniment", "cello playing", "conductor", "emotional", "tragic", "passionate", "romantic", "love song", "sensual"] | 1 | TnJE6W6Z6mM | 2865 |
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;