musiccaps_details (view)
4 rows where musiccaps_names contains "Percussion" and youtube_description = " "
This data as json, CSV (advanced)
Suggested facets: musiccaps_author, youtube_published (date), musiccaps_names (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Photo Zardari %%Bewafa dil tori chadei. | The low quality recording features a flat male vocal singing over digital piano melody and wooden percussion. The recording is noisy, in mono, loud and distorted. | 2012-06-03T10:43:33Z | arjiskani | ["Tabla", "Drum", "Percussion"] | ["low quality", "mono", "noisy", "flat male vocal", "wooden percussions", "digital piano melody", "loud", "distorted"] | 4 | -w4HLksto_k | 102 | ||
tema:ni tu ni yo,art: la barra (cuarteto) fctambora. | The song is an instrumental. The song is medium tempo with a percussionist practising Latin bass drums with a drum stick to a music track with male vocals, trumpet harmony and other percussion. The audio quality is poor and boomy. | 2012-09-12T01:14:54Z | fernando castro | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["percussion practice", "male singer", "backing track", "vocal chants", "exciting", "dance rhythm", "enthusiastic", "passionate", "drums demonstration", "steady rhythm", "latin dance rhythm", "male singer chants", "laitin dance hits", "bass drum", "drum sticks", "youtube music video", "groovy music", "medium tempo"] | 1 | CHo8wKj9J1w | 1347 | ||
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 | ||
Y8 Smoke on the Water Drum Tutorial | The low quality recording features a tutorial where a flat male vocalist is talking in-between punchy electro kick and synth hi hat. The recording is noisy and in mono. | 2012-10-08T11:44:50Z | CranfordCCMusic | ["Wood block", "Drum", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "mono", "punchy electro kick", "synth hi hat", "flat male vocal", "tutorial"] | 4 | jaJdPUAv6N0 | 4263 |
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;