musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Psychedelic rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic 4
- low quality · 4 ✖
- punchy snare · 4 ✖
- rock 3
- distorted bass guitar 2
- energetic cymbals 2
- punchy kick 2
- shimmering hi hats 2
- short snare rolls 2
- aggressive 1
- buzzy bass guitar 1
- electric guitars melodies 1
- flat male vocal 1
- groovy bass guitar 1
- harsh 1
- harsh cymbals 1
- imbalanced 1
- instrumental 1
- live performance 1
- loud 1
- loud electric guitar 1
- manic 1
- messy 1
- metal 1
- muddy 1
- muffled 1
- muffled vocals 1
- noisy 1
- screaming male vocal 1
- sloppy 1
- …
musiccaps_names (array) 7 ✖
- Music 4
- Psychedelic rock · 4 ✖
- Rock music 3
- Progressive rock 2
- Singing 2
- Heavy metal 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rat Race - Seminal Rats | The low quality recording features a rock song that consists of wide electric guitar chord progressions, distorted bass guitar, shimmering hi hats, uptempo kick pattern and punchy snare. This instrumental sounds a bit muffled and imbalanced in volume, as the guitars are really loud, but it is very energetic regardless. | 2008-12-31T23:39:53Z | Seminalrats | On the occasion of the 10th. anniversary of the death of Mick Weber. | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["rock", "low quality", "wide electric guitars chord progressions", "distorted bass guitar", "shimmering hi hats", "uptempo kick pattern", "punchy snare", "imbalanced", "energetic", "instrumental", "muffled"] | 4 | 9dBWFEpcJIo | 1030 | |
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 | |
No Matter What - Badfinger | The low quality recording features a live performance of a rock song that features muffled male vocals, loud electric guitar melody, buzzy bass guitar, punchy kick and snare and harsh cymbals. Sounds energetic, vintage and a bit harsh, due to the quality of the recording. | 2007-12-10T06:51:44Z | chevy505 | https://www.facebook.com/groups/2211874004/?ref=br_tf https://www.facebook.com/BadfingerThe-Iveys-294346940651268/?ref=hl https://www.facebook.com/Pete-Ham-72628688648/?fref=ts LIVE vocals over LP backing track. Beatles signed them to Apple label as The Iveys. Start of Power Pop, as every band plays this pop gem eventually. | ["Singing", "Music", "Psychedelic rock"] | ["rock", "low quality", "loud electric guitar", "buzzy bass guitar", "muffled vocals", "harsh cymbals", "punchy kick", "punchy snare", "harsh", "vintage", "energetic"] | 4 | Xoke1wUwEXY | 3227 | |
the whip - freelance liaison | The low quality recording features a metal song that consists of screaming male vocal singing over widely spread electric guitar riffs, distorted bass guitar, energetic cymbals and short snare rolls. It sounds loud, aggressive, energetic and manic - as every metal song should sound. | 2011-04-08T04:05:08Z | mullettaimer | the whip - freelance liaison from the 7inch | ["Heavy metal", "Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["low quality", "metal", "screaming male vocal", "energetic", "punchy snare", "wide electric guitars riffs", "distorted bass guitar", "energetic cymbals", "short snare rolls", "loud", "manic", "aggressive"] | 4 | eUZ-v8GEcNk | 3866 |
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;