musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- emotional · 2 ✖
- live performance · 2 ✖
- mellow · 2 ✖
- acoustic guitar melody 1
- ambient music 1
- atmospheric 1
- beautiful 1
- captivating 1
- classical 1
- euphonious 1
- gentle 1
- guitar lead 1
- guitar solo 1
- instrumental 1
- low quality 1
- mesmerising 1
- noisy 1
- opera 1
- passionate 1
- passionate female vocal 1
- plucked strings melody 1
- romantic 1
- slow tempo 1
- string instrument 1
- sustained string melody 1
- unbalanced stereo image 1
- western classical 1
musiccaps_names (array) 7 ✖
- Music 2
- Guitar 1
- Musical instrument 1
- Opera 1
- Plucked string instrument 1
- Singing 1
- Strum 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 | |
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 |
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;