musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "plucked strings melody"
This data as json, CSV (advanced)
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 | |
Jamilah sa'ad yemen song | The low quality recording features a passionate female vocalist singing over wooden percussion, synth lead melody and plucked strings melody playing in the background. It sounds passionate, emotional, joyful and traditional. | 2009-01-27T15:22:28Z | girhish | Jamilah sa'ad | ["Singing", "Traditional music", "Music"] | ["low quality", "mono", "noisy", "passionate female vocal", "wooden percussions", "synth lead melody", "plucked strings melody", "passionate", "emotional", "joyful", "traditional"] | 4 | gNpzuFPu6q8 | 4027 |
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;