musiccaps_details (view)
4 rows where musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Heavy metal"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| blues solo in A tokai les paul and marshall jcm900 dual reverb combo | The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. | 2014-03-06T23:42:30Z | Dave Hardy | Dave does a blue in A from a tracker off youtube.The guitar is a modded tokai/gibbo love rock with seymor duncan sh5 and warman p90.The amp is a 1992 Marhall 100 watt dual reverb combo.The effects and pedals are named as he uses them. | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] | ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] | 4 | -OAyRsvFGgc | 41 | |
| When We Team Up - 5,000 Candles In The Wind | The low quality recording features a rock song that consists of wide electric guitar chords, punchy kick and snare, electric guitar slide, distorted bass guitar, aggressive drums cymbals and flat male vocals singing over it. It sounds energetic, but also harsh and messy thanks to those cymbals. | 2013-01-01T17:33:25Z | WhenWeTeamUp | Hey everyone, we are a Pacific Northwest Pop Punk band called When We Team Up. This is the first track off of our debut Ep " Not For Me, But For My Friends" that comes out on January 22nd of 2013. Head over to Facebook.com/WhenWeTeamUp and like us if you like what you hear!!! | ["Heavy metal", "Music", "Rustling leaves"] | ["rock", "energetic", "low quality", "wide electric guitar chords", "aggressive drum cymbals", "punchy kick", "punchy snare", "electric guitar slide", "distorted bass guitar", "flat male vocal", "harsh", "messy"] | 4 | 7jWRIjFaoeU | 875 | |
| Fed Up - "So Stupid" | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | 2007-05-04T20:57:37Z | f1rstperson | This was the first music video I ever edited and filmed. It is simply awful, but it's fun too look back at the process and realize the things we learn. The band Fed Up was from Kansas City...this song was off their first EP....and they grew to be one of the best punk rock bands around (in my opinion). Check out the other video I did for them 3 years later...called "When Looking Back". | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | 4 | ARXTRdKCupM | 1115 | |
| KISS - Psycho Circus (Live 1998) | The low quality recording features a live performance of a rock song that features wide electric guitar chords, distorted bass, reverberant toms, punchy kick hits and energetic crash cymbals. There are a few electric guitar slides. The recording is very noisy and it sounds energetic. | 2007-03-22T02:19:12Z | reverendcuntbag | KISS - Psycho Circus Live 1998 on Fox TV Halloween Party | ["Heavy metal", "Music", "Angry music"] | ["low quality", "rock", "wide electric guitar chords", "distorted bass guitar", "reverberant toms", "punchy kick", "energetic crash cymbal", "live perforamnce", "energetic", "noisy", "electric guitar slide"] | 4 | iCHskFoUvbw | 4167 |
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;