musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering bells melody" and musiccaps_names contains "Bell"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- low quality 2
- shimmering bells melody · 2 ✖
- arpeggiated acoustic guitar melody 1
- chime bells 1
- crowd cheering 1
- emotional 1
- haunting 1
- joyful 1
- metallic impact 1
- noisy 1
- plucked strings melody 1
- sustained strings melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pichenda | The low quality recording features an arpeggiated acoustic guitar melody, shimmering bells melody, plucked strings melody and sustained strings melody, followed by chime bells. There are some crowd cheering noises in the background. It sounds emotional and joyful. | 2007-06-24T01:34:04Z | khmrch1cca | RHM Vol. 52 | ["Bell", "Music"] | ["low quality", "crowd cheering", "arpeggiated acoustic guitar melody", "shimmering bells melody", "chime bells", "plucked strings melody", "sustained strings melody", "emotional", "joyful"] | 4 | LTDle_h2YD8 | 2191 | |
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;