musiccaps_details (view)
4 rows where musiccaps_aspects contains "confusion"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Fraktal Noise - Paranoic Disaster | The song is an instrumental abstract piece. The song is medium tempo but with no actual pulse, whizzing sounds, shaker tones and buzzing noise and keyboard tones.The song is chaotic and highly experimental. The song is a psychedelic instrumental like a music Rorschach test. | 2012-01-06T22:42:55Z | trancecryption | VA - Happy My Life (2009) Compiled by Fullmoon Mondo 01 Kerosene Club - Shiva Dynamo 02 Kashyyyk - Crazy Story 03 Cosmo - Rhythmic Behavior 04 Ectogasmics - Ectoplasma 05 Fraktal Noise - Paranoic Disaster 06 Ankur - Weniger Ist Mehr Mit Mehr 07 Stranger - Night Wanderers 08 Highko vs Mondo - Berlin 09 Gu - May Day 10 Fullmoon Project - Eclipse Image: http://www.fractal-wallpapers.com/bulkupload/wallpapers/Fractal%20Wallpapers/dark-fractal-wallpaper.jpg | ["Electronic music", "Music", "Noise"] | ["experimental music", "whizzing tones", "brain exercise", "neurological test patterns", "paranoia", "white noise tones", "brain experiment", "musical rorschach", "no pulse", "scientific", "experiment", "no percussion pulse", "fractal music", "psychedelic music", "randomness", "tonal buzzes", "confusion", "chaos", "abstract music", "science experiment", "whizzing tones", "keyboard tones", "tonsl buzzz"] | 1 | AAoqx07aTRI | 1078 | |
| Diamanda Galas - O Death | The track features a scary and confused atmosphere. A female singer with a grating voice screams incomprehensive vocals. A piano accompanies the vocals. The track is simple but has a strong presence. | 2009-01-20T05:19:24Z | SirenOfTheSeas | from the album Guilty Guilty Guilty | ["Singing", "Yodeling", "Music"] | ["female singer", "screaming vocals", "piano chords", "scary", "dark", "grating female vocals", "confusion"] | 5 | Cchf2QH63bI | 1383 | |
| Genesis - Cinema Show (second part) live | This music is an upbeat instrumental. The tempo is fast with keyboard harmony, enthusiastic drumming and electronic arrangements. The harmony sounds like a synthetic sound of a bagpiper . The music is chaotic, quirky, playful, and cheerful. | 2006-08-31T18:22:42Z | lies112 | Genesis playing the Cinema Show in concert | ["Music", "Rock music", "Progressive rock"] | ["instrumental", "fast tempo", "keyboard harmony", "electronic music", "quirky", "confusion", "upbeat", "electronic arrangements", "playful", "animated", "bagpiper sound", "hard hitting drums", "chaotic music"] | 7 | KU2bOYiBX28 | 2086 | |
| BORN OF OSIRIS - Two Worlds Of Design | A male vocalist sings this aggressive song. The tempo is medium fast with electronic music; vigorous drumming, cymbal ride; synthesiser arrangements, distorted menacing vocals and electronic music. The song is angry, aggressive, sinister, menacing, spine-chilling and chaotic. This song is a Goth Rock/Hard Metal song. | 2011-06-07T23:49:14Z | Sumerian Records | FOLLOW BORN OF OSIRIS https://www.facebook.com/bornofosiris https://twitter.com/booofficial https://www.instagram.com/boocrue FOLLOW SUMERIAN RECORDS http://sumerianrecords.com http://facebook.com/sumerianrecords https://twitter.com/SumerianRecords https://www.instagram.com/sumerianrecords — — Lyrics: Will we ever really learn of our creation Or will this century Claim the natural domain Breakaway at a point when it's too late Now the course is set And our destination is our fate A lesson learned will not remain Gone past your call See the complex set You must explorate Toward the promise land The purity has taken leave with The modern age supremacy Manipulate the siege Grant me the means to Render useless, the machines We are falling into the circles The smallest pieces Are taking shape and taking charge We combine two worlds of design Never thought connecting I left myself inside the wires We combine to worlds of design Try living out in the open The slightest change Equals time inside the wires The harmony of nature Within the body of knowledge Find life in the consequence of discovery But there's still a mystery that blinds. | ["Music", "Angry music"] | ["instrumental", "medium fast tempo", "booming sounds", "chaotic", "cunfusion", "intense", "anger", "threatening", "goth rock", "electronic instrumentation", "synthesiser arrangements", "vigorous drumming", "sound of guns", "distorted voice", "sinister", "eerie", "goth", "aggressive", "syncopated melody", "chaotic", "confusion", "video game music", "electro pop", "electro rock", "cymbal rides"] | 7 | M2iOUwFHv9Q | 2238 |
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;