musiccaps_details (view)

1 row where musiccaps_aspects contains "shimmering shakers", musiccaps_aspects contains "soul" and musiccaps_aspects contains "syncopate snare hits"

✎ 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
Pan Masters--Stand By Me The Soul Instrumental features an addictive marimba melody, shimmering shakers, punchy kick hits, syncopated snare and tinny metallic percussive elements. It sounds narrow because it is recorded with one mono room microphone and therefore it is a low quality recording. 2007-02-02T04:58:56Z Discojones77 Pan Masters Steel Orchestra of Washington, DC performs Ben E. King's "Stand By Me" at their 20th Anniversary Concert--April 2005. The arrangement is by Kristen Jones ["Music", "Steelpan"] ["soul", "low quality", "instrumental", "marimba melody", "shimmering shakers", "tinny metallic percussive elements", "punchy kick", "syncopate snare hits", "low quality", "mono", "room microphone"] 4 OcdrbkDm2LQ 2452

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;