musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and musiccaps_aspects contains "screaming" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- energetic · 2 ✖
- screaming · 2 ✖
- adrenaline rush 1
- aggressive 1
- deteriorated audio quality 1
- distorted bass guitar 1
- energetic cymbals 1
- fast metal drumming 1
- guitar rhythm 1
- hard metal music 1
- head banging 1
- live performance 1
- male singer 1
- manic 1
- metal 1
- metal band 1
- mosh pit 1
- noisy crowd 1
- percussive bass line 1
- poor audio quality 1
- punchy kick 1
- punchy snare 1
- rebellious 1
- repetitive aggressive male vocals 1
- retro metal hits 1
- screaming vocals 1
- spirited 1
- vintage metal 1
- wide aggressive electric guitar chords 1
- wide toms roll 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Whoop 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
김경호 shout 초반 샤우팅 연도별 모음 | A male singer sings this screaming metal melody. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line and guitars playing accompaniment. The song is rebellious and highly spirited. The audio quality is very poor and vintage. | 2016-03-01T09:07:30Z | 갓경호 | 김경호 shout 초반 샤우팅 연도별 모음1998/1999/2000/2001/2002/2003/2004/2005/2009/2010/2011/2014 | ["Music", "Whoop"] | ["hard metal music", "male singer", "screaming vocals", "vintage metal", "metal band", "deteriorated audio quality", "head banging", "mosh pit", "retro metal hits", "screaming", "noisy crowd", "live performance", "fast metal drumming", "guitar rhythm", "percussive bass line", "energetic", "adrenaline rush", "poor audio quality", "spirited", "rebellious"] | 1 | g75kz9ffcg0 | 4007 | |
Endo - Suffer (Official Music Video) | The Metal song features a repetitive, aggressive male vocal screaming over wide, aggressive electric guitar chords, distorted bass guitar, punchy snare and kick hits and energetic cymbals. There is a toms roll at the end of the loop. It sounds aggressive, energetic and manic - like something you would jump into a mosh pit at the concert. | 2008-01-14T16:17:42Z | cucuzza21 | This is the official music for Endo's song "Suffer" off their debut album "Evolve". Enjoy! | ["Music", "Angry music"] | ["metal", "wide aggressive electric guitar chords", "repetitive aggressive male vocals", "screaming", "distorted bass guitar", "punchy snare", "wide toms roll", "energetic cymbals", "aggressive", "energetic", "manic", "punchy kick"] | 4 | w6zHc6nRJ0o | 5242 |
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;