musiccaps_details (view)
2 rows where musiccaps_aspects contains "bouncy", musiccaps_aspects contains "wooden percussions" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bouncy · 2 ✖
- low quality 2
- wooden percussions · 2 ✖
- groovy 1
- groovy bass 1
- happy 1
- intense 1
- metallic percussions 1
- noisy 1
- organ keys melody 1
- percussive 1
- percussive guitar 1
- playback instrumental 1
- plucked melody 1
- repetitive bells melody 1
- reverberant 1
- suspenseful 1
- weird 1
musiccaps_names (array) 5 ✖
- Electric piano 1
- Keyboard (musical) 1
- Percussion 1
- Piano 1
- Tabla 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 | |
Keyboard organ music | The low quality recording features an organ keys melody played over playback instrumental that consists of groovy bass, plucked melody and some wooden percussion. It sounds weird, bouncy, happy and the recording is very noisy. | 2008-03-31T18:50:13Z | Jim Baillie | A selection of 50's, 60's style music. | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "organ keys melody", "playback instrumental", "groovy bass", "plucked melody", "wooden percussions", "weird", "bouncy", "happy"] | 4 | mu0dlj8ibA4 | 4499 |
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;