musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "manic" and musiccaps_aspects contains "snare rolls" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- low quality 2
- manic · 2 ✖
- snare rolls · 2 ✖
- aggressive 1
- distorted bass guitar 1
- double pedal kick 1
- energetic 1
- energetic crash cymbals 1
- energetic cymbals 1
- energetic muffled drums 1
- filtered echoing flat male vocal 1
- groovy bass 1
- metal 1
- muffled 1
- punchy snare 1
- rock 1
- solo clean electric guitar melody 1
- throaty male vocal 1
- uptempo electric guitar melody 1
- wide aggressive distorted electric guitars 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Heavy metal 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Toy Dolls - PC Stoker | The low quality recording features a rock song that consists of filtered echoing flat male vocals, energetic muffled drums, energetic cymbals, snare rolls, uptempo electric guitar melody and groovy bass. It sounds manic and muffled, like it lacks the bass and overall frequency balance. | 2007-11-01T06:29:55Z | MBSS20 | Check out some punk gear: https://www.occultpunkshirts.com/one-offs.html The Toy Dolls Video of PC Stoker 1986 Promo. | ["Music", "Roll"] | ["low quality", "rock", "filtered echoing flat male vocal", "energetic muffled drums", "energetic cymbals", "snare rolls", "manic", "uptempo electric guitar melody", "groovy bass", "muffled"] | 4 | bpwO0lbJPF4 | 3655 | |
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;