musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "low quality", musiccaps_aspects contains "noisy" 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 | |
Melfina's Lullaby [Fandub] By Kizzy | The low quality recording features a lullaby that consists of mellow girl vocal singing over staccato string melody in the left channel and plucked strings melody in the right channel of the stereo image. There are muffled, barely audible, muffled snare rolls in the background. The recording is noisy and reverberant, and it sounds soft, emotional and mellow. | 2007-11-28T22:50:24Z | Kizzychan04 | A new version, it was hard to hear myself in the old on @3@ | ["Singing", "Gospel music", "Music", "Song", "Lullaby"] | ["low quality", "mellow girl vocal", "plucked strings melody", "staccato strings melody", "reverberant", "noisy", "lullaby", "soft", "emotional", "mellow", "muffled snare rolls"] | 4 | H_2ZPxy80Eo | 1815 | |
Raag Bhopali | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | 2011-01-20T17:29:46Z | aradhanakarhade | Raag Bhupali tutorial for beginners - Raag Bhopali has five notes, and is thus a raag of the "audhav jaati". Follow the instructions and practice this raag. Here, it is sung in the scale of B major. The corresponding notes in B scale are B, C#, D#, F#, G# PLEASE SUBSCRIBE TO OUR NEW CHANNEL: https://www.youtube.com/channel/UCezyky1nT-IVvKAEZagViUA | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | 4 | VV-DgnPPhSo | 3006 | |
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;