musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic cymbals", musiccaps_aspects contains "live performance" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- energetic 2
- energetic cymbals · 2 ✖
- live performance · 2 ✖
- low quality 2
- punchy snare 2
- aggressive 1
- aggressive electric guitar melodies 1
- crowd cheering 1
- distorted bass guitar 1
- electric guitars melodies 1
- flat male vocal 1
- groovy bass guitar 1
- manic drums 1
- messy 1
- metal 1
- muddy 1
- noisy 1
- punchy double pedal kick 1
- punchy kick 1
- rock 1
- shimmering hi hats 1
- short snare rolls 1
- sloppy 1
musiccaps_names (array) 8 ✖
- Music 2
- Rock music · 2 ✖
- Angry music 1
- Drum 1
- Guitar 1
- Heavy metal 1
- Psychedelic rock 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Pagan's Mind - God's Equation (Live at ProgPower USA X)(HD) | The low quality recording features a live performance of a metal song that consists of manic drums played over aggressive electric guitar melodies and distorted bass guitar. The drums consist of a punchy double pedal kick, punchy snare hits and energetic cymbals. There are some crowd cheering sounds in the background. It sounds aggressive, and energetic overall. | 2010-09-01T16:15:31Z | Pagan's Mind | Pagan's Mind live at ProgPower X in Atlanta, September 2009, performing "God's Equation" as part of the "Returning Heroes" concept. https://www.facebook.com/pagansmind/ http://www.pagansmind.com/ | ["Drum", "Guitar", "Heavy metal", "Music", "Rock music", "Angry music"] | ["low quality", "live performance", "metal", "aggressive", "energetic", "crowd cheering", "manic drums", "aggressive electric guitar melodies", "distorted bass guitar", "punchy double pedal kick", "punchy snare", "energetic cymbals"] | 4 | W7i4LkdSfjw | 3068 |
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;