musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting", musiccaps_aspects contains "mellow" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- haunting · 2 ✖
- mellow · 2 ✖
- soft 2
- celestial 1
- celtic folk music 1
- celtic new age 1
- delicate 1
- downtempo 1
- electronic 1
- enigmatic 1
- ethereal 1
- female singer 1
- low quality 1
- meditative 1
- melancholic 1
- modern classical 1
- mysterious 1
- new age 1
- noisy 1
- opera 1
- organ accompaniment 1
- shimmering wide bells melody 1
- sublime 1
musiccaps_names (array) 5 ✖
- Music · 2 ✖
- Bell 1
- Musical instrument 1
- New-age music 1
- Percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World Percussionist:Tom Teasley "REFLECTIONS" FOR SABIAN CROTALES, WAVE DRUM, MELODICA AND LOOPER | The low quality recording features a shimmering, widely spread, bell melody. It sounds soft, mellow and haunting. The recording is a bit noisy. | 2012-09-03T12:31:28Z | Tom Teasley | This is another piece inspired by the beautiful story of "Gilgamesh". I'll be performing this live in May for Constellation Theatre Company at Source Theatre This piece uses extended techniques for crotales including playing with a bass bow and hand dampening. I created a loop on the Korg Wavedrum live and double the crotale part on the melodica. No editing was used in this except sound mixing. It is a complete live performance. Special thanks to Sabian for the beautiful instrument. As always thank you for checking out my work. More info at www.tomteasley.com Stay in touch! https://www.Twitter.com/tomteasley https://www.facebook.com/pages/Tom-Teasley/168279076560112 | ["Bell", "Music", "Musical instrument", "Percussion"] | ["low quality", "noisy", "shimmering wide bells melody", "haunting", "soft", "mellow"] | 4 | LGrAwQnZ6Bs | 2171 | |
Enya - Evening Falls | A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. | 2006-11-01T15:54:46Z | Servet Tonga | Evening Falls video clip | ["New-age music", "Music"] | ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] | 7 | _nrz_BawPMY | 3492 |
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;