musiccaps_details (view)
5 rows where musiccaps_aspects contains "double pedal kick", musiccaps_aspects contains "metal", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "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 |
|---|---|---|---|---|---|---|---|---|---|---|
| [Gakupo + KAITO] poetaster and singing dolls [Vocaloid][English Sub] sm8522045 | The Metal song features a distorted flat male vocal singing over wide aggressive electric guitar riffs, distorted bass guitar, punchy snare, double pedal kick and shimmering cymbals. It sounds energetic, aggressive and manic - like something you would go into a mosh pit for. | 2009-10-21T18:59:14Z | hokorichan | poetaster_and_singing_dolls_ Gakupo + KAITO version by maya & 藤代叶 (Fujishiro Kanae), original song by hazyP From Nico: http://www.nicovideo.jp/watch/sm8522045 Original Miku version: http://www.nicovideo.jp/watch/sm6230352 作詞・作曲：hazyP 編曲・ギター・MIX：maya 動画・調教：藤代叶 "Poetaster, like rhymester or versifier, is a contemptuous name often applied to bad or inferior poets. Specifically, poetaster has implications of unwarranted pretensions to artistic value. " Romaji: http://community.livejournal.com/vocalyric/81979.html#cutid1 | ["Music", "/t/dd00003", "Synthetic singing"] | ["metal", "double pedal kick", "punchy snare", "shimmering cymbals", "distorted flat male vocal", "wide aggressive electric guitar riff", "distorted bass guitar", "energetic", "aggressive", "distorted", "manic"] | 4 | 0OY8XXZ98rw | 157 | |
| 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 | |
| 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 | |
| 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;