musiccaps_details (view)
1 row where musiccaps_aspects contains "cultural" and musiccaps_aspects contains "flute foley sound effects"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- breathy reverberant passionate flute 1
- cinematic 1
- cultural · 1 ✖
- flute foley sound effects · 1 ✖
- folk 1
- low bass 1
- sustained strings 1
- tinny subtle bells melody 1
- traditional 1
musiccaps_names (array) 3 ✖
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 |
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;