musiccaps_details (view)

1 row where musiccaps_aspects contains "fry scream", musiccaps_aspects contains "industrial effects", musiccaps_aspects contains "loud" and musiccaps_aspects contains "violent"

✎ 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
Static-X - Black And White This is an industrial metal piece. The male vocalist in the lead is singing using the fry scream technique. The distorted electric guitar is playing a heavy riff while there is a groovy bass line. There is a loud metal beat being played by the acoustic drums in the rhythmic background. Industrial sound effects can be heard which are distinctive to the industrial and nu metal scenes. The atmosphere is aggressive and energetic. This piece could be played at a rock/metal bar. It could also be included in the soundtrack of an action movie/video game. 2010-08-29T19:54:25Z Triggerself Lyrics: Lost in my own World Lost in my own World Lost in my Lost in my own World Lost in my own World Lost in my Getting to the right Getting to the wrong Getting mine Getting to the right Getting to the wrong Getting high Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Burning inside Burning inside Burning into white Burning inside Burning inside Burning into night Yourself collides Yourself collides Yourself into mine Yourself collides Yourself collides Yourself splinters like Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Blurring the light Blurring the light It's ours for the taking Flickering colors It's black and white ["Disco", "Jazz", "Music", "Pop music"] ["industrial metal", "nu metal", "male vocal", "fry scream", "distorted electric guitar", "bass guitar", "loud acoustic drums", "industrial effects", "aggressive", "energetic", "loud", "violent", "powerful"] 9 7OgH3B49_E4 842

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;