musiccaps_details (view)
2 rows where musiccaps_aspects contains "pensive", musiccaps_aspects contains "slow tempo", musiccaps_names contains "Music" and musiccaps_names contains "Tender music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Beautiful China and traditional music | This music is a calm Chinese instrumental melody. The tempo is slow with use of traditional chinese string instruments like the Guzheng and Pipa harmony accompanied with violin symphony and chimes. The music is soft, mellow, melancholic, meditative, dreamy, healing and ethereal. | 2008-02-26T22:59:29Z | baby john | Have a look at our back yard! | ["Music", "Tender music"] | ["instrumental", "slow tempo", "chimes", "melancholic", "string instruments", "pipa accompaniment", "viloin harmony", "calming", "soothing", "meditative", "healing", "pensive", "chinese instruments", "chinese instrumental", "guzheng harmony"] | 7 | KxVbdGPAfjE | 2133 |
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;