musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_names contains "Cymbal" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 29 ✖
- energetic · 3 ✖
- aggressive 1
- aggressive tom rolls 1
- bass guitar 1
- distorted electric guitar 1
- dub 1
- fast tempo 1
- fuzzy electric guitar 1
- groovy bass guitar 1
- grungy gritty electric guitar 1
- hard metal 1
- hard rock 1
- instrumental 1
- intense 1
- loud acoustic drums 1
- low quality 1
- metal rock 1
- potent 1
- punchy kick 1
- punchy snare 1
- punk rock 1
- rapid kick drum 1
- reverberant 1
- ride cymbals 1
- rock 1
- shimmering shakers 1
- soft ride cymbals 1
- violent 1
- wide electric guitar melody 1
musiccaps_names (array) 9 ✖
- Bass drum 3
- Cymbal · 3 ✖
- Drum 3
- Drum kit 3
- Drum roll 3
- Hi-hat 3
- Percussion 3
- Rimshot 3
- Snare drum 3
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
OSET MX-10, 24.0, Chris Northover at the 2014 Dirt Bike Show! | The low quality recording features a rock song that consists of wide electric guitar melodies, groovy bass guitar, shimmering shakers, punchy snare and kick hits, followed by aggressive tom rolls. It sounds energetic and the drums are reverberant, as they were probably recorded in a medium size drum room. | 2014-11-14T23:12:45Z | OSET Bikes | A run-down of OSET at the 2014 International Dirt Bike Show. This was the debut for the MX-10 mini motocross bike, and for the 24.0 24" concept bike. Both got lots of attention! This video shows both, and the OSET demo Team - including Chris Northover - in action. | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "rock", "aggressive tom rolls", "wide electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering shakers", "soft ride cymbals", "punchy snare", "energetic", "reverberant"] | 4 | Wu3LKQG1fwU | 3147 | |
Hot Sessions Remastered: Suicide Silence - "Wake Up" | Here we get to hear a hardcore metal piece. This is characterised, in part, by the rapid action on the kick drum - with notes being played at a rate of sixteenth notes on the kick. The drummer also frequents the ride cymbal. The guitar is grungy, gritty, fuzzy, heavy, deep, hardcore. | 2012-01-04T18:59:45Z | hottopic | Shop Suicide Silence: http://tinyurl.com/7h6bvks Hot Sessions Remastered takes us back to 2009, where Suicide Silence took the Hot Topic stage in support of "No Time To Bleed." In part three they perform the album opener "Wake Up." | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["metal rock", "hard rock", "hard metal", "rapid kick drum", "ride cymbals", "grungy gritty electric guitar", "fuzzy electric guitar", "intense", "potent", "energetic"] | 3 | 5KvjUzQbMT4 | 654 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 |
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;