musiccaps_details (view)
2 rows where musiccaps_aspects contains "jam" and musiccaps_aspects contains "poor quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- amateur recording 2
- jam · 2 ✖
- poor quality · 2 ✖
- acoustic drums 1
- bass guitar 1
- didgeridoo 1
- easygoing 1
- instrumental 1
- low-to-medium range 1
- male vocal 1
- no singer 1
- ominous 1
- single instrument 1
- sound check 1
- t-pop 1
- tribal 1
- unfamiliar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DIDJERIDU (DIDJERIDOO) | This is the amateur recording of an instrument showcase jam. There is a didgeridoo playing at low-to-medium range making various resonant sounds in the process. The atmosphere is ominous and tribal. The quality of the audio is quite poor. This piece could be played at a primary school music class to give the kids an impression of how a didgeridoo sounds like. | 2007-12-30T16:57:55Z | kaypacha | Didgeridus para la venta en julio 2007. http://www.kaypacha.com.ar Didgeridoos for the sale in July 2007. | ["Didgeridoo", "Music"] | ["jam", "no singer", "instrumental", "amateur recording", "poor quality", "single instrument", "didgeridoo", "low-to-medium range", "unfamiliar", "ominous", "tribal"] | 9 | 8KIoQ2HZ0Hg | 911 | |
Lipta sound check in Bangkok winter music festival 2010 | This is an amateur recording of a sound check jam. The audio quality is quite poor with an emphasis on the drum sound. There is a male vocal that can be barely heard over the sound of the bass guitar and the acoustic drums. The piece is easygoing. This recording can be sampled for use in beat-making. | 2010-02-18T08:24:09Z | Kandanai Visuthsiri | พี่เน มือกลองวงลิปตา ซาวน์เช็คงาน Bangkok Winter Music Festival 2010 ที่สนามราชมังคลากีฬาสถาน ครับ | ["Music", "Exciting music"] | ["jam", "sound check", "amateur recording", "poor quality", "t-pop", "male vocal", "bass guitar", "acoustic drums", "easygoing"] | 9 | O73wigUotGo | 2401 |
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;