musiccaps_details (view)
4 rows where musiccaps_aspects contains "love song", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- emotional 4
- love song · 4 ✖
- male singer · 4 ✖
- piano accompaniment · 4 ✖
- keyboard accompaniment 2
- acoustic pop 1
- ambient 1
- asian soap opera 1
- backup singers 1
- breakup song 1
- clapping rhythm 1
- courtship song 1
- dance song 1
- desperate for you 1
- duet 1
- female vocals 1
- foreign language 1
- foreign music 1
- gentle 1
- groovy bass line 1
- groovy rhythm 1
- hip hop hits 1
- hip hop music 1
- hip hops love song 1
- hissing tones 1
- k-pop 1
- keyboard harmony 1
- korean love song 1
- korean song 1
- live audience 1
- live performance 1
- loneliness 1
- madly in love 1
- mameluke in love 1
- medium tempo 1
- mellow 1
- melodic 1
- minimal instruments 1
- modern love 1
- modern pop hits 1
- movie soundtrack 1
- music covers 1
- music video 1
- original song 1
- passionate 1
- percussion hits 1
- pleasant 1
- poor audio quality 1
- romantic 1
- romantic piano 1
- romantic song 1
- sentimental 1
- shakers percussions 1
- slick drumming rhythm 1
- slow tempo 1
- soft pop 1
- soloist 1
- steady drumming line 1
- strong bass line 1
- subtle drumming 1
- super hits 1
- together forever 1
- tv show theme 1
- world music 1
- young love 1
- youtube music artist 1
- youtube music videos 1
musiccaps_names (array) 8 ✖
- Music 3
- Electric piano 1
- Keyboard (musical) 1
- Music of Asia 1
- Piano 1
- Song 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stevie Hoang - Addicted - new music video 2009 | A male singer sings this cool hip hop love song with backup singers in vocal harmony. The tempo is medium with keyboard accompaniment, piano accompaniment, steady drumming rhythm, clapping percussion and other sonic effects. The song is emotional and romantic with a cool dance groove, | 2009-05-18T16:36:44Z | steviehoang | Buy the Physicial CD http://www.cdbaby.com/cd/steviehoang3 Official Facebook https://www.facebook.com/StevieHoangMusic Twitter https://twitter.com/steviehoang | ["Music", "Soul music"] | ["male singer", "hip hop music", "backup singers", "live performance", "live audience", "super hits", "piano accompaniment", "groovy bass line", "steady drumming line", "slick drumming rhythm", "emotional", "romantic", "passionate", "together forever", "love song", "hip hop hits", "groovy rhythm", "dance song", "hip hops love song", "clapping rhythm"] | 1 | -oP-XX28B0s | 87 | |
Three Days Grace/ Breaking Benjamin/ Paramore - Mashup Cover by Kevin Staudt | A male singer sings this emotional melody. The song is medium tempo with a piano accompaniment and a strong bass drum kick . The song is emotional and romantic. The song is a home music video . | 2014-06-28T20:20:04Z | Kevin Staudt | Hey everyone, since I haven't uploaded much new stuff lately I wanted to put a few requests (Three Days Grace - Take Me Under / Breaking Benjamin - Dance With The Devil / Paramore - Decode) together in one cover. http//www.facebook.com/kevinstaudtmusic | ["Electric piano", "Keyboard (musical)", "Piano"] | ["male singer", "piano accompaniment", "soloist", "modern love", "loneliness", "breakup song", "mameluke in love", "music covers", "youtube music videos", "youtube music artist", "modern pop hits", "courtship song", "desperate for you", "madly in love", "original song", "acoustic pop", "emotional", "love song", "sentimental", "strong bass line", "keyboard accompaniment"] | 1 | 1OIfQHKnAcw | 265 | |
[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 | |
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 |
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;