musiccaps_details (view)
2 rows where musiccaps_aspects contains "ethereal" and musiccaps_aspects contains "melodic" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- ethereal · 2 ✖
- high notes 2
- melodic · 2 ✖
- alto 1
- amateur recording 1
- angelic 1
- animated 1
- captivating 1
- celestial 1
- choral harmony 1
- engaging 1
- enthralling 1
- female singer 1
- female soprano like sound 1
- harmonious 1
- inferior audio quality 1
- instrumental 1
- keyboard harmony 1
- lively piano 1
- mediocre sound recording 1
- mesmerising 1
- no instruments 1
- piano accompaniment 1
- quality of 1
- rhythmic acoustic guitar 1
- rustling 1
- scuffling 1
- seconds 1
- skilful 1
- skilled musician 1
- soprano 1
- sound of chatter 1
- spirited 1
- steady bass lines 1
- steady drumming 1
- synthesised arrangements 1
- tambourine 1
- theremin 1
- thereminist 1
- unique 1
- vocal vibrations 1
- whirring sound 1
musiccaps_names (array) 4 ✖
- Music 2
- A capella 1
- Theremin 1
- Vocal music 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fill the World With Love 6-09 | A female vocalist sings this mellifluous song.The tempo is slow with the vocalist singing a soprano, with alto choral harmony. There are sounds of rustling, whirring,scuttling and people talking in the background. The vocals are beautiful, mellifluous,and ethereal. | 2009-06-07T23:08:18Z | noodlebrain500 | Fill the World With Love 6-09 | ["Music", "Vocal music", "A capella"] | ["female singer", "high notes", "choral harmony", "ethereal", "vocal vibrations", "ethereal", "soprano", "alto", "whirring sound", "seconds", "melodic", "angelic", "celestial", "no instruments", "sound of chatter", "rustling", "scuffling", "harmonious", "amateur recording", "mediocre sound recording", "inferior audio quality", "quality of"] | 7 | -YIT4HBM__g | 61 | |
Thereminist IN HIS NATURAL HABITAT | A feminist plays this intriguing instrumental. The tempo is fast with keyboard accompaniment, steady drumming, rhythmic acoustic guitar, lively piano harmony , steady bass lines and shakers. The music is sharp, height pitched and almost like a female soprano vocalising. The song is energetic, spirited, melodic, animated, unique, skilful, engaging, ethereal and captivating; | 2009-03-25T22:15:57Z | ThomasGrillo | http://www.thomasgrillo.com Enjoy a little tour of "the coolest room in town" according to an anthropology major who recently documented thereminist Thomas Grillo in his natural habitat. ;) The song is an original jazz compostion by Thomas Grillo, called Mint Julep Fantasy, which is now available on CD, and MP3. Just visit http://www.thomasgrillo.com/shop.html and check out the album, Secret Agents from the id. The piece has been much improved since this video's release. Video was shot by professional photographer Josh Haley. Visit him at http://www.joshhaileystudio.com The lens was a 120 degree wide angle, fish eye lens. ;) Song and video are Copyright 2009 Thomas Grillo, and Josh Hailey. | ["Music", "Theremin"] | ["instrumental", "keyboard harmony", "theremin", "tambourine", "unique", "melodic", "spirited", "enthralling", "melodic", "skilful", "ethereal", "captivating", "steady bass lines", "lively piano", "mesmerising", "engaging", "animated", "thereminist", "piano accompaniment", "steady drumming", "synthesised arrangements", "rhythmic acoustic guitar", "theremin", "high notes", "female soprano like sound", "skilled musician"] | 7 | bHiRX6QYwEk | 3613 |
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;