musiccaps_details (view)
1 row where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "male vocals" and musiccaps_names contains "Music of Asia"
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] HISTORY(히스토리) _ Tell Me Love(열대야) | This is a K-pop music piece performed by a boy band. Initially, a male vocalist is singing in a rap-like manner. Then, it switches to another male vocal that is singing more melodically. The melody is being played by a crisp synth sound. The rhythmic background consists of an energetic electronic drum beat. There is a danceable feel to it. This piece could be playing at Korean nightclubs and dance clubs. | 2013-08-20T03:00:02Z | 1theK (원더케이) | [MV] HISTORY(히스토리) _ Tell Me Love(열대야) *English subtitles are now available. :D (Please click on 'CC' button or activate 'Interactive Transcript' function) :: iTunes DL : https://itunes.apple.com/us/album/just-now-ep/id690338532 The best rookie of 2013, 'HISTORY' comes back with a new story. Debuting in last April, HISTORY has attracted K-Pop industry and music fans' attraction with the debut song 'Dreamer'. Their unique music style and visual have made the boy band the best rookie of the year. The title song 'Tell Me Love' was co-composed by e.one the composing team where V.O.S Choi Hyunjoon belongs to and composer Lim Kwangwook who had worked with SHINee, EXO, and Dalshabet. Hip-hop group Eluphant's Kebee and the producing team HAAS wrote the lyrics. ▶ LOENMUSIC FB : http://www.facebook.com/LOENMUSIC.official ▶ LOENMUSIC TW : https://twitter.com/LOEN_MUSIC 2013年最も期待されている'HISTORY'が新しい物語で戻って来る。 今年4月デビュー!業界の関係者たちや音楽ファンたちの注目を一気に集中させながら登場したHISTORYは、デビュー曲の'Dreamer'を通じて差別化された音楽や格好いいビジュアルで関心を引いた。 リード曲の'Tell Me Love'はV.O.Sのチェ・ヒョンジュンが所属されている作曲チャームe.oneとSHINEE、EXO、Dalshabetのアルバムへ 参加し、注目されている作曲家のイム・カンウンクが共同作曲した曲であるし、ヒップホップグルップのEluphantのKebee、プロデュースチームのHAASが 作詞に参加した。 2013년 최고의 기대주 '히스토리'가 새로운 이야기를 들고 찾아온다. 지난 4월 데뷔! 가요계 관계자들과 음악팬들의 이목을 단번에 집중시키며 등장한 히스토리는 데뷔곡 'Dreamer'를 통해 차별화된 음악과 뛰어난 비쥬얼을 선보이며 2013년 최고의 기대주로 주목을 받고 있다. 타이틀곡 '열대야 (Tell Me Love)''는 V.O.S 최현준이 소속되어 있는 작곡팀 e.one과 샤이니, 엑소, 달샤벳의 앨범에 참여하며 주목을 받고 있는 작곡가 임광욱이 공동 작곡한 곡으로, 힙합그룹 이루펀트의 키비, 프로듀싱팀 HAAS가 작사로 참여했다. | ["Music of Asia", "Music"] | ["k-pop", "boy band", "male vocals", "rap-like singing", "melodic singing", "synth bass", "electronic drums", "energetic", "hip", "urban", "danceable"] | 9 | zeUEOxTd8IE | 5501 |
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;