musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- groovy bass · 5 ✖
- passionate male vocal · 5 ✖
- pop · 5 ✖
- low quality 4
- clapping 2
- emotional 2
- energetic 2
- happy 2
- passionate 2
- addictive 1
- addictive synth melody 1
- brass melody 1
- claps 1
- exciting 1
- fun 1
- groovy accordion melody 1
- harmonizing background vocals 1
- harmonizing vocals 1
- joyful 1
- people cheering sounds 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- snare roll 1
- soft crash cymbal 1
- soft kick hits 1
- straight piano melody 1
- sweep riser 1
- synth pad 1
- tinny hi hats 1
- upbeat 1
- wide chicken clucking sound effect 1
- wide claps 1
- wide electric guitar melody 1
- wide harmonizing background vocals 1
- wide shimmering tambourine 1
musiccaps_names (array) 7 ✖
- Music 4
- Disco 1
- Happy music 1
- Music of Asia 1
- Singing 1
- Soul music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
365 Days- Leon Thomas III Ft. Victoria Justice W/Lyrics | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing background vocals, singing over people cheering sounds, shimmering hi hats, claps, snare rolls, groovy bass and wide electric guitar melody. It sounds energetic and exciting. | 2011-10-09T01:46:15Z | stephylove33 | Just in time for October!! Think Pink For Breast Cancer =) XOXO | ["Music of Asia"] | ["low quality", "pop", "harmonizing background vocals", "people cheering sounds", "claps", "shimmering hi hats", "snare roll", "passionate male vocal", "groovy bass", "wide electric guitar melody", "energetic", "exciting"] | 4 | JXS5eW7g4HY | 2016 | |
Pharrell Williams - Happy (WE ARE FROM HONG KONG) Dance edition | The Pop song features a passionate male vocal, alongside wide harmonizing background vocals, singing over clapping, shimmering cymbals, groovy bass and soft kick hits. It sounds addictive, happy and joyful. | 2014-01-28T21:37:50Z | di2dadance | 今次誠邀多位跳舞前輩及好友拍攝HAPPY 希望鼓勵新一代的舞蹈員 以開心和享樂的態度跳舞 堅持不放棄! 由於我的時間有限,未能邀請所有的朋友參與拍攝, 非常感謝幫忙拍攝的 ﹣Allen To ﹣Kinko Koo ﹣Lok Man ﹣Leung ﹣Sunny Wong ﹣Vivian ﹣Bo Sir ﹣小燕 ﹣Bowie ﹣Popping Douglee ﹣Kato ﹣榮 ﹣Maska ﹣Timothy ﹣Louis ﹣Popper 88 ﹣Virago Carmen ﹣Wh Chung ﹣Popping Lok ﹣Chu Tin ﹣Shing ﹣Danie ﹣佳 三月我會繼續拍攝繼續享受跳舞的樂趣 PLS SUPPORT~~ | ["Music", "Soul music"] | ["pop", "passionate male vocal", "wide harmonizing background vocals", "clapping", "shimmering cymbals", "groovy bass", "soft kick hits", "addictive", "happy", "joyful"] | 4 | L2-EGNKzUAQ | 2146 | |
บาสโลบจังหวะดิสโก้ | The low quality recording features a pop song that consists of a passionate male vocal singing over punchy kick and snare hits, shimmering shakers, synth pad, groovy bass and brass melody. It sounds passionate, emotional, energetic and upbeat. | 2012-10-08T01:26:28Z | Tanwarat mu | เพลงนี้ใช่ท่าจังหวะบาสโลบที่ 3 ใช้เพลงจังหวะดิสโก้เป็นจังหวะที่สนุก ฝึกความจำและสมาธิในการเต้น | ["Disco", "Music"] | ["low quality", "pop", "punchy kick", "punchy snare", "groovy bass", "synth pad", "shimmering shakers", "passionate male vocal", "brass melody", "passionate", "emotional", "energetic", "upbeat"] | 4 | _x4a974Pl-A | 3500 | |
Charlie Puth - Marvin Gaye ft. Meghan Trainor | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing vocals, singing over wide claps, layered with shimmering tambourine, groovy bass and straight piano melody. It sounds emotional and passionate. | 2015-06-28T19:27:02Z | TheBlinkStudios | This video is dedicated to Mr. Charlie Puth... and Meghan Trainor. See you guys July 12th! | ["Singing", "Music", "Happy music"] | ["low quality", "pop", "straight piano melody", "harmonizing vocals", "passionate male vocal", "groovy bass", "wide claps", "wide shimmering tambourine", "passionate", "emotional"] | 4 | hrCf8rMBtA8 | 4146 | |
Takeo Ischi - New Bibi Hendl (Chicken Yodeling) 2011 | The low quality recording features a pop song that consists of passionate male vocal singing over punchy "4 on the floor" kick pattern, groovy accordion melody, wide tinny hi hats, claps and groovy bass. In the second half of the loop, the instrumental consists of claps, "4 on the floor" kick pattern without the bass, soft crash cymbal, addictive synth melody and wide chicken clucking sound effect. There is a sweep riser at the very end of the loop. It sounds fun and happy, like something kids would listen to. | 2011-07-09T07:21:30Z | fritz5190 | Takeo Ischi - New Bibi Hendl (Chicken Yodeling) 2011 .. Yodelmeister Mister Takeo Ischi Wiar i bin auf d'Alm aufi ganga hab mer wolln mei Bibi-Henderl fange. Gel mei Bibi-Hendl, gel bi-bi gel mei Bibi-Hendl, jetzt duckst Di! (Jodeln) Wiar i bin im Wald aussi kemma ham's ma wolln mei Bibi-Henderl nehma. Gel mei Bibi-Hendl, gel bi-bi gel mei Bibi-Hendl, jetzt duckst Di! (Jodeln) Jojo, do the Bibi-Hendl Jojo, with the Yodelmeister s'Henderl is am Herd aufi g'sprunga, hat si seine Pratzele verbrunna. Gel mei Bibi-Hendl, gel bi-bi gel mei Bibi-Hendl, jetzt duckst Di! (Jodeln) Again Ladies and gentlemen, mein Damen und Herrn presenting to you aus Reit im Winkl, southern Bavaria the Yodelmeister yodeling the Bibi-Hendl Muass i g'schwind in d'Stadt eini lafa und a neues Bibi-Henderl kafa. Gel mei Bibi-Hendl, gel bi-bi gel mei Bibi-Hendl, jetzt duckst Di! (Jodeln) And now we're gonna take you to the top with some extreme yodeling with Takeo Ishii Literal translating: When I went up to the alp I wanted to catch a chicken Yes, my chicken Bibi, Bibi yes yes my Bibi chicken, now you duck (Yodeling) When I got out of the woods they wanted to take my chicken Bibi away Yes, my chicken Bibi, Bibi yes yes my Bibi chicken, now you duck (Yodeling) The chicken has jumped on the stove (cooker) it has burned its claws Yes, my chicken Bibi, Bibi yes yes my Bibi chicken, now you duck (Yodeling) Again Ladies and gentlemen presenting to you from Reit im Winkl, southern Bavaria the Yodelmaster yodeling the Bibi-Chicken Now I have to run quickly to the city and buy me a new Bibi chicken Yes, my chicken Bibi, Bibi yes yes my Bibi chicken, now you duck (Yodeling) And now we're gonna take you to the top with some extreme yodeling with Takeo Ishii | ["Yodeling", "Music"] | ["fun", "happy", "tinny hi hats", "punchy \"4 on the floor\" kick pattern", "clapping", "groovy accordion melody", "addictive synth melody", "sweep riser", "soft crash cymbal", "groovy bass", "wide chicken clucking sound effect", "passionate male vocal", "pop", "low quality"] | 4 | yO7MWuJ7zLA | 5403 |
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;