musiccaps_details (view)
1 row where musiccaps_aspects contains "female vocals", musiccaps_aspects contains "male singer", musiccaps_aspects contains "mellow" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
[MV] 이수민, 신동우 '달리기' 뮤직비디오 ('Cheer up' Music Video) | A male vocalist sings this soft melody. The tempo is slow with soft , ambient piano /keyboard accompaniment. The song is mellow,melodic, romantic, soothing, emotional, idyllic, charming and dreamy. There is a female vocal at the onset of this clip indicating that this could be a duet. | 2016-06-08T00:07:17Z | 현대자동차그룹(HYUNDAI) | 현대자동차그룹 '현이와 대니의 뉴스룸' 의 MC 이수민, 신동우 출연! 윤상의 '달리기'를 10대의 감성으로 부른 새로운 뮤직비디오 공개! MC Lee Soo-Min, Shin Dong-Woo are on Hyundai Motor Group 'Newsroom of Hyuni and Dani'! Yoon Sang 'Cheer Up', reinterpreted in teen unique style is open! [KOR] 지겨운가요 힘든가요 숨이 턱까지 찼나요 할 수 없죠 어차피 시작해 버린 것을 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 이유도 없이 가끔은 눈물나게 억울하겠죠 일등아닌 보통들에겐 박수조차 남의 일인걸 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 It′s good enough for me bye bye bye bye "꿈을 향한 여러분의 달리기를 응원합니다." [ENG] Are you bored? Or are you tired? Otherwise are you out of breath now? Even if it is, there's no way around,cause you've already started. Even though your mouth is dried up in the middle of pouring sunshine, you can't just suddenly stop cause it will be embarrassing. The one and only promise is that you will definitely achieve something. After everything is over,you can take a rest as much as you want. Even though your mouth is dried up in the middle of pouring sunshine, you can't suddenly just stop cause it will be embarrassing. Sometimes without any reason you'll feel something is unfair, and burst into tears. For ordinary people, who are not at the top,it is not easy to get a big hand. The one and only promise is that you will definitely achieve something. After everything is over, you can take a rest as much as you want. It′s good enough for me bye bye bye bye "We support your race towards your own dream" | ["Music", "Tender music"] | ["male singer", "slow tempo", "love song", "korean song", "duet", "female vocals", "foreign language", "foreign music", "world music", "soft pop", "keyboard harmony", "ambient", "korean love song", "k-pop", "mellow", "emotional", "gentle", "melodic", "piano accompaniment", "minimal instruments", "emotional", "pleasant", "young love", "romantic piano"] | 7 | 7LGLhQFiE0s | 833 |
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;