musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "snare rolls", musiccaps_aspects contains "throaty male vocal" and musiccaps_names contains "Angry music"
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
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;