musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "sloppy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- low quality · 3 ✖
- noisy · 3 ✖
- sloppy · 3 ✖
- rock 2
- shimmering hi hats 2
- arpeggiated acoustic guitars melodies 1
- cover 1
- dissonant female vocal 1
- electric guitar melody 1
- electric guitars melodies 1
- emotional 1
- energetic 1
- energetic cymbals 1
- flat male vocal 1
- groovy bass 1
- groovy bass guitar 1
- harmonica solo 1
- hollow snare 1
- live performance 1
- messy 1
- mono 1
- muddy 1
- passionate 1
- punchy kick 1
- punchy snare 1
- short snare rolls 1
- soft kick hits 1
- unbalanced stereo 1
musiccaps_names (array) 7 ✖
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 | |
grace slick & the great society-white rabbit | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | 2008-01-07T17:16:48Z | Francesco Giuliobello | An early live version of this song. White rabbit(1965). The images are taken from the movie:Woodstock 3 days of peace & music | ["Singing", "Ska"] | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | 4 | YddV91xnUz4 | 3302 | |
Cover acustico Niño Soldado - Ska-P Guitarra y Armónica | The low quality recording features a cover of a song and it consists of harmonica solo melody over arpeggiated acoustic guitar melodies played a bit sloppy. It still sounds passionate and emotional. The recording is in mono and a bit noisy. | 2011-04-17T20:25:54Z | Ataque de Música | Cover acustico Niño Soldado - Ska-P Guitarra y Armónica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["cover", "low quality", "noisy", "mono", "harmonica solo", "arpeggiated acoustic guitars melodies", "sloppy", "passionate", "emotional"] | 4 | t3Y9Za9roJM | 5001 |
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;