musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "pensive", musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "soft"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tokyo Ghoul - Soundtrack [OST] Battle Theme (Symphony) | This song is an operatic harmony. The tempo is slow with a soft piano accompaniment and choral vocal harmony. The song is soft, melodic, enigmatic, ethereal, mystical, magical, dreamy and enchanting. This music is a Choral Symphony. | 2014-08-27T04:06:05Z | DarkVul | ["New-age music", "Music"] | ["instrumental", "slow tempo", "choral symphony", "soft piano", "vocalisation", "magical", "enchanting", "dreamy", "magicalvocalisation", "vocal harmony", "classical music", "western classical", "ethereal", "enigmatic", "celestial", "angelic", "heavenly", "mystical", "mellow", "soft", "soothing", "harmony", "soundtrack", "ost", "melancholic", "emotional", "sentimental", "pensive", "wistful"] | 7 | 63jbksEqycQ | 720 | ||
ne-yo why does she stay | A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. | 2008-09-25T21:35:05Z | X-tazi | ne-yo why does she stay from the new album-Year Of The Gentleman | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] | 7 | C-1i2GlbiIY | 1313 | |
Beaux Arts Trio plays Dvorak "Dumky" Trio, ii | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | 2008-05-09T02:43:46Z | Scott Meek | Live from Herbst Theatre, San Francisco April 20, 2008 Menahem Pressler, piano Daniel Hope, violin Antonio Meneses, cello | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | 7 | EkmHGd0U8yE | 1585 | |
Walking On Cars - Tick Tock (acoustic) 4.2.16 | A male vocalist sings this soft pop. The tempo is slow with a simple piano accompaniment, mellow acoustic guitar and rhythmic Cajun beats. The song is a simple, unaffected, romantic, melodic, sentimental, emotional and pensive Pop. | 2016-02-05T11:40:49Z | Kerri Loughney | Walking On Cars performing an acoustic version of Tick Tock from their new album Everything This Way. Performed in Banquet Records, Kingston for the album release on the 4th of February 2016. Enjoy! Check out my other videos from the Walking On Cars acoustic in-store show at Banquet Records: Always Be With You - https://www.youtube.com/watch?v=FG-wYSnmEwo Hand In Hand - https://www.youtube.com/watch?v=oaEMyV_dOXw Flying High Falling Low - https://www.youtube.com/watch?v=6M6AcVAQJMI Catch Me If You Can - https://www.youtube.com/watch?v=6nhEE5NpglQ Speeding Cars - https://www.youtube.com/watch?v=1YDNRlYRahs Plus check out Banquet's videos from the night! In-store - https://www.youtube.com/watch?v=aid6nk5I5Bw New Slang - https://www.youtube.com/watch?v=e-WkwnHWUJE | ["Music", "Tick"] | ["male vocalist", "slow tempo", "acoustic", "minimalist", "busking", "buskers", "simple", "earnest", "emotional", "sentimental", "keyboard accompaniment", "mellow acoustic guitar", "cajun percussion", "soft", "melancholic", "romantic", "pensive", "unplugged", "amateur recording"] | 7 | UDN11Q90Fa4 | 2895 |
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;