musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live performance" and musiccaps_names contains "Grunge" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- live performance · 2 ✖
- aggressive electric guitar chords progression 1
- ambient room noise 1
- death metal 1
- deteriorated audio 1
- distorted guitar rhythm 1
- emotional 1
- energetic 1
- energetic crash cymbal 1
- female singer 1
- gated 1
- groovy bass guitar 1
- haunting 1
- instrumental 1
- live audience 1
- low quality 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- punchy snare 1
- rebellious 1
- retro death metal hits 1
- reverberant 1
- rock 1
- screaming vocals 1
- shimmering hi hats 1
- short snare roll 1
- simple kick pattern 1
- steady drumming rhythm 1
- teenage age angst 1
musiccaps_names (array) 8 ✖
- Grunge · 2 ✖
- Music 2
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Singing 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 | |
AC/DC Sink The Pink (NO FLY DVD) | The low quality recording features a live performance of a rock song that consists of aggressive electric guitar chord progression, punchy snare, simple kick pattern, shimmering hi hats, energetic crash cymbal and a groovy bass guitar. At the very beginning the sound is gated, leaving only the distant, reverberant guitar chords and punchy snare hits audible. There is also a short snare roll, right before the drop. This instrumental is very energetic and exciting. | 2012-05-05T12:57:36Z | tekka018 | (Old DVD project). New project teaser and links here: https://youtu.be/nYo9WKbX0so?list=PLr3l5U7yFV_e1jVci8eAuIorhvhluA-fB | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["rock", "low quality", "gated", "aggressive electric guitar chords progression", "punchy snare", "simple kick pattern", "shimmering hi hats", "short snare roll", "energetic crash cymbal", "groovy bass guitar", "instrumental", "live performance", "energetic", "reverberant", "energetic"] | 4 | Ls6qMcgpdlM | 2227 |
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;