musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "pop" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- fun · 2 ✖
- instrumental 2
- pop · 2 ✖
- animated voices 1
- auto harp 1
- bells 1
- boomy drumming 1
- breezy 1
- catchy 1
- cello 1
- cheerful 1
- child playing 1
- child’s toy 1
- child’s voice 1
- chimes 1
- electric guitar 1
- electronic drone sound 1
- electronic sound 1
- fast tempo 1
- innovative 1
- intense 1
- interesting music 1
- keyboard accompaniment 1
- playful 1
- poor audio quality 1
- punchy bass lines 1
- recorder harmony 1
- simple 1
- soft rock 1
- static 1
- tambourine beats 1
- unique 1
- viola 1
- violins 1
- vocalisation 1
- wind instrument 1
- wood wind 1
- xylophone 1
musiccaps_names (array) 6 ✖
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Maraca 1
- Music 1
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Snoopy & Woodstock 3 | This music is an animated instrumental. The tempo is fast with a lively cello bass line , viola and violin harmony with a lead strung instrument which is either an Auto Harp or electric guitar. There is a child’s voice superimposed on the music with incoherent words and a lot of static. The music is lively, intense,playful, fun, cheerful, animated and breezy. This music is an animated Pop. | 2007-02-19T00:19:07Z | HITMANIV | Snoopy and Woodstock get their roll on | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "fast tempo", "animated voices", "cello", "pop", "fun", "breezy", "child playing", "auto harp", "static", "poor audio quality", "electric guitar", "violins", "auto harp", "viola", "intense", "playful", "child’s voice", "vocalisation", "cheerful"] | 7 | sUh43prJYMM | 4954 |
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;