musiccaps_details (view)
2 rows where musiccaps_aspects contains "suspenseful", musiccaps_aspects contains "wooden percussions" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- intense 2
- low quality 2
- suspenseful · 2 ✖
- wooden percussions · 2 ✖
- bouncy 1
- dissonant bells chords 1
- groovy 1
- metallic percussions 1
- percussive 1
- percussive guitar 1
- repetitive bells melody 1
- reverberant 1
- shimmering xylophone 1
- wide 1
musiccaps_names (array) 3 ✖
- Percussion · 2 ✖
- Tabla 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Global Drum Project featuring Mickey Hart and Zakir Hussain | The low quality recording features a wooden percussion, metallic percussion, percussive guitar and repetitive bells melody. It sounds groovy, bouncy, suspenseful, reverberant and intense. | 2007-09-14T06:07:52Z | The Flynn | Four Grammy-winning master drummers invoke percussion gods from all corners of the world in a celebratory, boundary-shattering musical journey that joyously reaffirms the drum's primal potency in today's high-tech world. Global Drum Project reunites Grateful Dead percussionist Mickey Hart with Indian tabla master Zakir Hussain and two longtime friends and collaborators—Nigerian "talking-drum" ace Sikiru Adepoju and Latin conga legend Giovanni Hidalgo—for an evening of new music and classics from the Planet Drum recording that won the first-ever Grammy for Best World Music Album. Saturday, October 13, 2007 at 8 pm $46 / $38 / $28 http://www.flynncenter.org/show_pages/FLW08P.shtml | ["Tabla", "Percussion"] | ["low quality", "reverberant", "percussive", "wooden percussions", "metallic percussions", "percussive guitar", "groovy", "bouncy", "repetitive bells melody", "suspenseful", "intense"] | 4 | TC4mH6nACm8 | 2820 | |
Meshuggah - Spasm - The Djentophonic Ensemble | The low quality recording features wooden percussion playing in the right channel, shimmering xylophone playing in the left channel and dissonant bells chords in the middle of the stereo image. It sounds suspenseful and intense. | 2015-09-15T07:44:01Z | Djentophonic Official | "Spasm" played on classical percussion. djentophonic @gmail.com for more info. | ["Wood block", "Percussion"] | ["low quality", "wide", "wooden percussions", "shimmering xylophone", "dissonant bells chords", "intense", "suspenseful"] | 4 | tlDBOenCGV4 | 5061 |
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;