musiccaps_details (view)

1 row where musiccaps_aspects contains "demo", musiccaps_aspects contains "keyboard" and musiccaps_names contains "Electric piano"

✎ 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
Black Gospel Keyboard - How To Play Talk Music - Sean Clayborn This music is a short instrumental. The tempo is medium with a church organ harmony with a male voice speaking something incoherent and subtle sounds like clinking and whirring. The audio is short and skillful. This is a tutorial on how to play the piano/organ. 2012-01-03T21:29:52Z Street Credit Classic Visit http://www.street.credit - Sean Clayborn is a talented musician from Louisville, KY and is the owner of Ncrediblez Production Company. He has played throughout the country, playing keyboard for numerous nationally recording artists. In this clip he gives an example of his approach to playing "More Than Anything" by Lamar Campbell. Sean comes from a family of musicians, his brother Jason Calyborn was part of the Stellar Award nominated Christian Rap Group "Righteous Riders", and has his own group "Jason Clayborn & Thee Ensemble, and sings background for Bishop Hezekiah Walker and Dr. Ron Kenoly. His father Frankie Raymore is also a talented jazz musician and mother Jocelyn Calyborn is also a music writer and performer ***Please help support us & these videos by sharing this video on Facebook or Twitter. It only takes moments. Thanks for watching!*** Follow Street.Credit on Twitter http://www.twitter.com/streetcredit Follow Street.Credit on Instagram http://www.instagram.com/street.credit/ Follow Street.Credit on Facebook: http://www.facebook.com/streetcredit/ http://www.Street.Credit ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] ["instrumental", "medium tempo", "organ", "sharp notes", "bass", "high notes", "low keys", "church organ", "keyboard", "male voice speaking", "clinking sound", "whirring sound", "tutorial", "demo"] 7 HVA9-fjtv6U 1807

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;