musiccaps_details (view)
1 row where musiccaps_aspects contains "low keys", musiccaps_author = 7 and musiccaps_names contains "Electronic organ"
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
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;