musiccaps_details (view)
1 row where musiccaps_aspects contains "electronic percussion", musiccaps_aspects contains "menacing" and musiccaps_names contains "Synthesizer"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mechwarrior 2 Mercenaries 12 Tick Tock | This is an instrumental electronic music piece. It has a high-pitched synth bass playing in a dissonant manner as the lead. The background consists of an ambient synth that is constantly switching between two chords and electronic percussion that keeps on reverberating. The dissonance and the character of the sounds create a very eerie atmosphere that is the perfect fit for a dystopian video-game soundtrack. | 2011-04-17T20:55:06Z | phillippi2sgaming | The Mechwarrior 2 soundtrack is the score to the second installment of Activision's Battletech-based sci-fi strategy/simulation Mechwarrior series. It received near universal praise from game reviewers and has been described as one of the greatest game soundtracks of all time. It is generally considered to be a cult classic of game music.[1][2] The music was stored as standard audio CD tracks allowing the music to be played on a standard Audio CD player. Track one contains the program data and should be skipped. The Soundtrack was composed by Gregory Alper & Jeehun Hwang, who has composed music for numerous PC games. A remix version of the song entitled "Labrea, Circle of Equals (Trial of Grievance)" (aka "Arkam Bridge") was used later in Civilization II in the Hoover Dam Wonder video. The track listings below reflect the original 1.0 DOS PC-releases of the games. Some variations of the games have the same music while others deviate. For instance, the Titanium version of the original game has the same tracks arranged in a different order, the Titanium version of Ghost Bear's Legacy has five tracks replaced with new material, and the Titanium version of Mercenaries has roughly a minute truncated from the end of most every track; the 1.05 standard DOS/Win95 version of Mercenaries also does this. The PSX release of the original game borrows the heavy metal tracks from Mercenaries. | ["Music", "Tick", "Synthesizer", "Electronica"] | ["electronic", "instrumental", "synth", "bass", "electronic percussion", "repeated theme", "dissonant", "eerie", "menacing", "bizarre", "robotic"] | 9 | JPVRBbdykSw | 2002 |
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;