musiccaps_details (view)

1 row where musiccaps_aspects contains "electronic percussion", musiccaps_aspects contains "robotic" and musiccaps_names contains "Synthesizer"

✎ View and edit SQL

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

CSV options: 

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;