musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow", musiccaps_aspects contains "passionate" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- low quality 2
- mellow · 2 ✖
- passionate · 2 ✖
- addictive 1
- choir 1
- emotional 1
- harmonizing female vocals 1
- live performance 1
- noisy 1
- opera 1
- passionate female vocal 1
- plucked strings melody 1
- soft 1
- sustained string melody 1
- unbalanced stereo image 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dame Kiri Te Kanawa sings "The Virgin Washes the Swaddling" | The low quality recording features a live opera performance sung by passionate female vocalists and followed by sustained and plucked strings melody. The recording is very noisy and the stereo image is unbalanced, since the audio from the left channel is occasionally cut out. It sounds emotional, mellow and passionate. | 2008-11-09T05:47:07Z | Dame Kiri Lover | Dame Kiri Te Kanawa sings "The Virgin Washes the Swaddling" (John Dobbs; Traditional arr. Colin Matthews). With Philharmonia Orchestra, Carl Davis / conductor. Recorded at Barbican Center, London, UK, 1988. | ["Singing", "Music", "Opera"] | ["low quality", "noisy", "live performance", "opera", "sustained string melody", "plucked strings melody", "mellow", "passionate female vocal", "unbalanced stereo image", "passionate", "emotional"] | 4 | ADxuhHNZVCc | 1087 | |
Choir Warm-Up(Women's Ensemble CVHS CHOIR) | The low quality recording features a live performance of a female choir that consists of harmonizing female vocals. It sounds addictive, mellow and soft. | 2009-05-16T04:49:23Z | CVHSChoir | Women's Ensemble (Kodaly warm-up) | ["Singing", "Choir", "A capella"] | ["low quality", "harmonizing female vocals", "passionate", "addictive", "mellow", "soft", "choir"] | 4 | OA63sRxGk6o | 2407 |
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;