musiccaps_details (view)
2 rows where musiccaps_aspects contains "high notes", musiccaps_aspects contains "tutorial" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- high notes · 2 ✖
- instrumental 2
- medium tempo 2
- tutorial · 2 ✖
- 8 stringed instrument 1
- bass 1
- bluegrass 1
- church organ 1
- classical 1
- clinking sound 1
- country song 1
- country songs 1
- demo 1
- ethnic music 1
- folk 1
- jazz 1
- keyboard 1
- low keys 1
- lute instrument 1
- male voice speaking 1
- mandolin 1
- mandolin instrumental 1
- melodious 1
- organ 1
- sharp notes 1
- soprano tone 1
- string instrument 1
- sweet 1
- whirring sound 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Hammond organ 1
- Keyboard (musical) 1
- Mandolin 1
- Music 1
- Organ 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
10 songs to play on mandolin that aren't bluegrass | This song is a mandolin instrumental. The tempo is medium with a lively melody on the mandolin. The music is minimalist without any other instruments. The music is high pitched, melodious and charming. This audio ends abruptly indicating that this could be a mandolin tutorial. | 2014-08-08T12:17:31Z | mandohat | I love bluegrass, but the mandolin is a great instrument for lots of styles! http://www.andyslessons.com ---Andy Hatfield, mandolin and guitarist | ["Music", "Mandolin"] | ["instrumental", "medium tempo", "mandolin", "folk", "classical", "jazz", "ethnic music", "country songs", "tutorial", "string instrument", "mandolin instrumental", "8 stringed instrument", "country song", "bluegrass", "high notes", "melodious", "sweet", "lute instrument", "soprano tone"] | 7 | 2ZogsGp-T4o | 381 | |
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;