musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy accordion melody", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "soft crash cymbal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;