musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- live performance · 2 ✖
- low quality 2
- punchy snare · 2 ✖
- rock 2
- aggressive electric guitar chords progression 1
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- emotional 1
- energetic 1
- energetic crash cymbal 1
- gated 1
- groovy 1
- groovy bass guitar 1
- harmonizing male vocals 1
- instrumental 1
- messy 1
- noisy 1
- passionate male vocal 1
- punchy kick 1
- reverberant 1
- shimmering hi hats 1
- shimmering open hats 1
- short snare roll 1
- simple kick pattern 1
musiccaps_names (array) 7 ✖
- Music 2
- Punk rock · 2 ✖
- Bass guitar 1
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;