musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- live performance · 3 ✖
- percussive bass line · 3 ✖
- poor audio quality · 3 ✖
- emotional 2
- passionate 2
- rebellious 2
- screaming vocals 2
- adrenaline rush 1
- ambient room noise 1
- bass guitar 1
- death metal 1
- deteriorated audio 1
- deteriorated audio quality 1
- distorted guitar rhythm 1
- energetic 1
- fast metal drumming 1
- female singer 1
- groovy music 1
- guitar rhythm 1
- guitars strumming 1
- hard metal music 1
- harp player 1
- haunting 1
- head banging 1
- instrumental music 1
- jam session 1
- latin dance music 1
- latin percussions 1
- live audience 1
- male singer 1
- medium tempo 1
- metal band 1
- mosh pit 1
- noisy crowd 1
- retro death metal hits 1
- retro metal hits 1
- romantic 1
- screaming 1
- shakers percussions 1
- slick percussive rhythm 1
- spirited 1
- steady drumming rhythm 1
- steady rhythm 1
- studio live sessions 1
- teenage age angst 1
- traditional music 1
- vintage metal 1
musiccaps_names (array) 7 ✖
- Music 3
- Grunge 1
- Rock music 1
- Salsa music 1
- Singing 1
- Whoop 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
Canon 70D & Instrumental de Arpa (Instrumental Harp) | The song is an instrumental. The song is medium tempo with Latin percussions, guitar strumming rhythm, groovy bass line and keyboard percussions. The song is exciting and groovy. The song has poor audio quality. | 2014-02-25T04:22:49Z | Jimmy Pastrana | Arpa: Natanael Rios Cuatro: Ferney Cotinchara Bajo: Jimmy Pastrana Maracas: Elias Pertuz | ["Music", "Salsa music"] | ["latin dance music", "guitars strumming", "traditional music", "jam session", "emotional", "passionate", "romantic", "harp player", "poor audio quality", "percussive bass line", "steady rhythm", "bass guitar", "slick percussive rhythm", "studio live sessions", "instrumental music", "latin percussions", "shakers percussions", "groovy music", "live performance"] | 1 | aT7LGemDB40 | 3541 | |
김경호 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;