musiccaps_details (view)
2 rows where musiccaps_aspects contains "deteriorated audio quality" and musiccaps_aspects contains "metal band"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- deteriorated audio quality · 2 ✖
- metal band · 2 ✖
- poor audio quality 2
- adrenaline rush 1
- amateur band 1
- amateur quality recording 1
- distorted guitar rhythm 1
- distortion 1
- energetic 1
- fast 1
- fast metal drumming 1
- guitar rhythm 1
- hard metal music 1
- head banging 1
- hissing tones 1
- instrumental music 1
- live performance 1
- male singer 1
- mosh pit 1
- noise 1
- noisy ambience 1
- noisy crowd 1
- percussive bass line 1
- rebellious 1
- retro metal hits 1
- screaming 1
- screaming vocals 1
- spirited 1
- vintage metal 1
youtube_published (date) 2 ✖
- 2007-11-25 1
- 2016-03-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breed Sheep(Nirvana cover)territorial pissings and love buzz | The song is an instrumental. The song is fast tempo with distorted guitars playing in rhythm. The song is energetic and an amateurish performance. The song is of very poor quality with audio noise and hissing sound. | 2007-11-25T17:53:33Z | Kurt (Breed Sheep) | Breed Sheep playing territorial pissings and love buzz | ["Music", "Buzz"] | ["poor audio quality", "noise", "distortion", "hissing tones", "noisy ambience", "instrumental music", "distorted guitar rhythm", "fast", "amateur quality recording", "deteriorated audio quality", "metal band", "amateur band"] | 1 | 2ZB7DUGOdZw | 377 | |
김경호 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 |
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;