musiccaps_details (view)
2 rows where musiccaps_aspects contains "high notes", musiccaps_aspects contains "whirring sound" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- high notes · 2 ✖
- whirring sound · 2 ✖
- alto 1
- amateur recording 1
- angelic 1
- bass 1
- celestial 1
- choral harmony 1
- church organ 1
- clinking sound 1
- demo 1
- ethereal 1
- female singer 1
- harmonious 1
- inferior audio quality 1
- instrumental 1
- keyboard 1
- low keys 1
- male voice speaking 1
- mediocre sound recording 1
- medium tempo 1
- melodic 1
- no instruments 1
- organ 1
- quality of 1
- rustling 1
- scuffling 1
- seconds 1
- sharp notes 1
- soprano 1
- sound of chatter 1
- tutorial 1
- vocal vibrations 1
musiccaps_names (array) 9 ✖
- A capella 1
- Electric piano 1
- Electronic organ 1
- Hammond organ 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fill the World With Love 6-09 | A female vocalist sings this mellifluous song.The tempo is slow with the vocalist singing a soprano, with alto choral harmony. There are sounds of rustling, whirring,scuttling and people talking in the background. The vocals are beautiful, mellifluous,and ethereal. | 2009-06-07T23:08:18Z | noodlebrain500 | Fill the World With Love 6-09 | ["Music", "Vocal music", "A capella"] | ["female singer", "high notes", "choral harmony", "ethereal", "vocal vibrations", "ethereal", "soprano", "alto", "whirring sound", "seconds", "melodic", "angelic", "celestial", "no instruments", "sound of chatter", "rustling", "scuffling", "harmonious", "amateur recording", "mediocre sound recording", "inferior audio quality", "quality of"] | 7 | -YIT4HBM__g | 61 | |
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;