musiccaps_details (view)

2 rows where musiccaps_aspects contains "instrumental music", musiccaps_author = 0 and musiccaps_names contains "Blues"

✎ 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
Mike Dowling " Blues In G ." This blues guitar song features a resonator guitar. Fingerstyle guitar is being played. The melody is a blues style guitar. There are no other instruments in this song. There are no voices in this song. This song can be played in a bar. 2014-05-08T19:25:05Z nationalguitars Mike Dowling presents "Blues In G." courtesy of Homespun. ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] ["blues guitar", "fingerstyle guitar", "no percussion", "resonator guitar", "no voices", "instrumental music", "relaxing"] 0 F1X7egd8Us0 1608
Set Acústico - Ruido Rosa - Concierto Cable This instrumental clip features a bass guitar playing a repetitive lick. This is accompanied by a shaker and a tambourine. After one bar, the tambourine stops playing. There are no voices in this song. There is no percussion in this song. The mood of this song is trippy. It can be used in a bank robbery movie. 2012-03-14T06:05:59Z Concierto Cable Miedo A Caer por Ruido Rosa Set Acústico de Ruido Rosa desde el Museo del Juguete Conciertos Acústicos en vivo solo por - http://www.conciertocable.com/ Ruido Rosa -- http://ruidorosa.com/ Concierto Cable -- https://twitter.com/#!/ConciertoCable Museo del Juguete -- http://museodeljuguete.mx/ Elefgant -- https://twitter.com/#!/Elefgant ["Blues", "Effects unit", "Music", "Distortion"] ["instrumental music", "bass guitar", "no voices", "shaker", "tambourine", "repetitive melody", "moderate tempo"] 0 fHNAxa0QaOM 3939

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;