musiccaps_details (view)

1 row where musiccaps_aspects contains "bagpipes melody", musiccaps_aspects contains "live performance" and musiccaps_names contains "Wind instrument, woodwind 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
2012 Chris Amstrong Concert cornemuse kemper The low quality recording features a live performance of a bagpipes melody. It sounds traditional, passionate and the recording is in mono and noisy. 2012-12-25T00:16:43Z YouennPiper Théâtre de Kemper le samedi 22 déc 2012. Concert du piper Chris Amstrong soliste écossais de renom et pipe major du Scottish Power Pipe Band, 2ème au championnat du monde 2012 à Glasgow. Suite de jigs, strathpeys, reels, hornpipes. C'est un talentueux compositeur qui est instructeur au Piping Center de Glasgow. Chris était un des juges du concours de cornemuse organisé ce jour là pour les jeunes de moins de 20 ans( organisation BAS 29). Il a aussi animé des stages les vendredi 21 et dimanche au Conservatoire de Musique de Kemper Video youennpiper ["Bagpipes", "Wind instrument, woodwind instrument"] ["low quality", "live performance", "noisy", "mono", "bagpipes melody", "traditional", "passionate"] 4 lnnlghshsVo 4422

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;