musiccaps_details (view)

1 row where musiccaps_aspects contains "environmental noises", musiccaps_names contains "Chant" and musiccaps_names contains "Music"

✎ View and edit SQL

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
Pirates of The Caribbean Medley - A Capella - Peter Hollens & Gardiner Sisters (DevinSuperTramp) A cappella choir is singing a melody with a deep male bass voice. Midrange female and male singers and high female voices. Then two female voices start singing two different arpeggio-melodies. The voices are spread across the left and right speaker. You can hear the sound of water. This song may be playing in a live presentation. 2013-10-30T02:43:10Z Gardiner Sisters Listen to our Pirate Medley with Peter Hollens on Spotify: https://open.spotify.com/album/2AJ8rs6rsu3EJqJW68pDe0 Loudr: http://bit.ly/17tEuIP iTunes: http://bit.ly/194zPNJ “Nearer to Thee” EP on iTunes: http://bit.ly/iTunesNearerEP Spotify: http://spoti.fi/1p2EvQf Loudr: http://bit.ly/NearerEP Amazon: http://bit.ly/NearerEP patreon | http://www.patreon.com/gardinersisters website | http://gardinersisters.com/ merch | http://bit.ly/GSLyricTees facebook | http://on.fb.me/19Ly1Ge instagram | http://instagram.com/gardinersisterso... twitter | https://twitter.com/gardinersisters @mandigardiner @alliegardiner @haileygardiner second channel | http://www.youtube.com/user/GardinerS... business & booking | info@gardinersisters.com subscribe | http://www.youtube.com/user/gardiners... All of the sounds in this video were made with the human voice! That's right, kids. All thanks to the INCREDIBLE Peter Hollens! Subscribe for more A Capella Awesomeness! http://www.youtube.com/user/peterholl... Thanks to Devin Graham, AKA Devinsupertramp for directing, filming, editing, and making our Pirate dreams come true with this video! Check out his channel here: http://www.youtube.com/devinsupertramp Thanks to Christian Busath for putting up with his creepy fake beard and making us laugh =) Check out his comedic videos here: http://www.youtube.com/hardcandyhumor Watch the behind the scenes in the link below: http://youtu.be/rfddgVhFv9U Behind The Scenes by Parker Walbeck! Find him at... http://www.youtube.com/parkerwalbeck Allison Dredge made all of our beautiful pirate costumes in the video (except for the Jack Sparrow costume). Facebook: https://www.facebook.com/allisondredg... Christian's Costume (Jack Sparrow) was made by the amazing Shannon Cheek! Check her stuff out as well in the links below. http://www.facebook.com/ShansAttic http://www.etsy.com/shop/ShansAttic Makeup by Ben Brooksby Thanks to Jacob Graham, Creighton Baird, and Seth Jones for helping as well! Vocals recorded with Dan Reyes Cairo. Dan is the man!… ["Chant", "Music", "A capella"] ["acapella", "male and female singers", "environmental noises", "adventurous"] 6 3XeMR8lX0dg 478

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;