musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 5 ✖
- low quality 5
- noisy · 5 ✖
- rock · 5 ✖
- easygoing 2
- emotional 2
- messy 2
- punchy kick 2
- punchy snare 2
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- bouncy snare 1
- cool 1
- cover 1
- crushed audio 1
- distorted bass guitar 1
- electric guitar melody 1
- groovy bass 1
- groovy bass guitar 1
- harmonizing male vocals 1
- live performance 1
- melancholic 1
- melancholic male vocal 1
- mono 1
- muddy 1
- muffled instrumental 1
- passionate male vocal 1
- reverberant male vocal 1
- shimmering hi hats 1
- shimmering open hats 1
- …
musiccaps_names (array) 12 ✖
- Music 5
- Bass guitar 3
- Punk rock 2
- Funk 1
- Grunge 1
- Guitar 1
- Independent music 1
- Plucked string instrument 1
- Progressive rock 1
- Radio 1
- Rock and roll 1
- Rock music 1
youtube_published (date) 5 ✖
- 2006-04-19 1
- 2008-10-25 1
- 2009-11-05 1
- 2011-09-25 1
- 2012-04-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afraid of Mice - Trans-parents | The low quality recording features a rock song that consists of reverberant male vocal singing over groovy bass, short electric guitar chords, punchy snare, soft kick hits, shimmering hi hats and soft crash cymbals. The reverb of the vocal is located in the right channel of the stereo image, which makes it sound interesting. It is easygoing and groovy. | 2011-09-25T11:40:58Z | exadaktylos | ["Funk", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["low quality", "noisy", "rock", "reverberant male vocal", "groovy bass", "shimmering hi hats", "soft crash cymbal", "punchy snare", "soft kick hits", "short electric guitar chords", "easygoing", "groovy"] | 4 | 4refolVb_uQ | 610 | ||
Rats - Pearl Jam | The low quality recording features a cover of a rock song and it consists of distorted bass guitar playing over muffled audio. The recording is distorted and very noisy, almost crushed, but it still sounds groovy. | 2009-11-05T15:21:32Z | frschone | I like this song very much, so I thought, lets cover it. There is much improvisation in it. In the solo itself I did my own thing :P | ["Bass guitar", "Music", "Radio"] | ["distorted bass guitar", "crushed audio", "muffled instrumental", "noisy", "low quality", "cover", "rock", "groovy"] | 4 | R3urUtvSgkU | 2662 | |
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 | |
Nothing In This World - The Kinks | The low quality recording features a rock song that consists of an electric guitar melody, smooth bass, shimmering shakers, snappy rimshots and soft male vocals singing over it. The recording is really noisy and in mono. It sounds cool, groovy and easygoing. | 2008-10-25T20:42:37Z | weeniebobeenie | Nothin in this world can stop me worryin bout that girl | ["Bass guitar", "Guitar", "Music", "Plucked string instrument"] | ["rock", "low quality", "electric guitar melody", "smooth bass", "shimmering shakers", "snappy rimshots", "soft male vocal", "noisy", "mono", "cool", "easygoing", "groovy"] | 4 | hOSzGYKaJGE | 4100 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;