musiccaps_details (view)
3 rows where musiccaps_aspects contains "haunting", musiccaps_aspects contains "instrumental" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- haunting · 3 ✖
- instrumental · 3 ✖
- grim 2
- intense 2
- amateur recording 1
- ambient sounds 1
- amplified organ 1
- bagpiper 1
- bellows-blown bagpipe 1
- chamber instrument 1
- chanting 1
- didgeridoo harmony 1
- droning 1
- echoes 1
- eerie 1
- emotional 1
- fast tempo 1
- humming melody 1
- hypnotic 1
- lilting 1
- live audience 1
- live performance 1
- loud 1
- male vocalisation 1
- medium fast tempo 1
- passionate 1
- pendulum choir 1
- people talking 1
- psychedelic 1
- resonating 1
- resounding 1
- resounding voices 1
- rhythmic foot tapping 1
- sad 1
- sinister 1
- slow tempo 1
- small pipe harmony 1
- static 1
- synthesiser arrangement 1
- timer clicking 1
- timer ticking 1
- trance 1
- trippy 1
- viloin harmony 1
- vocalisation 1
- woodwind 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fred Morrison | This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. | 2010-02-12T22:46:03Z | Doug Henkle | Recorded on February 6, 2010 using a Flip Video camcorder. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] | 7 | IbD0zpcimgM | 1921 | |
Ocarina of Time - Inside the Deku Tree (Zelda Reorchestrated) | This audio clip is an instrumental. The tempo is low with a subtle violin harmony, keyboard arpeggio and synthesised organ. The music is lilting, grim,incessant, intense, sad, bleak, enigmatic and ambiguous. The music sounds like the background score for a movie. | 2010-05-12T04:01:41Z | MusicOfZelda | http://zreomusic.com The Ocarina of Time was original composed: Koji Kondo. | ["New-age music", "Music"] | ["instrumental", "slow tempo", "viloin harmony", "amplified organ", "lilting", "haunting", "echoes", "intense", "synthesiser arrangement", "grim", "sad"] | 7 | asT8yaJPP1s | 3582 | |
Pendulum Choir | This music is instrumental. The tempo is medium fast with an incessant droning of the didgeridoo, sound of a timer ticking and male vocals like a chant. The music is eerie, creepy, spooky, sinister, scary, hypnotic, trance like and fear inducing with resounding effect. | 2011-10-02T15:46:31Z | codactdecosterd | Concert/performance - Cod.Act 2011 - www.codact.ch | ["Music", "Choir"] | ["instrumental", "vocalisation", "medium fast tempo", "pendulum choir", "resonating", "resounding", "timer ticking", "didgeridoo harmony", "male vocalisation", "resounding voices", "timer clicking", "intense", "grim", "sinister", "chanting", "psychedelic", "hypnotic", "eerie", "haunting", "trance", "trippy"] | 7 | vsXs3GUrw64 | 5215 |
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;