musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy" and musiccaps_aspects contains "unique"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- catchy · 2 ✖
- unique · 2 ✖
- bells 1
- boomy drumming 1
- button accordion 1
- child’s toy 1
- chimes 1
- crossover musical style 1
- electronic beats 1
- electronic drone sound 1
- electronic sound 1
- energetic 1
- engaging 1
- enthusiastic drumming 1
- experimental hip-hop 1
- experimental music 1
- fast tempo 1
- folk music 1
- folk tropics 1
- folktronic 1
- fun 1
- funky 1
- fusion music 1
- hip-hop 1
- innovative 1
- instrumental 1
- interesting music 1
- keyboard accompaniment 1
- male vocalist 1
- musical duo 1
- playful accordion harmony 1
- pop 1
- punchy bass lines 1
- recorder harmony 1
- rock elements 1
- simple 1
- soft rock 1
- tambourine beats 1
- thick accent 1
- unconventional 1
- upbeat 1
- wind instrument 1
- wood wind 1
- xylophone 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Attwenger - shakin my brain (official music video) | A male vocalist sings this enthusiastic song in a foreign language. The tempo is fast with infectious drumming and an animated button accordion melody. The song is a fusion of hip-hop with folk music making it unique,unconventional and experimental. It is youthful, buoyant, catchy, engaging and funky with electronic beats. This song is a fusion of Hip-Hop. | 2011-04-05T11:57:57Z | KM FILM | Flimmit: http://www.flimmit.com/attwenger-adventure Attwenger Adventure, 90 Min. Musikfilm/Rockumentary ansehen: http://www.attwenger.at http://www.trikont.de http://www.kmfilm.at http://www.facebook.com/KMFilm Gedreht im Februar 2011 in der KAPU Linz. | ["Funk", "Music"] | ["male vocalist", "fast tempo", "musical duo", "folktronic", "enthusiastic drumming", "playful accordion harmony", "button accordion", "folk music", "hip-hop", "crossover musical style", "experimental music", "unique", "unconventional", "folk tropics", "experimental hip-hop", "fusion music", "electronic beats", "rock elements", "funky", "youthful", "catchy", "upbeat", "energetic", "engaging", "thick accent"] | 7 | 5UmoK5WAW8Y | 663 | |
DMK: "Strangelove" | This music clip is an instrumental. The tempo is medium with a simple and interesting melody with a recorder harmony, steady drumming, groovy bass lines,keyboard accompaniment ,xylophone rhythm, a constant electronic sound like that of a child’s toy gun or car , tambourine beats and chimes and bells. The music is mellow, unique, fun, simple and catchy. This music is Soft Rock/Pop. | 2011-07-08T14:49:36Z | Dicken Schrader | DMK are a Depeche Mode cover band from Bogotá, Colombia. Visit our band page http://www.facebook.com/DMKband -------------------- Dicken Schrader: Keyboard, xylophone, tambourine, soda bottle, baby rattle, little bucket, chocolate mix can and voice. Milah Schrader: Recorder, little bucket, chocolate mix can and voice. Korben Schrader: Maraca, egg maraca, toy racetrack and voice. Music and lyrics by Martin L. Gore (Depeche Mode) There'll be times when my crimes will seem almost unforgivable. I give in to sin because you have to make this life livable. But when you think I've had enough from your sea of love I'll take more than another riverful, and I'll make it all worthwhile, I'll make your heart smile. Strangelove Strange highs and strange lows. Strangelove That's how my love goes. Strangelove Will you give it to me? Will you take the pain I will give to you again and again and will you return it? There'll be days when I'll stray I may appear to be constantly out of reach. I give in to sin because I like to practice what I preach. I'm not trying to say I'll have it all my way, I'm always willing to learn when you've got something to teach, and I'll make it all worthwhile, I'll make your heart smile. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I won't say it again. -------------------- Dicken Schrader: Teclado, xilófono, pandereta, botella de gaseosa, sonajero, baldecito, tarro de chocolate y voz. Milah Schrader: Flauta dulce, baldecito, tarro de chocolate y voz. Korben Schrader: Maraca, maraca de huevito, pista de carritos y voz. Música y letra de Martin L. Gore (Depeche Mode) Habrán momentos en los que mis crímenes parecerán casi imperdonables. Yo me rindo a pecar porque tienes que hacer esta vida vivible. Pero cuando creas que he tenido suficiente de tu mar de amor tomaré más de otro río entero, y haré que todo valga la pena, haré sonreír tu corazón. Amorextraño Ex… | ["Music", "Maraca"] | ["instrumental", "boomy drumming", "pop", "soft rock", "wind instrument", "fun", "simple", "catchy", "innovative", "interesting music", "unique", "wood wind", "punchy bass lines", "electronic drone sound", "tambourine beats", "bells", "child’s toy", "recorder harmony", "keyboard accompaniment", "chimes", "xylophone", "electronic sound"] | 7 | Yk2ZrS0ZS6g | 3308 |
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;