musiccaps_details (view)

1 row where musiccaps_aspects contains "chimes", musiccaps_aspects contains "soft rock" and musiccaps_aspects contains "wind instrument"

✎ View and edit SQL

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
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

CSV options: 

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;