musiccaps_details (view)
2 rows where musiccaps_aspects contains "folk" and musiccaps_names contains "Tender music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- folk · 2 ✖
- acoustic guitar 1
- breathy reverberant passionate flute 1
- cinematic 1
- cultural 1
- flute 1
- flute foley sound effects 1
- low bass 1
- soothing 1
- sustained strings 1
- tinny subtle bells melody 1
- traditional 1
- uptempo 1
musiccaps_names (array) 6 ✖
- Music 2
- Tender music · 2 ✖
- Acoustic guitar 1
- Guitar 1
- Plucked string instrument 1
- Traditional music 1
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 | |
LOTRO Music - The Bard's Song (band) | An acoustic guitar is finger-picking a tremolo melody along with a flute playing a melody on top. This song may be playing in an adventure video-game. | 2010-01-28T08:38:42Z | Matheus Eichelberger | Playing The Bard's Song with three instruments (lute, harp and flute) in Rivendell. Elcarandir, Elf Hunter Reidartyr Beowulfson, Man Guardian. Annr, Man Minstrel. Server: Landroval Kinship: House of Telperion - Brazil's RP Kinship | ["Guitar", "Acoustic guitar", "Music", "Plucked string instrument", "Tender music"] | ["folk", "acoustic guitar", "flute", "soothing", "uptempo"] | 6 | MfKSVJIcDK0 | 2287 |
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;