musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro rock" and musiccaps_aspects contains "synthesiser arrangements" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- electro pop 2
- electro rock · 2 ✖
- instrumental 2
- synthesiser arrangements · 2 ✖
- aggressive 1
- anger 1
- booming sounds 1
- boomy bass drops 1
- buoyant 1
- catchy vocal riff 1
- chaotic 1
- club music 1
- confusion 1
- cunfusion 1
- cymbal rides 1
- dance groove 1
- dance music 1
- distorted music 1
- distorted sound 1
- distorted voice 1
- dj 1
- edm 1
- eerie 1
- electronic instrumentation 1
- female vocals 1
- goth 1
- goth rock 1
- high strung 1
- inferior sound quality 1
- intense 1
- medium fast tempo 1
- party music 1
- punchy youthful 1
- sinister 1
- sound of guns 1
- syncopated melody 1
- threatening 1
- vibrant 1
- video game music 1
- vigorous drumming 1
musiccaps_names (array) 9 ✖
- Music 2
- Angry music 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Shuffle 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
endless squad SHUFFLE | A female vocalist sings this high energy pop song. The tempo is fast with vigorous drumming, synthesiser arrangements and boomy bass drops. The song is vibrant, lively, spirited, buoyant, punchy and youthful with a catchy vocal riff. The sound quality of this song is inferior and distorted. This song is an EDM/Synth Pop song. | 2011-08-12T07:05:36Z | omingendless | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music"] | ["instrumental", "vibrant", "high strung", "female vocals", "punchy youthful", "dance groove", "inferior sound quality", "distorted sound", "catchy vocal riff", "electro rock", "electro pop", "edm", "distorted music", "synthesiser arrangements", "dj", "dance music", "party music", "club music", "vibrant", "buoyant", "boomy bass drops"] | 7 | YWf3I4jKusI | 3291 |
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;