musiccaps_details (view)
3 rows where musiccaps_aspects contains "double pedal kick" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Torneo de Arqueria Medieval 2009 - TAM 09 - (parte 3/3) | The low quality recording features a metal song that consists of female opera vocal singing over double pedal kick, punchy snare, energetic cymbals, wide electric guitar melody and groovy bass guitar. It sounds aggressive, energetic and upbeat. | 2010-06-03T19:25:50Z | produccionesCARM | Torneo de Arqueria Medieval 2009, organizado por el CUDA (Club Universitario de Arqueria) Septiembre de 2009 La calidad del video fue reducida para una mejor experiencia on-line | ["Music", "Speech", "Angry music"] | ["low quality", "metal", "punchy snare", "double pedal kick", "female opera vocal", "wide electric guitar melody", "groovy bass", "energetic cymbals", "aggressive", "upbeat", "energetic"] | 4 | 4QJktFv916o | 569 | |
| Theatre Of Tragedy - And When He Falleth | The Metal song features a low throaty male vocal singing over widely spread, aggressive and distorted electric guitars, groovy bass guitar, punchy snare, energetic cymbals and double pedal kick. In the second part of the loop, the instrumental calms down, as there is an arpeggiated piano melody over which a soft female vocal is singing. Overall it sounds energetic, aggressive and manic. The male vocal in the first part of the loop is leaning towards the left channel of the stereo image, making it sound unbalanced and therefore low quality. | 2007-12-23T07:18:07Z | cristianfleitas | Theatre Of Tragedy : And When He Falleth Album: Velvet Darkness They Fear | ["Music", "Angry music"] | ["metal", "low quality", "aggressive", "energetic", "manic", "throaty male vocal", "wide agressive distorted electric guitar melody", "arpeggiated piano melody", "soft female vocal", "punchy snare", "energetic cymbals", "double pedal kick", "groovy bass guitar", "unbalanced stereo image"] | 4 | RoDS0k7qrIo | 2726 | |
| 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;