musiccaps_details (view)
3 rows where musiccaps_aspects contains "wooden percussions" and musiccaps_names contains "Wood block"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 3
- wooden percussions · 3 ✖
- mono 2
- noisy 2
- dissonant bells chords 1
- documentary 1
- dynamic 1
- flame sounds 1
- flat male vocal 1
- harmonizing male vocals 1
- intense 1
- passionate 1
- passionate male vocal 1
- shimmering shaker 1
- shimmering shakers 1
- shimmering xylophone 1
- soulful 1
- suspenseful 1
- wide 1
- wooden surface scratching sounds 1
musiccaps_names (array) 2 ✖
- Percussion 3
- Wood block · 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Percussion Instrument of Patayani - Thappu | The low quality recording features a flat male vocal narrating over flame sounds and wooden surface scratching sounds, after which there is a cut to a shimmering shaker and wooden percussion playing. The recording is noisy and in mono. | 2010-06-24T13:24:01Z | Kerala Tourism | Patayani Thappu is the major percussion instrument used in the performance of Patayani, a ritual dance observed in temples. | ["Wood block", "Percussion"] | ["low quality", "mono", "noisy", "flat male vocal", "wooden percussions", "flame sounds", "shimmering shaker", "wooden surface scratching sounds", "documentary"] | 4 | 3B-YYTbpFZE | 446 | |
OTIGBA UMUNOHA 2 | The low quality recording features a passionate male vocal chant, followed by harmonizing male vocals chants, after which a shimmering shaker and wooden percussion start playing. It sounds soulful, passionate and dynamic. The recording is mono and noisy. | 2012-12-22T07:55:13Z | nwaOkechi Nwafo Nnoha | ["Wood block", "Percussion"] | ["low quality", "wooden percussions", "passionate male vocal", "harmonizing male vocals", "dynamic", "passionate", "soulful", "shimmering shakers", "noisy", "mono"] | 4 | UxT3KG4AHAI | 2960 | ||
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;