musiccaps_details (view)

1 row where musiccaps_aspects contains "noisy", musiccaps_names = "["Bell", "Music", "Musical instrument", "Percussion"]" and musiccaps_names contains "Percussion"

✎ 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
World Percussionist:Tom Teasley "REFLECTIONS" FOR SABIAN CROTALES, WAVE DRUM, MELODICA AND LOOPER The low quality recording features a shimmering, widely spread, bell melody. It sounds soft, mellow and haunting. The recording is a bit noisy. 2012-09-03T12:31:28Z Tom Teasley This is another piece inspired by the beautiful story of "Gilgamesh". I'll be performing this live in May for Constellation Theatre Company at Source Theatre This piece uses extended techniques for crotales including playing with a bass bow and hand dampening. I created a loop on the Korg Wavedrum live and double the crotale part on the melodica. No editing was used in this except sound mixing. It is a complete live performance. Special thanks to Sabian for the beautiful instrument. As always thank you for checking out my work. More info at www.tomteasley.com Stay in touch! https://www.Twitter.com/tomteasley https://www.facebook.com/pages/Tom-Teasley/168279076560112 ["Bell", "Music", "Musical instrument", "Percussion"] ["low quality", "noisy", "shimmering wide bells melody", "haunting", "soft", "mellow"] 4 LGrAwQnZ6Bs 2171

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;