musiccaps_details (view)
1 row where musiccaps_aspects contains "mellow", musiccaps_aspects contains "mysterious" and musiccaps_aspects contains "sinister"
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
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;