musiccaps_details (view)

1 row where musiccaps_aspects contains "gurtural vocals", musiccaps_aspects contains "heavy metal" and musiccaps_names contains "Music"

✎ 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
Solemn Promise - Leave The Rats Behind The heavy metal music features a guttural male voice. The sound is aggressive and energetic. The background has a dark tonality that contrasts the heavily distorted guitars that strum chords. An aggressive drum kit plays a common heavy metal beat in the background. This is a song you could hear at a monster truck show. 2013-10-14T19:37:15Z SolemnPromiseMusic Get Solemn Promise's debut EP 'Worse Than Death' DOWNLOAD (name your price / free): http://www.solemnpromise.bandcamp.com PHYSICAL COPY / MERCH: http://www.solemnpromise.bigcartel.com LYRICS: Eyes burn green. Staring at me. Get what you earn. You want what you can't have. You're too weak to carry the weight of your words. Your teeth are blunt and blunt teeth don't dig deep. This is true heart, you have no heart. A poison mouth and glare won't stop me. So clear out your mouth and avert your eyes. Leave the rats in the sewer like the filth they are. You're on higher ground. Leave the rats behind. Say it to my fucking face. Sever the tongue and burn the roots. Eyes burn green. Get what you earn. Leave the fucking rats behind, leave you in the fucking dust. Your words mean nothing. FACEBOOK: http://www.facebook.com/SolemnPromiseMusic TWITTER: http://www.twitter.com/SolemnPromise BANDCAMP: http://www.solemnpromise.bandcamp.com BIGCARTEL: http://www.solemnpromise.bigcartel.com ["Heavy metal", "Music", "Progressive rock", "Grunge"] ["heavy metal", "hard rock", "aggressive drum kit", "heavily distorted aggressive electric guitar", "dark ambience background", "gurtural vocals", "dark", "energetic", "mid tempo"] 5 Wu-Oh9OJIlI 3146

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;