musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "messy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- energetic 2
- flat male vocal · 2 ✖
- low quality 2
- messy · 2 ✖
- punchy kick 2
- punchy snare 2
- rock 2
- aggressive drum cymbals 1
- distorted bass guitar 1
- electric guitar slide 1
- electric guitars melodies 1
- energetic cymbals 1
- groovy bass guitar 1
- harsh 1
- live performance 1
- muddy 1
- noisy 1
- shimmering hi hats 1
- short snare rolls 1
- sloppy 1
- wide electric guitar chords 1
musiccaps_names (array) 6 ✖
- Music 2
- Heavy metal 1
- Psychedelic rock 1
- Rock music 1
- Rustling leaves 1
- Singing 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 | |
Deep Purple- Perfect Strangers Live | The low quality recording features a live performance of a rock song that's sung by flat male vocals and played by electric guitars, groovy bass guitar and energetic drums that consists of punchy kick and snare hits and some short snare rolls, energetic cymbals and shimmering hi-hats. At one point in the loop, it seems that the drummer fell out of rhythm, so it kind of sounds sloppy. It also sounds very noisy, messy, muddy, but still energetic too. | 2007-08-14T22:42:57Z | NaturallyStoopid | One of the best performances of Deep Purple And I am proud to add them to my channel. This was performed in 2002 And is part of the DVD "PERIHELION". The Line-up Consists of Ian Gillan (vocals), Steve Morses (lead), Roger Glover (bass), Jon Lord (Keyboards) and Ian Paice (drums) Unfortunately the only way for me to get a dvd recording onto youtube for free is to use a service which only allows you to add each part by 30 seconds so it took a long time to put up but please enjoy one of THE best performances of this line up with an added keyboard solo/s | ["Singing", "Music", "Psychedelic rock", "Rock music"] | ["low quality", "noisy", "live performance", "rock", "electric guitars melodies", "groovy bass guitar", "flat male vocal", "energetic cymbals", "punchy snare", "short snare rolls", "punchy kick", "sloppy", "energetic", "shimmering hi hats", "messy", "muddy"] | 4 | CMfAu72qma0 | 1357 |
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;