musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "wooden percussive elements" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality 2
- noisy 2
- passionate male vocal · 2 ✖
- wooden percussive elements · 2 ✖
- 4 on the floor kick 1
- funk 1
- funky keys melody 1
- groovy bass 1
- live performance 1
- mono 1
- mystical 1
- passionate 1
- shimmering open hat 1
- shimmering shakers 1
- soulful 1
- suspenseful 1
- sustained suspenseful strings melody 1
- traditional 1
- unbalanced stereo 1
musiccaps_names (array) 5 ✖
- Funk 1
- Music 1
- Music of Africa 1
- Percussion 1
- Tabla 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Great Ghazal Singer Ahmad Wali with Siar Hashimi on Tabla | The low quality recording features a live performance of a traditional song that consists of wooden percussive elements, sustained suspenseful strings melody and passionate male vocal singing over it. It sounds passionate, mystical, soulful and suspenseful, even though the recording is a bit noisy and in mono. | 2009-03-05T15:38:49Z | TaalPanchamSawari | Ghazal Tabla: Siar Hashimi Taal: Kehrwa | ["Tabla", "Percussion"] | ["mono", "noisy", "low quality", "traditional", "live performance", "wooden percussive elements", "sustained suspenseful strings melody", "passionate male vocal", "soulful", "passionate", "mystical", "suspenseful"] | 4 | yx7BZ_djE-U | 5449 | |
Wildfire - Dance With Me - FUNK | The low quality recording features a funk song that consists of passionate male vocal singing over shimmering open hats and shakers, funky and groovy keys melody, groovy bass, wooden percussive elements and "4 on the floor" kick pattern. It is noisy, but also funky and the stereo image is unbalanced, as the song is leaning towards the right channel. | 2015-06-21T00:15:31Z | Djegu | Wild Fire – WFP-0003 http://www.discogs.com/Wildfire-Time-Is-The-Answer/release/3557173 http://www.juno.co.uk/products/tropical-disco-hustle-volume-2/569473-01/ | ["Music of Africa", "Funk", "Music"] | ["low quality", "funk", "funky keys melody", "shimmering shakers", "shimmering open hat", "passionate male vocal", "wooden percussive elements", "groovy bass", "4 on the floor kick", "noisy", "unbalanced stereo"] | 4 | DdxW_JziHTA | 1500 |
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;