musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "plucked strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- live performance · 3 ✖
- low quality 3
- noisy 3
- passionate 3
- plucked strings melody · 3 ✖
- traditional 2
- wooden percussions 2
- acoustic strings melody 1
- crowd chattering 1
- echoing male vocal 1
- emotional 1
- harmonizing male vocals 1
- mellow 1
- mono 1
- opera 1
- passionate female vocal 1
- soulful 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 |
---|---|---|---|---|---|---|---|---|---|---|
Saleem Javeed qawwali Nizampur part 1 | The low quality recording features a live performance of a traditional song and it consists of an echoing male vocal singing over acoustic strings melody, plucked strings melody and wooden percussion. There is a crowd chattering noise in the background. The recording is a bit noisy and it sounds passionate. | 2014-08-05T20:41:31Z | KOKAN MEHFIL-E-QAWWALI | Everyone should watch the video | ["Tabla", "Drum", "Percussion"] | ["low quality", "echoing male vocal", "acoustic strings melody", "crowd chattering", "wooden percussions", "plucked strings melody", "live performance", "traditional", "noisy", "passionate"] | 4 | -6QGvxvaTkI | 15 | |
`` Da Hujrey Mijlas `` | The low quality recording features a live performance of a traditional song that consists of harmonizing male vocals singing over plucked strings melody and wooden percussion. It sounds passionate and soulful, but the recording is very noisy and in mono. | 2009-12-19T20:50:04Z | alijk81 | `` Da Hujrey Mijlas `` | ["Music", "Middle Eastern music"] | ["low quality", "live performance", "traditional", "mono", "noisy", "wooden percussions", "plucked strings melody", "harmonizing male vocals", "passionate", "soulful"] | 4 | 8ZK1ajW598M | 930 | |
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 |
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;