musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting", musiccaps_aspects contains "low quality", musiccaps_aspects contains "noisy" and musiccaps_names contains "Bell"
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 |
---|---|---|---|---|---|---|---|---|---|---|
World Percussionist:Tom Teasley "REFLECTIONS" FOR SABIAN CROTALES, WAVE DRUM, MELODICA AND LOOPER | The low quality recording features a shimmering, widely spread, bell melody. It sounds soft, mellow and haunting. The recording is a bit noisy. | 2012-09-03T12:31:28Z | Tom Teasley | This is another piece inspired by the beautiful story of "Gilgamesh". I'll be performing this live in May for Constellation Theatre Company at Source Theatre This piece uses extended techniques for crotales including playing with a bass bow and hand dampening. I created a loop on the Korg Wavedrum live and double the crotale part on the melodica. No editing was used in this except sound mixing. It is a complete live performance. Special thanks to Sabian for the beautiful instrument. As always thank you for checking out my work. More info at www.tomteasley.com Stay in touch! https://www.Twitter.com/tomteasley https://www.facebook.com/pages/Tom-Teasley/168279076560112 | ["Bell", "Music", "Musical instrument", "Percussion"] | ["low quality", "noisy", "shimmering wide bells melody", "haunting", "soft", "mellow"] | 4 | LGrAwQnZ6Bs | 2171 | |
Avenged Sevenfold - Nightmare, Drum Cover, 5 Year Old Drummer, Jonah Rocks | The low quality recording features a shimmering bell melody that sounds haunting. There is a metallic impact. The recording sounds very noisy as it was probably recorded with a bad quality microphone. | 2010-08-01T22:46:53Z | Jonah Rocks | For A7X info visit: www.avengedsevenfold.com. Jonah Rocks Avenged Sevenfold - Nightmare. A7X is one of Jonah's fave bands.Click http://www.thrillershop.com/store/product.php?cat_id=22&sub_id=0&pro_id=61 For Jonah Rocks T-Shirts! Jonah would like to Thank these companies for all of their help: Vic Firth Drumsticks- http://www.vicfirth.com/artists/profile/profile.php?id=2756 SJC Custom Drums- http://sjcdrums.com/ Zildjian Cymbals- http://www.zildjian.com/en-US/news/newsDetail.ad2?newsID=1901 DW Pedals, Stands, and Hardware- http://www.dwdrums.com/ Evans Drum Heads - http://www.evansdrumheads.com/ Stoked Custom Thrones - http://www.myspace.com/stokedcustomthrones ALL COPYRIGHTED MATERIAL IS USED UNDER THE GUIDELINES OF "FAIR USE" IN TITLE 17 & 107 OF THE UNITED STATES CODE, AND UNDER ARTICLES 29 & 29.1 OF THE CANADIAN COPYRIGHT ACT. SUCH MATERIAL REMAINS THE PROPERTY OF THE ORIGINAL OWNER OF THE COPYRIGHT, AND IS USED HERE FOR THE PURPOSES OF EDUCATION, COMPARISON, AND CRITICISM ONLY. | ["Bell", "Music"] | ["low quality", "shimmering bells melody", "metallic impact", "noisy", "haunting"] | 4 | rLtXML8Y5wo | 4869 |
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;