musiccaps_details (view)

1 row where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "groovy distorted bass guitar", musiccaps_aspects contains "metal" and musiccaps_aspects contains "shimmering hi hats"

✎ 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
Testament - Eerie Inhabitants The Metal song features a manic solo electric guitar melody over shimmering hi hats, shimmering crash cymbals, double pedal kick hits, punchy snare, groovy distorted bass guitar and aggressive electric guitar riffs. It sounds aggressive, manic and energetic - like something you would jump to at the concerts. 2009-04-26T05:02:15Z TestAmenTtoons Testament - 1. Eerie Inhabitants - The New Order [Music: Peterson, Skolnick / Lyrics: Skolnick, Billy, Peterson] A world of chaos A world of fear A world of anger and corruption When all is lost And millions starve Is this humanity's destruction? Life! A game that people play Cryout! Will they see another day? No one help us, The children pray Nobody listens to their crying This great depression When will it end? To live like this is worse than dying Life! A game that people play Cryout! Will they see another day? Your destiny is over Your fate has declined Refuse to discover What so many could find Death's endless toil As I long for rest Life's now forsaken Condemned to repress! No sign of Heaven No sign of Hell Just the sign of pain and sorrow This generation inhabits all To form an order for tomorrow Life! A game that people play Cryout! Will we see another day? ["Music", "Cacophony"] ["metal", "energetic", "manic solo electric guitar melody", "shimmering hi hats", "shimmering crash cymbals", "double pedal kick", "punchy snare", "groovy distorted bass guitar", "aggressive electric guitar riffs", "aggressive", "manic"] 4 OEuBITrf-kE 2417

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;