musiccaps_details (view)

1 row where musiccaps_aspects contains "medium tempo", musiccaps_author = 9 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
"COLD DUCK TIME" - HARRIS/McCANN This is an amateur recording of a hard rock piece. An electric guitar solo is being played over a backing track that has a rhythm guitar, a bass guitar, a keyboard and acoustic drums playing in it. The sound resembles an 80s feel. It is a raw recording, so the mix is a bit muddy. 2010-04-26T20:44:14Z BGJ THIS GREAT TUNE GAINED NOTICE ON THE EDDIE HARRIS & LES McCANN "LIVE AT MONTREAUX" L.P. IT'S A FUNKY THANG, AND HAS BEEN COVERED BY EVERYBODY! THE L.P. ALSO FEATURED LES'S "TRY TO MAKE IT REAL, COMPARED TO WHAT?" A FINE SOCIAL COMMENTARY SONG OF THE TIME. VIETNAM WAR, CIVIL RIGHTS, STUDENT PROTESTS ECT. LES IS A DEAR FRIEND, WE TALK FROM TIME TO TIME. HE STILL GIGS, RECORDS, & LECTURES AT COLLEGES ACROSS THE COUNTRY. THANKS FOR LOOKING IN, ALOHA, BEAR P.S. THIS IS DEDICATED TO OUR DEAR FRIEND LES McCANN. LOVE YOU BABY! ["Blues", "Music", "Musical instrument"] ["hard rock", "electric guitar", "guitar solo", "bass guitar", "keyboard", "acoustic drums", "groovy", "80s feel", "crunchy", "medium tempo"] 9 HWe3TSUcvHc 1810

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;