musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Heavy metal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic · 3 ✖
- low quality 3
- punchy kick · 3 ✖
- distorted bass guitar 2
- electric guitar slide 2
- punchy snare 2
- rock 2
- wide electric guitar chords 2
- aggressive 1
- aggressive drum cymbals 1
- aggressive electric guitar riffs 1
- drum sticks countdown 1
- energetic crash cymbal 1
- energetic cymbals 1
- flat male vocal 1
- groovy 1
- groovy bass guitar 1
- harsh 1
- live perforamnce 1
- messy 1
- noisy 1
- punk 1
- reverberant toms 1
- shimmering hi hats 1
musiccaps_names (array) 8 ✖
- Heavy metal · 3 ✖
- Music 3
- Angry music 1
- Bass guitar 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Rustling leaves 1
youtube_published (date) 3 ✖
- 2007-03-22 1
- 2007-05-04 1
- 2013-01-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;