musiccaps_details (view)
3 rows where musiccaps_aspects contains "cultural" and musiccaps_aspects contains "folk"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- cultural · 3 ✖
- folk · 3 ✖
- accordion melody 2
- live performance 2
- low quality 2
- traditional 2
- addictive flute melody 1
- breathy reverberant passionate flute 1
- cinematic 1
- flute foley sound effects 1
- groovy bass 1
- high pitch female vocal 1
- low bass 1
- metallic percussions 1
- passionate 1
- shimmering triangle 1
- sustained strings 1
- tinny subtle bells melody 1
- trumpet melody 1
- uplifting 1
- wooden percussive elements 1
- woodwind melody 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Korean Traditional Instrumental Music (국악명상음악 12곡) | The Folk song features a sustained string, low bass, subtle tinny bells melody and passionately played breathy and reverberant flute melody. There are some foley effects from the flute which could be quieter in the mix. It sounds very traditional, cinematic and cultural. | 2011-01-25T01:50:21Z | LovelySosoWaiwai | This is a CPP resource to be used in introducing Korean culture to the aged care service providers in Australia. It contains 12 Korean traditional instrumental musics with 51 minutes of duration. Caroline at AKWA | ["Traditional music", "Music", "Tender music"] | ["breathy reverberant passionate flute", "sustained strings", "low bass", "tinny subtle bells melody", "traditional", "folk", "cinematic", "cultural", "flute foley sound effects"] | 4 | 7KCikXm6hic | 830 | |
Rela re rela 3 Roja&Santosha | The low quality recording features a live performance of a folk, traditional song where a high pitch female vocal is singing over addictive flute melody, layered with accordion melody, followed by wooden percussive elements and simmering triangle. It sounds uplifting and cultural. | 2009-11-29T02:31:49Z | Rangaptl | ["Singing", "Traditional music", "Music"] | ["low quality", "folk", "live performance", "high pitch female vocal", "accordion melody", "addictive flute melody", "shimmering triangle", "wooden percussive elements", "traditional", "uplifting", "cultural"] | 4 | VswY2mI7Wbo | 3038 | ||
adm&buldumea.mp4 | The low quality recording features a live performance of a folk song that consists of a woodwind melody, followed by accordion melody, trumpet melody, metallic percussion and groovy bass. It sounds passionate and cultural. | 2010-01-24T19:15:25Z | clivik tr-ta | adm&buldumea.mp4 | ["Brass instrument", "Clarinet", "Trumpet", "Wind instrument, woodwind instrument", "Accordion"] | ["low quality", "live performance", "woodwind melody", "trumpet melody", "folk", "passionate", "cultural", "accordion melody", "metallic percussions", "groovy bass"] | 4 | b12xqPnM0So | 3596 |
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;