musiccaps_details (view)

1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "metal", musiccaps_aspects contains "snare rolls" and musiccaps_aspects contains "wide aggressive distorted electric guitars"

✎ 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
Lost Eden - Forsaken Last The low quality recording features a metal song that consists of wide aggressive, distorted electric guitars, distorted bass, clean electric guitar solo melody, energetic crash cymbals, punchy snare, double pedal kick and throaty male vocal talking and screaming over it. There are some energetic snare rolls that serve as a breakbeat and transition to the next section. It sounds energetic, aggressive and manic. Putting the vocal so low in the mix, makes it a low quality sound. 2009-03-21T21:41:49Z MoshGoth Great melodic death metal/metalcore from Japan. Taken from their album Cycle Repeats I know that it stops before the video does, it's because movie maker failed somwhow and showed that the song still goes on. LYRICS: I'm the Forsaken last to eternity. This world navigates' its down' I search for the lost illusion. It makes me feel mad. Numb with cold, overflowing, out of control. It makes me feel alone. Continuous cry. It's for myself. Don't erase me. I'm the forsaken last call. Continuous cry. It's for my sake. I'm here. Seek me, notice me. Missing link' Lost place' The black past put me out' Fall' That steals up as shadow of suffocation. It makes me see the truth. Out of mind, out of sight, out of control. It makes me fade out. Continuous scream. It's for myself. If you erase me, I'll still rise over again Continuous cry. It's for my sake. I'm here. Seek me, notice me. ["Heavy metal", "Music", "Angry music"] ["low quality", "metal", "wide aggressive distorted electric guitars", "solo clean electric guitar melody", "distorted bass guitar", "throaty male vocal", "energetic crash cymbals", "punchy snare", "snare rolls", "double pedal kick", "energetic", "manic", "aggressive"] 4 f5eMUCSZCjc 3920

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;