musiccaps_details (view)
1 row where musiccaps_aspects contains "anger", musiccaps_aspects contains "booming sounds", musiccaps_aspects contains "chaotic" and musiccaps_aspects contains "medium fast tempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;