musiccaps_details (view)

1 row where musiccaps_aspects contains "chanting", musiccaps_aspects contains "repetitive rhythm", musiccaps_aspects contains "synthesiser articulation" and musiccaps_author = 7

✎ 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
The Speed Freak - Misanthrope This song has a heavily synthesised voice singing a rhythmic melody. The tempo is medium fast with synthesiser arrangements, punchy drumming, groovy bass lines and electronic instrumentation, with enthusiastic vocal backup. The song is vibrant, youthful, trance-like because of the insistent, monotone, chanting nature of the melody. This song is EDM/Synth pop. 2010-03-23T21:59:30Z MusicalIllness Label: Mokum Records Catalog#: MOK 119 Format: Vinyl, 12", 45 RPM, 33 ⅓ RPM Country: Netherlands Released: Nov 2009 Genre: Electronic Style: Hardcore, Gabber Real Name: Martin Damm Profile: Martin Damm has been releasing records since 1990 under various project names, the most recurrent ones being Biochip C., Speedfreak, and Search & Destroy. Starting off making german-style EBM techno, he soon became part of the Cologne school around walker, and released on labels such as Monotone, Force Inc., and Dj.ungle Fever. After his increased popularity especially with the dutch gabber scene in 1994 and 1995, Mokum and Shockwave became his home labels. His musical activities however stretch much further - tracks from his studio can be found on lots of different labels and on dozens of cd compilations. Apart from his further involvement in several labels such as Ozon (with Jammin' Unit), Napalm (plus its sublabels Agent Orange and Speedcore) and Anodyne (plus the defunct Biophobia), he is also available for live and deejay gigs. furthermore, he has started to produce his own videos and CD-ROM parts. Part of what makes the music of Martin Damm interesting is his versatility. The tracks coming from his studio, Biosfear, stylistically stretch over the whole area of electronic dance music - going from power acid to breakcore, from drum & bass to happy gabber, from straight techno to dubby trip hop. Fans will rave about the squiggly 303 programming, the bouncy kickdrums and clattering breakbeats, the powerful and dense yet transparent overall sound, the wonderfully witty combinations and structures, the overwhelming wealth of amazing sound ideas and little melodies, and last not least the cynically cheesy organs and shameless sampling. ["Music", "Sidetone"] ["electronic vocals", "fast tempo", "chanting", "psychedelic", "monotone", "insistent", "repetitive rhythm", "psychedelic", "synth pop", "edm", "recurring rhythm", "monotone", "vocal backup", "robotic voice", "trippy", "trance", "psychedelic", "freaky", "edm", "heavy auto tune", "punchy", "bouncy", "synthesiser articulation", "enthusiastic drumming", "tambourine beats", "funky bass lines", "table turner", "electronic music", "digital drum", "youthful", "contemporary", "dance groove", "club music", "party music"] 7 WhEd8h7J0Lk 3125

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;