musiccaps_details (view)
3 rows where musiccaps_aspects contains "intense", musiccaps_author = 4 and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- intense · 3 ✖
- low quality 3
- suspenseful 3
- wooden percussions 2
- bouncy 1
- breathy flute 1
- dissonant bells chords 1
- groovy 1
- metallic percussions 1
- percussive 1
- percussive guitar 1
- punchy 1
- repetitive bells melody 1
- reverberant 1
- reverberant snare rolls 1
- shimmering xylophone 1
- wide 1
- wide low toms hits 1
musiccaps_names (array) 7 ✖
- Percussion · 3 ✖
- Bass drum 1
- Drum 1
- Drum roll 1
- Snare drum 1
- 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 | |
ASK A SLAVE Ep 4: New Leaf, Same Page | The low quality recording features a reverberant snare roll, followed by wide low toms hits. At the very end of the loop, there is a short snippet of breathy flute melody. It sounds intense and suspenseful. | 2013-09-15T15:32:57Z | Ask A Slave: The Web Series | CREDITS BELOW Ask A Slave is a comedy web series directed by Jordan Black based on the actress' time working as a living history character at the popular historic site, George Washington's Mount Vernon. All questions and interactions are based on true events. Real Questions. Real Comedy. Learn more @ www.AskASlave.com Director: Jordan Black Writer: Azie Mira Dungey Director of Photography: Ryan Moulton Editor: Ryan Moulton Sound: Johnny Shryock Animator: Jamie Noguchi Production Manager: Pamela J Peters Azie Mira Dungey as Lizzie Mae and Amani Starnes as Emma the Runaway Featuring: Courtney Mueller, Carrie Daniel, Danielle Morrow, and Stephanie Carrie *This production is in no way affiliated with or sponsored by George Washington's Mount Vernon Estate, Museum, and Gardens. *This production is in no way affiliated with or sponsored by George Washington's Mount Vernon Estate, Museum, and Gardens. | ["Drum", "Drum roll", "Snare drum", "Bass drum", "Percussion"] | ["reverberant snare rolls", "wide low toms hits", "breathy flute", "low quality", "punchy", "suspenseful", "intense"] | 4 | ik-fXNjxw58 | 4215 | |
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;