musiccaps_details (view)

2 rows where musiccaps_aspects contains "crunchy", 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
Josh Gooch: Guitar Center King of the Blues '09 Finalist This is the live performance of a blues music piece. It is an instrumental performance. The lead electric guitar is playing a blues solo while another electric guitar and a bass guitar are playing in the background. The rhythmic background consists of a slow tempo blues acoustic drum beat. There is a groovy atmosphere to this performance. This piece could be playing in the background at a rock bar. 2010-02-05T23:29:42Z Guitar Center Guitar Center King of the Blues finalist, Josh Gooch's performance from the GC King of the Blues Grand FInals - Nov 12th, 2009 at the House of Blues Sunset. For more information on Guitar Center or King of the Blues visit www.guitarcenter.com ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] ["live performance", "blues", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "crunchy", "slow tempo"] 9 4bXb6GLm6zg 589
"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;