musiccaps_details (view)
4 rows where musiccaps_aspects contains "female vocals", musiccaps_aspects contains "keyboard harmony" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- female vocals · 4 ✖
- keyboard harmony · 4 ✖
- foreign language 2
- melodic 2
- slow tempo 2
- world music 2
- amateur recording 1
- ambient 1
- ambient sounds 1
- animated 1
- bells chining 1
- bright drumming 1
- cheerful 1
- devotional song 1
- duet 1
- emotional 1
- emphatic singing 1
- energetic 1
- enthusiastic 1
- enthusiastic vocals 1
- fast tempo 1
- folk song 1
- foreign music 1
- fun 1
- gentle 1
- groovy bass lines 1
- groovy dance music 1
- happy 1
- high notes 1
- high pitch 1
- hindi movie song 1
- hindi song 1
- hindu devotion music 1
- hip-hop 1
- indian classical 1
- indian devotion music 1
- indian music 1
- inferior audio quality 1
- k-pop 1
- keyboard 1
- korean love song 1
- korean song 1
- latin dance music 1
- latin hip-hop 1
- latin song 1
- latin urba 1
- latin urbano 1
- live performance 1
- lively 1
- love song 1
- male singer 1
- march like drumming 1
- mellow 1
- minimal instruments 1
- people cheering 1
- peppy 1
- perky 1
- piano accompaniment 1
- pleasant 1
- rap 1
- rapper 1
- regional song 1
- rhythmic patter 1
- romantic piano 1
- shakers 1
- soft pop 1
- song introduction 1
- spanish 1
- spirited 1
- steady bass lines 1
- tambourine 1
- tanpura 1
- upbeat 1
- vibrant 1
- violin harmony 1
- vivacious 1
- young love 1
- youthful 1
musiccaps_names (array) 6 ✖
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 | |
Nekrikh Sigh - Apla san oneiro | A female vocalist sings this spirited Latin Rap. The tempo is medium fast with keyboard harmony , infectious drumming, groovy basslines and digital beats. The song is upbeat, youthful, catchy, energetic, emphatic, melodic and vivacious with a dance groove. This song is a Latin Urbano. | 2009-08-15T07:55:39Z | Katadikasmenosz | ["Music", "Rhythm and blues"] | ["latin song", "female vocals", "hip-hop", "rap", "melodic", "vivacious", "world music", "rapper", "latin urbano", "lively", "spirited", "animated", "groovy dance music", "latin dance music", "latin hip-hop", "youthful", "vibrant", "keyboard harmony", "bright drumming", "groovy bass lines", "rhythmic patter", "latin urba"] | 7 | 8rCYRgePG-4 | 956 | ||
nitin chakrdhari katra ( jk ) satyam shivam | A female vocalist sings this Hindi Devotion song. The tempo is slow with keyboard harmony,tambourine beats, violin melody and rhythmic tanpura accompaniment. This clip is the song introduction with slow chants like singing. The song is a Hindu Devotion song to the God Shiva. It is emotional, sentimental, devotional, prayerful praise and worship. There are ambient sounds of people talking and cheering, indicating that this is a live performance. | 2012-03-20T04:43:45Z | NCRC STUDIO | nitin chakrdhari enterainmant perfomer | ["Music of Asia", "Music", "Synthetic singing"] | ["female vocals", "slow tempo", "high pitch", "high notes", "tambourine", "indian classical", "indian devotion music", "hindu devotion music", "indian music", "keyboard harmony", "hindi song", "hindi movie song", "devotional song", "song introduction", "amateur recording", "inferior audio quality", "live performance", "people cheering", "violin harmony", "keyboard", "shakers", "tanpura", "ambient sounds"] | 7 | HdRPdh-cSTw | 1821 | |
My Guinea-pigs ate the Christmas Tree... | A female vocalist sings this cheerful song. The tempo is fast with a peppy keyboard harmony, simple, march like drumming, steady bass line, acoustic guitar and bells chiming. The song is a foreign language but from the sound and vibe of it, it seems like a fun, happy, joyful, cheerful, warm hearted and popular folk song. | 2006-12-20T16:35:29Z | Havshexan | This may happen if you let the guinea pigs loose on a Christmas tree... Next day there was nothing left but some small peices of wood. The tree in the video is a Scandinavian spruce (picea abies) and it's not poisonous. There are other species of evergreens that are poisonous, like for exemple silver spruce. Don't give any branches to your guinea-pigs, if you aren't sure what they are! Even the spruce in the video contains etheric oils which could be harmful in large quantities. Some of the oils evaporate if you keep the brances a few day's before giving them to the piggies. Sadly, all the cute cavies in the video but one have gone to guinea pig heaven. Now there's only Olga left and she just turned 7 years (beginning of December 2011). Fortunatly she now has 3 new compagnions. | ["Music", "Happy music"] | ["female vocals", "fast tempo", "foreign language", "folk song", "regional song", "enthusiastic vocals", "energetic", "emphatic singing", "peppy", "spanish", "keyboard harmony", "bells chining", "steady bass lines", "enthusiastic", "fun", "happy", "cheerful", "upbeat", "enthusiastic", "perky", "march like drumming"] | 7 | ar4YQ_DOcyk | 3578 |
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;