musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mystical"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- live performance · 3 ✖
- mystical · 3 ✖
- low quality 2
- arpeggiate synth keys melody 1
- calming 1
- celtic music 1
- crowd excitement 1
- crushed 1
- distorted bass 1
- fantasy 1
- harmonizing mixed vocals 1
- harsh 1
- irish folk music 1
- irish traditional music 1
- mono 1
- noisy 1
- passionate 1
- passionate male vocal 1
- soothing 1
- soulful 1
- suspenseful 1
- sustained pad synth 1
- sustained suspenseful strings melody 1
- sweet sounding melody 1
- sweet tone 1
- traditional 1
- uillean pipes 1
- unbalanced stereo 1
- wooden percussive elements 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Rescues - Shout by Tears for Fears | The low quality recording features a live performance that consists of harmonizing mixed vocals singing over distorted bass and arpeggiated synth keys melody. It sounds crushed, harsh and the stereo image is unbalanced since the sound is leaning towards the right channel of the stereo image. There are some crowd excitement sounds in the background. | 2009-08-30T15:17:59Z | thevmannc | New Project 1 | ["Music", "Whoop"] | ["low quality", "harmonizing mixed vocals", "harsh", "live performance", "distorted bass", "arpeggiate synth keys melody", "crushed", "crowd excitement", "unbalanced stereo", "mystical"] | 4 | DKBbLySEGic | 1463 | |
Uilleann Pipes - John McSherry - Doinna - Celtic Air | In this clip we have a set of uilleann pipes being used to play a sweet and enchanting melody. It's a live performance. There's a sustained pad synth which also sounds ethereal, being used to support the uilleann pipes. This is traditional Irish or Celtic folk music. The song is emotional and captivating, with a slow tempo. | 2009-06-06T00:18:50Z | John McSherry | Celtic Slow Air 'Doinna' performed by John McSherry on Uilleann Pipes. Written by Jacky Molard. Celtic Irish Breton traditional music Thanks for watching and subscribing! :-) Albums available here - https://www.johnmcsherry.com/ https://www.facebook.com/johnmcsherry | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["uillean pipes", "live performance", "irish traditional music", "irish folk music", "sweet tone", "sweet sounding melody", "soothing", "calming", "celtic music", "mystical", "fantasy", "sustained pad synth"] | 3 | GzRvq0gJbj0 | 1769 | |
Great Ghazal Singer Ahmad Wali with Siar Hashimi on Tabla | The low quality recording features a live performance of a traditional song that consists of wooden percussive elements, sustained suspenseful strings melody and passionate male vocal singing over it. It sounds passionate, mystical, soulful and suspenseful, even though the recording is a bit noisy and in mono. | 2009-03-05T15:38:49Z | TaalPanchamSawari | Ghazal Tabla: Siar Hashimi Taal: Kehrwa | ["Tabla", "Percussion"] | ["mono", "noisy", "low quality", "traditional", "live performance", "wooden percussive elements", "sustained suspenseful strings melody", "passionate male vocal", "soulful", "passionate", "mystical", "suspenseful"] | 4 | yx7BZ_djE-U | 5449 |
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;