musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_author = 3 and musiccaps_names contains "Drum kit" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
musiccaps_names (array) 15 ✖
- Drum kit · 2 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum roll 1
- Hi-hat 1
- Music 1
- Musical instrument 1
- Percussion 1
- Rimshot 1
- Rock and roll 1
- Rock music 1
- Shout 1
- Snare drum 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 |
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;