musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic piano" and musiccaps_aspects contains "slower tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic piano · 3 ✖
- slower tempo · 3 ✖
- acoustic drums 1
- amateur recording 1
- background music 1
- church music/liturgical 1
- e-bass 1
- female voice singing 1
- male voice choir 1
- male voices talking 1
- organ 1
- pop-ballad 1
- rockballad 1
- romantic 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cody Jinks performs "Cast No Stones" on The Texas Music Scene | A deeper male voice is talking for a moment before changing to another male voice talking about something. In the background you can hear a professional recording containing an e-bass playing single long notes along with an organ and an acoustic piano playing chords in the midrange. An acoustic drum is holding a simple beat in the background. This song may be playing in a gospel church band. | 2015-02-17T18:12:12Z | The Texas Music Scene TV | Cody Jinks live from the Crown Royal Texas Stage with a performance of "Cast No Stones" from his 'Adobe Sessions' CD Connect to The Texas Music Scene: web: http://www.TexasMusicScene.com facebook: http://www.facebook.com/TXmusicTV twitter: https://twitter.com/TXmusicTV youtube: http://www.youtube.com/TXmusicTV "The Texas Music Scene" is a TV series that currently airs throughout Texas. HELP US SPREAD TEXAS MUSIC ACROSS THE NATION! Contact your local broadcast stations and cable providers, and DEMAND THE TEXAS MUSIC SCENE! | ["Music", "Speech", "Tender music"] | ["rockballad", "male voices talking", "background music", "acoustic drums", "e-bass", "acoustic piano", "organ", "slower tempo"] | 6 | 1Is1xfDjZrw | 256 | |
Maybe It's You | Someone is playing a minor chord composition on an acoustic piano while a female voice is singing with a lot of reverb on her voice. This song may be playing on a karaoke night. | 2006-05-09T03:19:08Z | neo0802 | Music Video | ["Music", "Lullaby"] | ["pop-ballad", "acoustic piano", "female voice singing", "romantic", "slower tempo"] | 6 | 9UD7qz7DuVY | 1013 | |
"NESSUN DORMA" - Welsh Male Voice Choir | This audio contains a male church choir singing from the low register up into the mid-higher register. An acoustic piano is providing single notes walking up the keybed. This song may be playing in a church sung by a male choir. | 2010-06-08T21:40:54Z | Cantorion Colin Jones | Cantorion's brand new CD is on iTunes. Please click on the link http://itunes.apple.com/gb/album/nessun-dorma/id488729653 Cantorion Colin Jones are a male voice choir from North Wales. FOR MORE DETAILS AND INFORMATION REGARDING THIS MALE VOICE CHOIR, CLICK ON OUR NEW CHOIR WEBSITE : http://www.cantorioncolinjones.co.uk or http://www.cantorioncolinjones.co.uk/guestbook Nessun dorma WITH LYRICS (None shall sleep) is an aria from the final act of Giacomo Puccini's opera Turandot, and is one of the best-known tenor arias in all opera. It is sung by Calaf, il principe ignoto (the unknown prince), who falls in love at first sight with the beautiful but cold Princess Turandot. However, any man who wishes to wed Turandot must first answer her three riddles; if he fails, he will be beheaded. The video is an excerpt from a concert in Welshpool, UK. The choir is the renowned North Wales Male Chorus, "Cantorion Colin Jones" under the musical direction of John A Daniel. www.cantorioncolinjones.co.uk | ["Singing", "Music", "Opera", "Choir"] | ["amateur recording", "acoustic piano", "male voice choir", "church music/liturgical", "slower tempo"] | 6 | k8AE-vqWbm4 | 4300 |
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;