musiccaps_details (view)
2 rows where musiccaps_aspects contains "devotional", musiccaps_aspects contains "heartfelt" and musiccaps_aspects contains "meditational"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- devotional · 2 ✖
- heartfelt · 2 ✖
- meditational · 2 ✖
- vocal harmony 2
- carnatic music 1
- cathedral 1
- choir 1
- choral harmony 1
- christian choir 1
- church choir 1
- church service 1
- classical singing style 1
- composer 1
- conductor 1
- emotional 1
- ethereal voices 1
- female singers 1
- flute countermelody 1
- four part harmony 1
- gospel music 1
- guitar accompaniment 1
- heavenly 1
- hymns 1
- love song 1
- medium tempo 1
- passionate 1
- poor audio quality 1
- praise and worship 1
- prayer 1
- prayers 1
- steady techno drumming rhythm 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- tamil devotional songs 1
- vocal duo 1
- western classical music 1
musiccaps_names (array) 5 ✖
- Music 2
- Carnatic music 1
- Choir 1
- Classical music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Parvai ondre pothume - Carnatic Fusion Tamil Kannan Song by S. J. Jananiy | Female singers sing this vocal in Tamil harmony. The song is medium tempo with a strong techno drumming rhythm, guitar accompaniment, stringed instrument accompaniment, flute countermelody, and a strong bass line. The song is devotional and highly passionate. The song is a Carnatic Hindu devotional song sung in Tamil. | 2010-02-08T22:06:22Z | Saumi Music | Sharing another beautiful carnatic fusion sung by S.J. Jananiy. Follow us on Facebook: https://www.facebook.com/pages/Gnanalayam-Berlin/246868511997333 | ["Carnatic music", "Music of Asia", "Music", "Classical music"] | ["carnatic music", "female singers", "vocal harmony", "guitar accompaniment", "stringed instrument harmony", "emotional", "passionate", "meditational", "devotional", "heartfelt", "classical singing style", "vocal duo", "tamil devotional songs", "prayers", "flute countermelody", "guitar accompaniment", "stringed instrument countermelody", "strong bass line", "steady techno drumming rhythm"] | 1 | ROA6DMBPlNM | 2695 |
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;