musiccaps_details (view)

1 row where musiccaps_aspects contains "drum beat", musiccaps_aspects contains "found sound" and musiccaps_names contains "Drum machine"

✎ 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: "Everything Counts" A rock drum beat that uses a boomy kick, trashy percussion, a tambourine to make a 'found sound' vibe. 2011-12-23T10:48:53Z 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, kazoo, tambourine, soda bottle and voice. Milah Schrader: Recorder, rattle, windchime and voice. Korben Schrader: Toy keyboard, maraca, cheese grater and voice. Music and lyrics by Martin L. Gore (Depeche Mode) The handshake seals the contract, from a contract there's no turning back, the turning point of a career in Korea being insincere. The holiday was fun-packed, the contract still intact. The grabbing hands grab all they can, all for themselves after all. The grabbing hands grab all they can, all for themselves, after all. It's a competitive world... Everything counts in large amounts. The graph on the wall tells the story of it all. Picture it now, see just how the lies and deceit gained a little more power. Confidence taken in by a suntan and a grin. -------------------- Dicken Schrader: Teclado, xilófono, kazoo, pandereta, botella de gaseosa y voz. Milah Schrader: Flauta dulce, sonajero, carillón y voz. Korben Schrader: Teclado de juguete, maraca, rallador de queso y voz. Música y letra de Martin L. Gore (Depeche Mode) El apretón de manos sella el contrato, de un contrato no hay vuelta atrás, el punto de quiebre de una carrera en Corea siendo insincera. La festividad estuvo llena de diversión, el contrato aun intacto. Las manos que agarran agarran todo lo que pueden, todo para ellas después de todo. Las manos que agarran agarran todo lo que pueden, todo para ellas después de todo. Es un mundo competitivo... Todo cuenta en grandes cantidades. La gráfica en la pared cuenta la historia de todo. Imagínalo ahora, ve justamente como las mentiras y el engaño ganaron un poco mas de poder. La confianza fue ganada por un bronceado y una sonrisa. ["Music", "Drum machine", "Maraca"] ["trashy percussion", "tambourine", "boomy kick", "drum beat", "found sound", "rock"] 8 BxQSEvHdyjQ 1307

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;