musiccaps_details (view)

1 row where musiccaps_aspects contains "chanting", musiccaps_aspects contains "grave" and musiccaps_aspects contains "sinister"

✎ 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
Misty Mountains from "The Hobbit" A Cappella - Street Corner Symphony This song is a choral harmony. The tempo is slow with intense bass and an instrument that sounds like a viola. The song is grim, grave, intense, sinister; eerie; spooky; scary, chant-like, and dreary. 2013-01-05T10:52:17Z Street Corner Symphony iTunes: http://bit.ly/Dwarves Amazon MP3: http://bit.ly/DwarvesA Google Play: http://bit.ly/DwarvesGP https://www.streetcornersymphony.com Facebook: https://www.facebook.com/StreetCornerSymphony Twitter: @StreetCornerSym Instagram: @streetcornersym Sung by Project Pigeon (1/3 of Street Corner Symphony), featuring Adam Chance (1/6 of Street Corner Symphony). They tell us that adds up to half of SCS, but math is hard. This is an expanded version of the beautiful dwarf ballad from the 2012 film "The Hobbit: An Unexpected Journey," arranged by John Martin, using the parts of Tolkien's poem describing Smaug's arrival at Erebor. We hope you love it! Please share with the world, leave a comment, and let us know what else you'd like to hear from us. We made this video in about a week, each of us videoing himself in his own home (Tuscaloosa, AL; Montgomery, AL; Nashville, TN). Mixed by John Martin Video Edited by Mark McLemore Sung by John Martin: Lead and Lots of Other Parts Adam Chance: Bass, Baritone and Burger Mark McLemore: Everything Else Follow Project Pigeon on Twitter! @ProjectPigeon1 The three of us are part of Street Corner Symphony. @StreetCornerSym http://streetcornersymphony.com ["Chant", "Music"] ["choral harmony", "slow tempo", "viola harmony", "sinister", "mysterious", "grim", "grave", "intense", "spooky", "acapella", "chanting", "threatening", "low pitch", "low notes", "intense", "grave", "sound of viola", "minimal instrumentation", "intense bass lines", "mellow", "intense", "dark"] 7 aY8-pXDdwiw 3552

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;